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

1 vote383 views1 answer
Nvl postgres
SQL
0 vote347 views1 answer
Pgadmin see indexes
SQL
1 vote417 views1 answer
Sql server set variable if exists
SQL
0 vote331 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote336 views1 answer
Wordpress sql change site url
SQL
0 vote402 views1 answer
Mariadb cast to int
SQL
12 votes378 views4 answers
How to check mysql version ubuntu
SQL
0 vote363 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote378 views1 answer
Sql drop schema
SQL
0 vote347 views2 answers
Sql max count
SQL