Oracle 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

0 vote198 views1 answer
Get number of rows in every table mysql
SQL
0 vote199 views2 answers
Sql having multiple conditions
SQL
0 vote357 views1 answer
How to find the most occuring in SQL
SQL
0 vote242 views1 answer
Mysql command line top 10
SQL
0 vote183 views1 answer
Get who is hired in month in sql
SQL
0 vote196 views1 answer
Sql server order by nulls last
SQL
0 vote197 views1 answer
Csv to sqlite python
SQL
0 vote210 views2 answers
Plsql function that return a table
SQL
0 vote194 views1 answer
Sql remove last x char
SQL
0 vote244 views1 answer
Sql server datetime
SQL