Interested to Buy Any Domain ? << Click Here >> for more details...
How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 7095 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
how can you initialize log miner?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how does an oracle clusterware manage crs resources?
What is the default port no on which sql server listens? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Where would you look for errors from the database engine?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you process messages in order asynchronously?
What is transparent data encryption? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
