Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7057 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
Why does Oracle not permit the use of PCTUSED with indexes?
What is a correlated sub-query? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Which autogrowth database setting is good? : sql server DBA
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?
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.
What the different topologies in which replication can be configured? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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.
what are the differences of where and if in SAS?
What are the commands used in dcl? : sql server DBA
how can you communicate with operating system files from oracle?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
