Home » RDBMS Server » Performance Tuning » utlbstat, utlestat
utlbstat, utlestat [message #64934] Wed, 10 March 2004 19:52 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
hi all, i ran the above mentioned scripts, but where does the system generates the reeport?

 i ran the scripts for the first time.so no idea .pls help
Re: utlbstat, utlestat [message #64935 is a reply to message #64934] Wed, 10 March 2004 23:17 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

The utlestat.sql script will generate a file called "report.txt" in your current directory. You need to rename this file after each run, otherwise you will be overwriting the output.

BTW: You might want to consider using STATSPACK instead of UTLB/ESTAT.

Best regards.

Frank
Re: utlbstat, utlestat [message #64937 is a reply to message #64935] Thu, 11 March 2004 00:01 Go to previous message
Sam
Messages: 255
Registered: April 2000
Senior Member
thanx frank
Previous Topic: is tuning necessary or not.
Next Topic: Oralce Error ORA-04031: unable to allocate 4608 bytes of shared memory ("large pool","unknown object
Goto Forum:
  


Current Time: Fri Apr 19 02:53:33 CDT 2024