Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
alter system switch logfile
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
what are the performance views in an oracle rac environment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is a correlated sub-query? : sql server DBA
how can a session indicate its interest in receiving alerts?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
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.
what is a user-defined lock?
Which autogrowth database setting is good? : sql server DBA
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
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.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how can you create a user-defined lock?
What are the commands used in dcl? : sql server DBA
