Oracle 11g new Background Process

This article will enable you to learn about some of new background processes in 11g. As per Oracle documentation there are 56 new background processes added in 11g release 1 Lets have a look at some important one’s…. MMAN – this process is responsible for ASMM in 10g and AMM in 11g  which manages memory allocation [...]

Read Full Post »

Oracle 10g new Background Process

MMAN ====== SGA Background Process The Automatic Shared Memory Management feature uses a new background process named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components. The SGA Memory Broker keeps track of the sizes of the components and pending resize operations RVWR ====== Flashback database [...]

Read Full Post »

Oracle Database 11g new feature – Automatic Memory Management

Automatic Memory Management was a new feature introduced in 10g. With 10g release oracle has come up with anew parameter called sga_target which was used to automatically manage the memeory inside SGA. The components which were managed by sga_target are db_cache_size, shared_pool_size, large_pool_size, java_pool_size and streams_pool_size With 11g, Oracle went a step further to manage [...]

Read Full Post »

Finding currently running SQL

Have you needed to find out what SQL was running in the database? Much of my time is spent on out data warehouse where long expensive queries may be running. When someone calls to ask why things are running slow one area to look is what SQL are they running. The database may not be [...]

Read Full Post »

Reducing datafile size to recover free space / ORA-03297: file contains used data beyond requested RESIZE value

At time, we want to recover some space from database just to allocate the same to some other tablespace or to return it back to OS disk. This situation arises many times. And many time we hit with error “ORA-03297: file contains used data beyond requested RESIZE value“. The concept is simple and many of [...]

Read Full Post »

Table Compression in Oracle

Recently i had to move a schema of size 70GB to another database[Oracle 10.2.0.1]. That was a readonly schema and never had any DML on any of the tables. In the new database i did compress the tables and the size was brought down from 70Gb to 22Gb. 1]Divided the tables based on the size. [...]

Read Full Post »

Empty/Remove Oracle Listener.log files

The listener.log file grows and its not possible to just move the file whilst the listener is up. The tnslsnr process always hold this log file. This can be confirmed using the command fuser. Test $> cd /oracle/product/10.2.0/network/log Test $> ls -lrt total 1522 -rw-r—–   1 oracle   dba       763075 Mar  7 22:40 listener_old.log -rw-r—–   1 [...]

Read Full Post »