Category : oracle

I. Origin of Waiting Events Everyone may be a little strange, why wait for the event, first talked about the index system. In fact, it is the development of the indicator system that leads to the introduction of waiting events. To sum up, Oracle’s index system has roughly gone through the following three stages: With ..

Read more

AWR in Oracle is all called Automatic Workload Repository, an automatic load repository. It collects operation statistics and other statistics about a specific database. Oracle takes a snapshot of all its important statistics and load information at fixed intervals (the default is 1 hour) and stores the snapshot in AWR. This information is retained in ..

Read more

I. Hint Overview 1. Why is Hint introduced? Hint is a unique function in Oracle database, and is often used in many DBA optimizations. Then why would Oracle consider introducing an optimizer? Cost-based optimizer is very smart. In most cases, it will choose the right optimizer to reduce the burden of DBA. However, sometimes it ..

Read more

incr Redis has incr function, which can easily increment atoms. At the same time, for non-existent key, the default initial value is 0, after incr, it is 1. This is convenient, which not only solves the problem of upsert, but also solves the problem of atomic concurrency. Pg has the function of upsert, but oracle ..

Read more

image docker pull registry.cn-hangzhou.aliyuncs.com/qida/oracle-xe-11g Or you can add tables automatically yourself. create role test_role; grant create any table, alter any table, drop any table, insert any table, update any table, delete any table, create any index, alter any index, drop any index, create any sequence, alter any sequence, drop any sequence, select any sequence, create ..

Read more

System: Linux Centos 7.0 In order for PHP to operate Oracle database, it is absolutely necessary to install the Oracle extension. The Oracle extension of php is called oci Oracle Extension Pack Download Address:http://www.oracle.com/technet … The following download list will be displayed on the webpage: Download Oracle Database 10g Instant Client for Microsoft Windows (32-bit) ..

Read more