The Link For Document : Here
Thank you
Osama mustafa
For the people who think differently Welcome aboard
The Link For Document : Here
Thank you
Osama mustafa
The Benefit of Using Temp Undo Tablespace :
SQL> show parameter TEMP_UNDO_ENABLED;
NAME TYPE VALUE
———————————— ———– ——-
temp_undo_enabled boolean FALSE
SQL> alter session set temp_undo_enabled=TRUE ;
Session altered.
also you set this parameter on database level :
SQL> alter system set temp_undo_enabled=true;
System altered.
SQL> show parameter temp_undo_enabled ;
NAME TYPE VALUE
———————————— ———– ——-
temp_undo_enabled boolean TRUE
View Related to temp undo tablespace :
SQL> desc V$TEMPUNDOSTAT;
Name Null? Type
—————————————– ——– —————————-
BEGIN_TIME DATE
END_TIME DATE
UNDOTSN NUMBER
TXNCOUNT NUMBER
MAXCONCURRENCY NUMBER
MAXQUERYLEN NUMBER
MAXQUERYID VARCHAR2(13)
UNDOBLKCNT NUMBER
EXTCNT NUMBER
USCOUNT NUMBER
SSOLDERRCNT NUMBER
NOSPACEERRCNT NUMBER
CON_ID NUMBER