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

2 votes276 views1 answer
Oracle kill job by sid
SQL
0 vote314 views1 answer
Look at running processes redshift
SQL
0 vote273 views1 answer
Show database not empty tables postgres
SQL
1 vote227 views1 answer
Postgres kill pid
SQL
0 vote290 views1 answer
Oracle list partitions
SQL
3 votes312 views2 answers
Truncate table
SQL
0 vote294 views1 answer
Shrink database file in sql server
SQL
0 vote276 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes302 views3 answers
Row number mysql
SQL
7 votes266 views1 answer
Safe mode mysql
SQL