Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7151 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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is the use of recording information about current session?
What is the default fill factor value? : sql server DBA
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?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is a correlated sub-query? : sql server DBA
what is asm?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
what are the benefits of flashback feature?
Which autogrowth database setting is good? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how to restore files with rman?
