Improve the query statistics of Oracle databases
In large database systems, the query statistics are often used, but for systems with large data volume, users often feel very slow when performing complex query statistics, and cannot meet application requirements, which requires us to make reasonable settings when designing database systems. Increase the speed of query statistics. This article combines the author's project development experience, explains the specific setup method. Taking the Oracle7.33 database system as an example, we combine the characteristics of the project when developing a large Oracle database system, in accordance with the security and efficiency principles, the database has been physically designed to greatly improve the query statistics of the database. Summarize as follows: 1) Expand data table space to 500m, used to store data of this system; 2) The initial size of the section is 10K, the growth rate is 10K, the growth rate is 1; 3) User temporary space increase Large 40m; 4) System temporary table space and rollback segment table space increased by 40M, and newly built four backgrous; 5) Need to join inquiry, and the amount of data is large, the list, the list, the send and receive sheet In a cluster; 6) Provide timed backups, the backup file is placed on another machine. Setting the SQL statement of the data table space is as follows: create tablespace wxgl_data1 datafile 'wxgl_data1 datafile' wxgl_data1.ora 'size 500m online; adds the SQL statement of the system temporary table space and the split segment table space as follows: ALTER TABLESPACE TEMPORY_DATA Add DataFile' tmp2orcl.ora 'size 40M ; ALTER TABLESPACE ROLLBACK_DATA ADD DATAFILE 'RBS2ORCL.ORA' SIZE 40M; data space in the data file specified set of SQL statements as follows: CREATE USER ZBGL IDENTIFIED BY ZBGL; GRANT DBA tO ZBGL; ALTER USER ZBGL DEFAULT TABLESPACE WXGL_DATA1 TEMPORARY TABLESPACE TEMPORARY_DATA;
