Database Administrator

MySQL Character Set settings Recently, in the MySQL database used by the project team, garbled data is inserted. We have summarized this issue. Let's start from the basic point, to the deep-seated causes and solutions of errors. Basic Concepts •

Oracle Database 11gR2 OEM troubleshooting case If the customer's OEM fails, the logon page is displayed as follows: Checking the database status and services is normal.The best way to solve the problem is, of course, to view the background log and

Create and modify temporary tablespace of Oralce A temporary tablespace is a disk space used to store the temporary data generated when you execute the order by lamp statement for sorting or summarizing. By default, all users use temp as the default

CentOS6.5 _ 64 bit compiler installation MySQL-5.6.23, centos6.5mysql Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44785511 **************************************** ********************CentOS6.5 _ 64bit compile

Oracle rac does not support rhel5.x, rhel6.x, and rhel5.xrhel6. x. Oracle rac does not support rhel5.x and rhel6.x Because rhel5.x and rhel 6.x appear in oracle as "different operating system versions" The answer from oracle's sr engineers is as

CppSQLite3U usage summary, cppsqlite3u Summary CppSQLite3U is a class for operating sqlite3 that can be used by encapsulated MFC. I wrote a copy of it myself, but later I always felt that it was not mature enough to modify the code and felt that it

Batch auto-fill row numbers in Excel and batch-fill row numbers in Excel1. Select the columns to be calculated: move the cursor to the last row, then press CTRL + SHIFT + cursor, and SHIFT + cursor to remove the header.2. ENTER =, and then CTRL +

First experience of mongodb, mongodbMongodb initial experience A new workflow product needs to be developed after the start of the year. It is mainly used to manage the management process in the automotive industry. Because it is similar to the old

Duplicate sid installation in oracle and repeated oraclesid After Oracle is uninstalled, it is installed again. If the configured SID is the same, "the specified SID already exists on the local machine. Please specify a different SID ." SID

20 database operation optimization experience and 20 databases summarized from the actual project 1. Use indexes to improve efficiency:An index is a conceptual part of a table to improve data retrieval efficiency. ORACLE uses a complex

Miscellaneous-excerpt from various IT tips and excerpt from it tips A. How to Set environment variables? /* Add the mysql running path (C: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin) as an example */ Method 1: [temporary, only effective in the

Stored Procedures, functions, triggers, and stored procedure triggersDifferences between stored procedures, functions, and triggers Compare items Stored Procedure Function Return Value? Yes or no Must have

Mysql "net" is neither an internal command or an external command, nor a program that can be run. I have not used mysql for a long time. I went to struts2 last night to work on the small bbs project, used the database, started it, and input net

The conversion from the datetime2 data type to the datetime data type generates a value out of the range, datetime2datetime This error occurs when you use Entity Framework to operate databases.This error is strange, in the garden saw a brother

Database transaction isolation mechanism and transaction isolation mechanism Transaction isolation level: the degree of isolation between one transaction's modification to the database and another transaction in parallel. When two concurrent

How to diagnose the error time returned by sysdate in rac, racsysdateRecently, 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

Mongodb query, mongodb1. query a single record > db.choice.findOne() 2. Specify query conditions during Query > db.choice.find({"_id":"005a38d5"}) All queries by default {} Return Column > db.choice.find({"_id":"005a38d5"},{"title":1,"results":1

Command for viewing Nic information in linux, and command for viewing Nic in linux Rhel kernel version: [root@hvrhub ~]# uname -aLinux hvrhub 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Linux   View the driver and

B * Tree Index Range Scan of CBO, cborange Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/44262353 **************************************** ******************** Ii. CBO's B * Tree Index Range Scan-IRS Algorithm****

[PLSQL] variable binding, dynamic SQL, hard parsing and soft parsing, plsqlsql**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column******************************