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 to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How do you trace the traffic hitting a sql server? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
what is grd?
Query processing is slow(eg select query)how will u solve that
How would you extract DDL of a table without using a GUI tool?
What is the default fill factor value? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What authentication modes does sql server support? : sql server DBA
what is the diffrence between core dba and apps 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