Oracle

Oracle uses flashback to activate the standby as read Wirte (10g and up) environment: Os:centos 6.5 x64db:oracle 10.2.0.5 Main Library Operations:sql> alter SYSTEM switch logfile ; System altered. sql> standby Operation de-archiving application sql>

Oracle 's memory structure is divided into SGA and PGA, which are dynamically allocated for the SGA , by parameter Sga_ The Max_size is configured to be allocated when the Oracle DB instance is started, and for all session connections share a SGA ;

The original database server uses Rman for a full-library backup, and then restores the exact database on the offsite server1.1Original Server Backup DatabaseThe first step is to view the database instance name and DBIDConnected to target

1, if there is a Plsql client, you can use the user login, select all the table right-click Drop.2. If you have permission to delete a user, you can:[SQL]View Plaincopy Drop user user_name cascade; Add the cascade can delete the user

Transferred from: http://database.ctocio.com.cn/tips/286/8104286.shtmlAbout partitioned tables and partitioned indexes (about partitioned Tables and Indexes) are basically divided into several categories for 10GR2: Range (range) partition

The previous article covered the full scan, which will describe the structure and scanning of the index, and will begin to describe each of these scanning methods later.An index scan is performed when Oracle retrieves specific column values for one

Oracle's number of sessions exceeds the limit, typically due to multiple connection sessions established by connect. Workaround:(Oracle login backstage, 1) Sqlplus/nolog 2) Conn/as sysdba)1. View the number of current connection processesSql>select

1. All configurations are the same as the file system . 2. Planning:Added 8 small plates, ASM for experiment using Asmlib Drive (rhel6 no longer supports Asmlib drive), 2 methods for bare devices (Rowdevice and Udev)Three discs using Asmlib, two

Java wants to connect to a database first to introduce a database driver package1 Final StaticString drive = "Oracle.jdbc.driver.OracleDriver";2 Final StaticString Oracleurl = "Jdbc:oracle:thin: @xx. Xxx.xx.xx:1521:orcl";3 Final StaticString dbuser=

People who often write SQL statements should know that the main use of the group BY statement is to do subtotals, the following is one of its most common use methods (according to Department, the position of the respective statistical

Create or Replace function Get_znj (Jfjzrq in Date,Yje in number,ZNJBL in number,ZT in Varchar2,Sjjfrq in Date,Mian_znj in Varchar2,Znj_jmcs in number) return number isV_ZNJ number (14,2);V_date DATE;V_days number;BeginV_znj: = 0;IF ZT V_date: =

One, cold backup 　　 A cold backup occurs when the database has been shut down properly and provides us with a complete database when it shuts down normally. Cold backup is a statement that copies critical files to another location. The fastest and

--Note: This article is for Oracle only and does not have a libraryOne: Put a readhat in the virtual machine 4systemTwo: With IPThe following IP addresses are provided:Three: Build user groups, usersNote: Oracle users should have the same

1. Locate the Oracle installation directory, and then locate the Tnsnames.ora fileModify the relevant file contents:XE =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.107) (PORT = 1521))(Connect_data =(SERVER = dedicated)(service_name =

Background:As a programmer, in daily work, our computers often need to run many programs at the same time, such as Eclipse, browser, Instant messenger, etc., and often need to open several Office documents or PDF documents. At this time your memory

Summary of common oracle commands Here, I would like to summarize some common oracle commands that are often used at work, but sometimes they are always forgotten and hope to be useful. The command is as follows: Cmd or sqlplus connect to

Analysis on the storage format of Oracle nested tables Oracle nested tables are rarely used. The following describes how to store them. For example, a user corresponds to a department. SQL> select * from v $ version;BANNER----------------------------

Cainiao database (6)-enabling and disabling Oracle services conveniently and quickly Background: As a programmer, in daily work, our computer often needs to run many programs at the same time, such as Eclipse, browsers, and instant messaging

One ORA-28000: theaccountislocked user-locked troubleshootingToday, my colleague reflected a problem, a test database modified the password, and changed the password used by the relevant application, still appear after a while the account is locked,

ORA-01552: non-system tablespace & #39; xxxx & #39; do not use system rollback segments ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segmentsFault analysis:The UNDO tablespace data file is damaged, causing the update operation