Database Administrator

ORA-03113 Solution Scenario: A solution to full ORA-00257 archiving logs the archived logs described in this log are full (SEE ). Now I want to switch the database to non-archive mode. Refer to how to start or disable Oracle ARCHIVELOG mode for

Slow MySQL subquery When you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit ". Related books: High-

Oracle session and connection Optimization 1. Modify the Oracle session and maximum number of connections 1. view the maximum number of connections SQL> show parameter processes; NAME TYPE VALUE--------------------------------------------------------

Compile and install MySQL 5.6.20 in CentOS 6.5 Overview:MySQL 6.5 installed through yum in CentOS 5.1 is old, so I want to install the later version 5.6.20 through the source code. Body:I. Uninstall the old versionRun the following command to check

BIEE11G Rpd merge and biee11grpd merge Rpd merge To merge two rpd files, you need to use three rpd files. One is blank. rpd: This is a blank rpd, which acts as the "original primary Archive" When biee is merged; the other is modified.

Meaning of CONNECT role in Oracle db, oracleroleFrom: Complete Checklist for Manual Upgrades to 11gR2 (Document ID 837570.1) This article contains the following text: From Oracle 10.2, 'connection' role only supports des 'create session'

Servlet execute update error ORA-12518, servletora-12518 ORA-12518: TNS: listener cocould not hand off client connection This error is generally tested for database concurrency by multiple users, The backend executes an update using the servlet

Modify the redolog size of the oracle dg bad environment master database, dgredolog-- Standby database standbyThe four redologs in the master database were previously 50 MB in size.SQL>Alter database recover managed standby database cancel; Database

Single-row oracle FunctionsZookeeper Single Row Function①. Character FunctionsLOWER (x): converts each word in x to lowercase.UPPER (x): converts every word in x to uppercase.INITCAP (x): converts the initial letter of each word in x to

Real-Time SQL Monitoring using DBMS_SQLTUNE, dbmssqltune Real-Time SQL Monitoring reports are available from three locations: Enterprise Manager-Click the "Performance" tab, then the "SQL Monitoring" link at the bottom-right of the page to display

Usage of input, out, And inout parameters in MySQL stored procedures, mysqlinoutStored procedure parameters: You can declare parameters in the brackets of the stored procedure. Syntax: create procedure p ([in/out/inout] parameter name parameter type

How can I know the password after I log on to another user's QQ account on iPhone 6? QQ1622863529, qq display iphone6 onlineQuery serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries,

Slow mysql subquery and mysql subqueryWhen you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit "...

Specific operation commands for adding and deleting new users in mysql, and specific operations in mysqlMethod 1: Use the mysql root (root permission) user to log on and directly grant permissions to users. You can also create

Partition Table, oracle Partition Table -- Delete partition truncate table partitionDeclare day number;BeginDay: = 20110901;LoopExecute immediate 'alter table lbidw. TB_DW_MGR_01_DAY truncate partition DATA _ '| day;Day: = day + 1;Exit when day> 2011

Dbms_stats, dbmsjob All function packages of dbms_stats are as follows: GATHER_INDEX_STATS: Analyze index information GATHER_TABLE_STATS: analysis table information. When cascade is set to true, the analysis table and column (INDEX)

The OracleOraDb11g_home1TNSListener service is stopped after it is started. Some services are stopped automatically when they are not used by other services or programs.The solution is as follows:1:

Mysql installation on linux 3 (Binary installation), mysqllinuxInstall the Binary source package:1. Download the binary Mysql installation package from the http://www.mysql.com // This MYSQL is a binary version, do not compile2. Change

Bat writing in dmp format for automatic database backup in window, dmpbat Copy the following command to a txt text file, and modify the corresponding parameters as needed. After everything is completed, save the file in bat format. In this way, you

Oracle when row function date, oracle when row Date of use   Oracle internal use of digital storage date: century, year, month, day, hour, minute, second. The default date display format is DD-MON-RR. -- Only the last two digits of a year can