PHP

The Oracle Database initialization parameters mainly come from two internal Oracle Data Dictionary tables: X $ KSPPCV and X $ KSPPI. Generally, we query the V $ Parameter view or use showpa. The Oracle Database initialization parameters mainly come

Many MySQL programs use the anonymous logon function. After installing MySQL, you can log on to the database. This is basically nothing for MySQL, Many MySQL programs use the anonymous logon function. After installing MySQL, you can log on to the

In Oracle10G or 11G version, how to properly set the sharedpool size has a great impact on the performance of Oracle databases. In Oracle 10g or 11G version, how to properly set the shared pool size has a great impact on the performance of Oracle

No matter whether it is Linux or Windows, a newbie encounters a Chinese character upon MySQL service installation. Today I installed CentOS6.5 and encountered this problem. Now we can solve it. No matter whether it is Linux or Windows, a newbie

PerconaXtraBackup is a backup tool developed by Percona. It mainly has two tools: XtraBackup and innobackupex. Among them, innobac Percona XtraBackup is a backup tool developed by Percona. It mainly has two tools: XtraBackup and innobackupex. Among

The following describes how to reconstruct the control file in the RAC environment, including two examples. One is to rebuild the control file in the noresetlogs mode, and the other is to resetlogs mode. The following describes how to reconstruct

In MySQL5.5, the following is the basedirC parameter of my. ini: ProgramFilesMySQLMySQLServer6.0datadir. The path where the table structure is stored is innodb. The following is the parameter basedir = C:/Program Files/MySQL Server 5.5/datadir =

The customer's database is Oracle11.1.0.7 and runs on the p550 host. 16 logical CPUs, 16 GB memory, and AIX6.164-bit systems are allocated 8 GB memory to SGA and 2 GB memory The customer's database is Oracle 11.1.0.7 and runs on the p550 host. It

For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_mu For centralized O & M of MySQL databases, you can deploy multiple MySQL

When I want to check the mysql database today, the messages log contains a large number of mysqlkernel: nf_conntrackversion0.5.0 connection information. Now I want to record the solution. When I want to check the mysql database today, the messages

Before InnoDBPlugin, we can only view the current database request through SHOWFULLPROCESSLIS and SHOWENGINEINNODBSTATUS, and then judge the transaction Before InnoDB Plugin, we can only view the current database request through show full processlis

After Oracle12c is installed, PLSQLDeveloper cannot connect to Oracle12c. Search online and follow the instructions in fcflying. After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions

1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQLgt; showparameterprocesses; NAME 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections

We know that the overhead of MySQL Reading and Writing Performance is quite different. Generally, the server is under 20% write pressure, and the other 80% pressure comes from reading. Of course, this depends on the actual industry. We know that the

For Oracle database servers with large memory, it is necessary to configure HugePage. The following describes how to configure Huge: For Oracle database servers with large memory, it is necessary to configure HugePage. The following describes how to

After learning the LinuxShell script for two weeks, I finally wrote a MySQL automated installation script. With today's full-day testing, you can install MySQL5.5.40. other versions normally. After learning the Linux Shell script for two weeks, I

Port an existing Oracle Database (non-binary executable program files) from one operating system platform to another operating system platform (for example, from Windows to Solaris ), Port an existing Oracle Database (non-binary executable program

This document can be used to downgrade the upgraded database from Oracle11gR2 to the following guidelines and checklists: Oracle10gR1, Oracle10gR2, Oracle This document can be used to downgrade the upgraded database from Oracle 11gR2 to the

Install MySQL in Linux, usually by using RPM and source code. For the production environment, you need to customize the installation path, data file location, Character Set, and supported Install MySQL in Linux, usually by using RPM and source code.

Today, I encountered another ldquo, strange rdquo, and problem during troubleshooting. The SGA Automatic Storage Management is disabled in the Test Library. Today, I encountered another ldquo, strange rdquo, and problem during troubleshooting. The