Database Administrator

After mysql is installed, the default character set is latin1. Installing mysql in linux is not like installing mysql on windows. You can select a character set (even if the default character set is used at the time, you can modify my. but it is not

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

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

Due to a problem with the stability of Fedora 14 in my current version, I decided to change it to Ubuntu 10.10, just because I had used this version for a while and felt that it was superior in performance, stability is also good (for the linux

1. Install CentOS 5 and disable selinux (you can enable selinux after installing Oracle)System-> Management-> Security Level and firewall-> Selinux-> disable 2. Check the installed software: rpm-qa | grep xxxxxBinutilsCompat-libstdc

Environment: Root@www.bkjia.com ~ # Lsb_release- LSB Version: core-3.1-ia32: core-3.1-noarch: graphics-3.1-ia32: graphics-3.1-noarchDistributor ID: CentOSDescription: CentOS release 5.5 (Final)Release: 5.5Codename: Final 1. Download and install

In many cases, you need to reference data other than the table to be updated in the expression. Like SQL server provides the update from clause, it can connect the table to be updated with other data sources. Although only one table can be updated,

Ora-28056The following error occurs during database connection: ERROR:ORA-28056: failed to write audit records to Windows Event Logs Solution: You have cleared the records under the application in the Event Viewer (run-eventvwr) (you can export

Oracle login uard is so disgusting that it took so long ~ Next I will introduce the simplest installation method ~ 1. First, install two oracle databases with the same directory (you can select different directories). Because I use a VM, it is

0. database parameter attributesCol PROPERTY_NAME format a25Col PROPERTY_VALUE format a30Col DESCRIPTION format a100Select * from database_properties; Select * from v $ version; 1. Find the SID of the current session, SERIAL #SELECT Sid, Serial #

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,

Replication: Copies executed statements or datasets from the master server to one or more slave servers to synchronize databases between multiple database servers. MySQL's built-in replication capability is the foundation for building large,

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, I was working on an Oracle database system under RHEL 5 to store the recording data of the cluster. The database driver is odbc, here is a simple record of how odbc is installed and configured. 1. Install ODBC Download

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

Sqlplus system/system @ orcl -- connect SQL> ed a -- create SQL textSQL> get a -- load a. SQL into the cacheSQL>/ Create temporary tablespace sa_temp -- temporary tablespaceTempfile 'e: \ dbf \ sa_temp.dbf'Size 10 mAutoextend on; Create tablespace

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.