Database Administrator

Oracle 11g RAC listener offline After the Oracle 11g RAC listener has changed the network, the listener process offline appears, and the two nodes are switched frequently. Check the log/var/log/message to find frequent registration and revocation

PostgreSQL9 PPAS9 stream replication Configuration Set up a stream replication cluster for PostgreSQL. Host: PPAS1 PPAS2 1Install PPAS 9.0[Root @ ppas1 ~] # Setenforce 0[Root @ ppas1 ~] # Ppasmeta-9.0.4.14-linux-x64.run-All installation [Root @ ppas1

Simple MySQL database operations For children who want to engage in or love mysql-related work, it is necessary to implement some simple operations on mysql under the command line. This article describes how to log on to the mysql database server,

Oracle batch update sequence Storage Preface: Sequence of Oracle (SEQUENCE) a schema object that generates a serial list of unique numbers for table columns. to use a sequence, your schema must contain the sequence or you must have been granted the

Oracle universal paging Stored Procedure Oracle universal paging Stored Procedure -- Create a package and define a cursor type in the packageCreate or replace package testfenyepackageType test_cursor is ref cursor;End testfenyepackage; -- Compile

How to Use sqlplus-prelim in Oracle hang In many cases, Oracle hang causes sqlplus to be unable to connect, and thus the Oracle system and process status cannot be obtained, which leads to a lack of a strong foundation for locating the problem.

Bug 7715339: 'row cache lock' wait when logon fails Bug 7715339-Logon failures causes "row cache lock" waits-Allow disable of logon delay(Document ID 7715339.8) to the bottomModification time: 2012-7-26 type: PATCHFor this document rating, email the

Optimize Oracle with full table Scan Today, development has met a very BT demand.Find all friends of a person, query all works of all friends, and sort them in reverse chronological order to obtain several records,Then associate the Work Comment

[11g architecture, 4] AMM (Automatic Memory Allocation Management), 11 gamm1. AMM (automaitc memory managerment)1. Automatic Management of oracle 10g SGA: SGA_TARGET specifies the maximum memory size that SGA can use. The size of each memory in SGA

Usage of drop, truncate, and delete statements in sqlserver, sqlservertruncate Although it is not recommended that you use commands to delete items in database tables, these delete commands are useful. When talking about the keywords used to delete

Hibernate uses the c3p0 data source,After configuring hibernate to connect to the database environment, we can perform the following operations to build the environment for using the c3p0 data source in hibernate. 1). Import the jar

Oracle copies an SQL statement (test OK) for any table row, oraclesql I tested it for a long time. There are many methods on the Internet, but they are all incorrect. The correct method is as follows: declare cursor rowAll is select * from

Oracle connection tests and Oracle connection tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table( Id

SetParameter and setParameterList in hibernate pre-compiled SQL statements, and hibernate pre-compiled Use pre-compiled SQL statements and placeholder parameters (which is in jdbc ?), This avoids the complexity of concatenating SQL statements with

SQL has one table but not the data in another table. SQL is not Select. id,. OA code,. custid,. custname,. xsz,. salename,. communicationtheme,. communicationproperty,. communicationtime,. productmanager, ''creator,. creator oaCreator,. createdate,

Oracle 11G direct path read is very beautiful and hurtful, oracle11gDirect path read In 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through gc buffer, so

Mysql Data truncated for column, mysqltruncated 1. Describe your problems first. If you want to remove the flag that allows null values... It happens that the data processed_f in the database is null and there is no value .... When you

Oracle queue type, oracle queue For more information, see the official oracle11gr2 documentation 《Oracle Database Reference11GRelease 2 (11.2)" Queue definition:The oracle queue has a shared memory for serial access to database resources.Lock. It is

[Translated from mos] After recreating the control file, the Missed Database Supplemental Log Information and databaseAfter the control file is rebuilt, the Supplemental Log Information of the Database (Missed Database Supplemental Log Information)

The SQL Server execution plan teaches me how to create indexes? I am not very familiar with the index, so the test results are of no value, or even some people are misleading. I am sorry here, but where did I fall. Application scenarios Or use the