Exadata Cell Offloading


oracle@bakuexa1dbadm01:~$ ps -afe | grep smon
 root 1536 1 0 Nov 07 ? 360:16 /u01/app/11.2.0.3/grid/bin/osysmond.bin
 oracle 2260 1 0 Nov 07 ? 0:46 asm_smon_+ASM1
 oracle 18359 1 0 Dec 03 ? 1:03 ora_smon_MISDEV1
 oracle 74887 1 0 Dec 03 ? 1:05 ora_smon_MISLIVE1
 oracle 36115 30639 0 11:43:29 pts/15 0:00 grep smon
oracle@bakuexa1dbadm01:~$ 
oracle@bakuexa1dbadm01:~$ export ORACLE_SID=MISDEV1
oracle@bakuexa1dbadm01:~$ echo $ORACLE_SID
MISDEV1
oracle@bakuexa1dbadm01:~$
Checking the cell offloading process in DB parameter
SQL> show parameter cell_offload_processing
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offload_processing boolean TRUE
SQL> alter system flush buffer_cache;
System altered.
SQL> alter system flush SHARED_POOL;
System altered.
Disabling Cell_offloading_process
SQL> alter session set cell_offload_processing=FALSE;
Session altered.
SQL>set timing on;
-------------------
SQL> select count(*) from cell_offload where id>4500;
COUNT(*)
----------
 28978100
Elapsed: 00:04:40.20
Now enabling cell offload process
SQL> alter system flush buffer_cache;
System altered.
SQL> alter system flush SHARED_POOL;
System altered.
SQL> alter session set cell_offload_processing=TRUE;
Session altered.
SQL>set timing on;
SQL> select count(*) from cell_offload where id>4500;
COUNT(*)
----------
 28978100
Elapsed: 00:00:35.80
We can see the huge difference:
Elapsed: 00:04:40.20 ---- cell_offload_processing=FALSE
Elapsed: 00:00:35.80 ---- cell_offload_processing=TRUE
It is very important for Performance issue.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: