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

Home -> Community -> Mailing Lists -> Oracle-L -> Export - DB Direct Read mode

Export - DB Direct Read mode

From: <Kapil.Mathur_at_wachovia.com>
Date: Tue, 2 May 2000 13:53:11 -0400
Message-Id: <10485.104706@fatcity.com>


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 ... Received on Tue May 02 2000 - 12:53:11 CDT

Original text of this message

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