RE: Export - DB Direct Read mode

Hi,

As I understand you only need to include DIRECT=Y in your exp command. You do not need to issue other commands such as ALTER DATABASE or ALTER SYSTEM. ALl would be taken care of by Oracle.

Long

-----Original Message-----
From: Kapil.Mathur_at_wachovia.com [mailto:Kapil.Mathur_at_wachovia.com] Sent: Wednesday, May 03, 2000 5:06 AM
To: Multiple recipients of list ORACLE-L Subject: Export - DB Direct Read mode

Hi,

     In the Oracle8 Backup & Recovery Handbook (Oracle Press), while referring to Export Utility with the Direct Path option (DIRECT=Y), it says "For added performance, the database can be set to direct read mode, thus eliminating contention with other users for database resources because database blocks are read into the Export session's private buffer rather than a public buffer cache".

     Are they referring to executing a ALTER DATABASE OPEN READ ONLY command before beginning an Export or do they recommend executing a ALTER SYSTEM SUSPEND command before beginning the Export or are they referring to something totally different ... any help appreciated ...

thanks

-- 
Author: 
  INET: Kapil.Mathur_at_wachovia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).