Oracle query archivemode

query to see if you are in ARCHIVELOG mode:
This can also be queried in Oracel SQL developer.

SQL> archive log list;
SQL> select log_mode from v$database;
+++++++++++++++++++++++++++++++++++++++++
You can also run this UNIX/Linux command 
to see if you are running in archivelog mode.  
If you are in ARCHIVELOG mode, 
you will see rows returned by this ps command:

$ ps -ef|grep -i _arc

Source: dba-oracle.com

Similar codes

3 votes144 views2 answers
How to start postgresql on windows
SQL
0 vote132 views1 answer
Create bdd mysql
SQL
0 vote139 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote128 views1 answer
Mysql command line ubuntu
SQL
4 votes149 views3 answers
Drop Table Oracle
SQL
0 vote128 views1 answer
Call function in query sql server
SQL
8 votes130 views3 answers
Mysql alter table add index
SQL
0 vote143 views1 answer
Oracle date winter time
SQL
0 vote137 views1 answer
Longtext sql
SQL
0 vote141 views1 answer
Soql queries for not contact related account records in salesforce
SQL