Database Administrator

Security Products Advantages Disadvantages Oracle Database Vault 1. Privileged users such as DBAs can be protected2. Internal Implementation of Oracle, no need to change the application, and flexible installation3. Good control

Hierarchical Query -- Auto-join: treats the same table as a different table using the table alias, and then uses the equivalent and non-equivalent join. Self-connectionSQL> selecte. ename | 'The Boss is '| d. ename 2 from emp e, emp d 3 where e. mgr

Functions in Oracle are similar to functions in C. They are also composed of function names, parameter tables, and return value types. A single-row function has a result for each record. A single-row function can appear after select or in the where

UseSome, anyAndAllProcess the multi-row results returned by the subquery. Next we will briefly introduce the meanings of these keywords. SomeThis indicates that one of the meanings is satisfied.OrThe comparative clause. AnyIt also indicates

When you start ASM after manually writing the ASM parameter file, the following error occurs: ORA-29701: unable to connect to Cluster Manager Through the explanation of the online document, I learned the reason why the CSS service was not added, run

One instance of RAC is found to be abnormal. view the spfile SQL> show parameter spfile NAME TYPE VALUE ----------------------------------------------------------------------------- Spfile string The result value does not contain spfile and is not

Suppose a subprogram declaresINParameter,OUTParameter, andIN OUTParameter. When you call the subprogram,INParameter is passed by reference. That is, a pointer toINActual parameter is passed to the corresponding formal parameter. So, both parameters

Fault description: Check the df-g space on AIX and check that the undo tablespace of the corresponding database has reached more than 90%. The following process the problem of too large data files in the tablespace. -- 1 check the tablespace size

Logical Storage Structure The file corresponding to the logical storage structure cannot be found in the operating system, but the description of the logical storage structure can be found by querying the data dictionary of the Oracle database. The

In the evening, Shidi yy said that he had a table with more than 90 fields, and all the fields should be listed. If you copy them one by one, it would be too much trouble, I wrote a small script. /* Lists all fields in the specified table.

Recently, the project has entered the cut over stage, which is under great pressure and never before. My task is to optimize long running SQL so that it can be completed within three hours. Yesterday, a Long running SQL statement appeared. It ran

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

1. Download necessary resource packages Download the installation package from the official Oracle website and select Version 10.1.0.5. Http://www.oracle.com/technetwork/topics/linuxsoft-082809.html Version 10.1.0.5 Instant Client Package-Basic: All

RDA full name RemoteDiagnostic Agent is a tool used by Oracle to collect and analyze databases. However, the statistical information is far greater than that of databases, it can also be said that the information of an Oracle db server that an

Oracle control statement Logical control statements in Oracle If elsifElse EndIf SetServeroutOn; DeclarePer_dep_count number; Begin Select Count(*)IntoPer_dep_countFromEmp; If per_dep_count> 0Then

A bug occurred in the test. I checked the logs printed by the application and found that the data of the previous day was correct, and the data of the next day was incorrect, the only possibility is that someone directly updates the database during

Environment Oracle 9 Release 2 User sys Test Table Name ATTRIBUTE_TRANSFORMATIONS $ Tables and views in the used data dictionary USER_TAB_COLUMNS: basic organization information of the User table User_constraints: basic user constraint

SQL>Lock table state in exclusive mode; Table (s) Locked. SQL>Insert into state (state_cd, state_name) values ('nm ', 'neimenggu '); 1 row created. SQL>Select * from state; STAT STATE_NAME ---------------------------------- AZ Arizona

I. creation process Create Or Replace ProcedureP_rebuild_all_index(Tablespace_nameIn Varchar2)AsSqltVarchar(200);BeginForIdxIn(SelectIndex_name, tablespace_name, statusFromUser_indexesWhereTablespace_name=Tablespace_nameAndStatus='VALID' And

My colleague said that the query encountered a strange problem. Two tables did not return results after performing the not in operation. Normally, there should be returned results. I. Problem Reproduction In general, the reproduction of the problem