Oracle database - Explain how to dump internal database structures posted by
Babu Kunwar
Explain how to dump internal database structures
We can dump the entire internal database structure by dumping the internal files
of the database. The following SQL statements can be used to dump the internal
database files:
Dump control file: alter session set events 'immediate trace name CONTROLF
level 10;
Dump file headers: alter session set events 'immediate trace name FILE_HDRS
level 10';
Dump redo log header: alter session set events 'immediate trace name REDOHDR
level 10';
Dump the system state: alter session set events 'immediate trace name
SYSTEMSTATE level 10';
More links
What are aggregate functions in SQL? What are those functions?
Using ROLLUP to aggregate data in SQL
Define, syntax and an example with output for:SUM function, AVG (average)
function, COUNT function, Max and Min function...............
|
