{"id":1607,"date":"2010-03-30T05:16:47","date_gmt":"2010-03-30T09:16:47","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/"},"modified":"2010-03-30T05:16:47","modified_gmt":"2010-03-30T09:16:47","slug":"real-application-testing-oracle","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/","title":{"rendered":"Real Application Testing Oracle"},"content":{"rendered":"

<\/a><\/a><\/a><\/a><\/a><\/a><\/a><\/a><\/a><\/a>1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introduction<\/p>\n

Real application testing is a powerful features of Oracle which has been introduced in 11g first and then it was back ported to other version including oracle 9i .\u00a0 In our Eaga specific scenario we have oracle 9.2.0.7 EBS database and we have 11g database with OEM grid cntrol . The real advantage of OEM is to generate report from GUI easily .<\/p>\n

Oracle\u00a0 has<\/a> provided patch for older\u00a0 version 9.2.0.7 the patch number is :-\u00a0p8542772_92070_SOLARIS64.zip , which needs to apply first in your 9.2.0.7 database to enable \u00a0RAT data captuing feature .<\/p>\n

\u00a0\u00a02.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pre-Requisite :-<\/p>\n

\u00a0RAT feat<\/a>ure does not work \/capture\u00a0 correct data if there is no active user session in your source (9.2.0.7) database . \u00a0Apply the oracle supplied patch p8542772_92070_SOLARIS64.zip .<\/p>\n

\u00a03.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Real Application Testing Implementation <\/a><\/p>\n

Download this patch p8542772_92070_SOLARIS64.zip from\u00a0 metalink.oracle.com<\/p>\n

Trasfer\u00a0 this patch to\u00a0 any temporary directory using ftp or winscp . copied this in \/ebstst4_bin\/db_u01\/oracle\/patch\u00a0<\/p>\n

$ ls -ltr<\/p>\n

total 3720<\/p>\n

-rw-r–r–\u00a0\u00a0 1 root\u00a0\u00a0\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0 1899202 Mar 16 04:43 p8542772_92070_SOLARIS64.zip\u00a0\u00a0<\/p>\n

Extract this patch using below command<\/p>\n

Unzip\u00a0 p8542772_92070_SOLARIS64.zip\u00a0\u00a0<\/p>\n

Read readme.txt of the patch . In case of database EBS (9.2..0.7) There was no need of any pre-req patch.<\/p>\n

Shutdown your application services and database .<\/p>\n

Login\u00a0 in ebstst4forms\u00a0 as dbaz<\/p>\n

Cd\u00a0 \/<\/p>\n

.\/ stop_ebstst4<\/p>\n

Login in ebstst4db as dbaz<\/p>\n

Cd \/<\/p>\n

.\/ stop_ebstst4<\/p>\n

Apply the patch in EBSTSTS4 (9.2.0.7)<\/p>\n

Login as\u00a0 oracle in ebstst4db<\/p>\n

.\u00a0 EBSTST4.env \u00a0(Set the env )<\/p>\n

Cd\u00a0 \/ebstst4_bin\/db_u01\/oracle\/patch\/8542772<\/p>\n

$ORACLE_HOME\/OPatch\/opatch apply (It will take time )<\/p>\n

After successful apply of the patch ,do the post patch task as per readme.txt<\/p>\n

Startup the database \u00a0and listener<\/p>\n

lsnrctl start EBSTST4<\/p>\n

Sqlplus \u201c\/as sysdba\u201d<\/p>\n

Startup<\/p>\n

SQL> @?\/rdbms\/admin\/catwrr.sql\u00a0<\/p>\n

4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start\u00a0 Data Capturing Process .<\/p>\n

Our main target is to capture the data of database EBSTST4 (9.2.0.7)<\/p>\n

First figure out\/create\u00a0 the direcotry where you want your capture data to store .<\/p>\n

mkdir\u00a0 \u2013p\u00a0 \/ebstst4_bin\/db_u01\/oracle\/RAT<\/p>\n

Connect \u00a0sqlplus in as sysdba to create\u00a0 directory .<\/p>\n

SQL> create or replace directory ebstst4_rat_sample as ‘\/ebstst4_bin\/db_u01\/oracle\/RAT’;<\/p>\n

Directory created.<\/p>\n

SQL><\/p>\n

Check weather directory created or not\u00a0 from sqlplus :-<\/p>\n

select directory_name, directory_path<\/p>\n

from dba_directories<\/p>\n

order by directory_name;<\/p>\n

Now\u00a0 you create filters at user \/schema\u00a0 level ,so that you can capture the data for specific user . Even you can capture the data for all the users .<\/p>\n

In my case I have figured out the user\u00a0 EAGA_GAPS to filter :-<\/p>\n

Exec\u00a0 dbms_workload_capture.add_filter(‘sample_test_filter2’, ‘USER’, ‘EAGA_GAPS’);<\/p>\n

— To see what filters are in place<\/p>\n

\/*<\/p>\n

select type, name, attribute, status, value from dba_workload_filters;<\/p>\n

*\/<\/p>\n

So\u00a0 I want to capture data for eaga_gaps<\/p>\n

Connect\u00a0 sqlplus as sysdba<\/p>\n

Sqlplus \u201c\/as sysdba\u201d<\/p>\n

SQL>\u00a0 exec\u00a0 dbms_workload_capture.start_capture(‘sample_test_rat’, ‘EBSTST4_RAT_SAMPLE’, NULL, ‘EXCLUDE’);<\/p>\n

— If you want to capture ALL workload except user ” EAGA_GAPS\u201d<\/p>\n

\/*<\/p>\n

exec\u00a0 dbms_workload_capture.start_capture(‘sample_cap_name’, ‘sample_cap_dirobj’, NULL, ‘INCLUDE’);<\/p>\n

*\/<\/p>\n

Check status of the capture<\/p>\n

\/*<\/p>\n

select name, directory, status, start_time, end_time, duration_secs, errors<\/p>\n

from dba_workload_captures;<\/p>\n

*\/<\/p>\n

Finish the capturing of the data using the below command<\/p>\n

exec \u00a0dbms_workload_capture.finish_capture;<\/p>\n

Check the status of the captuing<\/p>\n

\/*<\/p>\n

select name, directory, status, start_time, end_time, duration_secs, errors<\/p>\n

from dba_workload_captures;<\/p>\n

*\/<\/p>\n

Data captured<\/p>\n

$ cd \/ebstst4_bin\/db_u01\/oracle\/RAT<\/p>\n

$ ls -ltr<\/p>\n

total 3456<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 143 Mar 12 10:53 wcr_scapture.wmd<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 993 Mar 12 10:53 wcr_4r6hx70002rfm.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 817479 Mar 12 11:45 wcr_4r6hxf4002rft.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 903684 Mar 12 11:45 wcr_4r6hx58002rfd.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1002 Mar 12 11:48 wcr_4r6ja04002rgr.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 898 Mar 12 11:52 wcr_4r6jaqn002rgv.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 898 Mar 14 20:12 wcr_4r7a30w002tsh.rec<\/p>\n

-rw-rw-r–\u00a0 \u00a01 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1002 Mar 15 04:18 wcr_4r7dnw8002u5r.rec<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 208 Mar 15 04:19 wcr_fcapture.wmd<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4074 Mar 15 04:19 wcr_cr.html<\/p>\n

-rw-rw-r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1544 Mar 15 04:19 wcr_cr.text<\/p>\n

Now its time to replay the capture in your 11g database , which \u00a0has got all the features to replay .<\/p>\n

Login to sunmanage2\u00a0 as dbaz<\/p>\n

Su\u00a0 \u2013\u00a0 oracle<\/p>\n

. OEMTEST.env<\/p>\n

Create the replay directory<\/p>\n

mkdir\u00a0 \u2013p\u00a0 \/oemtest_bin\/db\/oracle\/RAT<\/p>\n

Transfer this captured data from ebstst4db to sunmanage2\u00a0 using ftp to your newly created directory .<\/p>\n

\/oemtest_bin\/db\/oracle\/RAT<\/p>\n

Create directory object \u00a0in 11g OEMTEST database .<\/p>\n

Connect\u00a0 sqlplus as sysdba<\/p>\n

Sqlplus \u201c\/as sysdba\u201d<\/p>\n

create or replace directory “sample_rep_dirobj” as\u00a0 ‘\/ebstst4_bin\/db_u01\/oracle\/RAT\u2019<\/p>\n

start the capturing process ********<\/p>\n

exec dbms_workload_replay.process_capture(‘sample_rep_dirobj’);<\/p>\n

Initialize replay ************<\/p>\n

exec \u00a0dbms_workload_replay.initialize_replay(‘sample_rep_name’, ‘sample_rep_dirobj’);<\/p>\n

Prepare replay: put DB state into REPLAY mode<\/p>\n

—\u00a0\u00a0\u00a0 You could specify:<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0 synchronization\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 – whether or not commit order is preserved<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0 connect_time_scale\u00a0\u00a0\u00a0\u00a0\u00a0 – scales the time elapsed between the start of<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0the replay and the start of each session<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0 think_time_scale\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 – scales the time elapsed between two<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 successive user calls from the same session<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0 think_time_auto_correct – Auto corrects the think time between calls<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 when user calls takes longer during the<\/p>\n

—\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 replay than during the capture<\/p>\n

—<\/p>\n

exec dbms_workload_replay.prepare_replay(synchronization => TRUE, connect_time_scale => 100, think_time_scale => 100, think_time_auto_correct => FALSE);<\/p>\n

\u00a0exit from the sqlplus<\/p>\n

\u00a0exit<\/p>\n

Its time to play from command prompt\u00a0 Use this below command to calibrate<\/p>\n

wrc\u00a0 system\/password\u00a0 mode=calibrate replaydir=\/oemtest_bin\/db\/oracle\/RAT<\/p>\n

\u00a0Start the reply Use this below command<\/p>\n

wrc system\/password mode=calibrate replaydir=\/oemtest_bin\/db\/oracle\/RAT<\/p>\n

At the same time take another terminal\u00a0 connect\u00a0 sqlplus as sysdba in 11g database<\/p>\n

Sqlplus\u00a0 \u201c\/as sysdba\u201d<\/p>\n

BEGIN<\/p>\n

\u00a0 DBMS_WORKLOAD_REPLAY.start_replay;<\/p>\n

END;<\/p>\n

\/<\/p>\n

After replay process you\u00a0 can check the status of the file in your file system<\/p>\n

Cd\u00a0 \/ebstst4_bin\/db_u01\/oracle\/RAT<\/p>\n

sunmanage2@oracle# ls -ltr<\/p>\n

total 39592<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 903684 Mar 15 06:16 wcr_4r6hx58002rfd.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 993 Mar 15 06:16 wcr_4r6hx70002rfm.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 817479 Mar 15 06:16 wcr_4r6hxf4002rft.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1002 Mar 15 06:16 wcr_4r6ja04002rgr.rec<\/p>\n

-rw-r–r–\u00a0 \u00a01 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 898 Mar 15 06:16 wcr_4r6jaqn002rgv.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 898 Mar 15 06:16 wcr_4r7a30w002tsh.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1002 Mar 15 06:16 wcr_4r7dnw8002u5r.rec<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4074 Mar 15 06:16 wcr_cr.html<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1544 Mar 15 06:16 wcr_cr.text<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 208 Mar 15 06:16 wcr_fcapture.wmd<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 143 Mar 15 06:16 wcr_scapture.wmd<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle \u00a0\u00a0dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 153 Mar 15 06:17 wcr_login.pp<\/p>\n

-rw-r—–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12288 Mar 15 06:17 wcr_scn_order.extb<\/p>\n

-rw-r—–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12288 Mar 15 06:17 wcr_seq_data.extb<\/p>\n

-rw-r—–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12288 Mar 15 06:17 wcr_conn_data.extb<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 35 Mar 15 06:17 wcr_process.wmd<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 633 Mar 15 06:20 wcr_replay.wmd<\/p>\n

-rw-r—–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0 18374656 Mar 15 06:23 wcr_ra_2383030089.dmp<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a028278 Mar 15 06:23 wcr_ra_2383030089.log<\/p>\n

-rw-r–r–\u00a0\u00a0 1 oracle\u00a0\u00a0 dba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10952 Mar 15 06:23 wcr_rr_2383030089.xml<\/p>\n

End of Reply process*****************<\/p>\n

\u00a05.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 We need to generate report and analyse the report . We have got 11g database with OEM grid control , now we will login to our OEM and try to generate report from OEM .\u00a0\u00a0<\/p>\n

Login\u00a0 as OEM\u00a0<\/p>\n

Open\u00a0 internet explorer and type the below url<\/p>\n

http:\/\/sunmanage2.eaga.co.uk:4889\/em\/console\/logon\/logon<\/a><\/p>\n

Type username :- sysman<\/p>\n

Password\u00a0 :- provide password \u00a0<\/p>\n

Below windows will appear<\/p>\n

\"OEM1\"<\/a><\/p>\n

Click on targets\u00a0<\/font><\/strong>\u00a0<\/font> <\/font><\/strong><\/p>\n

\"OEM2\"<\/a><\/font><\/strong><\/p>\n

Next click\/check\u00a0 your server accordingly <\/font><\/strong><\/p>\n

\"OEM3\"<\/a><\/font><\/strong><\/p>\n

Click on Databases <\/font><\/strong><\/p>\n

\"OEM4\"<\/a><\/p>\n

\u00a0Click <\/font><\/strong>\u00a0OEMTEST <\/strong><\/font><\/strong><\/p>\n

\"OEm6\"<\/a><\/strong>\u00a0<\/strong><\/font><\/strong>Click Software and Support for RAT <\/strong><\/strong>\"OEM7\"<\/a><\/strong>\u00a0<\/strong><\/p>\n

Click on Database Replay<\/strong><\/strong>\"OEM8\"<\/a><\/strong>Click on Analyze Results on right side <\/strong><\/strong>\"oem9\"<\/a><\/p>\n

Choose the directory , where we have captured the Replay\u00a0\u00a0<\/p>\n

\"oem10\"<\/a><\/p>\n

Click Continue<\/p>\n

\"oem11\"<\/a><\/p>\n

\u00a0Generate report<\/strong><\/p>\n

<\/a><\/strong>\u00a0<\/strong>*****************Below Sample Report**********<\/strong>\u00a0<\/strong><\/p>\n

\"sample\"<\/a><\/a><\/strong>\u00a0<\/p>\n

<\/strong><\/strong><\/strong><\/font><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[212],"tags":[],"class_list":["post-1607","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"\nReal Application Testing Oracle -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Real Application Testing Oracle -\" \/>\n<meta property=\"og:description\" content=\"1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-03-30T09:16:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/\",\"name\":\"Real Application Testing Oracle -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG\",\"datePublished\":\"2010-03-30T09:16:47+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Real Application Testing Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Real Application Testing Oracle -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Real Application Testing Oracle -","og_description":"1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introduction Real application testing is a powerful features of Oracle which has been introduced in 11g first and then […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/","article_published_time":"2010-03-30T09:16:47+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/","url":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/","name":"Real Application Testing Oracle -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG","datePublished":"2010-03-30T09:16:47+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2010\/03\/rat1.thumbnail.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2010\/03\/30\/real-application-testing-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Real Application Testing Oracle"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=1607"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1607\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=1607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=1607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=1607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}