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 |
Define atomicity and aggregation.
Who is communication horizons?
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
How do I create a database?
What is " group by " clause?
What is Data Redundancy and Consistency ?
What is dbms architecture?
Is it possible to declare or create a cursor for update of table? If no tell me why?
Explain the Logical Schema of Database
What is Restricted Mode of Instance Startup ?
Explain issues for database performance.
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)