The DBMS_SYSTEM Package.
SQL queries. OS. SQL Dev. Parallelism. RAC. EM. Statspack. Memory. I/O. Waits Events. Optimizer/Plan. DBA-Village. 10 MB is not that much!
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.
I am a freelance Oracle Corporate Trainer (DBA), blogger, author, speaker and technical reviewer. I share my knowledge about oracle via my blog.