Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
No Answer is Posted For this Question
Be the First to Post Answer
What is a database instance?
How does one create a new database?
Who is dba in dbms?
As an oracle dba what are the entire unix file you should be familiar with?
Explain the wait events in statspack report 'db scattered read'?
Which process writes data from data files to database buffer cache?
How long does it take to learn database administration?
Are database administrators in demand?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What do you understand by the term 'normalization'? Explain the various modes of normalization?
How do you install statspack?