What Are Different Views Dba Uses? Which Script Will Create Them?

1.	What Are Different Views Dba Uses? Which Script Will Create Them?
Answer» We use data dictionary views to LOOK into PERMANENT information about the DATABASE and dynamic performance views to get ongoing ACTIONS in the database. Both the views will be created after database creation USING catalog.sql script. We use data dictionary views to look into permanent information about the database and dynamic performance views to get ongoing actions in the database. Both the views will be created after database creation using catalog.sql script.

Answer»

We use data dictionary views to LOOK into PERMANENT information about the DATABASE and dynamic performance views to get ongoing ACTIONS in the database. Both the views will be created after database creation USING catalog.sql script.

We use data dictionary views to look into permanent information about the database and dynamic performance views to get ongoing actions in the database. Both the views will be created after database creation using catalog.sql script.

Discussion

No Comment Found

Related InterviewSolutions

What Is A System Change Number (scn)?
What Is The Main Purpose Of Checkpoint In Oracle Database? How Do You Automatically Force The Oracle To Perform A Checkpoint?
What Happens When We Fire Sql Statement In Oracle?
What Is The Use Of Large Pool, Which Case You Need To Set The Large Pool?
What Does Database Do During The Mounting Process?
What Are Log File States?
What Are Bind Variables?
What Is Difference Between Oracle Sid And Oracle Service Name?
What Is The Difference Between Data Block/extent/segment?
What Is The Difference Between Pga And Uga?

What Are Different Views Dba Uses? Which Script Will Create Them?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment