Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7236 Views
- I also Faced
- E-Mail Answers
Answer Posted / abul kasam topon
we can set db_catch_size using alter system command with
scope spfile sid='x';
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
when does an alert gets signaled?
which background process invoke at the time of upgradation tell me???
how can you process messages in order asynchronously?
internal architecture
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 is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where would you look for errors from the database engine?
how can you communicate with operating system files from oracle?
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
what is the use of recording information about current session?
What are the different types of indexes available in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
how to restore files with rman?
