Oracle

to see if an Oracle database is in archive mode1.select Name,log_mode from V$database; NAME log_mode------------------------------------------QUERY noarchivelog 2. Use archive log LIST command Database log MODE No Archive Mode Automatic Archival

Guide: Oracle Common Dump command, record for future reference I. Memory dumps 1). Global Area ALTER session SET EVENTS ' immediate trace name Global_area level n '; 1 contains PGA 2 contains SGA 4 contains UGA 8 contains indrect memory 2). Library

Data files and log files are the most important files in the database. They are where the data is stored. Each database has at least one data file associated with it, usually more than one and many. How the data is organized in the data file. To

Backing up with RmanDatabaseThe following error occurred:[Oracle@mzl orcl]$ Rman target/Recovery manager:release 10.2.0.1.0-production on Wed Feb 13 15:36:06Copyright (c) 1982, 2005,. All rights reserved.Connected to target DATABASE:ORCL (dbid=117255

The concept of cursors: A cursor is a memory workspace of SQL that is defined by the system or user as a variable. The role of a cursor is to temporarily store blocks of data that are extracted from the database. In some cases, the data needs to be

The Hsql script for the security ACL is only given on the official document of spring security, but spring did not explicitly give the database creation script and configuration instructions when using the Oracle database. The following are the SQL

For logging's understanding that the table's log is always set to no it will not generate the log, in fact it is not the following are some explanations and experiments for logging. Logging Introduction You can perform the following actions in

Manpower.s_salary 375w record, add field add_sh number (7,2) default 0 1. Excluding the use of the first SELECT P.spid,s.status,s.terminal,s.machine,s.program,s.osuser,s.client_info,s.logon_time from V$SESSION S,V$ ACCESS a,v$process PWHERE S.sid=a.

To use flashback, first start row movement: ALTER TABLE name enable row movement; Recover deleted and submitted data through the SCN 1. Get the SCN number of the current database Select Current_scn from V$database; (Switch to SYS user or System

Java JDBC Connection Oracle Execute Simple query Example: Package com.test.dbtest; Import java.sql.CallableStatement; Import java.sql.Connection; Import Java.sql.DriverManager; Import Java.sql.ResultSet; Import java.sql.SQLException; Import

Oracle TRANSACTION Isolation mechanism Transaction ISOLATION Level: the degree to which a transaction's modifications to the database are isolated from another transaction that is parallel to it. With two concurrent transactions accessing the same

Oracle EBS Newly created user, or from expiration to valid user, login always prompt: There are no active responsibilities available for this user (no valid liability is applicable to this users) In addition, assigning a new responsibility to the

The failover of Oracle Data Guard was described in both previous articles, but there was no systematic explanation, so in this paper, DG's failover is described in a systematic note. The processing of failover redo under physical data

v$session Reference: V$session &v$process The description of each field "reproduced" v$session of Oracle official documents The object described by v$session is a session . The object described by v$session is a currently existing session (not

Http://database.51cto.com/art/201108/280742.htm In the Oracle database , what is a sequence ? What it is used for. A sequence (SEQUENCE) is actually a serial number generator that can automatically generate serial numbers for rows in a table,

In the daily study of the database, we found that the default temporary table space of the company production database is up to 30G, the utilization rate is 100%, and the usage rate is 100% after being adjusted to 32G, which causes the disk space

OverviewBeginning in July, Oracle have transitioned to a more flexible and responsive strategy for the database software R Elease process.  these changes only affect Database and Grid Infrastructure release 12.2 or later. The primary goals of this

Oracle Installation 11g:1. Download Oracle packages via official website www.oracle.com, with 1 and 2 respectively, with two extracted and merged together, for example:2. Attention before installation: Turn off the virus firewall to ensure that the

In connection with the database, sometimes encountered a "ORA12514: Listener currently does not recognize the service requested by the connection descriptor" error, which is actually the database dynamic registration (about dynamic registration will

Vmware Workstation Installing Oracle Solaris 101, open the VMware Workstation, create a new virtual machine, type select "Typical";2, select the system version;3, configure the virtual machine name;4, select the size of the disk;5, configure the CD