Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
28 Cards in this Set
- Front
- Back
Name 3 main physical structures
|
-datafiles
-redo log files -control files |
|
Name 5 main logical structures, in order from largest to smallest
|
1. tablespace
2. schema object 3. segment 4. extent 5. data block |
|
How many segments does a non-partitioned schema object hold?
|
one
|
|
Name seven kids of schema objects
|
-tables
-indexes -views -procedures -Java-stored procedures -object tables -sequences |
|
What is an extent?
|
a contiguous group of data blocks that are assigned to a segment
|
|
Can an extent belong to multiple segments?
|
No
|
|
Can a segment hold multiple extents?
|
Yes
|
|
Can a database block belong to multiple extents?
|
No
|
|
Can an extent hold multiple data blocks?
|
Yes
|
|
What determines the name of a segment?
|
It is the same as the name of its parent schema object
|
|
How are extents named?
|
They do not have specific names.
They are numbered sequentially starting at zero for each segment |
|
How are blocks named?
|
They do not have specific names.
They are numbered sequentially starting at zero, relative to their position in the datafile. |
|
What component is the intersection of the logical and physical structures?
|
Data blocks. They exist within extents in the logical structure, and within datafiles in the physical structure.
|
|
How are segments and datafiles related?
|
There is no direct correlation. A segment can be spread among several datafiles as long as the datafiles belong to the segment's tablespace.
|
|
What are data blocks made of?
|
One or more operating system blocks, depending upon the size of each type of block.
|
|
What is the physical difference between locally-managed and dictionary-managed tablespaces?
|
Locally-managed tablespaces have a bitmap in their header containing info about free space, used space and location of extents. Dictionary-managed tablespaces maintain this data in the data dictionary tables.
|
|
What is the minimum extent size the system can set?
|
64Kb
|
|
What is the minimum extent size for uniform extents?
|
1Mb
|
|
What happens if you haven't created any temporary tablespaces?
|
The SYSTEM tablespace is used to store temporary segments, which can degrade performance.
|
|
Should transactional data have large or small data block sizes?
|
large
|
|
Should static data have large or small data block sizes?
|
small
|
|
What three methods can be used to take a tablespace offline, and how do they affect data and recovery?
|
-NORMAL: performs a checkpoint on each datafile. No recovery is needed.
-TEMPORARY: performs a checkpoint on all AVAILABLE datafiles. Recovery will be needed for the bad datafile. -IMMEDIATE: no checkpoint attempted. Media recovery will be required... using backup, archives and redo logs. |
|
What are the two most useful data dictionary views of storage data?
|
DBA_TEMP_FILES
DBA_DATA_FILES |
|
Explain coalescing
|
Free extents can be coalesced (brought together into one) when they are adjacent to one another.
|
|
What are the uses of undo data?
|
-"redoes" the original data if the user issues a ROLLBACK command.
-provides read consistency for users accessing the table during a pending update -in db recovery, if redo log entries change data that had not been officially committed, the undo data is applied to replace the changed data with the original data |
|
What is contained in the bdump directory?
|
background process trace files and the alert log
|
|
What is contained in the cdump directory?
|
memory state core dump trace files at the time of a database crash
|
|
What is contained in the udump directory?
|
trace files of user sessions/connections to the db
|