Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
655I have applied the following commands: now what will happen, will the database will give an error / it will work?
594Where 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?
617Post New Oracle DBA (Database Administration) Questions
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
If you are not sure what command does a particular unix function what is the best way to determine the command?
What do you understand by a control file?
Which dba certification is best?
What is a production dba?
What are the beneficial tools for administering the database?
What skills do you need to be a database administrator?
What are some indications that you need to increase the shared_pool_size parameter?
What are the roles and responsibilities of oracle dba?
You see multiple fragments in the system tablespace, what should you check first?
What is ora-1555 snapshot too old error? Explain in detail?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What happens if the constraint name is left out of a constraint clause?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
When configuring sqlnet on the client what files need to be set up?