Oracle

Oracle DBA Common Queries–1. Querying the system for all objectsSelect owner, object_name, Object_type, created, Last_ddl_time, timestamp, statusFrom Dba_objectsWhere Owner=upper (' Scott ')–2. View all system tablesSelect owner, TABLE_NAME,

Database backup recovery, patrol needs to focus on the object settings:1. Database name, and dbid;--dbid in V$database[email protected]>select dbid,name from V$database;DBID NAME---------- ---------1385095721 ORCL2. Control the location of the

Cont.: http://blog.csdn.net/bisal/article/details/389191813. Autotrace SwitchOpen the autotrace switch in sqlplus to get the SQL execution plan.From the tip you can see that Autotrace has several

DeclareV_rowcount integer;V_rowcount1 integer;V_rowcount2 integer;BeginSelect COUNT (*) into V_rowcount from dual where exists (SELECT * from colwhere tname = Upper (' Bailcalcinfo ')and CNAME = upper (' operator_no '));If V_rowcount = 0 ThenExecute

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: =

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 =

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