Oracle 11g result set cache restrictions There is a small table with a data volume larger than one million. This is similar to IP address range lookup. the number of queries to a table is large. the number is generated in real time, and sometimes
PostgreSQL source code customization: online global read only Based on a certain functional requirement on the cloud, a function similar to MySQL global read only has been recently implemented. PostgreSQL's read only function does not need to be
PostgreSQL transaction model Introduction PostgreSQL has its own transaction implementation model. There are three layers: top layer, middle layer, and bottom layer. 1. Top Layer The Top Layer is mainly controlled by users and visible to users. This
GoldenGate Extract process hang solution example The normal extract process suddenly hang. At first, I suspected that the Archive was not found. However, after careful check, all the archives required by extract are still there, and no error is
ORA-03135 connections lost contact Process ID: 0 Scenario Description:The leader callme said that the remote logon to pslql reports an error and the error message is:ORA-03135 connections lost contact Process ID: 01. Hurry to the vpn and log on to
Oracle 11g cannot export empty tables in multiple ways Oracle 11g empty table cannot be exported: Data Query shows a new feature in Oracle 11G: The new parameter "deferred_segment_creation" indicates that the segment delay is created. The default
How to obtain the SELECT result value in a Shell script Sometimes we may need to execute the SELECT statement in the Shell script and assign the result to a variable. In this case, we can use the following methods to achieve the goal. #! /Bin/ksh##
How to configure the STATSPACK performance report of Oracle 11g ADG Create a normal STATSPACK report user on the master database Sqlplus/as sysdba SQL> @? /Rdbms/admin/spcreate. SQLSQL> -- cancel some settings of $ Oracle_HOME/sqlplus/glogin.
"Fatal NI connect error 12170" error in Alert Log Regular inspection of Database alert log information is an important means of routine database maintenance, inspection and troubleshooting. Database Systems "Run with illness" and "Run with injury"
GoldenGate Security Configuration When implementing GoldenGate, security is often ignored. However, as a complete GoldenGate system, basic security settings are still necessary, such as password encryption. GoldenGate has the following five Security
Brief description of Oracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control File The control file is the root file of
The problem that the UUID cannot be returned when rac asm udev is installed on the VM Use UDEV service to solve the rac asm storage device name1. Confirm that necessary UDEV packages have been installed on all RAC nodes. [Root @ rh2 ~] # Rpm-qa |
SQL simple query, limited query and sorting, SQL query limited sorting Structured Query Language (structured Query Language) is a database Query and programming Language used to access data and Query, update, and manage relational database systems.
Cause of SQL Text "** SQL Text Not Available **" in the Oracle ash Report: oracleash Guess: Why "** SQL Text Not Available **" appears in SQL Text in the Oracle ash report The HVR data synchronization software is being tested today. Due to the large
Oracle basics-Introduction (first meeting) and oracle first meetingI. Overall introduction: Oracle databases and databases represent the basis of all Oracle database objects. Oracle is a large-scale relational database based on advanced Structured
/* + SYS_DL_CURSOR */This hint, sys_dl_cursorhint Run the/* + SYS_DL_CURSOR */hint. Today in a db SQL statement, encountered this/* + SYS_DL_CURSOR */hint, after baidu, In the post of Huang Wei http://www.hellodba.com/reader.php? ID = 201It is
In SQL Server replication, large transactions are divided into small transactions for distribution. In SQL server replication, when a large transaction is executed in the published database, for example, 100,000 or more data is operated at a time.
CDC changes data capture technology issues and limitations, cdc capturesThe current cdc function will still disappoint you.The advantage is not mentioned, that is, those written in online books.Disadvantages:1. So far, cdc cannot be associated with
Learning from the database, database Learning This time, I learned a lot about the evaluation system, learned a lot about the system of the eighth division, and learned a lot about database operations. We have been using SQL server databases when we
Extended SQL flexibility-static T_ SQL, dynamic SQL, and sqlt_ SQL In fact, I think this blog is best written in web-based application development, because at present we seldom implement the sorting and filtering functions on the client side, and