how will u see whether the dabase is in archive log mode or not?
Answers were Sorted based on User's Feedback
Answer / kittu
in two ways we can check
1) archive log list
2) select log_mode from v$database;
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
What would you use to improve performance on an insert statement that places millions of rows into that table?
How to start SQL Server in minimal configuration mode?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Explain an ORA-01555
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
Which autogrowth database setting is good? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you communicate with operating system files from oracle?
i had backup last manday.now i need back monday to now ..how do get backup?
How would you determine who has added a row to a table?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)