commit

A well-designed, performance-capable database engine can easily serve thousands of users at the same time. And the "weak" database system with more users to access the system will greatly reduce its performance. In the worst case, it could even

In practical applications, when we are ready to hand over a project to the customer for use, we need to clear all the tables in the library before the test data to give the customer a clean database, if the table involved a lot, to be emptied, not

ASP.net Our previous chapters describe how to display information in a database and the basic usage of DataReader and datasets. Have a friend say not enjoyable, want me to write the following chapter quickly, very sorry, I really do not have much

DG's core function is to provide high availability disaster, so the role-switching content described in this section is the most important part of DG. The role switching between DG Master and slave Libraries is divided into the following two kinds:

oracle| program | stored Procedure | recordset Tip: In Oracle8i, if you need to return a result set through a stored procedure, you need to use a cursor! CREATE OR REPLACE PACKAGE Body "Sms_pay". Smsmaint " Is --Functional Description: Inquiry

Database concurrent access, where two or more users access the same data at the same time, is the biggest problem for the database engine to design and implement a moderate response. A well-designed, performance-capable database engine can easily

Open the Trunks directory and create a new two text file in the Trunks directory A.java,b.java: Open A.java and enter the following: The B.java file can be entered randomly, and this example is used primarily to observe the

1. The main library encountered a ORA-01093 error while carrying out a physical master repository role conversion Sql> select Switchover_status from V$database; Switchover_status -------------------- SESSIONS Active----------has active sessions.

Triggers are blocks of code that are executed automatically when a particular event occurs. Similar to stored procedures, but users cannot call them directly. Triggers are a technology provided by many relational database systems. In Oracle systems,

Dynamic Network Forum 7.0 since the release has further expanded its reputation in the field of ASP forum and praise, whether in the art, performance, security and efficiency than the previous version of a great progress. The only thing I feel when

* * The test is for the next test, according to the condition of the increment column as the partitioning condition, according to the time as the partition condition. Create tablespace test01 datafile ' D:\oracle\oradata\myora\test01.dbf ' size

Why the introduction of transactional concepts The transaction is the concurrent control mechanism commonly used in the current mainstream database system. What is a transaction Transactions have the following 4 most important characteristics, which

My.ini (Linux system is my.cnf), when the MySQL server is started, it will read this file, set the relevant operating environment parameters. My.ini is divided into two pieces: Client section and Server section. Client section is used to configure

Two days ago, I wrote an article about a series of regular functions such as length to handle LOB types, and someone mentioned in the blog reply that using length is more efficient than dbms_lob. GetLength Low, here's a simple test. Create a test

oracle| Data Oracle's BLOB field is special, he is much better than a long field, and can be used to save binary data, such as pictures. It is very different to write a BLOB field and write to another type of field, because the BLOB itself has a

What is a distributed transaction The traditional solution based on database local transaction can only guarantee the atomicity, isolation, consistency and persistence of single service processing, but it can't guarantee the consistency of

In the definition of transaction given in the previous article, the reader of the information should see a method called Depedentclone. This method is used to create a dependent transaction (DependentTransaction) that is based on an existing

js| Insert | Dynamic Code:-------------------------------------------------------------------------------- Shipping List Shipping List Ordering Unit: Demo retailer Date: 2002-02-25 Order Number: Item No. Production lot

Whether the design of database model is reasonable can greatly affect the performance of the system. Based on the experience of designing and using database for many years, the author puts forward the following Accounting principles for the

"Guide" This paper presents the principle of flashback function, describes the use of Oracle 9i or Oracle 10g Flash-back function to recover accidental loss of data methods. Objective Human error is one of the important reasons for the failure of