Database Administrator

How to clear the execution plan of an SQL statement in the share pool in Oracle 11g In the past, if the execution plan was slow due to binding snoop on Oracle 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it

Oracle 10g Lsnrctl does not reflect database connection failure Symptom Description: The Oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is entered, no

Oralce's Save command and OralceSave command You can use the save () command to save the content of the current buffer to a file, so that even if the content in the buffer is overwritten, The syntax for saving the current statement is also retained

Install Mysql MMM On Redhat6.3, mmmredhat6.3 Haha, the last article at the end of the year. This afternoon's holiday. MMM official introduction:MMM (Multi-Master Replication Manager for MySQL) is a set of flexible scripts to perform

An exception is thrown when the default MySQL query time is used.The problem occurs when a mysql table is created, with a field of the Date type in the table. The default value is 0000-00-00 00:00:00. PrepareStatement is used for query, and the

What is HBase? HBase Classic explanation: http://www.cnblogs.com/skyme/archive/2012/07/25/2608310.html   HBase: Non-relational databases; distributed databases; HDFS-based minimum storage unit, which is a file storage. Column storage. (Relational

Oracle memory problems In Oracle, the memory structure mainly includes two categories: SGA and PGA. SGA represents the system global zone, and PGA represents the program global zone. Oracle memory mainly stores the execution program code (PL/SQL,

Oracle alter table, oraclealtertable Create table T_CLASS_INFO (CLASSNO number (3) primary key, -- class numberCLASSNAME varchar2 (10 ),CLASSPLACE varchar2 (13));Create table T_STUDENT_INFO (STUNO number (3), -- Student IDCLASSNO number (3 ),STUNAME

Install mysql in Linux and mysql in LinuxI. Simple Installation# Yum install-y mysql-server mysql-develIf an installation package conflict is reported:File/usr/share/mysql/ukrainian/errmsg. sys from install of MySQL-server-5.5.18-1.rhel5.i386

Install and configure Mongodb in linux and mongodblinux MongoDB is a product between relational databases and non-relational databases. It has the most abundant functions and features like relational databases. The supported data structure is very

[Leetcode SQL] Customers Who Never Order, leetcodecustomers Suppose that a website contains two tables,MERsTable andOrdersTable. Write a SQL query to find all customers who never order anything. Table:MERs. + ---- + ------- + | Id | Name | + ----

SqlServer export data files (figure), sqlserver export data 1. Right-click the database-> Tasks-> Generate Scripts 2. click Next. 3. Select to export the entire database and start a single data table. 4. Set to save as a file, set the

Use a stored procedure to update Tables in batches and a stored procedure to update Tables in batches Recently, we have made a demand to update database tables in batches. However, because there are a large amount of data involved (tens of millions

In mysql5.1, the following Chinese Character in utf8 encoding occupies a char. mysql5.1utf8Recently, it was found that the length of the Oracle and MySQL fields is calculated differently (both are UTF-8 encoded), for example:Defined in Oracle: name

Install Mysql on ubuntu online and perform some operations. Install Mysql online on ubuntu and perform some operations 1. Three commands used to install Mysql: Open the terminal and enter sudoapt-get install mysql-server. Enter sudoapt-get install

ORACLE user PROFILE and oracleprofile ORACLEUserPROFILEDetails I. Official Website description Oraclerecommends that you use the Database Resource Manager rather than the SQLstatement to establish resource limits. The Database Resource Manager

Oracle Data Type-3, oracle-3 9. TIMESTAMP WITH TIME ZONEIt contains all fields in the TIMESTAMP data type. In addition, it also contains two additional fields: timezone_hour and timezone_minute. This data type contains information about supported

Oracle data type-2, oracle-2 5. NUMBERIt is used to store zero, positive, fixed-length negative, and floating point numbers. The NUMBER data type can be set to NUMBER (P, S) Format to define the precision and range of numbers. Here: p indicates

Common timensten maintenance operations and timensten Maintenance **************************************** ********************************* * ************ --- 1. keep it in the memory ttAdmin-ramPolicy always ttwind --- 2. load the application to

Use of Oracle exp/imp Export Import tool-1, expimp The exp export tool compresses data backup in the database into a binary system file, which can be migrated between different operating systems. The imp import tool imports binary system files