How the status of the Rollback segment can be viewed ?
- 1 Answers
- 3952 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 big data in database?
When does checkpoint occur in dbms?
What is database example?
How do I keep my database up to date?
How is rdbms different from dbms?
What is the use of COMPRESS option in EXP command ?
Mention a query to add email validation to your database
What is a database in a website?
Explain the key constraints and constraints on Null Values with examples?
Why do we need foreign key?
What are the two types of data independence?
How does distributed database work?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
