Database Administrator

This article describes how to use ASP to display data records in Oracle. I. Introduction Pagination is required when you access a table with a large amount of data through a browser. ASP can display database records by page through the ADO object

Mysql-stadard-5.0.24-linux-i686.tar.gz does not need to be compiled. I installed it in the/usr/local/directory. Two commands 1. tar-zxvf mysql-stadard-5.0.24-linux-i686.tar.gz # extract the mysql-standard-5.0.24-linux-i386 name under the current

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

Oracle kills the deadlock ProcessFirst, check which tables are locked:Select B. owner, B. object_name, a. session_id, a. locked_modeFrom v $ locked_object a, dba_objects BWhere B. object_id = a. object_id;OWNER OBJECT_NAME SESSION_ID LOCKED_MODE-----

After firebird and flamerobin are installed in linux, I am very excited to use create database .. after creating my first FB database file in Linux, I opened flamerobin and planned to do something on it, connect to my database, or check the firebird

1. Go to mysql and create a new user, xuys: Format: grant permission on database name. Table name user @ login host identified by "User Password "; Grant select, update, insert, delete on *. * to xuys@192.168.88.234 identified by "xuys1234 ";

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

1.Mysql -- xml (-X) is used to display MySQL query results in XML format;Mysql -- html (-H) is used to display MySQL query results in HTML format;This output makes it easy to integrate with other programs.(For example, the query results obtained in

Is NULL the same as zero? Of course not. Null indicates that it does not exist or is not sure. 0 indicates no.In the development of the application Hibernate, a problem occurs: a field in the Oracle database (Number type) has no value (that is, NULL)

Two different Oracle database servers read the data of a user under another database server from one database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database. When creating dblink, you need to know

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

Select comm from emp;-- Query the employees with the highest salariesSelect ename, job, sal from emp where sal = (select max (sal) from emp );Select ename, job, sal * 13 + nvl (comm, 0) * 13 s from emp order by s desc;-- Query average salary and

For those who are new to Oracle, especially those who have previous ms SQL server experience, the most confusing thing is probably the word database and instance. In fact, these two concepts are quite simple to understand. Let's take an

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted. 1. Create SequenceFirst, you must have the create sequence

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 $

In Oracle9i, Oracle provides an internal event to force refresh the Buffer Cache. Its syntax is: Alter session set events 'immediate trace name flush_cache level 1 '; Or: Alter session set events = 'immediate trace name flush_cache '; Similarly, you

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This document describes how

Oracle temporary table-ON COMMIT PRESERVE ROWS Temporary tables: they are structured like normal tables, but managed differently. Temporary tables store intermediate result sets of transactions or sessions, the data saved in the temporary table is

This article records some Oracle table access methods For the index access method, see: For the stored procedure of displaying the execution plan, see (1) TABLE ACCESS FULL Scan a table from a full table and access the table through a full table