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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you implement fine-grained auditing?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
who owns the operating system files created by the utl_file package?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Where do you find the default index fill factor and how to change it? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how does an oracle clusterware manage crs resources?
What is transparent data encryption? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What is replication? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba