Oracle

1. Direction of DBA Development: Business DBA, architect (course 13, may be the case, but also reference)2, develop good habits: less use of graphical interface, multi-use Sqlplus3. Remember common SQL statements:Size of the query tablespace (the

Only one record of the associated table is exported at the same time as the left connectionWith X as SELEC T1IDfrom DUAL UNIONselect2from DUAL UNIONselect3from DUAL), Y as(SELECT1ID, 1 NR, ' B 'CODE From DUALUNIONSELECT1, 2, ' A '

the recipient has only one of the following procedures:CREATE OR REPLACE PROCEDURE P_mail_sina (sender in VARCHAR2,--SenderRecipient in VARCHAR2,--Receiving personSubject in VARCHAR2,--Email subjectMessage in VARCHAR2) is--Email contentMailhost

1. Log in to the Oracle user, login DBA, display garbled???[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 10.2.0.1.0-production on Tue Jul 22 18:27:40 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.?

Oracle Learning--buffer Cache in-depth analysis650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/40/BE/wKioL1PPVxOwPpjTAAL_LJN_ltc591.jpg "title=" 1.png " alt= "Wkiol1ppvxowppjtaal_ljn_ltc591.jpg"/>Server process and database buffer

First, what is a businessTransactions are used to guarantee the consistency of data, which consists of a set of related DML statements that are either all successful or fail altogether in the group's DML (data manipulation language, additions and

First, management index-Principle IntroductionAn index is a data object used to speed up data access. Proper use of indexes can significantly reduce I/O times and thus improve data access performance. There are many kinds of indexes we mainly

Packages are used to logically combine procedures and functions, which consist of package specifications and package bodies.1), we can use the Create Package command for creating packages such as:I, create a package sp_packageII. Declare that the

First, IntroductionA role is a collection of commands related to permissions, and the primary purpose of using roles is to simplify the management of permissions.Assume that there are user a,b,c in order for them to have the following permissions1.

Data loss during oracle Storage Using date, minute, and second, oracledate Today, a developer called me and said that there was a strange phenomenon. In the stored procedure, values of the date type are lost in minutes, minutes, And seconds. Here is

DBA_Tablespace table space concept and control (concept), dba_tablespace Control 2014-07-24 BaoXinjian I. Summary We know that the oarcle database actually stores data files ); Oarcle tablespaces (tablespaces) are actually a logical concept. They

The host of oraclelistener. ora cannot be set to localhost. Instead, it must be the machine name. Otherwise, it cannot be connected by an IP address. # Listener. ora Network Configuration

Oracle Optimization-double-edged sword Oracle optimization is a double-edged sword. Pay special attention to the use of this sword:OLTP or OLAP Optimization 1: Index During DML operations, indexes must be maintained. If a large number of DML

Role of TNS in Oracle What is TNS? TNS is a part of Oracle Net. It is a tool used to manage and configure the connection between the Oracle database and the client. In most cases, to communicate with the database, TNS must be configured, of course,

[Translated from mos] oracle Password Management Policy Oracle Password Management Policy Reference Original:Oracle Password Management Policy (docid 114930.1) Details:Password Management is created by using profile. After the password expires, if

OracleGoldenGate (ogg) 11.2.1.0.20 is the last ogg version that supports oracledb10g. Reference Original: Oracle GoldenGate 11.2.1.0.22 Patch Set Availability (Doc ID 1669160.1) This article does not translate and only extracts valuable

Common Oracle modification statementsI. Table Test Table: MY_TEST_TABLE -- Create tablecreate table MY_TEST_TABLE( A VARCHAR2(30), B NUMBER(10) default 1, C DATE)tablespace BOSSWG_CFG pctfree 10 initrans 1 maxtrans 255 storage ( initial 64

Oracle batch export AWR reports Work requirement: in the project, all the AWR reports in the production database must be dumped and imported to the database for testing convenience. The AWR report in the test database needs to be exported one by

Oracleimpexp command details How to import dmp database files in oracle? Importing and exporting oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local

ORA-02447: cannot defer a constraint that is not deferrable, ora-02447defer If a constraint is defined as deferrable, the constraints can switch between deferred and imediate states. Deferred is valid only in transaction, that is, it can only