Oracle

 View Tablespace usageSelect Upper (F.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space Size (m)",D.tot_grootte_mb-f.total_bytes "used Space (m)",To_char (Round (d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2),' 990.99 ')

Look at the SQL statement first: Merge into employee E using Emps em on (e.emp_id=em.emp_id)When matched then update set E.emp_name=em.emp_nameWhen isn't matched then insert values (em.emp_id,em.emp_name)1. Update the data in the Emps table to the

2016-02-16Relationship Division R÷sRelationship mode R (x, y) S (y,z)Meaning: Querying tuples in R that are related to all tuples in sFirst, create the base table R and SCREATE TABLER (XVARCHAR2(Ten), YVARCHAR2(Ten));CREATE TABLES (YVARCHAR2(Ten),

Original Url;http://www.oschina.net/question/30362_4057?fromerr=fiy27yllAuthor: CrazyinsomniaFirst, the concept of ROWIDStores the location of row in the data file: 64-bit encoded data, A-Z, A-Z, 0-9, +, and/,How row is stored in the data

Turn from: How Oracle writes Efficient SQLTo write efficient SQL statements requires some basic principles, and if you violate these principles, SQL will typically have poor performance.1. Reduce database access timesConnecting to the database is

Install oracle11g to 100% when suddenly stuck, Oracle database configuration assistant, such as:ALT + Tab button appears, template GENERAL-PURPOSE.DBC does not existThis is required two compressed files simultaneously selected together extract to

1. Create user DBA authority to operateCREATE user username (user name) identified by password (password)A user who has created a user name and password that are T11 SQL>CREATEUSER by T1; 2 3 User created.2. Granting permissionsGRANT ROLE to

db:11.2.0.3.0View Oracle's redo log switching frequencyTwo SQL, the principle is the same, the second uses the statistical functionTime Unit: MinutesMethod One,SELECT * from V$log a WHERE a.thread# = 1; Set Line 200Select b.sequence#, B.first_time,a.

Connection query:A connection query is a query that is based on more than one table or view. When you use a connection query, you should specify a valid query condition, or you might cause a Cartesian product to be generated. If the existing

db:11.2.0.30Convert a normal table to a distinguished tableI. Rebuilding a partitioned table using the original tableSql>create table Yoon (ID number primary key, time date);Table created.Sql>insert to Yoon Select rownum,created from Dba_objects;7493

1. The Start command is[Email protected] ~]$ CD $ORACLE _home/bin[Email protected] ~]$/emctl start dbconsoleStop command Yes[Email protected] ~]$./emctl Stop DbconsoleView OEM Status[Email protected] ~]$/emctl status DbconsoleOracle's environment

Set Linesize 132Column name format A30Column value Format A25SelectX.KSPPINM name,Y.KSPPSTVL value,Y.KSPPSTDF IsDefault,Decode (Bitand (y.ksppstvf,7), 1, ' MODIFIED ', 4, ' system_mod ', ' FALSE ') Ismod,Decode (Bitand (y.ksppstvf,2), 2, ' TRUE ', '

[Email protected] ~]# more/etc/oracle-releaseOracle Linux Server Release 5.7Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version

Sql> create Pfile from SPFile;Modify the Pfile file, add the implied parameter *._enable_rename_user= ' TRUE ' to start the database in restrict mode1, [[email protected] ~]$ cd/u01/app/oracle/product/11.2.0/db1/dbs/2, [[email protected] dbs]$

[Translated from mos] Things should be considered before the control file is rebuiltConsiderations before rebuilding Control FilesSource:Things to Consider Before Recreating the Controlfile (Document ID 1475632.1)Applicable:Oracle

[Translated from mos] the TCP port used by the OGGreplicat ProcessTCP port used by the OGG replicat ProcessSource:Tcp port used by replicat processes (Document ID 1060954.1)Applicable:Oracle GoldenGate-Version 10.4.0.12 and laterInformation in this

ORA-600 [KGHLKREM1] problems caused by drop_cache in the configuration of Linux large page memory The ORA-600 [KGHLKREM1] problem caused by drop_cache in the configuration using Linux big page memory Source:ORA-600 [KGHLKREM1] On Linux Using

[Translated from mos] Does the OGG integration capture mode support the Oracledatabase Standard Edition?Does the OGG integration capture mode support the Oracle database Standard Edition?Source:Does OGG 11.2.1 Integrated Capture Work with Oracle

[Translated from mos] Check whether $ ORACLE_HOME is the HOME method of RAC and the Oraclebinary method of relinkRAC. Check whether $ ORACLE_HOME is the HOME method of RAC and the Oracle binary method of relink RAC. Source:How to Check Whether

[Translated from mos] OracleGoldenGate's support for IBM mainframe z/OS2.1 and DB2v11 GoldenGate support for IBM mainframe z/OS 2.1 and DB2 v11Source:GoldenGate Support for z/OS 2.1 and DB2 v11 (Document ID 1941364.1) Applicable:Oracle