Database Administrator

Oracle 11g Set User Password case sensitivity Oracle 11g uses a parameter to set the password's case sensitivity. The following is an experiment: C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ ggSQL * Plus: Release 10.2.

ORA-13600 QSM-00794 error Solution 1, wanted to use dbms_advisor to do a SQL access advisor test, but unexpectedly encountered ORA-13600 QSM-00794 error, as follows: SQL> DECLARE2 task_name VARCHAR2 (200 );3 BEGIN4 task_name: = 'my _ task ';

Failed to upgrade Oracle Cluster Registry configuration (root. sh), clusterroot. shRecently, we have installed Oracle 10g RAC on Suse 11 sp3. After installing clusterware, run/u01/app/crs/root. sh received an error message, Failed to upgrade Oracle

From ORA-27300, ORA-27301 to ORA-00064, ora-27300ora-00064Recently, due to the increase in the number of sessions, you need to adjust the session, that is, to adjust the process parameter. Look at is a relatively simple problem, but encountered a

Data center billing system and Charging System In fact, I think the checkout part of the data room charging system consumes the most energy. First of all, I don't understand what the checkout is, so I feel dizzy as soon as I come up. Later, I read

Application of Oracle virtual index, oracle virtual Index When performing SQL optimization, you may need to add an index to test whether it can help improve the performance. If the table is very large at this time, it will be very troublesome to

Oracle OCP-hard parsing the process of obtaining the memory lock in the Shared Pool, oracleocp Reprinted please indicate the source: Http://blog.csdn.net/guoyjoe/article/details/38684819   1. Obtain the library cache Latch. (1) The text of the SQL

Data room charging system trigger and charging system trigger The earliest Contact trigger was seen in Yan jianling's video, but he did not understand it at all. However, when the data center charging system was implemented, it turns out that SQL

Mysql optimization, mysql Mysql optimization (in linux) Method 1: Add SQL logs to locate slow queries 1. First, add timeout control in the mysql configuration file, and add 2 S timeout under mysqld: Vi/etc/my. cnf 2. Restart mysql, set log to on,

Mysql id starts from 1 and mysqlid1Truncate table rectContent (data table)How can I reset the ID auto-increment from 1 when clearing the MySQL table ?? The truncate statement clears the table content, including the information of the

Sqlite learning notes 11: Using sqlite to delete records in C language, sqlite learning notes The last section describes how to delete data. All the previous code is inherited here and passed the test on Ubuntu14.04 and Mac10.9. # Include #

Sqlite learning notes 9: Using sqlite to insert data in C language, sqlite learning notes I have created a table before. Now I want to insert some data into the table. The data inserted is similar to that in the table creation. The SQL language is

Sqlite study notes 5: insert data, query data and delete data, sqlite Study Notes Zeng Wen: All programming is data-centric, which makes sense. The so-called database has no data. Next we will look at how to insert data into the table.   1. Insert

Postgresql ALTER common operations, postgresqlalter Postgresql version: psql (9.3.4) 1. ADD an alter table table_name ADD column_name datatype; 2. delete an alter table table_name DROP column_name; 3. Change the Data TYPE of the alter table

ORA-31693, ORA-02354 and ORA-01555 with Export Datapump, ora-31693ora-02354SymptomsORA-31693: Table data object "YXFUND". "MF_NOTTEXTANNOUNCEMENT" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing

Having has some differences in Oracle and mysql, havingoraclemysql In Oracle, having must be used in combination with group by, but in mysql, the situation is different and can be used separately. C: \ Documents ents and Settings \ guogang> sqlplus

Oracle groups fetch the first data in each group, and oracle groupsObtain the first data in each group after grouping in oracle. [SQL] SELECT * FROM (SELECT ROW_NUMBER () OVER (PARTITION BY x ORDER BY y DESC) rn, test1. * FROM test1) WHERE rn = 1;

Data center charging system-triggers and data center charging system triggers In the previous article, we learned how to use the view. We still need to know a lot about the database. What is a trigger? How to use it? What are the advantages of using

MYSQL, innodb_buffer_pool_size memory allocation method, innodbbufferpool I used to think that MYSQL, innodb_buffer_pool_size = 8 GB, MySQL will occupy 8 GB of memory when it moves together (I think TOP can see that the memory is used 8 GB), but I

Uninstall the oralce11g registry 20140810, oralce11g20140810 Windows Registry Editor Version 5.00[-HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE][-HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in