How would you go about increasing the buffer cache hit ratio?
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
How do you open a cluster administrator? : sql server DBA
who owns the operating system files created by the utl_file package?
Why would you use sql agent? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you enable flashback feature?
what do you understand by flashback feature of oracle?
what is a crs resource?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is logical system in sap basis
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is the diffrence between core dba and apps dba?
What are the commands you'd issue to show the explain plan for "select * from dual"?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?