How would you go about increasing the buffer cache hit ratio?
- 2 Answers
- 6590 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 is dbcc? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What types of replication are supported in sql server? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are statistics, under what circumstances they go out of date, how do you update them?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is the diffrence between core dba and apps dba?
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.
Why does Oracle not permit the use of PCTUSED with indexes?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what are the differences of where and if in SAS?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain about your sql server dba experience? : sql server DBA
