103 pages found, pages 1 to 10
http://www.databaseskill.com/2958388/    Similar Pages
... View v $ FAST_START_SERVERS: SQL> select pid, state, undoblocksdone from v $ fast_start_servers; PID ... select pid, state, undoblocksdone from v $ fast_start_servers; PID STATE UNDOBLOCKSDONE on --------- ... restored SQL> select sid, event, wait_class from v $ session_wait s where s.EVENT not in ('SQL * Net ...
http://agstamy.blogspot.de/2011/11/parallel-transaction-recovery-and-smon.html    Similar Pages
... from v$session s, (select * from v$process  where pid in (select pid from v$fast_start_servers)) p  where ... involves index block or when you querying the V$FAST_START_SERVERS you find only one server to be working then ... instances) : 1) Find SMON PID select pid, program from v$process where program like '%SMON%'; 2) on SQLPLUS ...
http://yong321.freeshell.org/oranotes/ParallelRollback.txt    Similar Pages
... describes). This parallel slave has an entry in v$px_process and v$process, and is a real Windows thread in ... session in v$session. It hangs around for about 5 minutes and exits. But the entries in v$fast_start_servers ... 1 CPU. But I always see only 1 process in v$px_process. v$sysstat shows all 0's for name like '%arallel%' ...
http://mkjay.wordpress.com/2013/08/02/mview-complete-refresh-and-atomic_refresh-parameter/    Similar Pages
... -9 '||spid||' ' from V$process where pid in (select pid from V$FAST_START_SERVERS); 'KILL-9'||SPID||'' ... 12-SEP-2009 02:52:36 SQL> select * from V$fast_start_servers; STATE UNDOBLOCKSDONE PID ... 06-JUL-2009 17:58:03 SQL> select * from V$FAST_START_SERVERS; no rows selected Using serial recovery ...
https://mkjay.wordpress.com/2013/08/02/mview-complete-refresh-and-atomic_refresh-parameter/?share%3Demail    Similar Pages
... -9 '||spid||' ' from V$process where pid in (select pid from V$FAST_START_SERVERS); 'KILL-9'||SPID||'' ... 12-SEP-2009 02:52:36 SQL> select * from V$fast_start_servers; STATE UNDOBLOCKSDONE PID ... 06-JUL-2009 17:58:03 SQL> select * from V$FAST_START_SERVERS; no rows selected Using serial recovery ...
http://www.iselfschooling.com/Online_Oracle_Training/04_Advanced/03_Articles/lesson16.html    Similar Pages
... * FROM v$fast_start_ transactions;   The V$FAST_START_SERVERS view Use the V$FAST_START_SERVERS view to ... transaction recovery. SQL> SELECT * FROM v$fast_start_servers;   The DBA_ENABLED_TRACES view Use the ... recovery by SMON? Q: How do you use the V$FAST_START_SERVERS view to display historical information about ...
http://www.perfvision.com/info/undo.html    Similar Pages
... there state query: select * from v$fast_start_servers; Column STATE shows the state of the ... parallel transaction recovery. You can check V$FAST_START_SERVERS to find these. 4. Turn off fast_start_ ... the database the v$transaction entry is lost, so you cannot estimate by examining v$transaction.used_ublk ...
http://serdarturgut.blogspot.de/2010/05/oracle-rollback-undo-monitoring-tips.html    Similar Pages
... l,cputime,rcvservers FROM v$fast_start_transactions; v$fast_start_servers provides information about ... can select detailed  information     from  v$fast_start_servers  view  if rcserver=1  means  FAST_START ... finishing time. SELECT USED_UREC FROM V$TRANSACTION; Also  we  can use  v$session_longops OPNAME column =' ...
http://danielwestermann.com/2014/08/    Similar Pages
... progress of this recovery is to use the v$fast_start_servers and v$fast_start_transactions views. small ... slave(s) doing recovery: select * from v$fast_start_servers; STATE UNDOBLOCKSDONE PID XID ----------- ... adding devices to ASM ouch: CTAS truncated in v$sql and v$sqlarea RSS Links RSS - Posts RSS - Comments ...
http://oracle.vdafa.com/2010/09/rollback-of-large-transaction-by-smon.html    Similar Pages
... that Oracle is recovering in Parallel. v$fast_start_servers: provides information about all the recovery ... recovering completed, there is no row in view v$fast_start_servers and no row returning from "select ktuxesiz ... There are two views to identify the undo recovering: v$fast_start_transactions: contains one row for each ...
Next Results