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 |
What is the best database software?
Can we assign Explicitly transaction to a rollback segment
What is environment of openedge?
What does clipper stand for?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What is progress open edge?
What are some of the important security features of a dbms?
From where ENQUEUE resources parameter information is derived ?
What is the difference between indexes,views,synonyms?
What are the different types of modeling?
Explain the necessary techniques to control deadlocks?
What do databases contain?
Oracle (3259)
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)