-
slow peroformance
my application is running is very slow, i have anyalysed the main tables and checking the statistics in user_tables, i have got chain_cnt as nil , what else do i need to check on this veiw and what do i need to work around.
i am also trying to use explain plan command, here can't i do i for the complete user or do i need to go for each sql statement.
thanks,
ram
-
To start with run a STATSPACK report to get an overview of what extacly is proble. Read the docs below..
https://metalink.oracle.com/metalink...,1,1,helvetica
Explain Plan is for sql statement.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Do you have a base line statistics?
Tamil
-
How have you defined "Slow" ?
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
How many licks does it take to get to the center of a tootsy roll tootsy pop?
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|