Database Administrator

1. Modify system parameters Alter system set aq_tm_processes = 2 scope = both;Alter system set global_names = true scope = both;Alter system set job_queue_processes = 20 scope = both;Alter system set parallel_max_servers = 20 scope = both;Alter

A problem solved by PHP: (The problem that cannot be found by the socket file) For this problem, baidu has a big copy! You have to worry about some problems ~~ As for the answers, they are of course the way to solve the problem. You can refer to

In MySQL, we sometimes want to select N records and add a column in each record in the results to mark the number of records.In Oracle, rownum can be used for simple implementation. But in MySQL, how can this problem be implemented? The following is

The loss of the database causes a lot of losses, so I wrote a script for backing up the Mysql database in Linux. It was initially in the php version, later, I found that the PHP configuration on the server restricted the calling of system functions,

Install MySQL 10.10 In Ubuntu 5.1 Linux: Sudo apt-get install mysql-server-5.1 for mysql-gui-tools-common Sudo vi/etc/mysql/my. cnf Search for bind-address and comment it out. Because it is not annotated, it can only be accessed using 127.0.0.1.

Flashback is not completely restored. drop table: The table name of the deleted table does not seem to have been changed, and it is not actually dropped (the recycle bin of windows) --> flash dropped table TechnologySQL> show recyclebinORIGINAL NAME

Oracle application efficiency can be improved from the following aspects: (1) Adjustment of business logic functions; (2) Optimize the data structure design; (3) optimize data processing steps; (4) Optimize SQL statements; ⑸ Physical structure

The following are some examples: (I hope you can add them) 1. Database Design Try to occupy less disk space for database design.1). Use smaller integer types as much as possible. (mediumint is more suitable than int ).2). Try to define the field as

In windows, you can set Oracle service to automatic in Computer Service Management. After Oracle is installed in Linux, Oracle will not start automatically if Linux is restarted, you can manually call the dbstart command to start the instance, but

I. EnvironmentServer1: 192.85.1.5Server2: 192.85.1.4Server3: 192.85.1.9 Ii. Cluster Solution1. Management node: server12. storage nodes: server2 and server33. SQL nodes: server2 and server3Upload the file

Environment: Operating System: windows xp Virtual machine: VMware 5.5.3 Linux: RHEL 5 Note: Since RHEL 5 is not supported in Oracle official documentation, the following configuration items are subject to Oracle requirements for RHEL 4.0. I. Check

* Modifications in Linux *Add the following to phpmyadmin. conf:AllowOverride NoneOrder allow, deny# Allow from 127.0.0.1Allow from all * Modification in Windows *1. Click the "WAMPSERVER" icon in the lower right corner.2. Select "Apache"> "Alias

For "ORA-01722: Invalid Number error" always encountered before, today again encountered! Cause: It is common to convert fields to the number type. For example, it is common to create a materialized view if a column needs to be converted to a

Oracle encountered a problem: after entering the user name and password in PL/SQL, a title error occurred. I have not backed up all the database databases in a project, and there is still a lot of data, this won't let me reload the database. Think

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell, which can be directly executed on the shell CLI port or through shell

A problem occurred on the contact marketing platform a few days ago. Ask a colleague to help solve the problem. The result is two days later and the problem is still not located.We still need to solve the problem near the Spring Festival. We have

1. Upgrade Grid Infrastructure1.1 prepare 1.1.1 software before Upgrade   Needless to say: Download, upload to server, decompress  1.1.2 create a new HOME for GI Mkdir-p/u01/app/11.2.0.4/grid Chown-R grid: oinstall/u01/app/11.2.0.4 Chmod-R

In Windows, Oracle 11g cannot be started normally after a shutdown and cannot be started to the mount state: ORA-03113: end-of-file on communication channel Process ID: 4276 Session ID: 1286 Serial number: 2 Find the trc file of the corresponding

Logical standby is built on physical standby Oracle10g Physical DataGuard detailed construction process -- Stop the log application on standby SQL> alter database recover managed standby database cancel; Database altered. -- Modify the

Dbms_random is a package that can generate random values or strings. This package includes several functions, including initialize (), seed (), terminate (), value (), normal (), random (), and string (), but value () is the most common. The