Database Administrator

The deepest cause of all deadlocks is resource contention. This article provides an example to illustrate this problem. Symptom 1 One user A accesses Table A (Table A is locked), then table B is accessed, and another user B accesses table B (Table B

I haven't used Oracle for a long time. I almost forgot to install an oracle9i today. I used svrmgrl to start the service. Then I found out after I checked it online, svrmrl is the startup method of oracle8. It will be different after oracle9i. Alas,

Password Complexity is an important aspect for IT auditors to check whether a system is secure. IT policies often point out that the password should have a minimum length and contain a mix of uppercase letters, lowercase letters, numbers, and

Log On As an Oracle user.1. Unzip the 9206 patch installation package$ Unzip p3948480_9206_solaris64.zip2. Set the environment variables ORACLE_HOME and ORACLE_SID.$ ORACLE_HOME =/opt/oracle/db01/app/oracle/product/9.2.0$ ORACLE_SID = ORCL$ Export

Now there is a Linux server with Oracle installed on it. We want to use the conn/as sysdba statement to log on to the database and manage the database. However, there is always an error, the error such as Service Name cannot be found. What is the

The procedure is as follows:Software environment:1. Windows 2000 + Oracle 8.1.62. ORACLE installation path: C: \ ORANTImplementation Method:You can use the following statement:Select user_name, SQL _textFrom v $ open_cursorWhere sid in (select sid

When I write a query condition, the problem is as follows:For example, if I want to write all records whose fields contain the word "Li ",? $ Str = "Li ";Select * from table where field like '%? $ Str % ';In addition to records containing the word

In the application, the system prompts you to provide reference information to help you use the system correctly. However, when running Oracle form, the prompt information of the information line at the bottom of the screen is in English. When more

Install MySQL in CentOS5Create a mysql user group and user[Root @ centos] # groupadd mysql[Root @ centos] # useradd-g mysql[Root @ centos] # cd homexule[Root @ centos] # chmod 755 mysql-5.0.22.tar.gzCompile and install MySQL[Root @ centos] # tar

In many cases, we need to terminate all Oracle processes ). When the database is "locked" and you cannot enter Server Manager to terminate the database, you can use the kill command in UNIX to terminate all Oracle processes. This is one of the

Oracle trigger query statistics table This project requires a hands-on drill to achieve the desired effect. It is roughly the same number of data inserted in the statistical table and the current data insertion time. Use row-level triggers +

This morning, a stored procedure has been written for many times. It can be easily written, reported for various errors, various confusions, and searched on the Internet, I did not mention the ending answer provided on the Forum. Let's take a look

System: LINUX 5.6-64Database Version: 11.2.0.2The following error occurs during Automatic SQL tuning of Oracle:Thu Jan 10 22:00:02 2013Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_ SQL _TUNING_TASK"Thu Jan 10 22:02:39 2013

I. background When we question the slow execution of an SQL statement, and then try to improve the possibility. We often need to check the execution plan corresponding to this SQL statement. This article describes how to obtain the execution plan in

Purpose: Do not memorize scripts. You can use them without having to understand the meaning of the view.Including: V $ SYSTEM_EVENT/V $ SESSION_EVENT/V $ SESSION_WAIT/V $

This type has never been met before. I learned that someone asked me yesterday and I only studied it.Later, we found that the Oracle Data dictionary used this data type in many places, such as the addr field of v $ process.What type is this? I have

SQL * Plus: Release 11.2.0.1.0 Production on Mon Feb 18 15:42:14 2013 OS: Linux node 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux Due to application requirements, some user passwords cannot expire, and

When online backup is performed, the output is modified to dynamically upload the output content to the browser page.   Import java. io. BufferedReader;   Import java. io. IOException; Import java. io. InputStream; Import java. io.

In the database O & M process, Shell scripts provide great convenience for O & M. The passing of shell script parameters as variables to SQL and SQL scripts is also a common situation for DBAs. This article mainly discusses how to pass parameters of

Oracle Auto-start configuration in Linux (I) modify the value of/etc/oratab to Y. [Root @ Rocky ~] # Cat/etc/oratab Orcl:/u01/app/oracle/product/10.2.0/db_1: Y (Ii) Modify ORACLE_HOME_LISTNER of dbstart to point it to $ ORACLE_HOME [Root @