| Script Needed -- SQL Statements - Performance Tuning [message #148889] |
Mon, 28 November 2005 20:44  |
reachriah
Messages: 5
Registered: November 2005
|
Junior Member |
|
|
Hi All
I am working on Performance Tuning on Oracle 10g/ Solaris environment.
My client needs a shell script that gives top 10 Time Consuming SQL Statements...... They dont want to utilize statspack or OEM for somereasons which i dont know. I am wondering if any of you might help me out ....
thanks in advance
riah
|
|
|
|
| Re: Script Needed -- SQL Statements - Performance Tuning [message #149034 is a reply to message #148889] |
Tue, 29 November 2005 15:23  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Look into the ADDM and other automatic monitoring features that are new to 10g and covered in the performance tuning guide. Most if not all of these have command line interfaces that can be run, or can be run using built in plsql packages that can generate lists, reports, and other helpful information.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
