Database Administrator

MySQL has become one of the most widely used databases on the network, especially for Web applications. It occupies the absolute advantage of Small and Medium applications. All of this comes from its small and easy-to-use, secure and effective, open

SQL statements are frequently used when dealing with databases. Unless you bind all controls, the method of binding controls has disadvantages such as poor flexibility, low efficiency, and weak functions. Therefore, most programmers seldom or seldom

This article analyzes how to use the Oracle optimizer to get twice the result with half the effort.1. select an appropriate Oracle optimizerThere are three optimizer types in Oracle:A. RULE (RULE-based) B. COST (COST-based) c. CHOOSE (selectivity

Oracle beginners often ask this question. Here is a unified answer.1. If you have a certain database foundation and know what SQL is going on, you can skip to 2 even if you cannot write simple SQL statements. Otherwise, let's take a look at the

Want to learn java Start from learning the database, and then learning the java Control database, in the java Control text, and finally the java control machine. I have written some low-layer driver modules before, and it is important to have

Create users and user groups firstSu-rootGroupadd mysqlUseradd-g mysqlDecompress the binary file.Gunzip-c filename | tar-xf-Copy the/home/mysql directory to/usr/local;Create a mysql license table:Linux:/usr/local/mysql # scripts/mysql_install_db --

1. How to create a management user for the mysqld database? After the database is installed, we should create a management account for the mysql database. To set the root user as the administrator, we should run the following command; [Root @

Many people know that the role permissions of users are not available in the stored procedure. Example: SQL> select * from dba_role_privs where grantee = 'suk '; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE -----------------------------------------

It is important to back up your database when database tables are lost or damaged. In the event of a system crash, you must be able to restore as much data as possible from your table to the State at the time of the crash. Sometimes it is the MySQL

Prerequisites: You have started Apache and MySQL servers. When CentOS is installed, the two servers are not started. We need to start them in the system service. 1. We need to log in with the root account. 2. PHP support module installation. After

When PL/SQL Developer is used to recover the backup, the backup is accidentally restored to the system user, so there is no unexpected success. At this time, my heart is broken. We all know that system is one of the super administrators of Oracle,

Use of insert in Oracle stored procedures, including the use of cursors Body section: -- Obtain the plan type number and name of the specified number of modifications for the specified stage of the specified plan by shiwei -- Used in the change

I. Execution Plan Tree Structure When an execution plan is displayed, it is similar to a table. In fact, it is a tree structure. This tree structure not only describes the sequence of SQL engine execution operations, but also the relationship

Oracle's transfer tablespace refers to the ability to copy all data files in one or more tablespaces of a database to another database server, and load the tablespace as the target database through import. The biggest advantage of using this method

1. TCP/IP network configuration file2. Use commands to configure the network3. Network Diagnostic Tools TCP/IP network configuration fileIP configuration file:/etc/sysconfig/network-scripts/ifcfg-eth0Network Management Configuration

Record exit and return usage Exit is used to exit the loop. Loop IF V_KBP IS NULL THEN EXIT; End if; End loop; Return jumps out of the stored procedure Loop IF V_KBP IS NULL THEN Return; End if; End loop; Skip loop once The Oracle 11g

Start and close an ASM instance The startup and shutdown operations of the ASM instance are similar to those of the RDBMS database instance: Execute the STARTUP operation FORCE, this option is forcibly disabled, the shutdown abort operation is

During database maintenance recently, data cannot be stored into the database during data parsing. The reason is that MySQL transactions have deadlocked. I restarted MySQL several times before. Recent frequent occurrences. So find a method. SELECT *

I. Preface: After a period of development and learning about the Oracle stored procedure, I wrote some summary and learning experiences during development to share with you. I hope this will be helpful to you. Ii. target readers: Database developers,

DBMS_RANDOM.STRING (var1, var2) in Oracle) This function has two parameters. The var1 parameter values include u, l, a, x, and p. U --> uppercase L --> lowercase A --> mixed case X --> uppercase, alpha & numeric P --> any printable char The