How the status of the Rollback segment can be viewed ?
Answer / 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 |
Explain types of indexing in dbms?
Explain some of the uses of openedge architect features useful for a developer?
Can two oracle blocks have the same address?
What are the different types of database keys?
Why do not you use gnu autoconf or scons for building?
Which parameters are optional in init.ora parameter file?
Is there some bulk load or other way to import a lot of data fast?
What is hot backup and how it can be taken ?
What is meant by database system?
What are its two major subsystems of r?
Can we save file in database?
How do you start a database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)