Oracle

1, the acid characteristics of the transaction: atomicity atomicity, consistency consistency, isolation isolation, durability persistence.2, the operation of the transaction① Transaction Commit sql>commit;   ② Transaction Rollback sql>rollback;     ③

1. View, close, and start the listener1) Use the Lsnrctl command with the status parameter to see if the listener is starting to work$lsnrctl status2) using the LSNRCTL command with the stop parameter, you can shut down the database listener and

An Oracle tablespace is a logical partition where a data file can belong to only one table space, and a tablespace may have multiple data files.In general, if an instance is assigned to more than one app, you need to create a different table space

What is written below is commonplace on the Internet: Plsql Developer connection to Oracle database garbled problem. It's written here purely for personal records.Problems that were encountered last week. Native Win7, with Oracle 11GR2 free

Create a table new_table and old_table table structure (no old_table Records)CREATE TABLE new_table as SELECT * from old_table where 1=0;Create a table new_table and old_table table structure (with Old_table Records)CREATE TABLE new_table as SELECT *

First, back up the original libraryRun{backup database format '/home/oracle/backup/db_%u_%t.bak '; backup current controlfile format '/home/oracle/backup/ Ctl_%u_%t.bak '; backup spfile format '/home/oracle/backup/spfile_%u_%t.bak '; backup

Haven't come up for a long time, do not have a little idle work today, studied the Oracle stored procedure returns the result set.With Oracle staging tables, the use of stored procedures to return data read from a result set can solve the problem of

First, IntroductionThe importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. The environment for this installation

Table data such as: In code as the version of the Group field, the creation time to sort by the latestID NAME CODE Create_time1FFG ABC 001 2014-01-011GFFD KABC 001 2014-01-021HFD LABC 001 2014-01-031GHD ABC 002 2014-01-011FHD KABC 002 2014-01-061FFD

Cache FusionIn practice, it is a block transfer between the SGA in each node of the cluster through the interconnection network, and the benefit is to avoid writing blocks to disk multiple times and re-reading them into the cache of other instances.

Original: Bat Start/Stop Oracle ServiceYour own computer is slow, especially installed oracle10g, service on and off with BAT file operation Easy PointOpen service@echo offnet start ORACLESERVICEORCLnet start ORACLEDBCONSOLEORCLnet start Oracleoradb1

A checkpoint is the writing by the DBWR (database writer), process of all modified buffers in the SGA buffer cache To the database data files. Data file headers is also updated with the latest checkpoint SCN, even if the file had no changed blocks,

Problem: In the development of the system, sometimes we want to be able to limit the front page to the database access behavior, such as in the Oracle database, we use a user-created database table structure, package, view, sequence, so a user has

/configure--with-php-config=/usr/local/php/bin/php-config--with-oci8=shared,instantclient,/usr/lib/oracle/11.2 /client/lib--with-curlTo install several Oracle packages firstoracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpmoracle-instantclient11.

The difference between basic table compression and advanced compression,Excerpt from MOS article difference between Basic Table Compression and Advanced Compression (Doc ID 1548187.1)Suitable for:Oracle database-enterprise edition-version 10.2.0.5

--1 , Last_day function: Find the last day of the month in which the specified date is located select Last_day (to_ DATE ( " 2014-12-02 ' , "Yyyy-mm-dd ' from Span style= "font-size:16px;font-family: ' Microsoft Jas Black ', ' sans-serif '

Data integrity Classification1. Domain IntegrityDomain integrity, also known as column integrity, specifies whether a dataset is valid for a column and determines whether null values are allowed.2. Entity integrityEntity integrity can also be called

SELECTC.*FromAverage_daily_overdraft C,customer_account_information bWHERETo_date (c.year| | C.month, ' yyyymm ') sysdateand To_date (c.year| | C.month, ' yyyymm ') > Add_months (sysdate,-6)And not EXISTS (SELECT * from Average_daily_overdraft a

Generate multiple ADDM reports in OracleI have written an article in Oracle to generate AWR reports in batches. We used to monitor AWR reports every day to eliminate performance risks in a timely manner. Now there is another way to generate an ADDM

Oracle lock table troubleshooting example One time a developer directly runs the delete table operating system on the database server during peak hours, resulting in no response for a long period of execution. Then, the SQLPLUS client is closed and