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

3 votes664 views1 answer
Postgresql cast
SQL
0 vote355 views1 answer
Find largest table in mysql database
SQL
9 votes369 views5 answers
Sql delete duplicate rows but keep one
SQL
4 votes350 views1 answer
Select nls_date_format
SQL
0 vote431 views1 answer
Mysql get nth highest
SQL
0 vote334 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
-2 votes355 views3 answers
Sqlite reset autoincrement
SQL
0 vote307 views1 answer
Oracle sysdba connect as another user
SQL
0 vote344 views1 answer
Mysql remove tabs from string
SQL
9 votes347 views4 answers
Last mysql
SQL