Exadata Cell Offloading


oracle@anarexadatatest:~$ 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_ANARDEV1

 oracle 74887 1 0 Dec 03 ? 1:05 ora_smon_ANARLIVE1

 oracle 36115 30639 0 11:43:29 pts/15 0:00 grep smon

oracle@anarexadatatest:~$

oracle@anarexadatatest:~$ export ORACLE_SID=ANARDEV1

oracle@anarexadatatest:~$ echo $ORACLE_SID

ANARDEV1

oracle@anarexadatatest:~$

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: