Database Administrator

This article allows you to use eight simple sentences to teach you how to deal with the MySQL database.1. Connect to MYSQLFormat:Mysql-h host address-U User Name-P User Password1. Example 1: connect to MySQL on the local machine:First, open the DOS

This article describes how to optimize your Oracle in Linux through 12 procedures.1. Standard optimization: follow the instructions in the Oracle technical documentation to tune your Linux, such as shared memory. I will not go into details here,

1. IntroductionSince PL/SQL cannot be used to develop applications for common users, you must use other languages or development tools. In Linux, what language or development tool should I use to develop Oracle database applications? This article

In viewing Mysql file operations, it operates on files on different operating systems, in addition to using standard C Runtime library functions, including open, close, seek, etc, the file and directory operation functions under Win32 use CreatFile,

1) The so-called zys font, is-misc-ZYSong18030-, the so-called tlc font, is-tlc-song -. Zys comes with RedHat AS3_U6. You need to download the Turbo Linux font from the Internet, install it, and search for it. The common versions are 1.4-13 and 1.5-1

Structured Query Language (SQL) --- Structured Query LanguageVPD (virtual private database) --- virtual private databaseOAS (Oracle Application Server) --- Oracle Application ServerSynonym --- synonymInstance --- instanceSGA (System Global Area) ---

Especially when I cannot find my. cnf, I should take it seriously.Author: Fan guanqunAfter a few days of desperate Baidu and continuous experiments, I finally solved the problem of Mysql 5.0.22. Online articles are neither too long nor too important,

Deploying multiple MySQL services on the same Linux server can effectively improve machine utilization. In addition, it is safer to classify different content into different services. MySQL provides mysqld_multi, but it is not used in actual

It was installed five times in debian4.0 to securely install Oracle. I have found a lot of information and installation methods on the Internet, and none of them can completely solve the problem. Finally, we can only get the power of the family.1.

After installing Mysql in Linux, You need to perform some configuration.Modify/etc/my. cnf as needed. Refer to the Configuration:[Mysqld]# Set the default value to the INNODB table, which supports transactions and row locks:Default-storage-engine =

Idea: PLSQL depends on OCI. DLL and some other Client files. Therefore, you must provide the. Environment Variable TNS_ADMIN to find LISTENER. ORA and tnsnames. oRA to establish a connection. Steps: 1. Install Oracle_client 2. Go to PLSQL to set the

Trace file:Each service process and background process can write some special information into the corresponding operating system file during the running process. This operating system file is called a tracking file.Each service process and

Solution to ORA-12520 errors The ORA-12520 listener cannot find the available handler for the requested server type: 1) The database is a dedicated server, but the connection mode is set to shared in the tnsname. ora configuration. In this case,

Query statements for all table structures in the PostgreSQL Column SELECT tablename FROM pg_tablesWHERE tablename not like 'pg %'AND tablename not like 'SQL _ %'Order by tablename; Query the field information of the t_appointment_apply

Reference: Doc ID 109095.1 First, create a Java class that calls Unix shellon the database, and use runtime.getruntime(cmd.exe c () to implement 1. Create or replace java source named "CaptureStream"Import java. util .*;Import java. io .*; Class

1. parameterized cursorPurpose: Open the same cursor multiple times and return different result sets. The parameters in the declaration part of the cursor must correspond to the real parameters provided in the OPEN statement (quantity and data type )

The V $ view contains information about the data structure maintained by the kernel in the memory, which can be accessed through a DBA account with the SYS permission. The following is a summary of the recovery-related views: Articles: Oracle

An Oracle 11g database is installed on a Windows server. After running for a period of time, a ORA-12537 error suddenly occurs and the application cannot be connected. Check the alert. log file and find the following error message: Fatal NI connect

Thread pool operation process: The thread pool contains a certain number of thread groups. Each groups manages a certain amount of client connections. when mysql establishes a connection, the thread pool will be cyclically (round-robin fashion)

The default number of connections in Oracle XE seems to be 40. If the process exceeds this number, the request for a connection again will be rejected. 1. Log On with the system user: Sqlplus system/password @ xe 2. Run the following command: