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 |
Dept wise avrage salary
Explain the Normalized Relations?
Is it good to save image in database?
What is 2-tier architecture?
How is view stored in database?
What is a hierarchical database?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
what is ORACLE CLINICAL What are the uses of Oracle clinical
How do you link a spreadsheet to a website?
What is field in database give an example?
What is difference between database and dbms?
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)