Database Administrator

PL/SQL cursor usage Use of cursors ① Cursor ConceptTo process SQL statements, Oracle must allocate a region called context area to process required information,This includes the number of rows to be processed, a pointer to the expression after the

In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved? In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved? Problem: The program reports the error of Table 'xxx' doesn'

Five most common problems that cause RAC instance crashes Five most common problems that cause the RAC instance to crash (Document ID 1549191.1) Applicable: OracleDatabase-Enterprise Edition-version 11.2.0.1 and laterThe information contained in

Oracle jobs regularly execute stored procedures to refresh materialized views and record exceptions In Oracle, jobs regularly execute stored procedures to refresh the materialized view and record exceptions (My materialized view cannot be refreshed

Lock, lock 1. view the current Lock ObjectSelect a. owner,A. object_name,B. xidusn,B. xidslot,B. xidsqn,B. session_id,B. oracle_username,B. OS _user_name,B. process,B. locked_mode,C. machine,C. status,C. server,C. sid,C. serial #,C. programFrom

Comparison of InnoDB row format (compact, redundant), innodbredundantThe InnoDB row format is divided into two formats (COMPACT, redundant). By default, the storage format of COMPACT compact is the first to be a list of non-NULL variable length

Oracle dynamic display log, oracle dynamic log   1. view the location of the log file; IND_USER @ PROD> select inst_id, name, value from v $ diag_info; INST_ID NAME VALUE--------------------------------------------------------------------------------

New MySQL users and Database Access authorization, new mysql # Mysql-u root-p # Allow local IP addresses to access localhost, 127.0.0.1 # insert into mysql. user (Host, User, Password) values ('localhost', 'zhouz', password ('000000'); # allow

In Nagios, the alarm Shell script for monitoring MySQL transactions that have been RUNNING but not finished, nagiosmysqlPreface:An error occurred while submitting the business alarm order. The page was not responded. After troubleshooting, the

Mongodb 1 quick start deployment Quick Start deployment of Mongodb 1. Download mongdb and unzip vue I downloaded the windows zip package here.     2. decompress the package Rename mongodb     3. Create data, log, and repair files in the

Alex's Hadoop cainiao Tutorial: 7th Sqoop2 export tutorial, hadoopsqoop2 Take over the previous lesson. Now let's talk about the export tutorial.Check connection First, check whether there are available connection connections. If not, create a

Mysql master-slave replication, mysql master-slave1. mysql master-slave replication Principle For the master server, the information generated in the current database will be recorded in the binary log. If the server receives a Statement on the

Java MySQL batch processing and javamysql Batch Processing In essence, it is to use the addBatch () method of Statement and PreStatement. Code import java.sql.*;public class GetConnection{public static void main(String[] args){Access2Database

Oracle Apex practical notes Series 2, oracleapex1. Page Design Page A has several region, one of which is used for file list management (including display, download, and delete) and. There is A button on page A. Clicking it will call page B. Page B

Install oracle software using NFS and nfsoracle Software Yesterday, I used openfiler to create a nas storage system and install the oracle software. Everything went well before that. A ora error was reported when I created a database. When I used

When rac _ executes grid self-check, a prompt is displayed for executing the runfixup. sh script, gridrunfixup. sh. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

When rac is installed on the grid, the system reports the INS-41112 error and the racgrid reports the ins-41112 error. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

Hadoop Yarn (II)-create an Eclipse project, hadoopyarn HamaWhite (QQ: 530422429) original works. For more information, see http://write.blog.csdn.net/postedit/40615469.1. The installation environment is described as follows: System:

Single block read, block read What is single read? As the name implies, a single block can be read by a single block. The waiting event is db file sequential read. What are the situations of a single block read? Most index scans are for a single

Can the voice be restored after it is deleted? QQ1622863529, deleted qq1622863529[Recommendation team QQ1622863529] This team specializes in cracking, QQ, Momo, email, and other chat tools and passwords (hacker QQ: 1622863529) to query and restore