Explain how to dump internal database structures

          

Explain how to dump internal database structures


Oracle database - Explain how to dump internal database structures posted by Babu Kunwar
<<Previous   Next>>

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';



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
More links
Oracle displaying & aggregating data

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...............

Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring