OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Database reports

Fri, 14 January 2005 04:56

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.

Fri, 14 January 2005 05:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

what kind of information are you looking into from the report?

Fri, 14 January 2005 06:04

Alan
Messages: 68
Registered: October 1999

Member

hi,
performance of the instance,
space issues,
Fragmentation metrics
etc etc

cheers

Alan.

Fri, 14 January 2005 06:26

Mahesh Rajendran
Messages: 10708
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]

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

Goto Forum:

]

Current Time: Thu Jan 09 06:36:04 CST 2025