What are the steps you will take to improve performance of
a poor performing query?
No Answer is Posted For this Question
Be the First to Post Answer
1)how to Take Backup in sql server 2005 from Flash Drive
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the ways tablespaces can be managed and how do they differ?
what is the use of ocr?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you trace the traffic hitting a sql server? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you best determine why your MVIEW couldn't FAST REFRESH?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How would you go about increasing the buffer cache hit ratio?
what is ora 24313?what is the procedure to exclude that error?