Re: Can Anyone Explain ...

Dereck L. Dietz wrote:
> Why the "DBA" in charge of a database would not use RMAN to back up a
> database? It currently takes nearly 24 hours each weekend to do a cold
> backup.
>
> When I questioned why about all the answer I got was that the RMAN catalog
> "wasn't installed". I also wasn't able to find out what it was he was using
> to do the backup of an over 2,000 GB data warehouse.
>
> Also, can anyone confirm/deny whether he has valid points in not using
> Oracle ASM when we are experiencing bad I/O throughput. His "reasons" were
> that he'd have to shut the database down in order to convert to ASM and he
> had a problem with raw devices.
>
> The I/O throughput problem we've been having is that there are 6 data
> tablespaces, 5 indexes tablespaces and 3 temporary tablespaces (and their
> associated physical files) all on the same drive causing massive waits if
> more than a few people start querying data.
>
>
>

ASM won't solve your I/O throughput problems if you still put everything on one disk unit.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown