OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

Archive for the 'Tuning' Category

Create a Histogram on a Specified Column

How to select hidden initialization parameters

What is the difference between V$ and GV$, also V$ and V_$?

How to monitor the amount of redo generated per hour

How to calculate buffer cache hit ratio

How to “improve” buffer cache hit ratio

How to locate unindexed foreign keys

Which segments have top LIO (Logical IO)/PIO (Physical I/O)

How to create text index and sync schedule in one step?

How to find the top SQL statements that have caused most block buffer reads?

How can I measure the performance of a specific i/o configuration for Oracle?

How to display the explain plan of a query using dbms_xplan table funtion?