Database Administrator

How to configure the STATSPACK performance report of Oracle 11g ADG Create a normal STATSPACK report user on the master database Sqlplus/as sysdba SQL> @? /Rdbms/admin/spcreate. SQLSQL> -- cancel some settings of $ Oracle_HOME/sqlplus/glogin.

Notes on installing Oracle 10.2.0.1.0 on Oracle Linux 4u4 Exercise the Oracle RAC formation process. Step 1: First practice installing Oracle 10.2.0.1.0 on Oracle Linux 4u4. It is difficult to directly install RAC. Start from simple. For the overall

Use Oracle to recover MySQL Data problems Today, I want to solve a problem. In my daily work, it is still very difficult to restore some nonstandard operations, such as drop, truncate, and delete, the drop operation is basically safe if recycle bin

Oracleclient + PLSQL Developer remote login to Oracle Database Oracle databases have powerful functions and excellent performance. When these advantages are created, Oracle accounts for more memory than memory. To address this problem, how can we

Install Redis in RedHat Linux My Linux system is: RedHat [Root @ infa ~] # Wget http://download.redis.io/releases/redis-2.8.12.tar.gz Tar xzf redis-2.8.12.tar.gz [Root @ infa ~] # Tar xzf redis-2.8.12.tar.gz [Root @ infa ~] # Cd redis-2.8.12 [Root @

GoldenGate dml target table of synchronization process and field processing test -- Experiment: For goldengate processes that only have dml synchronization, if the source end performs the ddl plus field operation, how to deal with the corresponding

Statistics on the size of Oracle Database files, statistics on oracle databases1. Statistics file, temporary file, Log File Size Select sum (bytes)/1024/1024/1024 as GB from dba_data_files; select sum (bytes)/1024/1024/1024 as GB from

MySQL Time Zone parameter, mysql Time Zone Environment Introduction: OS Version: RHEL5.5 MySQL version: 5.5.40 Reference: http://dev.mysql.com/doc/refman/5.5/en/time-zone-leap-seconds.html There is a requirement: an attendance system, where multiple

/* + SYS_DL_CURSOR */This hint, sys_dl_cursorhint Run the/* + SYS_DL_CURSOR */hint. Today in a db SQL statement, encountered this/* + SYS_DL_CURSOR */hint, after baidu, In the post of Huang Wei http://www.hellodba.com/reader.php? ID = 201It is

C # key points of reading and writing excel tables through OleDb, 1. connection string of OleDbConnection: 0 ffice 97-2003: StrConnection = string. format ("Provider = Microsoft. jet. OLEDB.4.0; Data Source = {0}; Extended Properties = \ "Excel 8.0;

ADO. NET -- Connection, Command ., Ado. netconnection The. NET Framework Data Provider includes four core objects: Connection, Command, DataReader, and DataAdapter. Here, I will just talk about the objects that are frequently used in SQL Server. The

SQL Sever connection failure -- SQL Sever remote process call failed, sqlsever Today, I started three layers of learning with great enthusiasm. I watched the video and knocked on the code. I felt like I hadn't knocked on the code for a long time,

ERROR 1366 (HY000): Incorrect string value: '\ xC6 \ xF4 \ xD3 \ xc3' for column 'name' at row 1, hy000xc6ERROR 1366 (HY000): Incorrect string value: '\ xC6 \ xF4 \ xD3 \ xc3' for column 'name' at row 1Mysql> statusD: \ mysql6.0 \ bin \ mysql.exe

[Access MySQL Server], mysql ServerTo access a MySQL server, you must use a user account to log on to it. Each MySQL user account has many related attributes, such as the user name, password, permissions, and resource restrictions. "Permission"

[Mybatis] add, delete, modify, and query using Mybatis interface programming method. Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka In the previous chapter [Mybatis], the introduction to

Oracle divides a column into multiple columns, while oracle splits one column into multiple columns. Oracle divides a column into multiple columns In Oracle, we can use listparts (Oracle 11g and above) to merge multiple rows into one column. Now we

Mongod. conf, mongodbmongodb. conf Mongod-f 'config path' MongoDB introduces a configuration file in YAML-based format. Versions earlier than 2.4 are still compatible. My mongodb configuration file: systemLog: destination: file path:

[Translated from mos] explanation of histogram information and mos Article histogram Information     Interpreting histogram InformationSource:Interpreting Histogram Info (Doc ID 72539.1) Applicable:Oracle Database-Enterprise Edition-Version 7.3.0.0

Redis learning records and redis recordsRedis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset) and hash (hash type ). These data types support push/pop,

Database-Introduction to databasesDatabase status Since the end of 1960s, database technology was the latest technology in data management and an important branch of computer science.Database technology is the core and foundation of information