Database Administrator

Oracleclient + PLSQL Developer remote login to Oracle Database Oracle databases have powerful functions and excellent performance. When these advantages are created, Oracle accounts for more memory than memory. To address this problem, how can we

Oracle DBA_EXTENTS view and DBA_SEGMENTS ViewDBA_EXTENTS describes the extents comprising the segments in all tablespaces in the database. note that if a datafile (or entire tablespace) is offline in a locally managed tablespace, you will not see

How to diagnose sysdate Return Error time in RAC Environment Recently, some rac environments have been used to access sysdate and return the error time. This problem often occurs when the database link is created through Listener, and, in most cases,

Mha vip switch script MHA can ~ Automatic Fault Detection and Failover within 30 seconds, suitable for high availability and high data integrity requirements. To achieve seamless switching, you also need to rely on VIP drift. The commonly used

Install and configure MongoDB 2.4.10 IntroductionMongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for WEB applications. FeaturesHigh performance, easy

Precautions for storage planning before Oracle11g RAC + ASM Installation When should we start to better optimize the performance of Oracle databases ?, Based on my years of practical experience, I think it is best to start with the storage plan

Basic Principles of Oracle Indexing I. Basic indexing conceptsOracle provides two methods: Read all rows from the table (full table scan), or read a row at a time using ROWID. If you only access 5% of rows in the big data table and use indexes to

[Mybatis] add, delete, modify, and query using Mybatis interface programming method. Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka In the previous chapter [Mybatis], the introduction to

R language and data analysis [quarter 1st], Data Analysis Today's computer systems need to process a variety of data types and filter data for deep understanding. At the same time, open-source applications are becoming increasingly popular, all

Error Code: 1630. FUNCTION rand. string does not exist, 1630rand. string 1. Error description 13:50:13call new_procedureError Code: 1630. FUNCTION rand.string does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference

Mongod. conf, mongodbmongodb. conf Mongod-f 'config path' MongoDB introduces a configuration file in YAML-based format. Versions earlier than 2.4 are still compatible. My mongodb configuration file: systemLog: destination: file path:

Use codeblocks to debug mysql and codeblocks to debug mysqlCodeblocks debugging mysql environment setup 1.decompress mysql-5.6.23.zip to the user root directory ~ /2. In the user root directory ~ /, Create a Folder build and mysql3. open codeblocks,

Secondary index of the Aerospike-Architecture series, aerospikeSecondary Index (Secondary Index) The secondary index is built on a non-primary key to give the model a one-to-multiple relationship. The index is specified based on bin (similar to

DS sequence tables implement output in disordered input sequence, ds There are many instances of sequence tables. When learning other programming languages, you must have learned to input a series of numbers in disorder, which requires sorting to

SQLite tutorial (6): expression explanation, sqlite expression I. common expressions: Like most relational databases, SQLite can well support expressions provided in the SQL standard, and its functions are consistent with the SQL standard, such:Copy

[Translated from mos] explanation of histogram information and mos Article histogram Information     Interpreting histogram InformationSource:Interpreting Histogram Info (Doc ID 72539.1) Applicable:Oracle Database-Enterprise Edition-Version 7.3.0.0

Database-Introduction to databasesDatabase status Since the end of 1960s, database technology was the latest technology in data management and an important branch of computer science.Database technology is the core and foundation of information

[Mysql] mysql database Common commands, mysql database Common commands1. Database authorization Go to the mysql database: mysql> use mysql; set a new password for the root user: mysql> update user set password = password ("new password") where user =

Error: 1130-host... is not allowed to connect to this MySql server, 1130-hostallowed Solution: 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql

Several useful functions in mysql, useful functions in mysql1. FROM_UNIXTIMEPurpose: display the time stored in INT (11) in MYSQL in the "YYYY-MM-DD" format. Example: select mtime, from_unixtime(mtime) from topics limit 10; 2. CONCAT (str1, str2