Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7098 Views
- I also Faced
- E-Mail Answers
Answer Posted / daid kumar
We find the Information from V$SYSSTAT
And for Increasing The Hit Ratio we hav eto incraese the
Size Of SGA. by Alter System Command and also In init.ora
file
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is a system database and what is a user database? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can you enable flashback feature?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Explain about your sql server dba experience? : sql server DBA
what do you understand by fine-grained auditing?
what is the use of recording information about current session?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is dcl? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
