Database Administrator

Recently, the project has been completed (maybe not enough), but a fatal obstacle is performance. Now let's think about how brilliant the TOP author is. The performance runs through various stages such as project requirements, project analysis and

1. Backup File Define fil =/home/Oracle/cdbk. SQLDefine log =/home/oracle/cdbk. logSpool & filPrompt connet sys/sysdba @ asmdemo as sysdba;Prompt shutdown immediate;Select 'host cp' | file_name | '/u01/asmdemo' | substr (file_name, instr (file_name,

First, we use the Linux RedHat 4.6 system. The runtime of mysqlis mysql-5.0.18.tar.gz. The kernel version is as follows: The theoretical content in this article is not explained in detail. It only describes how to install and deploy one machine and

1. Create users and groupsGroupadd-g 700 beaUseradd-u 700-g bea-G dba weblogic-d/home/weblogicPasswd weblogic 2. Create an installation directoryMkdir-p/Oracle/product/9.2.0/bea/Chown-R weblogic: bea/oracle/product/9.2.0 3. Change the configuration

Function call for a client request thread:Handle_connections_socketsCreate_new_threadStart_cached_thread/* Use thread pool */Handle_one_connection/* New thread */Handle_one_connection is the thread function used to process client requests. The core

Create TableMyinfo (myname varchar2 (10), passwdVarchar(10 )); Based on the above table myinfo PL/SQL (procedural language/SQL ):Oracle is an extension based on the standard SQL language. In PL/SQL, You can nest SQL statements, define variables,

The following command was run in the db2 command window today: Db2stop Then, when we enter db2start, an error is returned !!! "SQL1397N failed to log on to the DB2 service" Why is the Instance suspended after it is started? I checked the

In an External table file, if the fields in the file are separated by ctrl + F, the ctrl + F separator cannot be recognized after the Chinese characters, causing an error in External table import, the solution is to add the following content when

1) download the Linux-Generic package of Mysql5.5: http://download.softagency.net/mysql/downloads/mysql-5.5/ I download the license mysql-5.5.17-linux2.6-x86_64.tar.gz.2) Confirm that the installed mysql has been thoroughly uninstalled. For details,

The installation and configuration steps are as follows: Note: The # sign in front of the command line indicates that the account is currently in the root account state. You can switch to the root account by running "$ sudo su-" on the terminal of

Database startup: Nomount: Oracle first looks for the parameter file, and then creates an instance, allocates memory, and starts background processes based on the settings in the parameter file. SQL> startup nomount The ORACLE routine has been

Recently installed a jboss-as-web-7.0.2.Final, now will configure the mysql Data Source process records as follows: 1. Add the Mysql driver File Copy the mysql driver file mysql-connector-java-5.1.18-bin.jar to the/modules/com/mysql/main/directory (/

Go to http://dev.mysql.com/downloads/mysql/5.5.html#downloads: Download the following three files respectively (because my machine is 32-bit, the following is a 32-bit package. If your machine is 64-bit, please download the 64-bit version

Example of Oracle Partition Table usage: Create or replace procedure bl_partition isV_ SQL varchar (1024 );V_count int;V_partname varchar2 (32 );V_startdate date;V_enddate date: = trunc (sysdate) + 1;BeginV_ SQL: = 'select count (*) from user_tables

Due to the recent increase in business volume, the growth rate of tablespaces has become very fast, and customers have begun to worry about the growth rate of tablespaces. Therefore, we also raised the need to monitor the growth of tablespaces on a

Download the Oracle client. The net service name is the same as that of the host database. The host name is the ip address of the host. Remember not to test whether the host listening program is enabled (execute lsnrctl start in the command line ).

To configure automatic archiving for the database (if you configure Oracle installation to use PFILE), add the following log parameter lines to the INIT (SID). ORA file in the $ ORACLE_HOME/dbs directory: LOG_ARCHIVE_START = TRUE LOG_ARCHIVE_DEST =

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 Hardware 8c65g About 74 I/O operations for database queries without lob The database has lob but does not query lob I/O operations about 146. The database has lob and query lob io operations

Method 1/// Query the record serial number and Add 1Public int RecnoSelect (string strSq1) { // Record serial number Int r = 0; String t = ""; OracleCommand cmd = null; Cmd = new OracleCommand (); Cmd. Connection = conn; Cmd. CommandText =

Mysqldump Xtrabackup is a data backup tool for InnoDB. It supports online Hot Backup (which does not affect Data Reading and Writing during Backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup contains two tools: * Xtrabackup-A Tool for