PHP

Token ), In the previous blog we mentioned how to enable or disable Oracle's ARCHIVELOG mode (http://www.linuxidc.com/Linux/2014-10/108120.htm ), V $ recovery_file_dest; v $ flash_recovery_area_usage; v $ version; Directory of the archived log

There are two temporary tables in Oracle. One is session-based, that is, when a commit occurs, the data is cleared; the other is session-based. When a session is disconnected, the data There are two temporary tables in Oracle. One is session-based,

1. Create a table createtablett1 (idintprimarykey, c1INT); createtablett2 (idintprimarykey, c2INT); insertintott1value Create table tt1 (id int primary key, c1 INT); create table tt2 (id int primary key, c2 INT); insert into tt1 value 1. Create

Generally, Oracle database software is installed on the OUI gui. However, some UnixLinux systems do not have a graphical system installed, and therefore the GUI cannot be used for security Generally, Oracle database software is installed on the OUI

I like Redis. This is the only technology that makes you wonder why you need to compile it for so long. Predictable, high-performance, and adaptable. This is my past few years. I like Redis. This is the only technology that makes you wonder why you

ORA-01110ORA-01180 error reported when rman backup is restored to an exception ORA-01110 ORA-01180 error reported when rman backup is restored to an exception [Oracle @ server1 ORACLE] $ rman target/ Recovery Manager: Release

Different Oracle database versions are installed based on different operating systems. The configurations are slightly different. Here we will not describe them one by one. You can set them according to your own environment. In this example, we

In addition to the reprinted content, this article is original site: reposted from lovewifelovelife-Roger's Oracle technology blog. Link: OraclePSU updated on April 9,. PSU updated on April 9, mainly in four versions: 12.1.0.2, 12.1.0.1, 11.2.0.4, 11

When end users cannot use MySQL, mixed use of InnoDB and MYISAM may occur. In this case, you need to consider configuring cache and other resources for the two engines, even if InnoDB is used only in the end, this will lead to the failure to make

The sharding principle adopted by mongodb is actually very simple. To put it bluntly, a cake is very big and requires a very large box to be loaded. It is not convenient even if it is stored, therefore, the big cake is cut into small cakes for

1. Resource isolation 1.1. Status Quo a. MinResources and MaxResources are set for each queue. When the queue is idle, other queues can compete for resources from the queue, breaking through the minimum number of resources of the queue. Busy queues

In addition to the reprinted content, this article is original site: reposted from lovewifelovelife-Roger's Oracle technology blog this article URL: Oracle12c Study Series identitycolumn before 12c, if you want to achieve automatic column growth, it

1. subquery optimization is not good. 2. Weak processing of complex queries 3. Immature query optimizer 4. Insufficient performance optimization tools and measurement information 5. Weak audit functions 6. Immature security functions, even rough.

Previously, when I designed Doodle2 and developed zhihu daily, the most data type I faced was ID-based data. When using relational databases, the auto-increment primary key can meet this requirement, but it is a little more troublesome in Redis. I

PHP + MySql get the ID value of the newly added record 1. assume that the field name is recordID2. the field attribute must be set to auto_increment3. after adding data, use $ newIDmysql_insert_id (); obtain the ID value ASP to obtain the Real-Time

Generallyspeaking, Iloverandomizedalgorithms, expires, itstillremainsmagicalfromaprogrammerpointofview. Itaccomplishessomethingthatisalmostillogic Generally speaking, I love randomized algorithms, but there is one I love Fig after you understand how

1. concepts related to RMAN full recovery 1. In RMAN full recovery, we mainly use two Commands: restore and recover. 2. Data can be restored at three levels: database, tablespace, and data file. 3. In RMAN, you can use the user management recovery

1. When an error is reported through floor, use the following code: andselect1from (selectcount (*), concat (version (), floor (rand (0) * 2) xfrominformation_schema.tablesgroupbyx) ); and (selectcount (*) from (select1unionselectnullunionselect! 1)

Anyone who has used the Oracle database knows that Oracle has a FlashRecoveryArea that can write changed blocks to this area. When data operations are incorrect and need to be restored, you can use the data block stored in the flash back space to

Case study: Some program execution MYSQL statement error messages are displayed in the exception log of A webgame we are operating. "Deadlockfoundwhentryingtogetlock; tryrestartingtransaction" is commonly used, and "Errornumber: 1205: