Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7243 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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why would you use sql agent? : sql server DBA
how can you record information about current session?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
. 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?
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 are the performance views in an oracle rac environment?
how to restore files with rman?
what functionality does oracle provide to secure sensitive information?
what is the role of dip user in our database?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what are the types of connection load-balancing?
what do you understand by flashback feature of oracle?
