database capacity planning oracle

ORACLE 11g R2 database installation hardware environment requirements, 11gr2 Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1. Virtual Memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2 GB and 16 GB Equal to the size of RAM More than 16 GB

In many cases, when the application administrator notifies us that the application is very slow and the database is very slow, we also find the same problem when performing the Select statements in the database for several examples, sometimes we will not be able to get started, because we believe that the various life-saving rates of the database meet the recomme

InOracle DatabaseDuring the operation, we may encounter this situation, and the data in the table may be repeated, which makes it inconvenient for us to operate the Oracle database, so how can we delete the useless data? The deduplication technology can provide a larger backup capacity for longer data retention, continuous verification of backup data, improve the

In Linux, the entire backup process lasted about five hours, and the backup capacity was as follows: [oracle @ smsbackup] $ du-sk1448023700. Backup script: In Linux, the entire backup process lasts for about five hours. The backup capacity is as follows: [oracle @ sms backup] $ du-sk1448023700. backup script: Last

=800m; redo the log buffer (Redo log buffer): Any modifications to the database are recorded sequentially in the buffer, and then the LGWR process writes it to disk. Size determined by Log_buffer shared pool: is the most critical memory fragment of SGA , the shared pool is primarily made up of library cache (shared SQL and PL) and data dictionary cache composition, Its role is to store frequently used SQL, and under limited

reads. The method of design and optimization is to reduce the logical reading of individual statements, or to reduce their execution times. In addition, some computational functions, such as custom functions, decode, etc. frequently used, will also consume a lot of CPU time, causing the system load, the correct design method or optimization method, need to avoid the calculation process, such as saving the results to statistics is a good way. (2) disk subsystem in an OLTP environment, its load

In Oracle databases, a series of initialization parameters are used for database constraints and resource restrictions. These parameters are usually stored in a parameter file and read and load when the database instance starts. Initialization parameters are very important to the database. Many parameters can greatly i

, child nodes through SSH communication, automatic configuration) ./runinstaller Do not select check box security updates checkbox, next. Select "Create and configure a database", and next. (Choose to create databases and create data warehouses with official recommendations) Select Server Class, and the next step. (If Oracle is simply under Linux, not clustered environment can also) Select all nodes, co

view, this can make full use of the database capacity, scalability, and so on, all the conditions of judgment, The numerical computation statistics can be appended to the temporary table after the database server is unified processing, and the process of data result can be realized by the process or function of the database