Database Administrator

A friend asked me how to create a database in Oracle? What is the difference between Oracle and other databases? He has too many problems, and I think his simple explanation can satisfy his curiosity about Oracle, so I wrote this article. (Ps: the

Because of work requirements, you need to install another Oracle instance in a Linux operating system. After receiving help from many netizens, I finally solved the following problems: 1. install a new instanceLog On with the Linux Account Oracle,

Thinkc wrote, "a user named Klaus Keppler submitted a bug report (Bug # April 17) to MySQL at on November 23, 36187 ), the content is in the just release of the mysql-5.1.24-rc binary version has been unable to find ndb and other commands related to

Environment: Linux Prerequisites: Install VSFTPD, MySQL, and PAM_MySQL 1. Add a VSFTPD user[Root @ xxx] # useradd ftpguestAfter a virtual user logs on, the user is located in the/home/vsftpguest directory of vsftpguest. To log on to other

After Linux is installed, mysql is always waiting and cannot be started. Processing: Check the MYSQL Log (/var/lib/mysql/user. err), the most common case is permission issues. That is to say, after the machine is installed and there are no mysql

Installing MySQLdb in Linux still has some problems. If you do not pay attention to it, you may always report an error. Here I will give a brief introduction. First, download the MySQLdb source package, here are:

1. Open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters! (By default, php only allows the maximum size of data to be uploaded to 2 MB, that is, 2048KB. The maximum memory usage of memory_limit is only 128 MB, the

When encountering such a requirement at work, mysql needs to execute a large number of scripts to update the database. After checking the mysql source command, only one script file can be executed. I tried source/sqkdir/*. SQL; No. Mysql cannot use *

It is more practical to sort out some MySQL Chinese garbled solutions. When MySQL is used, Chinese characters are inserted, and garbled characters are often inserted. Are all Chinese characters used? . Most of the reasons for this are Character Set

Anyone who has learned Web development should know ODBC. This Microsoft-Created database connection method makes it easy for a program to connect to the database in Windows, such as Java ODBC to connect MSSQL and Access. To develop a cross-platform

Non-RAC Environment Character Set Modification 1.1 Oracle Character Set Problem Summary 1.1.1 concept of oracle Character Set The oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different

In some cases, if only one query result is known, using LIMIT 1 in SQL statements will increase the query efficiency. For example, the following User table (primary key id, email address, and password ): Create table t_user (Id int primary key

Shell calls the Oracle database Method AddStudent (){LOGPATHFILE =/home/test/user/xxxx/log/bdfWarn. logUID = $1UNAME = $2 UAGE = $3 USEX = $4 Db_user = enter the user name here Db_password = Password Db_server = service name or SID Table =

If the system data is not updated, check the Oracle scheduled task. It is estimated that the task is not executed. The next_date is changed to 4000/1/1, and the broken is selected. Select * from user_jobs: the number of failed tasks of this task

The purpose of Flashback is to roll back the data if you have misperformed the data and submitted it. Some people may say that the backup can be used to restore the system to a previous error, but the correct operation data is also lost. The only

Select SQL _text from v $ SQL where hash_value in (select SQL _hash_value from v $ session where sid in (select session_id from v $ locked_object )) Check Methods for database deadlocks I. Database deadlock When the program is executed, click OK or

Starting from Oracle Database 10 Gb, columns SQL _TEXT and SQL _BIND in DBA_AUDIT_TRAIL are filled only when the initial parameter AUDIT_TRAIL is set to DB_EXTENDED. Oracle uses a large number of different audit methods to monitor which permissions

Recently, we have used PostgreSQL for backend databases in some projects. Due to the need to control the client connection usage type and connections, PgBouncer is used for implementation. The PgBouncer-related basic documentation pgsqldb has many

1. Estimate the execution Plan-Explain Plan The Explain plan uses an SQL statement as the input to obtain the execution plan of the SQL statement and store the execution plan output to the schedule. First, add explain plan for before the SQL

I. Software preparation 1. Oracle linux installation package 2. Putty 3. WinSCP Ii. Operating System Configuration 1. network configuration (red indicates the change content) Cd/etc/sysconfig/network-scripts Vi ifcfg-eth0 The changed file is: DEVICE