Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

is Oracle slow???

615452Jul 10 2008 — edited Jul 11 2008
Hi,

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.......
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2008
Added on Jul 10 2008
12 comments
992 views