Database Administrator

According to the development feedback, the application will trigger an alarm at recently. The application log shows that the database connection pool is full and new connections are rejected. First, I made an ASH report (Report range: 7: 25 ~ ),

I. HA FAILOVER: the technical basis for High Availability of Oracle RAC is Failover, which means that faults of a node in the hot river in the cluster will not affect user usage, the user who connects to the faulty node will be automatically

Database repair tools-only Access databases in *. mdb Format Introduction: There is a serious Bug in Access Database Operations. When the database file content increases, the file capacity increases. However, when the database content is deleted,

Part 1 Database SQL language Database script comments   1. Overview Annotations play an important role in programming languages. Beautiful and proper comments not only help developers understand programs, but also improve programming efficiency (and

Three words: strong, big, comprehensive, and strongly recommended SQL statement Query Result select (timestamp '2005-01-17 10:00' - timestamp '2005-01-01'); 16 10:10 select (timestamp '2005-01-17 10:00' -

Ubuntu14.04 has been out for a while. I just upgraded it to this version a few days ago and I got a fresh one. However, there was a small problem during mysql installation. record it for later use. Prerequisites: There are many ways to install mysql

I started to install MySQL today. I used to download the installation package from the official website, but it was not available after installation. I guess it was necessary to configure it. I found a lot of information on the Internet and the

Mysql is connected to the job for one day. Finally, I decided to start learning jsp from scratch, saving me the trouble. After a full night of work, I finally connected the database. However, it's so sad that I even have a database... "> My

Redis is a memory database that supports more value types than memcache. Sina Weibo uses redis for caching. Install redis source codeCopy codeThe Code is as follows:Wget http://download.redis.io/redis-stable.tar.gzTar-zxvf redis-stable.tar.gzCd

For select statements: 1. When a table scan is used, the page is directly locked, instead of locking a specific record. Therefore, these locks are available: A. Database S lock B. Table IS lock C. Page S lock 2. When indexes are used to search for

This version is different from the previous one. It has a dedicated github project. Https://github.com/mongodb/mongo-cxx-driver First, obtain the source code: git clone https://github.com/mongodb/mongo-cxx-driver.git Switch the branch: git

Preface 1. the relational model requires that the relationship must be normalized. the most basic of these normative conditions is that each component (tuples) of the relationship must be an attribute of an unidentifiable data item. 2. The mode

Intranet connections are generally used in simple projects, but Chinese and foreign connections are common in actual system-level projects. In the use of external connections, I found that many people are confused about the role of the on clause

MySQL supports multiple column types: numeric, date/time, and string (character. This chapter first gives an overview of these column types, and then describes in more detail the types of various columns and the summary of column type storage

1. Open SQL developer in the Start Menu; 2. Create a database connection Click the plus sign in the upper left corner. In the displayed dialog box, enter the user name and password. If the test succeeds, click Connect. Remember to write the role

: Wget http://download.redis.io/releases/redis-2.8.8.tar.gzInstall steps:1 downloadOfficial Website: http://redis.io/Address: http://redis.io/documentationMaster-slave copy document address: http://www.redis.io/topics/replication2. decompress and

The Function Room of the Database Control Language controls the user's access permissions to the database. The DBA determines the operation permissions of a user on a certain type of data. Oracle GRANT permissions using the GRANT statement and

1Prompt NO listening service Solution: Open Net Configuration Assistant and follow the prompts to delete the existing listening service, and then create another one. 2 SQL Plus login prompt user name or password is invalid Cause: Does the

In pinwu performance optimization, Chapter 4.4.3 describes the two features of composite indexes: prefix and optionality. What is prefix? The book explains how to exclude skip scan index (there are not many pre-index columns, such as gender). If the

Service name for Dynamic Registration in the listener: If service_names is not set, the parameter values of db_unique_name and db_domain are spliced to register the listener. (service_names has a high priority). The verification is as follows :.----