Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 6658 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed
in DMT data dictionary tables stores the information of free and used extents, for used extents information in dmt tablespace uses sys.uet$ view and free extents information in DMT tablespace stored in sys.fet$
in LMT tablespace, tablespace datafiles maintains own bitmaps @ datafile headers these store the used extents and free extents information.
LMT is preferable, because it won't generate any rollbacks,
dictionary contention is reduced, space wastage removed & fragmentation removed
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kittu
tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed
In dictionary managed tablespace oracle will take care of tablespace
In locally managed tablespace we need to take care of tablespace
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the difference between dropping a database and taking a database offline? : sql server DBA
How would you determine the time zone under which a database was operating?
What is dcl? : sql server DBA
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the importance of a recovery model? : sql server DBA
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What would you use to improve performance on an insert statement that places millions of rows into that table?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What the different components in replication and what is their use? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What are the commands you'd issue to show the explain plan for "select * from dual"?
-
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)
