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 vote179 views2 answers
Oracle list partitioned tables
SQL
1 vote335 views1 answer
Import sql file from laravel
SQL
0 vote191 views3 answers
Run sql command line
SQL
0 vote163 views1 answer
What is the essence of SQL?
SQL
2 votes203 views2 answers
Python escape string for sql
SQL
16 votes232 views6 answers
Python sqlite
SQL
0 vote182 views1 answer
Netstat -tln mysql
SQL
0 vote175 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote197 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote168 views1 answer
Mariadb search columns
SQL