Database Administrator

ORA-01219 database not opened Today after the connection data, a look at the prompt that the ORA-01219 database is not open, closed the service re-opened is still like this, in the Baidu found the problem. I deleted a data file and looked at the

After Oracle is upgraded to 11.2.0.4, The NUMA warning is displayed in the alert Log. Note: the articles related to this article are: After upgrading to 11.2.0.4, The NUMA warning is displayed in the alert Log. Translated from mos: NUMA warning

Oralce's Save command You can use the save () command to save the content of the current buffer to a file. In this way, even if the content in the buffer is overwritten, the syntax of the save command for executing the current statement is retained

MongoDB cluster in Linux-replica set Environment Construction MongoDB replica sets are suitable for scenarios with fewer writes and more reads. You can use message queues for write control to reduce the pressure on highly concurrent writes. The

Oracle memory problems In Oracle, the memory structure mainly includes two categories: SGA and PGA. SGA represents the system global zone, and PGA represents the program global zone. Oracle memory mainly stores the execution program code (PL/SQL,

Python production environment MySQL database Incremental backup script A common method for MySQL databases is to use MySQLdump to export SQL for backup, but it is not suitable for databases with large data volumes. The speed and table lock are two

Typical use cases of MySQL MHA 1. Manage the node deployment location1.1. Dedicated Manager server and multiple MySQL (master, slaves) serversUse a dedicated management server to manage multiple groups of MySQL Master/Slave servers Since MHA Manager

Oracle fails to return an index due to an error. There is an Oracle script that has been running for a long time without any results. After optimization, the results are instantly displayed. The original statement is as follows:SQL> explain plan2

Cursor: pin S, cursorpin Cursor: pin S OTN is explained as follows: Cursor: pin SA session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same

ORACLE 11G Official documentation Demonstration: Search for manual database creation statements, oracle11g Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them.

[Translated from mos] a thorough understanding of rman compression, mos Article rman Compression A thorough understanding of rman CompressionSource:A Complete Understanding of RMAN Compression (Document ID 563427.1) Applicable:Oracle

Rman multisection backup Test 2, rmanmultisection Use section size in the two channels for backup. [Oracle @ rhel63single ~] $ Rman target/Recovery Manager: Release 11.2.0.4.0-Production on Thu Feb 19 01:07:28 2015 Copyright (c) 1982,201 1, Oracle

[Translated from mos] Delete the tablespace if the datafile on the OS does not exist. Source:I want to remove a tablespace and the datafile is already removed from the O.S (Documentation ID 786567.1) Applicable:Oracle Database-Enterprise

Oracle uses the pagesize command and oraclepagesize commandYou can use the pagesize command to set the size of each page to control the data volume displayed on each page. Syntax format of the pagesize commandAs follows:Set pagesize nHere, parameter

The SQL statement queries the structure of all tables in the database. SELECT TableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END, TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''), Column_id=C.column_id,

Oracle 10 Gb SGA size at startup, oracle10gsga size The size of the SGA started in Oracle 10g Database is determined by sga_target and sga_max_size. The following three cases are discussed: Sga_target = sga_max_size Parameter file

Oracle 11g how to clear the execution plan of an SQL statement in the share pool, 11 gpool In the past, if the execution plan was slow due to binding snoop on a 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it

Mysql cluster mysql-cluster installation, mysqlmysql-cluster Environment DescriptionSystem Environment: CentOS 6.5 mini (64bit) Software Version: mysql-cluster-advanced-7.3.7-linux-glibc2.5-x86_64.tar.gz IP Address: MGM: 192.168.100.211 NDBD1: 192

SQL statement Dual Loop, SQL statement The shunxu field in Table j_wenzhang_aps201503 is null. Now you want to update the shunxu Field Based on lanmu_id and qishiye. 1. If the shunxu field is auto-incremented, there are no duplicates, And the

Oracle date operations, oracle date1. Obtain the last day of a month. SELECT TO_CHAR(LAST_DAY(TO_DATE('20140125', 'yyyymmdd')), 'yyyymmdd') LASTDAY FROM DUAL 2. Obtain the last day of the last month: select to_char(add_months(last_day(to_date('2008-