Database Administrator

Oracle claims that the installation of the Oracle9i database in Linux requires at least MB of memory and at least 1 GB or two times of memory swap space. For servers with a system memory larger than 2 GB, the swap space can be between 2 gb-4gb. If

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,

Copy command of SQL * Plus Copying data between data tables is one of the tasks that Oracle DBAs often face. Oracle provides a variety of solutions for this task. The SQL * Plus Copy command is one of them. The SQL * Plus Copy command uses SQL *

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

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

This article describes in detail the initial settings after installing the MySQL database in Ubuntu.1. It should be easy to install MySQL, and I don't think there is much problem in the installation, so I will not talk about it much. Next let's talk

Database Oracle10202, memory 4G, adjust the database sga_target, initially sga_target is 160 M, ready to adjust it to 2147483648, the results of the error ORA-27102, after multiple experiments, it is found that the database is started when

Solution 1:Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to thisMySQL serverThis is because of permission issues. The

Mysql dual-Machine backup method:In Unix, It is/etc/mysql/my. cnf or/MySQL user's home directory/my. cnf. In windows, it depends on the location of the my. ini file you called, and my location is under the mysql root directory. Setting method:Set

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

In Oracle databases, there are at least the following table spaces:1) SYSTEM tablespace. Each database contains a SYSTEM tablespace. When a database is created, the SYSTEM tablespace is automatically created. When the database is opened, the SYSTEM

In Oracle development, the conditional expressions between if and then are full of "art" and require us to discover and appreciate them. Appreciation 1: Three-value Logic If an expression contains a null value, what is the final result of the

Oracle 10 Gb partition tables do not support automated management. Generally, you must manually create and delete partitions. Today, we have a script for automated table space management. This script consists of three parts: sys_ConfigTable. SQL,

Partition index summary: I. Partition indexes are divided into two types:1. global, it must be Prefix. Non-prefix does not exist2. local, which is further divided into two categories:2.1. prefix: the first column of the index is equal to the

In the Oracle RAC environment under VMware, multi-path images of ocr or votingdisk are not enough for shared storage or need to be added to a new shared disk, we can add shared storage through the command line under VMware, and then append these new

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

Non-current online Log File fault recovery 1. ORA-00313 error when starting the database. ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/home/Oracle/oradata/s1/redo01.log' 2. view the v $ log

Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10. * Back up single or multi-table data: Exp user/password @ server file = filefullpathname log = logfullpathname tables = (tablespacename. table1,

The principle of the backup control file is to back up the control file after the physical structure of the database changes. 1. trace: used to control file reconstruction (the generated trace file is in udump)SQL> alter database backup controlfile

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