Database Administrator

The WITH clause is the content of the SQL-99 standard and is introduced in Oracle9.2. The WITH clause can be used to name subqueries. When a subquery is used in multiple places, you can directly use the query name. Subqueries named by this clause

Stored Procedures in Oracle: /* Create a storage function and return the name, salary, and annual income of the specified employee. */ Create or replace function queryEmp2 (eno in number, empname out VARCHAR2, empsal out NUMBER) -- Returns the

Today I encountered a very serious problem... I installed a database of MySQL5.5.18 under CentOS6, but later I found that crontab was not installed.Yum install vixie-cron crontabsBut the following exception is reported:

Now Oracle 11G has gradually matured, But oracle 10g is still king. Recently, many people on the Internet have not very familiar with rman catrman, so I hope to write it down to help them. Oracle's rman backup data includes: Catalog Database is a

OS: aix5DB: 9.2.0.8The customer needs to restore the production database to the development and testing environment through RMAN, restore data files, control files and related archive files through RMAN, and then start to recover the database, the

SQL> select * from v $ log;   GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM ------------------------------------------------------------------------------------------- 1 1 2 52428800 1 yes active 464602 07-SEP-12 2 1 3

A MySQL cluster is a technology that applies a memory database cluster in a SNA (Share Nothing Architecture) system. This non-shared architecture can make the system use low-cost hardware to obtain high scalability. A MySQL cluster is a distributed

Recently, a large volume of data in Oracle tables needs to be deleted due to slow queries and updates. It is found that the query speed after deletion is still very slow. It turns out that the high watermark of delete oracle has not declined. In

Basic Application of a function 1. Create a function (in the SQL window) Create or replace function get_hello_msgReturn varchar2BeginReturn 'Hello world ';End get_hello_msg; The function must have a return value. The return value of this function is

Test environment:System: LINUX-64Database: 10.2.0.1Two-node RAC: RACDB1, ASM used by RACDB2 Storage (1) Insert data without submittingRACDB1> insert into xuhm. test3 values (4, 'A '); There is an active transaction.RACDB1> select usn, xacts from v $

An error occurred while creating pfile in your environment today. Environment: OS: 11.2.0.2 RAC, OS: RHEL 5.6 Create pfile, reporting ORA-01565 this is because spfile cannot be found.[Oracle @ 11rac1 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.

System: openSUSE 12.1 x86_64Database: Oracle 10g r2 (10.0.2.0.4) 64-bit1. Check if the operating system fails:Modify SuSE-release under/etcAll values of 12.1 are modified to 9.0. 2. decompress the cpio.gz FileDecompress the fileMethod 1:Zcat lnx_920_

(1) After the Oracle Database Console is started, 1) The database instance has no information. 2) The Listener is in the unavailable state. 3) the proxy connection status to the instance is unavailable. Problem analysis: the service has just started

Because the system front-end uses the OpenLayers framework, the background database uses Oracle spatial. We all know that the SDO_GEOMETRY of Oracle spatial is very complicated. If you use java APIs for a long time, you will have to deal with a lot

This article describes how to use SQL profile to bind the correct execution plan. 10gR2 is quite practical. Of course, baseline can be used for 11 GB, Of course, I think both of them are quite good. We may often encounter some big tables, such as

Version: Tested on R12.0.6/R12.1.1 Note: Adjust the GUEST user password according to the specific environment. The default password is Oracle. The password of the GUEST user can be found in the $ CONTEXT_FILE file: View $ CONTEXT_FILE 51 52 GUEST 53

Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days [11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracle SQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012 Copyright

Oracle table management-how to create a table-------------------------------------------------------Create a tableStudent tableSQL> create table student (Xh number (4), -- Student IDXm varchar2 (20), --- nameSex char (2), --- genderBirthday date, ---

Dynamic listening: When an Oracle instance is started, or the command alter system register is used, or every minute, the PMON process dynamically registers with the listener. the instance_name and service_names parameters in ora dynamically

Currently, complex "Hot swappable" systems and Service-Oriented Architecture (SOA) have been widely used, making it increasingly difficult to reasonably integrate data. Although your primary application database runs on the Oracle database, there