Database Administrator

1. Operating System commands require OS users: Bash-3.2 $ strings-a $ IEX_TOP/patch/115/import/US/iexmdmsg. ldt | grep '$ Header' # $ Header: iexmdmsg. ldt 120.88.12000000.15 2008/12/08 18:05:52 ehuh ship $ 2. Through SQL, DB users are required:

Principle and topology of MySQL master-slave replication: 650) this. width = 650; "border = 0> Preparations:1) configure the Host Name and IP addressNode1.forman.com 172.16.220.11Node2.forman.com 172.16.220.122) time synchronization and dual-host

Audit problem: when the sys user is audited, the audit file that records sys user operations cannot be found in audit_file_dest. I installed an Oracle 10g (10.2.0.3.0) on Windows 7. I did the same thing and found that the audit records of common

Introduction: My friend used rm for a moment. I deleted the Oracle data file and asked for help. When I was helping my friend restore the database, When I encountered a recover, if an error is reported, the archive log no. 28739 cannot be found, so

OS Version: RHEL5.6-x86-64 DB version: Oracle 11.2.0.1 When I used dbca to create a database today, an error occurred in the progress bar of 61%, and an XML file parsing error occurred: [Thread-71] [17:59:31. 528 CST] [BasicStep.

1 Definition RBA is the address corresponding to redo entries in the redo log file. 2 components RBA consists of three parts: Serial number (4 bytes) Block number (4 bytes) Start byte (2 bytes) All of the above are in hexadecimal storage. 3 type 3.1

The red part is used to handle exceptions where no data is found. Create or replace trigger TIG_MONITOR_ALARM After insert on t_monitor_real_minuteFor each rowDeclare-- Standard valueStandvalue number;-- Alarm fact table idLiveid number;Begin----

For Oracle 11gR2 RAC best practices for adding nodes, see:OS information:[Grid @ 11grac1 ~] $ Uname-Linux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/LinuxDB information:SQL> select * from v $ version where

Mysql usually does not use an index if no indexed columns are isolated in the query. "Isolation" column means it is not part of the expression and is not in the function. For example: Mysql> select id from test where id + 1 = 5; We can easily see

First look at a phenomenon: 19:33:31 hr @ ORCL (^ ω ^)Select Name, Value 19:33:59 2FromV $ mystat a, v $ statname B 19:33:59 3WhereA. statistic # = B. statistic # 19:33:59AndB.Name='Redo size' 19:33:59 5/ NAMEVALUE --------------------

Batch update Optimization for Oracle 10g large tables. In fact, 7 million of the tables are not big tables and are enough for testing. I. t table informationSQL> alter table t add is_del number (1 );SQL> alter table t modify is_del default 0; SQL>

Hot BackupSystemTablespace SQL> alter tablespace system beginbackup;  Tablespace altered.  SQL>! Cp/u01/tiger/oradata/orcl2/system01.dbf/bk  SQL> alter tablespace system end backup;  Tablespace altered Then make some transactions Destroy

For the strange data, the value of select is obviously 0.0140625, but it is not rounded down by round (vv, 6. It should be calculated as follows: 0.014063, but the actual result is: 0.014062. It violates the rounding principle. Case: Drop table

Create a job in Oracle: Create table date_log (create_date date constraint create_date_pk primary key ); Create or replace procedure create_date_log_rowIsBeginInsert into date_log (create_date) values (sysdate );End;/Call create_date_log_row

At work, a table inserts a lot of data every day, and the amount of data will become larger than millions or even tens of millions of records over time. In this case, can we split the table? The answer is that Oracle has provided a horizontal split

Recently, the program needs to generate DDL statements to modify the database table of the Oracle database. Therefore, I have summarized the situation of modifying the database table of the Oracle database as follows: 1. ADD a column: alter table

Fault symptom:ERROR: 12-09-20 16:15:03 get the maximum size ERROR: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users'

On one server, you can use mysqld_multi to configure multiple Mysql instances to run. Assume that a MYSQL instance is running on the server. The data directory is/var/lib/mysql and the port is 3306. The SOCKET connection file used is located

Database ErrorGATHER_STATS_JOB encountered errors. Check the trace file.Errors in file/opt/Oracle/diag/rdbms/dbserver1/dbserver1/trace/dbserver1_j003_10544.trc:ORA-20011: Approximate Newcastle failed: ORA-01476: divisor is equal to

The InnoDB Storage engine of MySQL not only caches indexes, but also caches data. If you store tables and indexes on Raw devices, by bypassing the file system's high-speed cache and buffer, direct access to the disk will greatly reduce the burden on