user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
Answer Posted / basanti
1. Check the volume of data.
2. check whether index need to be rebuild or not.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the differences between an exclusive lock and a shared lock?
What is the benefit of database?
Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com
What are the 5 databases?
What is index hunting?
What are the types of database lock?
How many types of data are there?
Why do I need netlib?
How is data stored in a relational database?
What is netlib for clipper?
What is foreign key in database?
How many records can a database hold?
What is database transaction?
What is erd?
What is query in database?