background preloader

Tuning

Facebook Twitter

The DBMS_SYSTEM Package.

Concurrency

SQL queries. OS. SQL Dev. Parallelism. RAC. EM. Statspack. Memory. I/O. Waits Events. Optimizer/Plan. DBA-Village. 10 MB is not that much!

DBA-Village

You must have some queries doing full table scans. Identify them, and then address each one by one. To identify the expensive queries, find the PriceyTopTenMini.sql in the scripts on this site. About me - ORACLE IN ACTION. Anju Garg I am Oracle Ace having more than 14 years of experience in IT ndustry.

About me - ORACLE IN ACTION

I am a freelance Oracle Corporate Trainer (DBA), blogger, author, speaker and technical reviewer. I share my knowledge about oracle via my blog.