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 vote322 views1 answer
Sql datum formatieren
SQL
2 votes138 views1 answer
Oracle find unusable indexes
SQL
1 vote215 views1 answer
How to select the nth row in a SQL database table?
SQL
19 votes219 views5 answers
Mysql between date range
SQL
0 vote126 views1 answer
List MySQL Table and Index Size
SQL
0 vote219 views1 answer
Site:av.ru "files"
SQL
0 vote151 views1 answer
Sql select min row
SQL
0 vote149 views1 answer
Hex string sql becomes int64
SQL
0 vote143 views1 answer
Create table in dbms cmds
SQL
0 vote156 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL