how will u see whether the dabase is in archive log mode or not?
Answer Posted / krishna
archive log list
select log_mode from v$database;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what do you understand by fine-grained auditing?
what is the use of recording information about current session?
when does an alert gets signaled?
which background process invoke at the time of upgradation tell me???
What is a system database and what is a user database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Why does Oracle not permit the use of PCTUSED with indexes?
how can you enable flashback feature?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is asm?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How do you trace the traffic hitting a sql server? : sql server DBA