Oracle

Action class Using System;Using System.Data;Using System.Configuration;Using System.Data.OracleClient;Using System.Text;Using System.Windows.Forms;Using System.Xml;Using Transactions;DB Summary description written by Luos.luo, the creator of

Characteristics of Oracle TransactionsACID, an abbreviation for the four basic elements that a database transaction performs correctly. Contains: atomicity (atomicity), consistency (consistency), isolation (isolation), persistence (durability). A

In the afternoon, a table structure was exported from the production library to test for some problems, because the production library is connected to a table under other users, so by simulating it locally through the view, the view is

Transferred from: http://www.cnblogs.com/ebs-blog/archive/2011/07/28/2167232.html1. What is PSU/CPU?Cpu:critical Patch UpdateOracle releases security patches once a quarter for its products, often to fix security concerns in the product.Psu:patch

There are more and more databases that need to be migrated. How to measure the database performance before and after has become a difficult point. This article uses the AWR Compare report to solve this problem.The following are test library

1. Generate a single-instance AWR report:@ $ORACLE _home/rdbms/admin/awrrpt.sql2. Generate the Oracle RAC AWR report:@ $ORACLE _home/rdbms/admin/awrgrpt.sql3. Generate an AWR report for a specific DB instance in the RAC environment:@ $ORACLE

In an earlier essay, "How Oracle implements a one-stop operation for creating databases, backing up databases, and importing data exports" provides a rough overview of backup and restore operations for Oracle databases, and this article wants to

We've talked about the construction of Oracle 11G Dataguard in the front, and the 10G build is similar. However, Oracle 10G does not support standby openEnvironment: Role Host Name Ip Database version Operating

Basic EnvironmentUse two HP DL580 servers as RAC nodes, storage using IBM V7000. The specific environment is as follows: Equipment Use IP Address Disk space HP DL580 RAC Node 01 rac01-pub:116.1.

64-bit operating systems are commonly used at the PC end, 64-bit operating systems are better than 32-bit performance, but not as compatible as 32 operating systems, Oracle offers 64 and 322 versions, and Plsql tools are only 32 bits. In this

naming Conventions for table and column names :Must start with a letterMust be between 1-30 characterscan only contain a-z,a-z,0-9,_,$,#Cannot duplicate user-defined other objectsCannot use Oracle's reserved wordsPre-created conditions:CREATE Table

first, the new database1. Create a new database. 1.1 Open the Database Configuration Assistant;1.2 Select New Database, Next, choose the first "general purpose or thing processing";1.3 Give the database a name, which is the unique identifier. (the

Oracle Create serialization:CREATE SEQUENCE seq_itv_collectionINCREMENT by 1--add a few each timeStart with 1399-counting starting from 1Nomaxvalue--Do not set the maximum valueNocycle--keep accumulating, not loopingCACHE 10;Oracle Modified

Recently when performing performance tests, the developer directly hung all the business tables into the Oracle database because of the space data to be mounted. Several recent tests have found that the response time and throughput are not ideal,

The example given below for writing text file or Csv Using Text_io Package from a tabular block in Oracle Forms. Suppose there is a tabular grid data block ' job_history ' in your forms ' and you ' want to ' write a CSV on click of a button by

Recently, when working on a table, you need to sort by date, and the Date field has two formats.Format one: 07-aug-2015Format two: 10/28/16Date conversions and formatted SQL statements:SelectTo_date ('07-aug-2015','dd-mm-yyyy','nls_date_language =

How the Oracle command prompt appears as a user nameFor example: Sqlplus/as sysdba After the command prompt is sys>Fang Yi: Temporarily modify the sqlplus configuration variableSql> Show User--The output is the current user, take the SYS as an

1. View all table space sizessql> Select Tablespace_name,sum (bytes)/1024/1024 from Dba_data_files Group by Tablespace_name;2. The size of the table space that has been idlesql> Select Tablespace_name,sum (bytes)/1024/1024 from Dba_free_space Group

The query parameter is provided in EXPDP, which can be used when you want to export part of the data in a table conditionally, as if it were used in the Where condition in the SELECT statement.Database version[Email Protected]>select * from

The original Oracle reset sequence begins with a specified number of methodsResets the Oracle sequence starting with the specified numberDeclareN Number(Ten); V_startnum Number(Ten):=10000001;--starting from how muchV_step Number(Ten):=1;--Step