Skip to main content

Posts

Showing posts from October, 2019

How to find 18c Grid version without connecting to SQLPLUS

How to find Oracle 18c ASM/Grid version without connecting to SQLPLUS < Grid_Home/bin >: +ASM > ./oraversion This program prints release version information. These are its possible arguments: -compositeVersion : Print the full version number: a.b.c.d.e. -baseVersion : Print the base version number: a.0.0.0.0. -majorVersion : Print the major version number: a. -buildStamp : Print the date/time associated with the build. -buildDescription : Print a description of the build. -help : Print this message.

How to Perform Real Application Testing(RAT) using SQL Plus

How to Perform Real Application Testing(RAT) using SQL Plus Real Application Testing (RAT) using SQLPLUS, Step 1. Capture the Load,using DBMS_WORKLOAD_CAPTURE SQL > create directory <DIR NAME> as '<OS Location>';  SQL > exec dbms_workload_capture.start_capture(name => '<Name>', dir => '<CAPTUREDIR>'); <<Simulate the load or Capture during high load time>> SQL > exec dbms_workload_capture.finish_capture(); SQL> exec dbms_workload_capture.export_awr (capture_id => 1); Step 2. Process the load on Snapshot Standby using DBMS_WORKLOAD_REPLAY, SQL > create directory <DIR NAME> as '<OS Location>'; $ cp <Capture load dir created in step 1>* <DIR location of step 2> SQL> exec DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => '<CAPTUREDIRstep2>'); Step 3. Replay multiple time, SQL> exec DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY(repla...