Oracle 12c Load testing with SwingBench

Coming shortly ...

Please leave comments for any questions..

Comments

Post a Comment

Popular posts from this blog

Interview Questions and Answers of Oracle DBA

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...
Read more

Basic Unix/Linux commands in RAC Administration

Basic Unix/Linux commands in RAC Administration SRVCTL Utility is used to start and stop the database and instances and configuration management etc. To Start a RAC database srvctl start nodeapps -n  <nodename> srvctl start asm -n  <nodename> srvctl start database -d  <dbname> options: srvctl start database -d  <dbname>  -o open | -o mount | -o nomount Stop a RAC database srvctl stop database -d  <dbname>  -o immediate options: srvctl stop database -d  <dbname>  -o normal | -o transactional | -o immediate | -o abort srvctl stop asm -n  <nodename> options: srvctl stop asm -n  <nodename>  -o immediate srvctl stop nodeapps -n  <nodename> To check status and configurations Nodeapps: srvctl status nodeapps -n  <nodename> srvctl config nodeapps -n  <nodename> ASM: srvctl status asm -n  <nodename> srvc...
Read more

Oracle 12c load testing withThe Silly Little Oracle Benchmark(SLOB)

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 ...
Read more