|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE parameter we can optimize the size of ... Latest Answer : these r the extents which indicates data was not stored in the segment. ... Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into A free extent is a collection of continuous free blocks in tablespace. When a segment is dropped its extents are reallocated and are marked as free. Free extents cannot be merged together in Ver 6.0.Free extents are periodically coalesces with the neighboring free extent inVer 7.0 We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of free space for row updation in future) Latest Answer : A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parametersa.pctused b.pctfreesuppose pctused=40 ... To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage. Latest Answer : 1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment. ... It will try to fit the transaction in a cyclic fashion to all existing extents. Once it found an extent is in use then it forced to acquire a new extent (No. of
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
