Database Administrator

DB2 memory usage too high Optimization Recently, I was working on the benchmark of DB2 and found that the memory usage of the database was very high. Because the benchmark test was performed, there were not many tables, And I mainly tested one of

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 Partition Table execution plan Oracle Partitioned Tables have many advantages, such as being big, small, and small. With parallel use, loap can often improve the performance by dozens or even hundreds of times. Of course, poor table design

Oracle restrict connected IP addresses In Oracle, you can control which IP addresses can connect to the database and which IP addresses cannot connect to the database. In 9i and later, setting the allowed IP address and the prohibited IP address is

SQL serveri does not need a cursor, so it is suitable for instances with circular DML (update delete insert), serveridml SQL serveri does not need a cursor, so it is suitable for instances in the case of circular DML (update delete insert ). use

Oracle 10 Gb SGA size at startup, oracle10gsga size The size of the SGA started in Oracle 10g Database is determined by sga_target and sga_max_size. The following three cases are discussed: Sga_target = sga_max_size Parameter file

SQL assistant-SQL Prompt and SQL assistant promptBackground: When the database design is complex and huge, if we are not very familiar with the script, it will be difficult to complete seemingly simple addition, deletion, modification, and query

SQL -- process the accumulation of rows, and SQL process the accumulation Background: There is now a report, where the above data is the seller's order data, according to the daily statistics, from the order table to find a seller's order volume

Oracle quickly creates DBLink SQL statements, oracledblinksql Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable

Oracle modifies the listening port number 1521, oracle1521 In oracle, the default listening port number is 1521. Once someone scans this port number, it will know that this server is an oracle database server. This poses an extremely high security

10046 Getting Started: Use 10046 to view the execution plan and read the trace file, 10046 trace **************************************** * ********************* 1. enable 10046 ************************************** * ********************* SQL>

Redis cluster _ 1. redis master-slave configuration, redis cluster _ 1. redisMaster-Slave Redis configuration (Master-Slave)I. Redis Replication features:1): one Master can synchronize multiple Slave instances.2): not only can the Master synchronize

Hpux mcsg oracle 10.2.0.4 rac for storage image, hpuxmcsgA recent case:Status quo: hp-ux operating system, oracle 10.2.0.4 rac, mcsg mode, two ocr and three voting disks correspond to one lv in the same concurrent volume group.Objective: To create

ERTU. The database model starts from here and er starts here. Today, Zibin's senior brother asked me to design a database table for the project first. I 'd better draw an erfigure. ERTU: I know what it is, because I used to take database and

Lscpu, lspci, lsblk, lsscsi command, [Root @ rhel63single kernels] # uname-r2.6.32-279. el6.x86 _ 64 [root @ rhel63single kernels] # uname-aLinux rhel63single 2.6.32-279. el6.x86 _ 64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64

Hot modification of Redis configuration parameters and redis configuration parameters Redis uses configCommand to hot modify configuration item parameters without restarting. RedisIt is recommended that you do not restart the instance. A restart

Batch export the shell script and informaticaobject of the ICA object #!/bin/bash # -----------------------------------------------------------------------# Script Name: inf_impobj.sh# Purpose: To batch export mappings or workflows to xml files #

Oracle Advanced queue introduction, oracle queueOriginal link: http://www.oracle-developer.net/display.php? Id = 411Oracle Advanced queue IntroductionAdvanced Queue (AQ) is available in multiple oracle versions. He is an oracle native messaging

ORA-14551: cannot perform a DML operation inside a query, ora-14551dml The ORA-14551: cannot perform a DML operation inside a query will be reported when the insert operation is performed in the Oracle Function Cause: Functions that have write

Use of mysql innodb on Openwrt and related exceptions, openwrtinnodb First, configure mysql in menuconfig, specifically in Utilities-> database-> mysql-server. In this way, you can compile it directly. However, innodb Storage engine is not supported