Database Administrator

Innotop MySQL Monitoring Tool Innotop is a monitoring tool that displays MySQL and InnoDB Storage engines in text mode. Innotop is developed in the perl language. It can be used more flexibly on various operating platforms. It can monitor the

Oracle stored procedure description for determining whether a point falls on the surface 1. Background In the leting project, our engineering colleagues proposed that they should be able to determine whether the point is located in the leting

MySQL batch Insert application ON DUPLICATE KEY UPDATE It is not clear whether the problem is design or implementation.At last, it was a strange demand for me. Award_credit_room table, which stores user gift historyAward_credit is the point record

Oracle deletes records in a table in batches When Oracle deletes a large number of records in a table in batches, batch deletion is often used and is submitted one by one for three reasons:1. Avoid the impact on select of other transactionsIf other

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

Oracle SCN-system change number learning notes SCN is the internal clock of Oracle, which is used to reflect changes in the database and is constantly updated during operation. SCN types include: (1) Current SCN OF THE SYSTEM (2) Checkpoint SCN

RMAN backup Error 1.1.1RMAN backup Error1.1.1.1 problems and phenomenaChannelORA_DISK_1: starting piece 1 at 05-MAY-15 RMAN-00571: ========================================================== ============================== RMAN-00569: =================

ORA-02050 transaction processing xxx has been rolled back, some remote databases may have problems -- Database check found a database today reported a ORA-02050 error:ORA-02050: transactions 35.28.256948 have been rolled back and some remote

MongoDB basic (6) security (permission operation) and mongodb Security Like all other databases, permission management is similar. Mongodb stores all user information in the admin database collection system. users and stores the user name, password,

Date and Time storage and processingThis section summarizes the knowledge about date and time that are frequently used in databases.Because the character set has an effect on the date and time, this is the first thing we need to pay attention to,

Database introduction, database I have a certain understanding of this aspect of knowledge, but there is still some confusion. The first database I know is Access relational database, which is the most commonly used database on Microsoft Office to

I implemented the JDBC driver for the memory database and the jdbc driver for the memory database. I made a memory database last year and thought it was very powerful. The memory database is a program that runs independently. The client accesses the

Oracle generation random date and time, oracle generation date 1. Generate a random date For example, to generate an arbitrary date within January 1, 2015: /** Analysis: any date within, that is, the date range is (2015)* Can be converted to + (0,36

Oracle12c installation, connection, usage, etc. oracle12c Installation 1. oracle12c Installation See the following link: Http://jingyan.baidu.com/article/f96699bbab21c0894e3c1bf8.html 2. A ORA-12514 error occurred while connecting to the

DS-based linked list for reverse local configuration The reverse setting of data elements in a linked list is a very common example. An additional inverse function is required for the blog to reverse the input data in an ordered table, to implement

RMAN duplicate database, rmanduplicate Use the RMAN duplicate command to create a secondary database. Once the secondary database is created successfully, it is out of the source database. You can use the secondary database for some

Database and database LearningLogical Structure Design Task of Logical Structure DesignThe basic E-R diagram designed at the conceptual structure design stage is converted into a logical structure that complies with the data model supported by the

Database and database LearningConceptual Structure Design What is conceptual structure design?Abstract The user requirements obtained from the requirement analysis into an information structure, that is, the conceptual structure design process.The

MySQL learning notes _ 6_ SQL language design and writing (below), learning notes _ 6_ SQL SQL language design and writing (II) -- SELECT query Summary: SELECT [ALL | DISTINCT] # distinct is DISTINCT, clear, and different. {* | Table. * | [table.]

Slow parameterization query and slow parameterization I am so tired that I have worked overtime till now, but you have done all the work you are in charge. But you still need to cooperate with others. You can only wait !!! It's already early in the