Database Administrator

Dba_indexes and dba_ind_columns are required to view table index information, including the composite index script: WITH nonformat (SELECT I. index_name, I. table_name, t. column_name, t. column_position, I. uniqueness, t. table_owner FROM

Using like '%', Oracle performs a full table scan, which consumes a considerable amount of system resources. This allows you to use full-text retrieval of oracle to increase the query speed. SQL>Select*FromV $ versionWhereRownum = 1; BANNER ---

Recently, when I was working on two sets of AIX5.3 + 10.2.0.4 RAC, I didn't find the AIX Toolbox for Linux Applications for POWER Systems CD. To make it simple, I used RSH as the remote node file copy method. After the database is installed, it is

1. install MySQL database first download MySQL from the MySQL official website, and then enter the directory of the downloaded Installation File, run the following command to install, where the MySQL-server-community-5.1.56-1.rhel5.i386.rpm is just

When you use ROLLUP or CUBE for GROUP operations, fields with NULL values are generated, then, how can we tell whether the field itself is NULL or generated by ROLLUP and CUBE? In this case, GROUPING (groupingfield) can be used to solve the problem.

Recovery Type1. Time-based recovery2. sequence-based recovery3. SCN-based recovery Recovery Process:1. mount the database2. Allocate multiple channels for concurrency3. Restore all data files4. Restore the database with until time, until sequence,

There is a MySQL database with more than 1.1 billion records because of its working relationship. I thought that the query performance of the MyISAM engine would exceed InnoDB. I tried it these two days, but because the data volume is too large, the

How does an Oracle service process user process requests? The server process mainly completes the following seven tasks in the process of completing the user process request: 0. SQL statement Parsing1. Read data blocks into db buffer2. log recording3

Most of the time, the operating system is Windows, and Liunx is rarely understood.During this time, an image system requires that all applications be deployed on the RedHat system. In this way, there are two software usage problems: 1. Database 2.

1. Calculation of the table's occupied space Select S. SEGMENT_NAME, DECODE (SUM (BYTES), NULL, 0, SUM (BYTES)/1024/1024) Mbytes From DBA_SEGMENTS S Where S. SEGMENT_NAME = 'mtl _ MATERIAL_TRANSACTIONS '-- table name And S. SEGMENT_TYPE =

This chapter describes how to configure and manage the Oracle EBS warning system. It is convenient and timely for users or the system to operate databases. Next we will talk about the procedure: 1. Manage the alert system --> System --> OptionThe

This article mainly explains the problem of MySQL optimization in the CentOS system, and describes some basics of MySQL optimization. MySQL optimization is divided into two parts. Physical server hardware optimization and MySQL optimization. The

Outgoing cursor process: Create or replace procedure pub_mes2erpauto_cur_kt (I _flag in varchar2,Res out varchar2,O_cur out sys_refcursor) IsV_class varchar2 (20 );V_classstr varchar2 (100 );V_mmark varchar2 (20 );V_mmarkstr varchar2 (100 );V_mtype

There are two methods to create a database in Oracle. The first is to use Oracle database builder and DBCA, which is a graphical interface and easy to understand because of its friendly and beautiful interface and complete prompts. In Windows, this

RMAN> startup nomount; RMAN> SQL 'alter session set nls_date_format = ''yyyy-mm-dd hh24: mi: s ''";-- Because rman reads the time format using environment variables by default, which is different from the fixed format of sqlplus, you must set the

This article discusses the situations where the index should have been established due to negligence or Incomplete consideration. Select distinct sp. OBJECT_NAME, round (ds. bytes/1024/1024, 2) MB, num_rows, last_analyzedFrom v $ SQL _plan sp, v $

PostgreSQL lists SQL statements in progress SELECT Procpid, Start, Now ()-start AS lap, Current_query FROM (SELECT Backendid, Pg_stat_get_backend_pid (S. backendid) AS procpid, Pg_stat_get_backend_activity_start (S. backendid) AS start,

Use the cursor and temporary table in the MySQL stored procedure: BEGIN DECLAREC_egidINTEGER; DECLAREDoneINT DEFAULT0; DECLAREMy_testCursorCURSOR FOR (SELECTCp. tb_electricGroup_idFROMTb_chargingPoleASCpWHERECp. tb_chargeStation_id = 12 );

1. Glossary and conventions Table space: Provides the logical structure of the space used by the database. Its physical structure is a data file. A table space can contain multiple data files. Local table space management (LMT): a new table space

Solution 1: merge into statement: MergeIntoExcel e Using (SelectEt .*FromExcel_temp etWhereEt. id ='1') Tmp On(E. root_affair_code = tmp. root_affair_code) Note that:OnThe following condition must be that the candidate code in using (tmp in