RSS Feed for Oracle DBA interview questionsCategory: Oracle DBA interview questions

Oracle DBA Interview Questions Part 1 »

| 0 Comments |

If a table space shows excessive fragmentation what are some methods to defragment the table space? (7.1,7.2 and 7.3 only)
In Oracle 7.0 to 7.2 The use of the ‘alter session set events ‘immediate trace name coalesce level ts# command is the easiest way to defragment contiguous free space fragmentation. The ts# parameter corresponds to the [...]

Oracle DBA interview questions »

| 0 Comments |

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Multiple extents in and of themselves aren?t bad. However if you also have chained rows this can hurt performance.
How do you set up tablespaces during an Oracle installation?
You should always attempt to use the Oracle Flexible Architecture standard or [...]