Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amsu
ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different sql server versions you have worked on? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What purpose does the model database server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you communicate with operating system files from oracle?
what are the performance views in an oracle rac environment?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How do you trace the traffic hitting a sql server? : sql server DBA
