Database Administrator

Monitoring MySQL monitoring transaction hanging (RUNNING) alarm notification in Nagios Preface:An error occurred while submitting the business alarm order. The page was not responded. After troubleshooting, the transaction was not committed or

An example of ORA-28547 Fault Handling Last week to the customer training Oracle, talked about the DG part of the actual configuration demonstration, encountered a ORA-28547 fault, the customer database 11.2.0.1 version, Window platform. Previously,

A review of the IT Ninja Turtles oracle grouping method, Ninja Turtles oracle Oracle analysis functions are very powerful. We only need to master these methods. A more direct saying is that knowing the functions of these analysis functions can

Oracle's restored tablespace UNDO is full of disk space. The specific steps to solve this problem are oracleundo.Zookeeper There are two main causes:1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting

Stored Procedure ora-00942 when ora-00942 table or view does not exist Solution: Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password' Authorization statement: Grants the XXX select, insert, update,

ORA-07274: spdcr: access error, access to oracledenied., spdcroracledenied ORA-07274: spdcr: access error, access to oracledenied.     Symptom: The ORA-12545 error is reported when SQL plus/as sysdba logs into the database, as

About T-SQL and SQL Enterprise Manager, SQL Enterprise After reading the database video, we often use two methods in the video. One is the SQL Enterprise Manager, and the other is the T-SQL (Tansact-SQL ). For the first method, it feels very simple.

The structure of the Mysql table is InnoDB and data is restored from the ibd file. innodbibd The customer's machine system is shut down abnormally. After the restart, the mysql database cannot be started normally. After the system is reinstalled,

Interview Questions, java interview questions 1. Use case when for subquery SELECT u.id user_id,u.username user_username,g.id group_id, CASE g.flag WHEN '0' THEN g.groupcode ELSE (SELECT t.fullname FROM tab_0009 t WHERE t.id = g.id)

Redis Research (13)-security and communication protocols, redis research communication protocols I. Security Salvatore Sanfilippo, author of Redis, once published the Redis declaration, which mentions Redis to be concise and beautiful. Redis does

DB2 Client installation + SysBase installation tutorial + SysBase Client installation tutorial, db2sysbase Related DB2 client, SysBase database, SysBase client file resources: http://yunpan.cn/cKKzYYVdgXi4v extract code f27d 1. Install the DB2

8. Basic Redis commands-management-persistence-RDB, redis-rdb1. Redis supports two methods of Persistence: RDB and AOF. It can be used separately or in combination.2. The rdb a and RDB modes are the default persistence methods adopted by Redis,

T-SQL time operations (dateadd, datediff, datepart, datename), datepartdatename -- 1. current System Date and Time select getdate () -- 09:27:27. 277--2. the Time Operation dateadd returns the new datetime value dateadd (datepart, number, date)

Redis data persistence, redis dataIn general, there are two persistence solutions: RDB and AOF.The RDB method creates a time point-based snapshot for the dataset at a certain interval.The AOF method records the write operations received by the

A simple instance of a stored procedure and a simple instance of a stored procedure The content of the bank deposit table (bankMoney) is as follows: Id UserID Sex Money 001 Zhangsan Male 30 002 Wangwu

Install mongoDB in windows and mongodb in windows1. Original Intention This is so simple that I have been thinking about whether to write an article for a long time. However, for beginners, anything they have never touched may become a stumbling

Com. microsoft. sqlserver. jdbc. SQLServerException: The result set does not have the current row, and the result set is exhausted.Refer to blog com. microsoft. sqlserver. jdbc. SQLServerException: The result set does not have the current row. Java

How to Choose enterprise-level data storage (DAS), NAS and SAN, and enterprise-level dasnassan For an enterprise, the security of network data is extremely important. Once important data is damaged or lost, it will have a significant impact on the

Elasticsearch October 2014 briefing, elasticsearch1. Elasticsearch Updates 1.1 released Kibana 4 Beta 1 and Beta 1.1 Kibana 4 is different from Kibana in layout, configuration, and bottom-layer Chart Drawing. After learning the functional

Oracle displays the user's table names, Table Comments, field names, field comments, whether it is empty, field type, and oracle fields. -- Oracle: view all the table names, Table Comments, field names, field comments of the user, whether the table