is Oracle slow???
615452Jul 10 2008 — edited Jul 11 2008Hi,
I am in a typical situation...as an oracle dba I need to explain the the difference between Oracle and SQL Server to management..
Oracle:
My question is we have one Oracle 10g 10.2.0.1 instance running on HP-UX 11.21 itanium server...
I have written RMAN online Backup to take backup with compression...thati is the script that what i am using..Daily night there is no load, at that time backup is occuring...
--------------------------------------------------
crosscheck backup;
backup as compressed backupset database;
sql 'alter system switch logfile';
backup as compressed backupset archivelog all;
backup as compressed backupset current controlfile;
=========================
The above backup took 1 hour 20 mins to complete. After moving the above backupsets to TEST Machine.... It took 2 hours 30 Mins to clone entire database....
So finaly...
For taking Backup = 1 hour 20 Mins
For Cloning = 2 Hour 30 Mins
We have important 2 tablespaces for java based application....
DATA_TBS used size = 3.5 GB
INDEX_TBS used size = 4 GB
In Oracle..For Cloning..I move all RMAN backupsets to TEST Machine and clone using
run
{
restore database;
revover database;
alter database open resetlogs;
}
================================
This is regarding SQL Server 2005 on windows 2003 Machine with same type of hardware and memory and processor speed with same type of hard disks.
Here same Java Application database ( Same tables ) which is on SQL Server....
For taking Backup = 10 Mins
For Restore backup to other machine = 20 Mins
Here for Backup...right click on database and take backup..for restore also..right click and restore...everything is GUI....
============================================
Why this much difference between Oracle and SQL Server....Management is asking..
Is Oracle slow???????
If it is slow...why cant we migrate our databases to SQL Server like that they are asking....
Friends...what I can say...as normal Oracle DBAs does...same thing I am doing regading RMAN Backup and Restore...
But for taking Backup and Clone in Oracle it is taking much time compared to SQL Server
what might bethe reasons?????
Please help me in this regard???
Keep in mind that...
In both machines where we are clong..both are with same hardware and same memory and same processors and same hard disk speed...but why Oracle is slow for backup and cloning...how can i explain these things to management??????please sched some light on this.......