Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
No Answer is Posted For this Question
Be the First to Post Answer
You're getting high "busy buffer waits" - how can you find what's causing it?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is RAID and what are different types of RAID configurations?
What are the different ways you can create databases in sql server? : sql server DBA
How would you begin to troubleshoot an ORA-3113 error?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?