Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
562I have applied the following commands: now what will happen, will the database will give an error / it will work?
503Where 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?
527Post New Oracle DBA (Database Administration) Questions
What is the difference between a database and instance?
As an oracle dba what are the entire unix file you should be familiar with?
How do you install statspack?
How do I become a data manager?
What file will give you oracle instance status information? Where is it located?
What database block size should I use?
What should a dba know?
What is explain plan and how is it used?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What do you understand by recovery catalog?
What are types of data model?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What does >> do?
What is the difference between raid 5 and raid 10? Which is better for oracle?
If you see statistics that deal with "undo" what are they really talking about?