Others

Dblink is a database object, allowing you to access remote tables and execute remoteProgramIn addition, dblink is a one-way connection. When dblink is created, Oracle records its metadata in the data dictionary.. In dB link, you must consider

The use of mingw to learn boost is a trigger. If you want to avoid detours, you should use the compilers that come with windows. Open-source Dongdong is really hard to see and trouble on Microsoft's platform. Let's talk about the compiling

Question: Catch an error with Zero Divisor ("ORA-01476: divisor is equal to zero") and show "bad division" in this case"All other exceptions must be transmitted to the call block intact.In other words, if I add the following exception handling

Original article address:RMAN Incremental Backup tips Incremental Backup greatly reduces the cost of Oracle backup time, but this mechanism may be cumbersomeIn versions 10 GB and later, you can use the Incremental backup of RMAN to roll the image

These are my interpretations of OSI. They are not very rigorous, but very simple:① Physical layer: define what is 0 and what is 1② Link layer: communication between two points directly connected through Homogeneous Media (Use MAC address)③ Network

    Oracle does not have a lock manager or lock list. This prevents contention problems caused by overhead of Row-Level Lock maintenance and insufficient number of Row-level locks. Each row of ORACLE data has a flag to indicate whether the row data

sys@ORCL> select EVENT,TOTAL_WAITS,TIME_WAITED,TIME_WAITED_MICRO 2 from v$system_event 3 where event like '%log file%';EVENT TOTAL_WAITS TIME_WAITED TIME_WAITED_MICRO------------------------------ -----------

There are two origins: 1) Frequent redo records2) server process generates a small amount of data each time.   If the redo log file generated each time requires a large number of highly concurrent SPSS to write the redo log file, there are two

Record PCM lock information in GRDIt is located in the SGA of each instanceHowever, each instance only contains part of GRD, And the GRD of all instances is a complete GRD.PCM lock has three main attributes: mode, role, and PI.① Mode-- S-- X--

Each node has a VIP, which is the IP address we access. If a node goes down, its VIP address will be moved to another node according to the algorithm, In this way, user access is normal. I think VIP is used for failover. When node A fails, the VIP

From a single instance to RAC, the architecture is also built by the RAC cluster and clusterware cluster. In essence, RAC databases and single-instance databases are not much different. data files and control files are shared, but each instance has

1 Definition RBA is the address corresponding to redo entries in the redo log file.   2Composition RBA consists of three parts:Serial number (4 bytes)Block number (4 bytes)Start byte (2 bytes)All of the above are in hexadecimal storage.   3 type 3.1

SQL _trace/10046 is a means provided by Oracle for SQL tracking. The content includes the SQL parsing process, SQL Execution Plan, variable binding, and session wait events. Note the following two parameters before using the SQL _trace/10046 event:

Environment: SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE 11.2.

Many people mentioned the idea of modifying the hostname first to modify the/etc/hosts file. The configuration file of hostname is/etc/hosts. Actually not. The hosts file acts as DNS and provides the corresponding IP address hostname. There were few

HenceFaults, DBAs, and O & M personnel are always pain points, but the principle of avoiding failures is the same thing by the way. It is listed as follows. (I) changes must be rolled back and tested in the same environment first. Buddha said:

When practicing RMAN Incremental backup, refer to ocp tk 042: For RMAN Incremental Backup objects, the official network is extracted as follows: You can make incremental backups of databases, individual tablespaces or datafiles. Apparently, the

In the domain model, the concept of object and value object is very important. hibernate also requires that the two be clearly distinguished, so that their ing preparation is different. Take a pair of multiple examples as an example. The same set is

Join and join fetch are two different things. Don't confuse them! Join is taken from the join concept of SQL. Objects to be joined usually appear in other clauses such as select and where. Because the purpose of join is to process the objects to be

A notable feature of enterprise-level applications is that they need to process a large amount of data. Developers should carefully load objects from the database, make sure that only the necessary minimal object set is loaded for business