There are some important question and answer for Oracle DBA. 1. What are the components of SGA? SGA is used to store shared information across all database users. It mainly includes Library cache, Data Dictionary cache, Database Buffer Cache, Redo log Buffer cache, Shared Pool. 2. Difference between SGA and PGA. SGA (System Global Area) is a memory area allocated during an instance start up. SGA is allocated as 40% of RAM size by default. SGA size is controlled by DB_CACHE_SIZE parameter defined in initialization parameter file (init.ora file or SPFILE). PGA (Program or Process Global Area) is a memory area that stores a user session specific information. PGA is allocated as 10% of RAM size by default. 3. What is System Change Number (SCN)? SCN is a unique ID that Oracle generates for every committed transaction. It is recorded for every change in the redo entry. 4. What is Database Writer (DBWR) and when does DBWR write to the data file? -D...
SLOB is the best SQL workload to drive maximum physical random I/O from a database platform. SLOB is an I/O intensive SQL generator, instead of a synthetic I/O generator, with the following characteristics: Ø Supports testing physical, random single-block reads (database file sequential read/DB file parallel read) Ø Supports testing random single-block writes (database file parallel write) Ø Supports testing extreme REDO logging I/O Ø Consists of simple PL/SQL Installation: Installation steps are below: 1. Install the latest SLOB RPM yum install http://yum.outrun.nl/outrun-extras.rpm 2. Go to the url "https://kevinclosson.net/slob/" and then click on SLOB 2.3: Click Here link. This link will redirect on " https://my.syncplicity.com/share/ize90aqgqy9yj1d/2015.07.16.slob_2.3.0.3-1.tar " page, then click on download button to download the SLOB 2.3 in .tar file ...
Comments
Post a Comment