Answer Posted / senthil
By this way also you can force log switch:
ALTER SYSTEM CHECKPOINT
FAST_START_MTTR_TARGET="timeSpecification"
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How would you go about verifying the network name that the local_listener is currently using?
What types of replication are supported in sql server? : sql server DBA
what is logical system in sap basis
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Which autogrowth database setting is good? : sql server 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.
What is the default port no on which sql server listens? : sql server DBA
Why would you call update statistics? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What are the steps you will take to improve performance of a poor performing query?
internal architecture
Where would you look for errors from the database engine?
how can you enable flashback feature?
How would you extract DDL of a table without using a GUI tool?