Database Administrator

Bulk collect for batch processing of multi-row data When writing pl/SQL statements, a typical mode is often used to define a cursor and process the values cyclically from the cursor.Similar to the following formatDeclareCursor xxxx is

Solution to scott users locked in Oracle 11g Modify the locked user in Oracle 11g: scott After installing Oracle10g and creating an oracle database, you can log on to the database using scott to check whether the connection is successful. When you

Problems with using the yum install command on OEL 5.4 32bit Problems with using the yum install command on OEL 5.4 32bit [Root @ localhost yum. repos. d] # yum install elfutils-libelf-devel-static *Loaded plugins: securitySetting up Install

Redis data type -- List, redis -- list The Redis list is a simple string list sorted by insertion order. You can add an element to the header (left) or tail (right) of the list) The LPUSH command inserts a new element into the header, Insert a new

ERROR 1130: Host ''is not allowed to connect to thisMySQL server, 1130 thismysqlOne user asked for help today, saying that PHPmyadmin can connect to the database normally. An error is reported when sqlyog is used: ERROR 1130: Host '2017. 27.214.1

Make progress every day-MySQL-myisampack and mysqlmyisampack I. Introduction Myisampack is a tool for compressing tables using the MyISAM engine. Generally, it compresses 40% ~ 70%. When you need to access data, the server will read the required

Use a windows client to connect to the postmaster and linuxpostmaster on a linux Server1. Modify the pg_cmd.conf file on the server.Modifying filesHost all 127.0.0.1/32 trustAs follows:Host all 0.0.0.0 0.0.0.0 trust2. Modify the postgresql. conf

5th million,5. Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT ('hm _ RUN_1061 ') Run Name: HM_RUN_1061 Run Id: 1061 Check Name: Data Block Integrity Check Mode: REACTIVE Status: COMPLETED Start Time: 22:11:02. 03229

MySQL dynamic SQL statement execution uses time as the table name, mysqlsql1. Description When using data, we need a lot of databases and want to use time as the table name to differentiate them. However, MySQL does not support using variable names

MySQL view and mysql View Part 1: Basic concepts and applications 1. View Overview The MySQL view and the Oracle view are a concept, that is, a virtual table with no data, and the data is stored in the base table; 2. Add a view 1: syntax CREATE [Or

Start and Stop the mongodb database.The start and stop of the zookeeper database is the most basic operation of the database and the prerequisite for the database to provide services and be connected to and managed. There are some differences

Another method to split fields into tables in Birt, birt Field Source: http://developer.actuate.com/community/forum/index.php? /Topics/36204-split-data-row /. Splitting a field into multiple records can be implemented using a stored procedure or

Redis _ dictionary and redis dictionaryTwo things you should know before reading this article. First, Redis is a Key-Value database, and second, the dictionary is an abstract data structure that stores Key-Value pairs. It is difficult to guess that

About rman duplicate from active database to build dataguard, rmandataguard For rman duplicate from active database, the actual operation is backup as copy. Many empty blocks will be copied. It is not recommended for those with database data files

246th questions, 053246246. The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generatesPlan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are already med by the optimizer

Sqlplus logon fails to locate the program Input Point longjmp in the dynamic link library error message, sqlpluslongjmp Problem description: When we log on to Oracle sqlplus as follows, the program cannot be located. The longjmp input point is in

OGG rep process to view the rep processing progress when processing large transactions, oggrep GGSCI (hosta) 17> info repxyREPLICAT REPXY Last Started 11:35:56 Status RUNNINGCheckpoint Lag 00:00:31 (updated 01:50:21 ago) Log Read Checkpoint File/u03/

SQL--MYSQL query statement Daquan, sqlmysql statement 1: Use the SHOW statement to find out the current database on the server: Mysql> show databases; 2. Create a database named MYSQLDATA Mysql> create database mysqldata; 3: select the database you

Error code: 1242 Subquery returns more than 1 row, 1242 subquery1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT t. id, DATE_FORMAT (t. statisTime, '% Y-% m-% d % H: % I: % s') statisTime, (SELECT 'id' FROM

Redis master-slave replication complete synchronization and partial re-synchronization process, redis master-slave synchronization process I recently read the master-slave replication section of redis. I have summarized the two Synchronization