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

1 vote153 views1 answer
Change table to innodb mysql
SQL
0 vote155 views1 answer
Porcentaje sql
SQL
0 vote156 views1 answer
Sql update subtract value
SQL
51 votes248 views6 answers
Change column name sql
SQL
17 votes139 views4 answers
Show tables sql server
SQL
0 vote163 views1 answer
Automated psql csv export script on windows
SQL
1 vote151 views2 answers
How to check if sql query is correct online
SQL
3 votes143 views1 answer
Postgresql cast
SQL
0 vote146 views1 answer
Mssql now diff 90 day
SQL
4 votes185 views1 answer
Mysql query first character
SQL