Database Administrator

Although the OUI graphical Installation Method of the Oracle database is relatively intuitive, the project jumps several times through the vpn in the Intranet environment, spanning several network segments and the data center is not local, therefore,

650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131228/225U043W-0.jpg "/> Below 650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131228/225U05603-1.jpg "/> The method

mysql> show slave status\G;  *************************** 1. row ***************************                 Slave_IO_State: Waiting for master to send event                    Master_Host: 192.168.8.22                    Master_User: repl 

Obtain the number of rows in each subpartition of a specified partition table in batches! Otherwise, manual query is too troublesome! --- View the number of rows in each sub-partition of the specified partition table Create or replace procedure

Show innodb status is only a direct display mode, and can only be turned on interactively. It cannot automatically capture information cyclically. innodb status information can be output to the err log library. We recommend that youTestCreate the

The method is as follows:1. first, make sure to back up the database to reduce or clear the database with log files) 2. right-click the database, select and open the "properties" window, find the "option" column, and change "complete" in the fault

At a.m. on July 22, May 10, a text message was sent to the police. The XXX Business Database went down and was busy with various problems, so it was only possible to troubleshoot it at night. Let's take a look at the alarm information first, 650)

Mysql5.6 Master/Slave is quite good, and many parameters are added to improve the security and efficiency of Master/Slave synchronization. The following is a detailed description of mysql5.6 Master/Slave parameters. ##################################

I think timesten is a bit more powerful. You can directly load the entire table to the timesten cache database through ttisql. The following is an example. 1. Create a table "test" in oracle ". CREATE TABLE "LION"."TEST" ("ID" number PRIMARY KEY NOT

Mapper. xml configuration Call pro_emp (# {emps, mode = OUT, jdbcType = CURSOR, javaType = java. SQL. ResultSet, resultMap = empMap})]> Stored Procedure: Create or replace procedure pro_emp (cur_sys out sys_refcursor) As Begin Open

This afternoon, I encountered a strange problem. On windows, I logged on to the database with sqlplus/as sysdba, prompting that I had insufficient permissions, 650) this. width = 650; "title =" qq 30608164853.jpg "src =" http://www.bkjia.com/uploads/

An ASM disk is an ASM disk pool managed as a logical unit. Like any other LVM, ASM manages a large number of physical volumes and submits them to Oracle as one or more logical volumes. A physical volume can be an actual disk or disk partition, or a

The user wishes to dynamically display the product Log in Cognos according to the product. This can be achieved through the condition variable in Cognos, and each product value corresponds to an image name. This is more complex. You must first

Tree-structured data is common in project development. For example, it is typical for Forum topic messages. Each topic node) can have n message subnodes ). These messages can have their own messages. Therefore, this structure is a tree. This article

This article was sponsored by 51cto.com and first launched in the dark world. In the previous article, I introduced how to use Navicat for SQLServer. Today I will introduce its fellow teacher Navicat for Oracle. Navicat for Oracle is a client tool

1. The web server suddenly keeps RESTART. When querying LOGS, an error is reported when the web server calls an API; 2. Check the API. DWON is finished. Restart the API to restore it; 3. Check the api logs and find MYSQL exceptions; 4. top, found

Dynamic Setting of variables may cause unexpected side effects, such as refreshing dirty blocks from the buffer. Be careful with the settings that can be modified online, because they may cause the database to do a lot of work. Sometimes, you can

What is row Migration & Row link? # The following description is from Oracle 11gR2 Document 1. Line Link The row is too large to fit into one data block when it is first inserted. In row chaining, Oracle Database stores the data for the row in

Recently, the company was using the postgresql database and developed many ddl/dml statements for us. So I spent two days completing this script to Create Table spaces and users, script for Automatic Data Import #!/bin/bash# 2013/07/26, DD.#

When the client connects to the oracle database through the network in the form of "connect user name/password @ connection string", the listener needs assistance. After the connection is established, even if the listener fails, the established