Database Administrator

Oracle Developer code The following are quotations from Oracle: Oracle Database developers shocould follow is to do everything they can in SQL. what they cannot do in SQL, they shoshould do in PL/SQL. and what they cannot do in PL/SQL, they

Solution to ORA-4031 errors In the face of ORA-4031 error, your heart will not send? The ORA-4031 can easily cause an abnormal database crash, which will crash when Oracle's core processes fail to get the Shared Pool memory. Of course, ORA-4031 is

Database performance exception and slowness caused by full archiving of Oracle logs When the database performance is abnormal and slow due to full archiving of Oracle logs, I did not view the alarm log and thought it was because the lock blocking of

Oracle DBCA does not see started instances and Handling Methods I. Problem description: I tested the Oracle database in a unit. I wanted to use DBCA to check the database configuration information. Of course, I am also in a panic. Who would have

A Simple Method for importing data to mysql. Because ubuntu comes with mysql 5.5 by default and cannot use the advanced feature load data infile, we have written a general script to upload files. Shell script cat ./employee.csv | while read LINE

Innodb change buffer passive merge, innodbbuffermergePassive merge scenario 1: insufficient secondary index page space: ibuf0ibuf. cc: ibuf_insert_low 1. When a cache insert operation is attempted, if the estimated space of the secondary index page

Beckham _ redis string type learning, _ redisstring RedisString type 1. View string-type commands Ii. string operation example     1. View string-type commands 1. Open the redis client and enter help 127.0.0.1: 6379> help Redis-cli2.8.19 Type: "help

Transform mondrian's conception and mondrian's ConceptionMondrian needs to be used recently in the project, so first read the following mondrian source code. In general, mondrian is a ROLAP engine, but its positioning is still a component provided

How to ignore the title of the first row of an oracle External table? Article from the csdn blog Oracle bug, if reproduced please indicate the source: http://blog.csdn.net/yfleng2002/article/details/47104723 Introduction When an oracle External

Obtain the random time of the specified date (oracle function), oracle Function Address-http://blog.csdn.net/qq525099302/article/details/47146067 /* The relative minimum value of the date string v_begin random date in the format of v_date

How Does oracle execute stored procedures? The stored procedure is as follows: Create procedure gokul_proc (pId in number, pName in varchar2, OutCur OUT G_PKG_REFCUR.rcDataCursor) isBEGIN Open OutCur For select * from gokul_table ob where ob.

The "pitfalls" and key points encountered during Oracle RAC installation (I), oraclerac When using virtual machines to build the RAC environment on a physical machine, many "pitfalls" and key points are encountered.   Physical Machine: Intel (R)

Path had bad permissions error solution when Mac OS X is started, pathpermissions Recently, I encountered the above prompt when installing mongodb. I found no solution for various Chinese websites, so I checked the foreign websites and finally

MongoDB master-slave and replset test, mongodbreplset1. masterslavemaster configuration file: dbpath = ../data_test/db/masterLogpath = ../data_test/master. logPort = 8642Logappend = trueOplogSize = 2048StorageEngine = wiredTigerNojournal = trueSlave

Beckham _ mysql optimization learning, and Beckham _ mysql OptimizationMysql OptimizationBrief:1. Database Design Optimization2. SQL statement Optimization3. Table Segmentation4. read/write splitting technology   I. Database Design Optimization 1.

MySQL displays "error 1067: Unexpected Process Termination", and mysql1067 1. Error description 2. Error cause Today, I am exploring how to use commands to view MySQL logs. I have checked a lot of information, mostly by modifying the

Windows operating system logs when a hard disk suddenly drops out of the disk in windows 7, and Windows 7Environment: three desktop hard disks (sata3 Interface) are connected to the same desktop without raid, one of which is hard disk (Note: Not a

ORACLE11g poisoning recovery, oracle11g poisoning Unfortunately, the win2003 server is neglected to manage and poisoned. After the virus is cleared, oracle is paralyzed. What should I do if the last backup is still one week ago? The first idea is

Centos-based mysql learning Supplement 1: centosmysql Learning Export the SQL script of a database in the mysql database-that is, import the structure and data of the database to an SQL script, and then restore the database through the SQL

Mongodb chunk size settings, mongodbchunk The default value is 64 MB. The value range is 1 MB to 1024 MB. So what will the modification cause? The following table is a summary: Chunk size adjustment Splitting