How the status of the Rollback segment can be viewed ?
Answer Posted / guest
select SEGMENT_NAME,
OWNER,
TABLESPACE_NAME,
SEGMENT_ID,
FILE_ID,
BLOCK_ID,
INITIAL_EXTENT,
NEXT_EXTENT,
MIN_EXTENTS,
MAX_EXTENTS,
PCT_INCREASE,
STATUS,
INSTANCE_NUM
from dba_rollback_segs
order by SEGMENT_NAME
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between case version and decode version?
What is data independence and also explain its types?
What is entity and its types?
What are good databases?
What is data management process?
Explain dml compiler?
What is metadata and why should I use it?
What is the largest component of a database?
How to find the size of database?
What is the biggest advantage of rdbms?
Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com
Can we store images in database?
What are the different types of keys in database?
What are dml and ddl statements?
What is delimiter in dbms?