Home » RDBMS Server » Performance Tuning » Physical gets increasing after scheduled export
Physical gets increasing after scheduled export [message #240648] Fri, 25 May 2007 07:19 Go to next message
csharat
Messages: 7
Registered: August 2006
Junior Member

The version of database i am working for is 8.1.7.
Physical gets have been increasing as and when the scheduled export has done everyday. I need to bounce database every morning.
Export options using are:

echo off
exp userid=<user/pwd@instance> file=<file_path>log=<log_file_path> compress=y rows=y owner=<username>
echo on

Any suggestion could be appreciated.
Thanks in advance.
--Sharat
Re: Physical gets increasing after scheduled export [message #240727 is a reply to message #240648] Fri, 25 May 2007 10:23 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
take a look over here.
http://oracle.ittoolbox.com/pub/AJ032403.pdf

[Updated on: Fri, 25 May 2007 10:35]

Report message to a moderator

Re: Physical gets increasing after scheduled export [message #241075 is a reply to message #240648] Mon, 28 May 2007 05:03 Go to previous message
sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai
Junior Member

Plz take export with option direct=y and feedback=10000 and revert back.
Previous Topic: Oracle Database Performance Tuning (Note Sheets)
Next Topic: Improving performance of a query using order by clause
Goto Forum:
  


Current Time: Sat Dec 10 18:18:40 CST 2016

Total time taken to generate the page: 0.09975 seconds