Funda 1 > Undo - 25th May
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Funda 1 > Undo - 25th May as PDF for free.
More details
- Words: 895
- Pages: 7
sql> sql> select * from v$transaction; no rows selected sql> desc v$transaction name null? type ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------addr raw(4) xidusn number xidslot number xidsqn number ubafil number ubablk number ubasqn number ubarec number status varchar2(16) start_time varchar2(20) start_scnb number start_scnw number start_uext number start_ubafil number start_ubablk number start_ubasqn number start_ubarec number ses_addr raw(4) flag number space varchar2(3) recursive varchar2(3) noundo varchar2(3) ptx varchar2(3) name
varchar2(256) prv_xidusn number prv_xidslt number prv_xidsqn number ptx_xidusn number ptx_xidslt number ptx_xidsqn number dscn-b number dscn-w number used_ublk number used_urec number log_io number phy_io number cr_get number cr_change number sql> desc v$session name null? type ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------saddr raw(4) sid number serial# number audsid number paddr raw(4) user# number username varchar2(30) command number ownerid number taddr varchar2(8) lockwait varchar2(8)
status varchar2(8) server varchar2(9) schema# number schemaname varchar2(30) osuser varchar2(30) process varchar2(12) machine varchar2(64) terminal varchar2(16) program varchar2(64) type varchar2(10) sql_address raw(4) sql_hash_value number prev_sql_addr raw(4) prev_hash_value number module varchar2(48) module_hash number action varchar2(32) action_hash number client_info varchar2(64) fixed_table_sequence number row_wait_obj# number row_wait_file# number row_wait_block# number row_wait_row# number logon_time date last_call_et number pdml_enabled varchar2(3) failover_type varchar2(13) failover_method varchar2(10)
failed_over varchar2(3) resource_consumer_group varchar2(32) pdml_status varchar2(8) pddl_status varchar2(8) pq_status varchar2(8) current_queue_duration number client_identifier varchar2(64) sql> sql> select * from v$session where username='session'; no rows selected sql> select * from v$session where username='sys'; saddr command
sid serial# audsid paddr ownerid taddr lockwait status server
user# username schema# schemaname
-------- ---------- ---------- ---------- -------- --------------------------------------- ---------- ---------- -------- -------- ---------------- ---------- -----------------------------osuser process machine terminal program ------------------------------ --------------------------------------------------------------------------- ------------------------------------------------------------------------------type sql_addr sql_hash_value prev_sql prev_hash_value module module_hash action action_hash ---------- -------- -------------- -------- -------------------------------------------------------------- ------------------------------------------ ----------client_info fixed_table_sequence row_wait_obj# row_wait_file# row_wait_block# row_wait_row# logon_tim last_call_et pdm failover_type failover_m fai ----------------------------------------------------------------------------------- ------------- -------------- --------------- --------------------- ------------ --- ------------- ---------- --resource_consumer_group pdml_sta pddl_sta pq_statu current_queue_duration client_identifier -------------------------------- -------- -------- -------- ------------------------------------------------------------------------------------682115b8 3 2147483644
11
kgisltrust\velusamy kgisliim195 sqlplusw.exe
5 active 3304:3308
0 681e73bc dedicated
0 sys 0 sys
kgisltrust\kgisliim195
user 0 77 1 no none sys_group
66df4f90
3060534714 66df4f90
3060534714 0
-1
none
0
0 no disabled enabled
0 24-may-08 enabled
0
sql> sql> sql> sql> desc v$undostat name null? type ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------begin_time date end_time date undotsn number undoblks number txncount number maxquerylen number maxconcurrency number unxpstealcnt number unxpblkrelcnt number unxpblkreucnt number expstealcnt number expblkrelcnt number expblkreucnt number ssolderrcnt number nospaceerrcnt number sql> select * from v$undostat 2 ; begin_tim end_time undotsn undoblks txncount unxpstealcnt unxpblkrelcnt unxpblkreucnt expstealcnt ssolderrcnt nospaceerrcnt --------- --------- ---------- ---------- --------------------- ------------- ------------- -----------
maxquerylen maxconcurrency expblkrelcnt expblkreucnt ----------- ------------------------- ------------
----------- ------------24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0
1
9 0
26793
1
16 0
26402
1
17 0
25567
1
19 0
24671
1
17 0
23803
1
15 0
22969
1
20 0
22171
1
17 0
21191
1
18 0
20443
1
15 0
19515
1
20 0
18712
1
15 0
17704
1
20 0
17025
1
15 0
16026
1
17 0
15272
1
18 0
14503
1
17 0
13600
1
19 0
12733
17 0
11888
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1
0
0
3
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
2 0
0
1 0
0
1 0
0
1 0
4 0 0
3 3
0 0
4 3
0 0
1 3
0 0
3 2
0 0
3 2
0 0
3 3
0 0
2 5
0 0
3 3
0 0
6
24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
32 rows selected. sql> clear screen sql> spool off
1
19 0
11025
1
15 0
10074
1
20 0
9287
1
16 0
8296
1
16 0
7539
1
18 0
6787
1
16 0
5846
1
19 0
5071
1
16 0
4164
1
19 0
3337
1
18 0
2377
1
17 0
1609
1
21 0
714
3 0 0
3
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
3 0 0
4 3
0 0
3 17
0 0
4 3
0 0
3 2
0 0
1 3
0
varchar2(256) prv_xidusn number prv_xidslt number prv_xidsqn number ptx_xidusn number ptx_xidslt number ptx_xidsqn number dscn-b number dscn-w number used_ublk number used_urec number log_io number phy_io number cr_get number cr_change number sql> desc v$session name null? type ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------saddr raw(4) sid number serial# number audsid number paddr raw(4) user# number username varchar2(30) command number ownerid number taddr varchar2(8) lockwait varchar2(8)
status varchar2(8) server varchar2(9) schema# number schemaname varchar2(30) osuser varchar2(30) process varchar2(12) machine varchar2(64) terminal varchar2(16) program varchar2(64) type varchar2(10) sql_address raw(4) sql_hash_value number prev_sql_addr raw(4) prev_hash_value number module varchar2(48) module_hash number action varchar2(32) action_hash number client_info varchar2(64) fixed_table_sequence number row_wait_obj# number row_wait_file# number row_wait_block# number row_wait_row# number logon_time date last_call_et number pdml_enabled varchar2(3) failover_type varchar2(13) failover_method varchar2(10)
failed_over varchar2(3) resource_consumer_group varchar2(32) pdml_status varchar2(8) pddl_status varchar2(8) pq_status varchar2(8) current_queue_duration number client_identifier varchar2(64) sql> sql> select * from v$session where username='session'; no rows selected sql> select * from v$session where username='sys'; saddr command
sid serial# audsid paddr ownerid taddr lockwait status server
user# username schema# schemaname
-------- ---------- ---------- ---------- -------- --------------------------------------- ---------- ---------- -------- -------- ---------------- ---------- -----------------------------osuser process machine terminal program ------------------------------ --------------------------------------------------------------------------- ------------------------------------------------------------------------------type sql_addr sql_hash_value prev_sql prev_hash_value module module_hash action action_hash ---------- -------- -------------- -------- -------------------------------------------------------------- ------------------------------------------ ----------client_info fixed_table_sequence row_wait_obj# row_wait_file# row_wait_block# row_wait_row# logon_tim last_call_et pdm failover_type failover_m fai ----------------------------------------------------------------------------------- ------------- -------------- --------------- --------------------- ------------ --- ------------- ---------- --resource_consumer_group pdml_sta pddl_sta pq_statu current_queue_duration client_identifier -------------------------------- -------- -------- -------- ------------------------------------------------------------------------------------682115b8 3 2147483644
11
kgisltrust\velusamy kgisliim195 sqlplusw.exe
5 active 3304:3308
0 681e73bc dedicated
0 sys 0 sys
kgisltrust\kgisliim195
user 0 77 1 no none sys_group
66df4f90
3060534714 66df4f90
3060534714 0
-1
none
0
0 no disabled enabled
0 24-may-08 enabled
0
sql> sql> sql> sql> desc v$undostat name null? type ---------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------begin_time date end_time date undotsn number undoblks number txncount number maxquerylen number maxconcurrency number unxpstealcnt number unxpblkrelcnt number unxpblkreucnt number expstealcnt number expblkrelcnt number expblkreucnt number ssolderrcnt number nospaceerrcnt number sql> select * from v$undostat 2 ; begin_tim end_time undotsn undoblks txncount unxpstealcnt unxpblkrelcnt unxpblkreucnt expstealcnt ssolderrcnt nospaceerrcnt --------- --------- ---------- ---------- --------------------- ------------- ------------- -----------
maxquerylen maxconcurrency expblkrelcnt expblkreucnt ----------- ------------------------- ------------
----------- ------------24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0 24-may-08 24-may-08 0 0 0
1
9 0
26793
1
16 0
26402
1
17 0
25567
1
19 0
24671
1
17 0
23803
1
15 0
22969
1
20 0
22171
1
17 0
21191
1
18 0
20443
1
15 0
19515
1
20 0
18712
1
15 0
17704
1
20 0
17025
1
15 0
16026
1
17 0
15272
1
18 0
14503
1
17 0
13600
1
19 0
12733
17 0
11888
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1
0
0
3
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
2 0
0
1 0
0
1 0
0
1 0
4 0 0
3 3
0 0
4 3
0 0
1 3
0 0
3 2
0 0
3 2
0 0
3 3
0 0
2 5
0 0
3 3
0 0
6
24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0 24-may-08 0 0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
24-may-08 0
0
32 rows selected. sql> clear screen sql> spool off
1
19 0
11025
1
15 0
10074
1
20 0
9287
1
16 0
8296
1
16 0
7539
1
18 0
6787
1
16 0
5846
1
19 0
5071
1
16 0
4164
1
19 0
3337
1
18 0
2377
1
17 0
1609
1
21 0
714
3 0 0
3
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
0
1 0
3 0 0
4 3
0 0
3 17
0 0
4 3
0 0
3 2
0 0
1 3
0
Related Documents
Funda 1 > Undo - 25th May
November 2019 7
Funda 1 > Man_database - 25th May
November 2019 4
Funda 1 > Table Space - 25th May
November 2019 2
Funda 1 > Regologs - 22 May
November 2019 5
Funda 1 > Redolog - 21 May
November 2019 4