Index Full Scan:

  • Returns Data in sorted order
  • Scan will not use multiblock reads
  • At least one column in the index is not NULL

Index Fast Full Scan

  • Use multiblock reads
  • Use parallelism
  • Rows returned NOT sorted order
  • Use only if all required columns are in the index
  • Do not return ROWIDs for subsequent table access


Parallel_force_local =  TRUE – parameter restricts the PX servers local to the parent process node and not distributed across the RAC nodes

Oracle 12c – password file can be created in ASM as follows.  Make sure the selected FORMAT is 12

orapwd  file=’+DATA/orcl/orapworcl’ ENTRIES=10 FORMAT=12 DBUNIQUENAME=’ORCL’

Linux Parameter – swappiness  holds value between 0 – 100 which will decide the aggressiveness swapping the physical memory when the pages are idle and the default value is 60.   For database servers it is not recommend to keep the default value 60 as it can aggressively flush physical memory pages to the VM.  The Red hat recommended value is 10.

You may set the parameter vm.swappiness=10 in /etc/sysctl.conf to set the values permanently.  Or to set the value temporary set as follows

$ echo 10 > /proc/sys/vm/swappiness

PGA_AGGREGATE_LIMT : PGA memory is defined by pga_aggregate_target in database level and is not a har5d limit.  Oracle 12c introduces a new parameter pga_aggregate_limit which will restrict the growth of the PGA.  By default it will be maximum of 2GB or 200% of the pga_aggregate_target.  In databases with large PGA target configurations, it is necessary to set the PGA limit rather leaving to the default value of 200% of PGA target.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: