Home » RDBMS Server » Performance Tuning » Database reports
Database reports [message #65860] Fri, 14 January 2005 04:56 Go to next message
Alan
Messages: 68
Registered: October 1999
Member
hi all
does anyone have an sql script which reports the status of the database which can then be read in WORD.

cheers

Alan.
Re: Database reports [message #65861 is a reply to message #65860] Fri, 14 January 2005 05:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what kind of information are you looking into from the report?
Re: Database reports [message #65862 is a reply to message #65861] Fri, 14 January 2005 06:04 Go to previous messageGo to next message
Alan
Messages: 68
Registered: October 1999
Member
hi,
performance of the instance,
space issues,
Fragmentation metrics
etc etc

cheers

Alan.
Re: Database reports [message #65863 is a reply to message #65862] Fri, 14 January 2005 06:26 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. Statspack reports / Trace outputs is the one you actually need to look into.
If you have anything VERY specific, you can include.
There is NO hard rule / threshold limits that would report about performance.
2.
These might help...

http://www.orafaq.com/scripts/sql/tsspace.txt
http://www.orafaq.com/scripts/sql/dffree.txt
http://www.orafaq.com/forum/t/20164/0/

3. use LMT ( local managed tablespace) as default!.
You get no fragmentation.

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: How much used space percentage set for tablespace?
Next Topic: Required Index .(Urgent help)
Goto Forum:
  


Current Time: Thu Oct 01 02:44:51 CDT 2020