Database Administrator

How to view the Oracle database lock and unlock -- View database lock details SelectA. sid, B. serial #, B. username, B. oSUSEr, B. machine, B. program, c. object_name, d. spid, Decode (a. type, 'Mr','Media recovery', 'Rt','Redo thread', 'Non'

Add reference: Using System. Data. OracleClient; Here I select an Oracle (Service name (Data Source here is separated from Data Source): GIS user Name (user): gis password (password): gis) your Oracle database has its own name. Please modify it. I

The following describes how to add a disk to an Oracle ASM disk on the Linux platform. 1. Operating System settings 1. Map the storage disk to the server, restart and scan the disk. /Opt/D */bin/dlnkmgr view-lu 2. After scanning a new disk (both

Use log mining to restore accidentally deleted tables, data, and views from incomplete Oracle recovery /*-------------------------- Prerequisites: 1. DB works in archive mode; 2. Prepare cold data files; ---------------------------*/   Col

NULLNoGreater than/less than/equal to/not equal to any value (including NULL itself), with only: NULL IS NULL SQL>SetServeroutput on SQL> SQL> BEGIN 2 IF (2> NULL) 3 THEN 4 dbms_output.put_line ('>'); 5 ELSIF (2 6 THEN 7

If Oracle 11g has not been successfully installed in the AIX system, during the second installation, the Oracle 11gGrid installation software cannot automatically identify the disk because the disk has been written into heap data and data needs to

I. Check the environment 1. Check whether the software package is installed. Binutils-, compat-libstdc ++-, elfutils-libelf, glibc, gcc, elfutils-libelf-devel Glibc-common, glibc-devel, gcc-c ++, libaio, libaio-devel, libgcc, libstdc ++ Libstdc

In Ubuntu 10.10, Qt is used to connect to the Mysql database. The detailed steps are described first. Step 1: Install the qt Development Environment

Because a lot of data is on the Hadoop platform, when migrating data from the hadoop platform to the hive directory, the default delimiter of hive is \, In order to smooth migration, you must specify the data delimiter when creating a table. The

View method: select name, log_mode from v $ database; The Oracle database has a redo log of the connected machine. This log records changes made to the database, such as insertion, deletion, and data update. All these operations are recorded in the

First of all, the environment required for installation is not mentioned in Mysql and Python. MySQLdb is installed. Free in http://linux.bkjia.com/ The username and password are both www.bkjia.com The specific download directory

The master-slave synchronization of MySQL is a mature architecture with the following advantages: ① the query can be performed on the slave server (that is, the READ function we often call) to reduce the pressure on the master server; ② back up data

How does Mysql implement MVCC? There are countless people asking this question, but there is no answer in google. This article attempts to find the answer from the Mysql source code. In Mysql, MVCC is supported in the Innodb Storage engine. Innodb

  ReateOr Replace TriggerTr_insert_emp BeforeInsert OnEmpForEach row Begin Insert IntoAValues(: New. empno,: new. ename,: new. job,: new. mgr,: new. hiredate,: new. sal,: new. comm,: new. deptno ); End;

This morning, the alert. log of erp db suddenly ran out of N multi-ORA-1693 error. ARC1: Completed archiving log 1 thread 1 sequence 343118 Fri Sep 9 09:52:55 2011 ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040

SELECT * FROM TableLIMIT[Offset,]Rows|Rows OFFSET offset The LIMIT clause can be used to force the SELECT statement to return the specified number of records. LIMIT accepts one or two numeric parameters. The parameter must be an integer constant. If

A friend said that the rebuild index reported a ORA-01652 error. And temporary tablespace is large enough. The rebuild index is 6 GB, and the remaining space of indextablespace is 2 GB. Ask a friend to increase the index tablespace by 10 Gb. The

A business table contains the following fields: province name (Csqmc), Province code (Csqdm), city name (Csxmc), and city code (Csxdm ). By selecting the province/region name, city/county names are linked. 1. No Csqmc or Csxmc fields exist in

Today the customer's Oracle 11.2.0.2 database encountered the ORA-600 error. The error details are as follows: Fri Sep 16 15:23:52 2011Errors in file/u01/diag/rdbms/ora1/ora1/trace/ora1_ora_20382140.trc (incident = 169704 ):ORA-00600: Internal error

Paging Query format: SELECT * FROM(Select a. *, ROWNUM RNFROM (SELECT * FROM TABLE_NAME)Where rownum )Where rn> = 21 SELECT * FROM TABLE_NAME indicates the original query statement that does not flip pages. ROWNUM = 21 control the range of each