Interested to Buy Any Domain ? << Click Here >> for more details...
How the status of the Rollback segment can be viewed ?
- 1 Answers
- 4711 Views
- I also Faced
- E-Mail Answers
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 |
More Database Management Interview Questions
What is bcnf?
what is Data Definiton Language ?
How big is google's database?
Why do I need netlib?
explain the term ‘attribute’?
What is rdbms data?
What is data types in database?
Is the internet a database?
How to know the Architecture of the Database
What is the use of FILE option in IMP command ?
All questions related to Control m monitoring tool
What is the main difference between union and union all?
Categories
-
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)
