Database Administrator

In Oracle, The OBJECT_ID in the following table is the same as that in DATA_OBJECT_ID. However, the expression of DATA_OBJECT_ID after truncate changes. This feature can be used to determine whether the table has been truncate. Note: (database link,

Installing Oracle in linux is usually a headache, If we only want to deploy CMS, there is no need to have a detailed understanding of Oracle parameters. Is there a way to simplify the installation process? The following is an sh script executed in

#/U01/app/Oracle/oraInventory/orainstRoot. shChanging permissions of/u01/app/oracle/oraInventory to 775.Changing groupname of/u01/app/oracle/oraInventory to oinstall.The execution of the script is complete#/U01/app/oracle/product/10.2.0/db_1/root.

Oracle is divided into archive and non-archive modes. The difference between the two is the redo log processing. In archive mode, when a redo log is fully written, the content in the redo log is written to the archive file. After the redo log is

We all know thatOracleEach entrySQLThe statement must be parsed before execution, which is divided into soft parsing and hard parsing. InOracleThere are two typesSQLStatement.DDLStatement(Data Definition Language)They are never shared, that is, each

Create a listening port (using Oracle Net Configuration Assistant and Oracle Net Manager to create and start using commands. Both methods have been tried ). Create a local service name and use tnsping. However, when creating a service name, the

I made a small modification to the eclipse project today and found that the previously running project is always stuck today. I started to think that the database has not closed the connection, leading to connection congestion, later, I took a

Each MySQL database directory contains a file db. opt, which is mainly used to store the default Character Set and character verification rules of the current database. Eg. default-character-set = latin1Default-collation = latin1_swedish_ci This

1. Compile and install the first MySQL 5.1.33Cd/opt/Usr/sbin/groupadd mysql/Usr/sbin/useradd-g mysql-s/bin/nologin-d/usr/local/mysqlTar-zxvf mysql-5.1.33.tar.gzCd mysql-5.1.33/. /Configure -- prefix =/usr/local/mysql/-- enable-validator --

// Question:ID NAME------------11 Wang2 Zhao// Result:ID NAME--------1Wang2 Zhao// Solution 1:With t (Select 1 id, 'zhang 'name from dual union allSelect 1 id, 'King' name from dual union allSelect 1 id, 'lil' name from dual union allSelect 2 id,

// Connect to the database$ Conn = mysql_connect ("localhost", "root", "123456 ");// Select a databaseMysql_select_db ("test", $ conn );// Start ErrorMysql_query ("start transaction ");// Add a master table$ InsertStudent = "insert into student

First, download an Oracle 11 GB package from the oracle official website (it indicates that you try to package all the development packages when installing CentOS 5.5, so that you will install fewer packages when detecting the installation package,

Recently, the company bought a video conferencing software, but only the operating system provided by the company (CentOS 5.2 x86), and there is no graphical interface, which makes me very depressed. Since there is no graphic interface environment,

The details are as follows:Note the relationship between new. attribute and old. attribute and source table and view attributes.[Root @ me root] # su postgresBash-2.05b $ psql-E-h me.linux.edu.cn mydb1* ******** QUERY **********BEGIN; SELECT

First, let's talk about basic operations. This is not related to java. It only talks about mysql operations, but also about Windows operations, which are roughly the same in linux. 1. If mysqldump is used, you need to install the mysql server. If

Install Oracle 10gR2 RAC on aix. If raw is used for storage, hacmp (PowerHA) is required for shared storage.For 10gR2, Oracle only supports hacmp 5.3 or later versions, and has different requirements for each specific version.1. hacmp 5.3.The

1. Change the password Because no password is used by default, you can change the password for security first: Stop mysql first /Etc/init. d/mysql stop -- Start in Safe Mode[Root @ mysql var] # mysqld_safe -- skip-grant-tables &[1] 10912[Root @

Install mysql 5.5.13 in rhel4// Author: guojin. chenI. rpm Installation1. Prepare the package:MySQL-server-5.5.13-1.rhel4.i386.rpmMySQL-client-5.5.13-1.rhel4.i386.rpm2. check whether there are any old mysql versions.Rpm-q mysqlIf yes, it will be

I have been creating a database manually using bare devices in Oracle 10 Gb. Today I try to create a database manually using bare devices in oracle 9i, but after some trouble, finally, the solution is solved. The detailed record is as follows. I

SQL tuning focuses on the filter information. The developer sends an email asking me to optimize the following SQL Hi Robinson, Kindly need your help to check the below SQL for performance issue with Hyper plan detail report. Thanks in advance.