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

0 vote104 views1 answer
Get first monday of month sql
SQL
3 votes97 views1 answer
Oracle user quota unlimited
SQL
0 vote104 views1 answer
Mysql récupérer le code création de vue
SQL
4 votes96 views2 answers
Sql server date now
SQL
0 vote107 views1 answer
Drop view in mysql
SQL
16 votes99 views6 answers
Mysql find and replace
SQL
11 votes110 views2 answers
Insert current date sql
SQL
8 votes102 views1 answer
Oracle find text in functions
SQL
0 vote110 views5 answers
Mode sql course
SQL
0 vote125 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL