Database Administrator

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

Cross-platform cross-version database migration using RMAN in the same byte sequence Cross-platform transmission DatabaseRMAN's convert database command is used to move the entire database from one platform to another. When the source platform and

How to manually delete an Oracle 11g database in Linux The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment. I installed the Oralce 11G database on CentOS 6. Use SQLPlus or other command line tools you

Debugging and optimization techniques for 101 MySQL instances MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for adjusting and optimizing

Data structure, data structure and AlgorithmChain Storage Chain storage: stores data elements in a linear table with any group of storage units. Linear table stored in this method is short for Linear Linked List. Any group of storage units of nodes

MySQL database update sub-query, mysql database update For example: UPDATE test. tb_vobileSet a. name = '20140901'WHEREA. id = (select max (id) id from test. tb_vobile) Error: [SQL] UPDATE test. tb_vobileSet a. name = '20140901'WHEREA. id =

SQL is required. Note chapter 16th to update and insert data. SQL is required.16.1 update data To UPDATE (modify) The data in the table, you can use the UPDATE statement. UPDATE can be used in two ways:(1) update specific rows in the table(2) update

Where 1 =-1 and 1 = 1 will it affect the query efficiency ?, Where-1 Today, when I use SQL profiler to talk to an SQL statement generated at the underlying layer, I followed the following code: WITH TempQuery AS (SELECT *, ROW_NUMBER () OVER

SQL Server Reporting Services create and subscribe to reports, reportingservices If the data in the database is updated in real time, and the report we use for research and evaluation is based on such real-time data, then we can use the SQL Server

Slave have equal MySQL server UUIDs, equaluuids Recently, When I deployed The MySQL master-slave replication architecture, I encountered "Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs;

Oracle lock 4: system lock, oracle lock 4 System Oracle databases use multiple system locks to protect internal databases and memory structures. These mechanisms are transparent to users.Latches) Latches are simple and low-level serialization

Mysql HA-Install Keepalived + LVS + Mysql (dual master) On Redhat 6.3, keepalivedlvs Host information: Scheduling node: Name: lvsOS: Redhat 6.3IP: rule: 192.168.56.236 data node 1: Name: rule: Redhat 6.3IP: 192.168.56.230 data node 2: Name:

Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently, ora12505When you connect to oacle12c using java, an error is returned:Java. SQL. SQLException: Listener refused the connection with the following

We are already in the process of making n + connections and the number of simultaneous builds has bee, simultaneous Simultaneous-build-throttle:This is the maximum number of connections we can be building at any one time.That is, the number of new

Optimistic locks and pessimistic locks, optimistic locks pessimistic locks Locking) This concept has been touched upon when we learned multithreading. In fact, the lock here and the concurrent lock processing in multithreading are a truth. They all

Unable to start MySQL service. Another MySQL daemon is already running with the same UNIX socket, unablemysqlUnable to start MySQL service. Another MySQL daemon is already running with the same UNIX socket  Features If you encounter any of the

About the script configuration during DDL replication when the ogg version is upgraded after the db version is upgradedAfter the db version is upgraded, the ogg version is also upgraded.The db version upgrade here is from 10.2.0.5 to 11.2.0.3, so it

[Oracle] oracledba6 SQL Tuning sets, oracledba6tuning You want to use the SQL Tuning Advisor to generate recommendation S for badly written SQL statements in your development environment. W Hich three sources can you select for the advisor to

Common methods for processing cross-row group computing reports and solutions for computing reports and computing reportsReport description The order amount is calculated by month based on the order table and specified year (parameter), and compared

Oracle FGA fine-grained audit and oraclefga fine-grained Audit If you want to audit the table, it is a good choice to use FGA for a certain period of time, persons and DML statements. SQL> select * from v $ version;Oracle Database 11g Enterprise