Table Export Using Windows7 Scheduler

Table Export Using Windows7  Scheduler

1.       Create Directory  F:\backup\Export\Tables

2.       SQL> connect sys as sysdba

3.       SQL> create directory test_dir as ‘F:\backup\Export\Tables’;

4.       SQL> grant read,write on test_dir to scott;

5.       Start ---> run ---> notepad --. SAVE ---> F:\backup\scrips\

File Name ---> SCOT_TABLE_EXPORT.BAT

Encoding ---> UTF – 8

Click on SAVE

SCOT_TABLE_EXPORT.BAT

Set oracle_sid=orcl set oracle_home=f:\oracle\product\10.2.0\db_1 F: Cd  f:\oracle\product\10.2.0\db_1\bin expdp userid=scott/tiger directory=test_dir dumpfile=emp_expdp_%date:~7,2%_%date:~4,2%_%date:~10,4%.dmp  tables=emp logfile=empdate.log

1.       Start ---> run ---> taskschd.msc

2.       Left Side pane click on Task Scheduler Library

3.       Right Side Pane click on Create Taks

4.       Click on General tab ---> write task Name -------------SCOTT_TABLE_EXPORT

5.       Click On Triggers Tab ---> NEW ---> 

Begin The Task ---> on a schedule

Setting  select Daily and there is various option please choose according to your need

Click on OK

6.       Click on Action Tab ---> NEW --->

Action ---> Start a Program

Setting --->

Program/Scripts ---> F:\backup\scrips\ SCOT_TABLE_EXPORT.BAT ( Browse the batch file )

Add Argument ---> -a adv

Start in optional ---> F:\oracle\product\10.2.0\db_1\bin

SYSAUX Tablespace purging

First check sysaux table used/free/tolal space 

NAME         USED_SPACE_GB FREE_SPACE_GB TOTAL_SPACE_GB     %_FREE

------------ ------------- ------------- -------------- ----------

SYSAUX                17.9          22.1            40         55

SYSTEM                13.8           6.2            20         31

UNDOTBS01             63.9         161.1           225         72

USERS                 43.5          43.5            87         50

 
1. To know how long statistics available

    select dbms_stats.get_stats_history_availability from dual;

2. exec dbms_stats.purge_stats(sysdate-20);

select dbms_stats.get_stats_history_availability from dual;

*********************************************************

SQL> select dbms_stats.get_stats_history_availability from dual;

GET_STATS_HISTORY_AVAILABILITY
------------------------------------------
14-SEP-15 07.45.26.010132000 AM +05:30


SQL> SELECT owner,

            segment_name, 
            partition_name,
            bytes/1024/1024/1024 Size_GB
      FROM dba_segments
      WHERE segment_name='WRH$_ACTIVE_SESSION_HISTORY';

OWNER  SEGMENT_NAME                   PARTITION_NAME                     SIZE_GB

------ ------------------------------ ------------------------------- ----------

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19681     .094604492

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19729     .066589355

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19777     .079528809

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19825     .068359375

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19873     .105102539

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19921     .029907227

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_19969     .052124023

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_20017      .05456543

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_20065     .040649414

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_20337     .042358398

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_20385      .00012207

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_28730     1.24621582

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_88323     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_88706     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_89090     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_89521     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_89905     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_90289     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_90674     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_91057     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_91537     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_91970     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_92348     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_169052300_92732     .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY    WRH$_ACTIVE_SES_MXDB_MXSN       .000061035

SQL> select min(snap_id) 

    from sys.WRH$_ACTIVE_SESSION_HISTORY 

    partition(&WRH_ACTIVE_NAME);

Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19681

MIN(SNAP_ID)
------------
       19688

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19729

MIN(SNAP_ID)
------------
       19729

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19777

MIN(SNAP_ID)
------------
       19777

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19825

MIN(SNAP_ID)
------------
       19825

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19873

MIN(SNAP_ID)
------------
       19873

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19921

MIN(SNAP_ID)
------------
       19921

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_19969

MIN(SNAP_ID)
------------
       19969

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_20017

MIN(SNAP_ID)
------------
       20017

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_20065

MIN(SNAP_ID)
------------
       20065

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_20337

MIN(SNAP_ID)
------------
       20339

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_20385

MIN(SNAP_ID)
------------
       20385

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_89090

MIN(SNAP_ID)
------------


SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_88706

MIN(SNAP_ID)
------------


SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_88323

MIN(SNAP_ID)
------------


SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_88323

MIN(SNAP_ID)
------------


SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_169052300_28730

MIN(SNAP_ID)
------------
       28791

SQL> /
Enter value for wrh_active_name: WRH$_ACTIVE_SES_MXDB_MXSN

MIN(SNAP_ID)
------------

SQL> select min(snap_id) from WRH$_ACTIVE_SESSION_HISTORY;

MIN(SNAP_ID)
------------
       19688

SQL> select min(snap_id) from dba_hist_snapshot;

MIN(SNAP_ID)
------------
       19688

SQL> select min(snap_id),MAX(snap_id) from dba_hist_snapshot;

MIN(SNAP_ID) MAX(SNAP_ID)
------------ ------------
       19688        92858

SQL> select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19681);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19729);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19777);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19825);

MIN(SNAP_ID)
------------
       19688

00:06:59 SQL> select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19873);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19921);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_19969);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_20017);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_20065);

MIN(SNAP_ID)
------------
       19729

SQL> select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_20337);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_20385);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_28730);
select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_88323);




MIN(SNAP_ID)
------------
       19777



MIN(SNAP_ID)
------------
       19825

SQL>
MIN(SNAP_ID)
------------
       19873

SQL>
MIN(SNAP_ID)
------------
       19921

SQL>
MIN(SNAP_ID)
------------
       19969

SQL>
MIN(SNAP_ID)
------------
       20017

SQL>
MIN(SNAP_ID)
------------
       20065

SQL>
MIN(SNAP_ID)
------------
       20339

00:06:59 SQL>
MIN(SNAP_ID)
------------
       20385

SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_88706);
MIN(SNAP_ID)
------------
       28791

SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_89090);
MIN(SNAP_ID)
------------


SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_89521);
MIN(SNAP_ID)
------------


SQL>
SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_89905);
MIN(SNAP_ID)
------------


SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_90289);
MIN(SNAP_ID)
------------


SQL>select min(snap_id) 

          from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_90674);
MIN(SNAP_ID)
------------


SQL>select min(snap_id) 

          from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_91057);
MIN(SNAP_ID)
------------

SQL>select min(snap_id) 

          from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_91537);
MIN(SNAP_ID)
------------

SQL>select min(snap_id)
          from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_91970);
MIN(SNAP_ID)
------------

SQL>select min(snap_id)
         from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_92348);
MIN(SNAP_ID)
------------

SQL>select min(snap_id)
          from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_169052300_92732);
MIN(SNAP_ID)
------------

SQL>select min(snap_id) from sys.WRH$_ACTIVE_SESSION_HISTORY partition (WRH$_ACTIVE_SES_MXDB_MXSN);
MIN(SNAP_ID)
------------


00:06:59 SQL>
MIN(SNAP_ID)
------------


00:06:59 SQL>

MIN(SNAP_ID)
------------


00:07:01 SQL>

00:07:57 SQL>
00:07:58 SQL>
00:07:58 SQL> select table_name, count(*) 

                          from dba_tab_partitions 

                          where table_name like 'WRH$%' 

                          and table_owner = 'SYS'
                          group by table_name order by 1;00:07:59   2

TABLE_NAME                         COUNT(*)

-------------------------------- ----------

WRH$_ACTIVE_SESSION_HISTORY              25

WRH$_DB_CACHE_ADVICE                     26

WRH$_DLM_MISC                             2

WRH$_EVENT_HISTOGRAM                     25

WRH$_FILESTATXS                          28

WRH$_INST_CACHE_TRANSFER                  2

WRH$_INTERCONNECT_PINGS                   2

WRH$_LATCH                               27

WRH$_LATCH_CHILDREN                       2

WRH$_LATCH_MISSES_SUMMARY                26

WRH$_LATCH_PARENT                         2

WRH$_MVPARAMETER                         13

WRH$_OSSTAT                              25

WRH$_PARAMETER                           25

WRH$_ROWCACHE_SUMMARY                    25

WRH$_SEG_STAT                            25

WRH$_SERVICE_STAT                        25

WRH$_SERVICE_WAIT_CLASS                  25

WRH$_SGASTAT                             25

WRH$_SQLSTAT                             27

WRH$_SYSSTAT                             25

WRH$_SYSTEM_EVENT                        27

WRH$_SYS_TIME_MODEL                      25

WRH$_TABLESPACE_STAT                     25

WRH$_WAITSTAT                            27

25 rows selected.

00:08:00 SQL>

00:08:08 SQL> alter session set "_swrf_test_action"=72;

Session altered.

00:08:11 SQL> select table_name,

                      partition_name 

  from dba_tab_partitions 

  where table_name = 'WRH$_ACTIVE_SESSION_HISTORY';

TABLE_NAME                         PARTITION_NAME

---------------------------------- ------------------------------

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19681

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19729

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19777

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19825

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19873

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19921

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_19969

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_20017

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_20065

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_20337

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_20385

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_28730

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_88323

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_88706----

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_89090

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_89521

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_89905

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_90289

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_90674

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_91057

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_91537

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_91970

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_92348

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_92732

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_169052300_92861

WRH$_ACTIVE_SESSION_HISTORY        WRH$_ACTIVE_SES_MXDB_MXSN

26 rows selected.
SQL> col table_name for a80
SQL> select table_name, 

                     count(*) 

           from dba_tab_partitions 

           where table_name like 'WRH$%' 

           and table_owner = 'SYS' 

           group by table_name order by 1;

SQL>

TABLE_NAME                          COUNT(*)

--------------------------------- ----------

WRH$_ACTIVE_SESSION_HISTORY               26

WRH$_DB_CACHE_ADVICE                      27

WRH$_DLM_MISC                              2

WRH$_EVENT_HISTOGRAM                      26

WRH$_FILESTATXS                           29

WRH$_INST_CACHE_TRANSFER                   2

WRH$_INTERCONNECT_PINGS                    2

WRH$_LATCH                                28

WRH$_LATCH_CHILDREN                        2

WRH$_LATCH_MISSES_SUMMARY                 27

WRH$_LATCH_PARENT                          2

WRH$_MVPARAMETER                          14

WRH$_OSSTAT                               26

WRH$_PARAMETER                            26

WRH$_ROWCACHE_SUMMARY                     26

WRH$_SEG_STAT                             26

WRH$_SERVICE_STAT                         26

WRH$_SERVICE_WAIT_CLASS                   26

WRH$_SGASTAT                              26

WRH$_SQLSTAT                              28

WRH$_SYSSTAT                              26

WRH$_SYSTEM_EVENT                         28

WRH$_SYS_TIME_MODEL                       26

WRH$_TABLESPACE_STAT                      26

WRH$_WAITSTAT                             28

25 rows selected.



 SQL> EXEC DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE( 19688,28791,169052300);

PL/SQL procedure successfully completed.

Elapsed: 00:00:42.79

SQL>  select owner,

                      segment_name,

                      round(sum(bytes/1024/1024),2)MB, 

                      tablespace_name from dba_segments 

             where segment_name = upper('WRH$_ACTIVE_SESSION_HISTORY'
             group by owner,segment_name,tablespace_name;

OWNER  SEGMENT_NAME                           MB  TABLESPACE_NAME

------ -------------------------------   -------  ---------------

SYS    WRH$_ACTIVE_SESSION_HISTORY       1926.13  SYSAUX

Elapsed: 00:00:00.11

SQL> alter table WRH$_ACTIVE_SESSION_HISTORY shrink space cascade;
alter table WRH$_ACTIVE_SESSION_HISTORY shrink space cascade
*
ERROR at line 1:
ORA-10636: ROW MOVEMENT is not enabled


Elapsed: 00:00:00.01
SQL> alter table WRH$_ACTIVE_SESSION_HISTORY enable row movement;

Table altered.

Elapsed: 00:00:00.00
SQL>
SQL> alter table WRH$_ACTIVE_SESSION_HISTORY shrink space cascade;

Table altered.

Elapsed: 00:04:17.55
00:20:31 SQL>
00:24:36 SQL>
SQL> select owner,

                     segment_name,

                     round(sum(bytes/1024/1024),2)MB, 

                     tablespace_name 

           from dba_segments 

           where segment_name = upper('WRH$_ACTIVE_SESSION_HISTORY')
           group up by owner,segment_name,tablespace_name;

OWNER  SEGMENT_NAME                                               MB TABLESPACE_NAME
------ -------------------------------------------------- ---------- ------------------------------
SYS    WRH$_ACTIVE_SESSION_HISTORY                           1026.69 SYSAUX

Elapsed: 00:00:00.13

SQL>

NAME         USED_SPACE_GB FREE_SPACE_GB TOTAL_SPACE_GB     %_FREE

------------ ------------- ------------- -------------- ----------

SYSAUX            16.9          23.1             40         58

SYSTEM            13.8           6.2             20         31

UNDOTBS01         65.5         159.5            225         71

USERS             43.5          43.5             87         50

20 rows selected.

Elapsed: 00:00:00.34
SQL>
SQL>  SELECT owner,
                           segment_name,
                           partition_name,
                           bytes/1024/1024/1024 Size_GB
             FROM dba_segments
             WHERE segment_name='WRH$_ACTIVE_SESSION_HISTORY';

OWNER  SEGMENT_NAME                    PARTITION_NAME                    SIZE_GB

------ ------------------------------- ------------------------------ ----------

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19681    .052368164

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19729    .066589355

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19777    .079528809

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19825    .068359375

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19873    .105102539

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19921    .029907227

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_19969    .052124023

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_20017     .05456543

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_20065    .040649414

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_20337    .042236328

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_20385     .00012207

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_28730    .410217285

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_88323    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_88706    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_89090    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_89521    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_89905    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_90289    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_90674    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_91057    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_91537    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_91970    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_92348    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_92732    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_169052300_92861    .000061035

SYS    WRH$_ACTIVE_SESSION_HISTORY     WRH$_ACTIVE_SES_MXDB_MXSN      .000061035

26 rows selected.

Elapsed: 00:00:00.11
04:03:02 SQL>