Oracle query archive mode

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 vote169 views1 answer
Max length found in mysql
SQL
0 vote181 views1 answer
Sql select all tables from database change url
SQL
10 votes184 views4 answers
SELECT FROM WHERE
SQL
48 votes284 views3 answers
Psql create database
SQL
3 votes199 views1 answer
Where id is in list sql
SQL
0 vote187 views1 answer
Write SQL in ruby on rails
SQL
2 votes195 views1 answer
How to show the whole table in sql
SQL
1 vote172 views2 answers
Mysql spring boot application.properties
SQL
9 votes221 views4 answers
Oracle get table column names
SQL
1 vote183 views1 answer
Mysql decimal allow negative values?
SQL