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 vote124 views1 answer
Oracle index hint multiple tables example
SQL
1 vote127 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote128 views1 answer
Postgresql comandos basicos
SQL
0 vote130 views1 answer
How to print mysql query of codeigniter query builder
SQL
3 votes121 views1 answer
Oracle wait
SQL
0 vote149 views1 answer
Check command
SQL
24 votes134 views4 answers
Mssql get all table names
SQL
0 vote138 views1 answer
Get initial in sql
SQL
1 vote124 views1 answer
Customer using hdfc bank sql query
SQL
0 vote177 views1 answer
Sql server is not
SQL