Interested to Buy Any Domain ? << Click Here >> for more details...
How the status of the Rollback segment can be viewed ?
- 1 Answers
- 4715 Views
- I also Faced
- E-Mail Answers
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 mechanism provided by ORACLE for table replication ?
What is the 3-tier architecture?
What is implicit cursor in dbms?
Why its better to use files than a DBMS when there are multiple users to access the data
How does notification services work?
Why do we need database management?
Explain fully functional dependency?
what is storage manager?
What is the difference between internal and external schema?
What is the use of SHOW option in IMP command ?
Can you explain the 'between' clause?
How do queries work in a database?
-
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)
