Database Administrator

Quickly build a Linux operating system + Oracle database environmentI always wanted to learn about the O & M of Oracle databases in Linux, but the process of installing the Linux operating system from the beginning and then installing the Oracle

ORA-01536: exceeds the space limit for tablespace XXXX /******************** ORA-01536: exceed the space quota of the tablespace XXXX *******************/ /******************** ORA-01950: the table space FMISINDEX has no permissions *****************

Test data of PostgreSQL running on FreeBSD and Linux This afternoon I wanted to test DragonFly dports. I suddenly wondered why I didn't compare the performance difference between PostgreSQL in BSD and Linux. For this reason, I set some standards to

Password verification during Oracle user Creation We need to perform some performance tests in the test environment today. In order not to affect the original data, we need to create a temporary schema. However, the following error is reported

Lock, lock 1. view the current Lock ObjectSelect a. owner,A. object_name,B. xidusn,B. xidslot,B. xidsqn,B. session_id,B. oracle_username,B. OS _user_name,B. process,B. locked_mode,C. machine,C. status,C. server,C. sid,C. serial #,C. programFrom

Comparison of InnoDB row format (compact, redundant), innodbredundantThe InnoDB row format is divided into two formats (COMPACT, redundant). By default, the storage format of COMPACT compact is the first to be a list of non-NULL variable length

Oracle static listener registration details, oracle details Oracle static listener registration details There are a lot of articles on oracle listening for static registration on the Internet, but most of them are a simple example, there is no

In Atitit. Hibernate, Criteria uses summary and join queries and queries o9o and hibernatecriteria by sub-objects. In Atitit. Hibernate, Criteria uses summary and association query and queries o9o by sub-Object   1. Criteria, Criterion, 13. Criteria

New MySQL users and Database Access authorization, new mysql # Mysql-u root-p # Allow local IP addresses to access localhost, 127.0.0.1 # insert into mysql. user (Host, User, Password) values ('localhost', 'zhouz', password ('000000'); # allow

[MySQL] grouping and sorting: obtain the first N records and generate an automatic number sequence, similar to group by after limit, mysqlgroupPreface:The business scenario of a colleague is to group by cid and author, and then reverse the id to

Mac_MySQL installation, mysql 1. Download and install Go to the MySQL official website at http://dev.mysql.com/downloads/mysql/, and download about 164 MB of Community Server. On the following page, select No thanks, just start my download] The

Test interview that little thing (database knowledge), test interview 1> relational database standardization is introduced to solve the problems of relational databases (insertion exceptions, deletion exceptions, and data redundancy.   2> the

Impdp import Materialized View (mv) error: ORA-31685: Object type MATERIALIZED_VIEW, impdpora-31685 This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/38782657 Impdp import

Atitit... Summary of the trigger mechanism ltrigger mechanic sumup. O8f, ltriggero8f Atitit... Summary of the trigger mechanism ltrigger mechanic sumup. O8f   1. Trigger type 1 2. Implementation Principle 1 3. After trigger Vs Instead Of trigger 1 4.

Xin Xing makes mysql run faster. First, it optimizes the direction and database modeling. Xin Xing makes mysql I plan to write a set of bibliography recently, that is, about mysql optimization. First, I will write it on my blog and then sort it into

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction, hy000restarting My friend asked me that the execution of a simple update statement failed. The symptoms are as follows:Mysql> update order_info set province_id = 15, city_id

Summary of several memory data and several memory data MemSQL Principle: combines unlocked data structures with real-time compilers to handle large workloads, lock-free hashtable and lock-free skiplists (a hierarchical linked list structure) are

Blocking blocked and racblocked in RAC Environment The blocking in the RAC environment is different from that in a single instance, because we need to consider the session in different instances. That is to say, the corresponding strain of the

Use DBCA (database configuration assistant) in linux to create an oracle database and dbcaoracle Prerequisites: switch to the graphic interface Go to the bin directory of Oracle and run dbca as the oracle user. The effect is the same as that of

Solve the problem of Access denied for user ''@ 'localhost' to database 'mysql', deniedlocalhost After modifying the root user password of mysql, log on again, and the system prompts an error such as the title. After finding the answer, the solution