Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Anyone Explain ...

Re: Can Anyone Explain ...

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Jan 2007 16:04:44 -0800
Message-ID: <1170115484.743553.47970@a75g2000cwd.googlegroups.com>

On Jan 29, 6:50 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> 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.

PS - Obviously ASM means 10g. -- Mark -- Received on Mon Jan 29 2007 - 18:04:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US