Database Administrator

New Features of ASE12.5.0.31. Performance Monitoring System TableA new set of system performance monitoring system tables. Using the information in these system tables, It is very convenient to analyze the performance of the ASE server. These

Creating user groups in the operating system is an effective way to ensure database security. Oracle programs are generally divided into two categories for security purpose: one class can be executed by all users, and the other class can only be

There has always been such a problem in ms sqlserver. the SQL server status is "questionable". Let's first analyze the reasons for the SQL Server database "beyond doubt: 1. The deletion log is incorrect; 2. Hardware (HD) damage, resulting in log and

: ERROR: checking for C compiler default output... configure: error:C compiler cannot create executables$ Sudo apt-get install libc6-dev: ERROR: configure: error: C ++ preprocessor "/lib/cpp" fails sanity check$ Sudo apt-get install cpp g ++: ERROR:

When you connect to a MySQL server, you should usually use a password. The password is not transmitted in plain text on the connection. All other information is transmitted as text that can be read by anyone. If you are worried about this, you can

The main reason is that the Code in Hacking Linux Network Stack was not compiled in 2.6.22 yesterday and the member nh cannot be found, I guess the struct must have changed. Check/include/linux/skbuff. h and find that the original combination of h,

By default, MySQL search is case-insensitive (however, some character sets are always case-sensitive, such as czech ). This means that if you use col_name LIKE 'a % 'for search, you will get all columns starting with a or. If you want to make the

How to start MySQL in Linux: (this document uses the installation of MySQL in/usr/local/mysql as an example)#/Usr/local/mysql/share/mysql. server startNote that before the first execution, mysql. server to be executable (chmod 744 mysql. server). In

I. Formal method (officially recommended by mysql ):MySQL mysqldump is used for export. The basic usage is as follows:Mysqldump [OPTIONS] database [tables]If you do not specify any tables, the entire database will be exported.Run mysqldump -- help

Using MYSQL for database backup has a very regular database backup method, which has the same concept as other database servers, but have you ever thought about it, mySQL will have a simpler backup method using the file directory, and it will be

If the Linux Kernel Parameter settings are inappropriate or unreasonable, Oracle may also encounter errors, such10 GB:SQL> startup;ORA-27102: out of memoryLinux-x86_64 Error: 28: No space left on device11g RAC error:SQL> startup;ORA-00845:

Initially Oracle database installed on HP-Unix, and later to test the port to the Windows platform, test other items are not a problem, and later found a asp.net write program is not accessible, an error prompt ORA-12641: the verification service

When CentOS 6.2 64-bit Oracle 11g is installed, check package cannot pass. In fact, this problem occurs in 11g. It is estimated that this problem will occur in earlier versions of oracle, the 64-bit and 32-bit packages of the corresponding package

Because after Oracle shares the SQL statements, the intercepted SQL statements contain variables. Create a function jy_getsql to obtain the complete SQL statement during execution. Create or replace function jy_getsql (my_ SQL _id in

1. in Oracle open mode, the datafile file is directly deleted from the OS. Rm/u02/rmants. dbf 2. After the database is closed, the database cannot be opened and can only be mounted. SQL> alter database open;Alter database open*ERROR at line 1:ORA-

1. monitor recovery progress1.1 view the activity status of a process Select process, CLIENT_PROCESS, SEQUENCE #, status from v $ MANAGED_STANDBY; PROCESS CLIENT_P SEQUENCE # STATUS---------------------------------------ARCH 0 CONNECTEDARCH 0

Note: MySQL supports unidirectional and asynchronous replication. One server acts as the master server during the replication process, and one or more other servers act as slave servers. The master server writes updates to the binary log file and

The following are some steps to change, but the startup problem still exists. It is easy to modify the SID of a single-instance database. You only need to modify the pfile-related parameters to mount the database. The RAC environment is actually the

Oracle 11.2 instant client installation in RHEL5.6 Download the installation file as needed: I only need two files: oracle-instantclient11.2-basic.rpm and sqlplus. rpm. View the path information in the rpm: Rpm-qpl download rpm package name

Oracle to get today's data, previously used to where to_char (t. t_created_tm, 'yyyy-MM-DD ') = to_char (SYSDATE, 'yyyy-MM-DD '); This method is inefficient, and even if t. t_created_tm is indexed, the index cannot be used during query because it is