Database Administrator

PostgreSQL xlog file name specification source code parsing PostgreSQL xlog, that is, WAL (Write Ahead Log), is located In the pg_xlog directory and is the Log on which PostgreSQL fully or PITR (Point In-Time Recovery) depends. Why is there WAL

"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"

Dynamic Registration listening and dynamic listeningSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release

Dell shareplex and HVR data replication software, shareplexhvr Today I have a general understanding of Dell shareplex data replication software, web site: http://software.dell.com/products/shareplex/ You can see from this URL,Shareplex is the

Why does the Database need Implict Commit (implicit Commit transaction), implictcommit First look at an SQL statement. What do you think is the output of the last SQL statement? SET AUTOCOMMIT = 1;BEGIN;INSERT INTO t1 VALUES (1);CREATE TABLE t2 (pk

How to Use union, except t, and INTERSECT in SQL, unionintersectThere is a reason to put these three together, because they all operate on two or more result sets, and these result sets have the following restrictions:The columns and columns in all

Fatal NI connect error 12170 under RAC. error handling, fatal12170 Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to pursue legal

Oracle obtains the year, month, and date list of a certain period of time, and oracle year. Get date list: SELECT TO_CHAR (TO_DATE ('2017-10-01 ', 'yyyy-MM-dd') + ROWNUM-1, 'yyyymmdd ') as daylist from dualconnect by rownum Obtain the month

RHEL5.8 physical opportunities to Read-only file system, rhel5.8read-only RHEL5.8 physical opportunities to Read-only file system   [root@lei1 tmp]# dateThu Jun 4 04:36:31 CST 2015[root@lei1 tmp]# mkdir ssmkdir: cannot create directory `ss':

Using the easy connect naming method simple connection test, connectnamingI have never understood what NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT) in sqlnet. ora means. Today I see a document about how to log on to and perform a test:Tnsnames. ora1

Awk skills, diagram of reversing warehouse receiving skills Awk uses spaces and tabs by default. If you want to specify a TAB, you can use awk-F' \ t'. If you want to specify multiple tabs as one, you can use awk-F' \ t + '************************ 1.

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

Oracle --- use PL/SQL Developer to connect to Oracle12C (64-bit), oracle --- oracle12cOracle --- connect Oracle12C (64-bit) version with PL/SQL Developer1. Install Oracle 12c 64-bit2. Install a 32-bit Oracle client (instantclient-basic-nt-12.1.0.1.0)

Use of STDistance and difference between geometry and geography, stdistancegeometry 1. First, let's talk about the difference between geometry and geography in SQL Server: Geometry: Planar plane coordinate system [supported by SQL Server conforms to

Oracle Study Notes (4) ------------ learning route summary, oracle Study Notes It was a little difficult to learn Oracle, so I found some learning routes on the Internet to learn regularly, which is more efficient and shared with you. Concepts|New

11G result set cache limit, 11G cache limitThere is a small table with a data volume of more than one million. This is similar to the IP address range lookup. The Table query volume is large. The data is generated in real time and sometimes

Simple usage of the substr function in Oracle, oraclesubstr Function Substr (string, truncation start position, truncation length) // returns the truncated string (including the start position) Select substr ('helloworld',) value from dual; -- the

Detailed usage of record, varray, table, % type, and % rowtype in ORACLE, varray % type 1 Note 1.1 RECORD Define the record data type. It is similar to the STRUCTURE in C language. PL/SQL provides a holistic approach to combine several related,

Test-use SQL Lorader to import lob data, loraderlob 1. Prepare the data file to be transferred and transfer it to the server 2. Create a target table in the database DROP TABLE lob_tab;CREATE TABLE lob_tab ( number_content NUMBER(10), varchar2_

MySQL Error Query database. Causejava. SQL. SQLException: Incorrect key file for table '/tmp/# SQL _181c,      1. The developer gave me the following background error: Error Query database. Causejava. SQL. SQLException: Incorrect key file for