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.
To start with run a STATSPACK report to get an overview of what extacly is proble. Read the docs below..
Explain Plan is for sql statement.
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?
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.
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
Click Here to Expand Forum to Full Width