Oracle

This explains my understanding of the Oracle Network (static listening):650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/57/wKioL1e8W1XhBxylAABNjdsDQZs648.png "title=" Qq20160823221132.png "alt=" Wkiol1e8w1xhbxylaabnjdsdqzs648.png

Database Stop (four modes)1. Normal shutdown: shutdown normal = shutdownNormal user connections are not allowed to establishWait for query to endWait for transaction to endGenerate checkpoints (data synchronization)Close online logs and data

Oracle's analytic functions are powerful, and work is often used over the years. This time, the usual analysis functions are sorted out for later viewing.We learn by taking cases, so it's easier to understand them.1. Build a tableCREATE table

Here's a look at the monitoring configuration in the Oracle network:650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/57/wKioL1e8W1XhBxylAABNjdsDQZs648.png "title=" Qq20160823221132.png "alt=" Wkiol1e8w1xhbxylaabnjdsdqzs648.png "/>How

VARCHAR2 (6) Zhang San--two bytes in JBK, three bytes in UTMCHAR (6) Zhang San--can be used to determine the length of the CharCLOB--large storage, nothing less, when the extra 4000 bytes, will be used to store lob, efficiency is lowerNumber 100.123-

Check whether a table is locked in--oracle to see if the table is lockedSELECT/*+ rule*/A.sid, B.owner, object_name, object_typeFrom V$lock A, all_objects bWHERE TYPE = ' TM 'and a.id1 = b.object_id;--so you can kill it.SELECT sid,serial# from

Batch file (. bat) @echo off Echo ================================================ Automated backup scripts for Oracle databases in the Echo Windows environment Echo 1. Use the current date to name the backup file. Echo 2. Automatically

There are two main analytic functions used in the work, one is sum () over (partition by ... order by ...) The other one is lead (lag) over (|partition By|order by)Sum does not need to say much, mainly by the partition by the field, the total, the

　　1, the database instance: After the database is created there will be a series of memory space for the database service and the acquired process, known as an instance of the database. Each database will have at least one instance for its service.

type char (length) varchar2 (length) number (p,s) date timestamp clob blob

The standard for JDBC to provide access to a database is a series of interfaces that define a common approach to accessing a databaseThe implementation of JDBC is provided by each database vendorDefinition of the JDBC interfaceDatabase

Cascade Delete, such as when you delete a table and then add the keyword, will delete the table and delete the relationship between the tableotherObject1. Cascade delete the information in table A, when the field in table A refers to the field in

CRS Resource in Oracle 10g includes GSD (Global serveice Daemon), ONS (Oracle Notification Service), VIP, Database, Instance and serviceWhen you start the CRS in the 11GR2, you will be prompted that OHASD has been started. So what resources does

These four functions are a bit like the functions in Java, first of allTrunc (Number,[decimals]) This function is similar to the Intercept functionNumber: Indicates that you want to enterDecimals (decimal): Indicates the number of digits you want to

Original: http://www.jb51.net/article/37633.htmNumber (precision, scale)A) precision represents a valid bit in the number, and if no precision is specified, Oracle uses 38 as the precision.b) If scale is greater than 0, indicates the number of

The loadbalance is to distribute the load evenly to each node in the cluster, thus improving the overall throughput capacity. The Oracle 10g RAC provides two different ways to spread the load:1. By connection balancing, the user is assigned to a

Startup Nomount# #启动实例, start the first step, Oracle first look for the parameter file, and then according to the settings in the parameter file (memory allocation settings), create an instance, allocate memory, start a background process, nomount

1. Simple example of stored procedureCREATE OR REPLACE PROCEDUREstored procedure name (parameter in, parameter out) as--variable declarations, with each declaration ending with a semicolon. Can be initialized at the same time as the

--View Log filesSelect member from V$logfile;--View Table space usageSELECT SUM (bytes)/(1024x768 * 1024x768) as free_space, Tablespace_nameFrom Dba_free_space GROUP bytablespace_name; Selecta.tablespace_name, a.bytes total, b.bytes used,

To define sub-typesWe can define our own subtypes in any PL/SQL block, subroutine, or package, with the following syntax:Subtype Subtype_name is base_type[(constraint)] [not NULL];Subtype_name is the name of the declared subtype, Base_type can be