Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle generate sequence of numbers 
Sql :: SQL Hello, [firstname] [lastname] 
Sql :: oracle rolling back transactions 
Sql :: oracle sql date summer time 
Sql :: SQL INNER JOIN With AS Alias 
Sql :: oracle database table to check invalid login attempts 
Sql :: sql server: how to assign value to table variable returned from function 
Sql :: sql server split string and insert into table select 
Sql :: for row in sql database python loop 
Sql :: trigger stock phpmyadmin output message 
Sql :: modify xml in sql server 
Sql :: oracle list subpartitions 
Sql :: conectar base de datos mysql con java 
Sql :: sql change date time from SGT to GMT 
Sql :: watch mysql command line 
Sql :: Sql select by content lenght 
Sql :: mysql convert charset 
Sql :: fonction stockée pl/sql 
Sql :: sql interview query questions 
Sql :: Laravel SQLSTATE[HY093] with array query 
Sql :: java mysql date format 
Sql :: IN from in sql 
Sql :: != not working in mysql 
Sql :: sql create table with references not primary key 
Sql :: python sqlalcahmey compare datetime using AND_ or OR_ 
Sql :: nth max in my sql 
Sql :: postgresql regular expression special characters 
Sql :: SQL Copy Table Schema Only 
Sql :: Monthly Birthday SQL Query 
Sql :: laravel How to find the password of mysql on desktop docker in laravel 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =