Database Administrator

How to manually delete an Oracle 11g database in Linux The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment. I installed the Oralce 11G database on CentOS 6. Use SQLPlus or other command line tools you

Debugging and optimization techniques for 101 MySQL instances MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 101 tips for adjusting and optimizing

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device) Because the customer's database needs to be patched, similar test environments are installed. You must first install Oracle RAC 10.2.0.1 and then upgrade it to 10.2.0.5. Because I have many

How does GitHub improve website performance by migrating MySQL databases? GitHub, as a widely used open-source code library and version control system, has a significant impact on the performance of its database MySQL. Next we will follow the pace

Basic knowledge about NoSQL Databases This article is from: NoSQL database getting started. For details about how to download the PDF version, seeWhat is NoSQL? Have you heard of NoSQL? In recent years, this word has received a lot of attention.

Case study of SQLyog client unable to connect to MySQL Server-- View the Client ip Address [root @ mysql ~] # W 22:20:43 up, 1 user, load average: 0.00, 0.01, 0.05 user tty from login @ idle jcpu pcpu WHATroot pts/1 192.168.1.7 22:23:15 3.00 s 0.07

Mongoose simple table connection query and Mongoose simple The original article is taken from my front-end blog. You are welcome to visit Http://www.hacke2.cn As I mentioned in this article, it is based on Node. js + jade + Mongoose mimic gokk. TV,

MySQL variable definition and assignment, mysql variable assignment Variables can be declared and used in subprograms (functions, stored procedures, anonymous blocks). These variables are used in the BEGIN... END program.Syntax format for defining

Soft test path-linear table of Data Structure, soft Test Data Structure The data is the value, that is, the result we get through observation, experiment, or calculation. There are many types of data, the simplest of which is numbers. Data can also

How to uninstall the "hidden oracle" software installed after an error is reported, and the hidden oracle **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog".

Database usage-oracle bitmap index,-oracle bitmap Index Currently, a large number of indexes are mainly B * Tree indexes. The index structure stores the rowids of key values and key values, which correspond one to one. Bitmap indexes are mainly

How to obtain the correct base estimation and base EstimationOriginal article: http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13asktom-1886639.htmlI have a question about joining with collections and cardinality estimation. the

About the script configuration during DDL replication when the ogg version is upgraded after the db version is upgradedAfter the db version is upgraded, the ogg version is also upgraded.The db version upgrade here is from 10.2.0.5 to 11.2.0.3, so it

Simple tutorial on SQL statements in linux --- primary key, foreign key, and SQL Primary Key)Each item in is a unique value in the table. In other words, it is used to uniquely identify each row of data in a table. A primary key can be a column in

Blood lessons --- ogg must use the latest version, and blood lessons --- ogg must useThis cocould be a Bug 19517566-ie extract abend with OGG-01161 bad column index relating to the extract where the extract was still resolving the old metadata and

The five most common problems that cause the RAC instance to crash, the rac instance to crash Five most common problems that cause the RAC instance to crash (Document ID 1549191.1)   Applicable: OracleDatabase-Enterprise Edition-version 11.2.0.1

Assertion: 18 {code: 18, OK: 0.0, errmsg: "auth fails"}, assertionerrmsg When auth is enabled, mongodump is executed and mongorestore has the following error: "assertion: 18 {code: 18, OK: 0.0, errmsg:" auth fails "}" Actually, authentication

ORACLE _ create and manage tables, oracle CreationZookeeper ORACLE _ create and manage tables ① Common database objectsTable: A Basic Data Storage set consisting of rows and columns.View: logically related data set extracted from the table.Sequence:

Bat + sqlcmd run scripts in batches and batsqlcmd run scripts Hello, this BAT script helps developers to Batch Execute all SQL scripts in a folder by file name in the specified database. Powershell invoke-sqlcmd is too cumbersome to handle. Bat file

Redis memory fragments and Redis memory fragments Redis uses jemalloc to allocate memory by default. According to the best article in fast '14, when a variable-length key-value load occurs, the fragmentation problem may occur: low memory utilization,