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 vote259 views1 answer
Shortcut run sql pgadmin
SQL
0 vote179 views1 answer
Table values functions in SQL
SQL
0 vote193 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote185 views2 answers
Drop table if exists test
SQL
27 votes217 views6 answers
Sql update record
SQL
0 vote214 views1 answer
Reindexing all tables sql server
SQL
-1 vote197 views1 answer
Mysql delete duplicate rows except one
SQL
8 votes179 views1 answer
Oracle all_source package body
SQL
0 vote164 views1 answer
Mql5 list all available symbols
SQL
2 votes181 views1 answer
Postgresql create schema in specific database
SQL