Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
572I have applied the following commands: now what will happen, will the database will give an error / it will work?
515Where 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?
539Post New Oracle DBA (Database Administration) Questions
What is the dba role in oracle?
What is oracle log switch?
What are the different responsibilities of a dba?
How to drop an oracle database?
How do you prevent output from coming to the screen?
How do you put database is archivelog mode, explain procedure?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
What is a dba?
I am getting error "no communication channel" after changing the domain name? What is the solution?
what does the no logging option do? Why would we use it?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct 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 is ora-1555 snapshot too old error? Explain in detail?
What are the beneficial tools for administering the database?
What is pct free/pct used/pct increase parameter in segment?