Database Administrator

I want to monitor a Job. The session is in the Library cache lock wait state. The database has two nodes.SQL> select inst_id from gv $ instance; INST_ID----------21 SQL> select inst_id, sid, serial #, event, p1raw, machine, status from gv $ session

I. MySQL index type Mysql currently only supports four types of indexes: full-text, B-tree, hash, and r-tree. B-tree indexes should be the most extensive indexes in mysql, except for archive, which is supported by almost all storage engines. 1.

Ps-ef | more # view system processes in linux and use the more command to paging (press the space key to flip the page) Ps-ef | grep Oracle # view processes of Oracle users in Linux Sqlplus/nolog # log on to sqlplus Conn/as sysdba # Log On as A

In the Oracle PL-SQL, left and right connections can be implemented in the following way: Statement segment: Select modelname, TABLENAME FORM EMCD_MONITOR_MODEL, EMCD_MONITOR_TABLE WHERE EMCD_MONITOR_TABLE.MODELID (+) = EMCD_MONITOR_MODEL.ID

1. Create oinstall, dba, and quota groups2. Oracle users 3. system parameter optimization (aio has been dynamically configured in AIX 6L and does not need to be configured. Running rootpre. sh to warn aio problems can be ignored) 4. Check the system

The new features of R12 Multi-Org Access Control (MOAC). Oracle have the following benefits:1. enable users to access to secured data in one or more Operating Units from a single responsibility2. End-Users can access/transact data within several

1. Block Cleanout description Previous test references: Effece ITL (Interested Transaction List) Description OracleBlock scn/commit scn/cleanout scn description Block clean out refers to changing the data in a block from dirty to clean. It is

View the time of the current database Select sysdate from dual To export data in expdp, you can specify flashback_time For example, HP-UNIX server export: Expdp test/test DIRECTORY = EXPDP_DIR dumpfile = hyomswas20151114.dmp logfile = hyomswas201

Scott is a demo user who helps you learn how to use Oracle The hr user is an example user. It is generated after "Sample Database" is selected during database creation. It is used to simulate the database of the Human Resources Department. SYSDBA is

The latest MySQL versions require cmake compilation and installation. It is estimated that this method will be used in future versions. Therefore, we will record the installation steps and procedures for your reference. Note:The latest toolkit has

Sequence: A sequence is a SEQUENCE number generator. It can automatically generate a SEQUENCE number for rows in a table and generate a set of equal-interval values (numbers ). Its main purpose is to generate the table's primary key value, which can

1. Copy the driver package \ product \ 10.2.0 \ db_1 \ jdbc \ lib under the Oracle directory to copy the ojdbc14.jar file to the lib directory under the tomcat directory; 2. server in the tomcat conf directory. insert the following code in

1. Configure the listener for the Oracle server Modify the listener. ora and tnsnames. ora files in the /network/admin/directory. WhereThe listener file is roughly as follows:# Listener. ora Network Configuration File:/oracle/app/product/10.1.0/db_1/

1. query all users -- select * from dba_users 2. query all roles -- select * from dba_roles 3. query user _ role -- select * from dba_role_privs 4. query user _ system permissions -- select * from dba_sys_privs 5. query user _ object permissions --

1. unlock a user. If the user is not unlocked when the database is installed, the user can be unlocked in sqlplus, for example: First use sys to log on, and then use alter user account unlock; 2. desc table nameTip: varchar2 () supports

Use shell to call sqlplus to access Oracle for direct execution. However, when you use crontab for calling, sqlplus is not considered as a valid command because the environment variable does not take effect. Note: Oracle users used for

A table is designed in PowerDesigner15, and you want to connect to Oracle through PowerDesigner, and then generate the table directly in the database. Set the connection options according to the methods provided on the Internet, and click the test

The business problem can be roughly described as follows: A parent table and a sub-table, the query result is to find the records in the sub-table that do not use the parent table id. In this case, it is estimated that many systems will be involved.

Add in tnsnames. ora: (the host ip addresses are all vip addresses) RAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.221) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.222) (PORT = 1521 )) (LOAD_BALANCE =

SID is used to distinguish different instances of the same database on the same computer. SID and Oracle_HOM are hashed together to allocate a unique key name to SGA. The ORACLE database server consists of two parts: the physical database and the