Database Administrator

ORA-12520 error resolution instance Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I can report the

Modify the size of Oracle redo log files Modify the size of Oracle redo log files 1. Create 3 new log groups SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log') SIZE 500 M; SQL> ALTER DATABASE ADD LOGFILE GROUP 5 ('/u0

Oracle Database cannot be accessed using localhost and 127.0.0.1 I recently learned about Oracle databases and installed Oracle 10g (Version: oracle_10g_10.2.0.20.win32) in Windows XP SP3 on a virtual machine ). After the installation is complete,

RedHat6.5 install Oracle 12C RAC 12c RAC Installation Process Note: The following configurations are executed on both nodes.1. Network Configuration Take rac01 as an example. Both nodes must be configured. Eth0 and eth1 are bond0 Eth2 and eth3 are

Oracle locks the temporary table statistics and whether the hint can be dynamically collected after the lock The statistical information of the global temporary table cannot be collected. If it is collected, its statistical information must be 0,

How to avoid the problem that the table cannot be used when MySQL modifies the table structure When modifying the table structure, MySQL may interrupt the normal operation of the product and affect the user experience, or even worse, resulting in

When the Oracle Session is locked A problem often occurs. A table in Oracle cannot be updated suddenly, either through pl/SQL Developer or through sqlplus, the execution of the update statement or the execution of the select * from table_name for

Memcached status analysis, memcached status 1. memcache status stats description: Pid memcache server process ID uptime server has run seconds time server current unix timestamp version memcache version pointer_size pointer size of the current

Oracle dynamic SQL, oraclesql The syntax for executing dynamic SQL statements is: Excute immediate dynamic SQL statement using binding parameter list returning into output parameter list   Test Table: student (id, name, age ); Example: Storage

Oracle forced index using HINT, oraclehint First of all, it depends on whether your Oracle optimizer uses RBO or CBO,(1) If RBO is used, it will be performed in the Rule Order.(2) If CBO is used, you can use the HINT method to modify it.

High-efficiency frequent mode mining algorithm PrePost and fin c ++ source code, prepostfin For the C ++ source code of PrePost, see http://www.cis.pku.edu.cn/faculty/system/dengzhihong/source%20code/prepost.cpp.For details about the Algorithm, see

Oracle 11g system automatically collects statistics, oracle11g--- 11 GB is from Monday to Friday-Saturday-SELECT w. window_name, w. repeat_interval, w. duration, w. enabledFROM dba_autotask_window_clients c, dba_scheduler_windows wWHERE c.

MySQL database environment and simple operations, mysql database environment **************************************** ****************************************************** Original works, from the "Xiaofeng residual month xj" blog, welcome to

Mysql com. mysql. jdbc. StatementImpl $ CancelTask Memory leakage problem and solution, mysqljdbc Recently, I have been responsible for the maintenance and construction of the company's SMS gateway. As the company's business develops, the reliance

Chinese celebrities in various database fields -- china topgun and -- chinatopgunCelebrities in various database fields:Oracle db is currently a hot topic. There are quite a few celebrities in this field, such as white eel, krzl, old gai, old Yang,

After the oracle splits the string, it is displayed in a single column and multiple rows in oracle. Original SQL: Select substr (field1, instr (field1, '|', 1, rownum) + 1, instr (field1, '|', 1, rownum + 1)-instr (field1, '|', 1, rownum)-1) as

Shell extracts msyql and specifies the statement used to create a table in the database as a single file, dbcn="mysql -h172.16.1.194 -uroot -p123456";db=dsp_ad_center;ii=0;ct=`$dbcn -N -e " SELECT COUNT(1) FROM information_schema.TABLES AS t WHERE

Set Type and redisset type in redis In redis, the set type is an unordered Set. It is implemented through HashTable in redis. The advantage of the set data type is to quickly find whether an element exists and record some non-repeated values, for

Mysql statement Summary Some time ago, my project was finally completed. The project mainly involves reports and a lot of SQL statements, so I would like to summarize it.I. Basics 1. Database-related commands A>. Create a database Create database

In windows, mysql forgets the password, and mysql forgets the password.In windows, what should I do if I forget my mysql password? I will give a case and explanation! Solve the problem! The actual operations in Windows are as follows: 1. Disable