Database Administrator

Association between "beaten" and "Peking University"-one of the interesting data mining series (Tang changjie) (Note: This is the first article in the 12 interesting data mining series on the science blog. I discussed it with my friends. The blog

Recently, the company was using the postgresql database and developed many ddl/dml statements for us. So I spent two days completing this script to Create Table spaces and users, script for Automatic Data Import #!/bin/bash# 2013/07/26, DD.#

Today, we are doing experiments to help identify machines and use them at will.Hostname sourceCommand to change the linux host name and then start the database to report the following error:[Oracle @ source dbs] $ sqlplus/as sysdba SQL * Plus:

Q: SYBASEStored ProcedureWhy is this sentence not executed? Select @ nSerialNo = serialno from schedule where phonenum = @ strPhoneNum and type = @ nTypeIf @ rowcount = 0Begin...EndElseBegin...EndThe aboveSelectThe result is an empty record set.

ConfigurationOperating System-HP-UXVersion-10.20Hardware System-HP9000System-K580Subsystem-Oracle 8.0.5 Solution   To configure Oracle 8.0.5 correctly in HP-UX 10.20, perform the following steps: Note: This information is excerpted from the Oracle 8

Problem: the Instance name is o8161 and o8151 when two sets of databases are in the same fashion on one machine. Two listener instances cannot be started at the same time,An error is displayed when the second listener is started. $ Lsnrctl

Today, a network administrator asked me why the unix oracle OS process consumes so much CPU?Log on to the server and find that process, which is a process for connecting a user to oracle.According to the OS process number (I use the direct

Differences: 1. the length of CHAR is fixed, while the length of VARCHAR2 can be changed. For example, the storage string "abc", for CHAR (20 ), it indicates that the characters you store will occupy 20 bytes (including 17 null characters), while

Q: What is NULL? A: When we do not know the specific data, it is also unknown. We can use NULL. We call it NULL. in ORACLE, the column length containing NULL values is zero. ORACLE allows blank fields of any data type, except for the following two

This article uses examples to explain how to useLogMinerMethod to Analyze database logs. ◆ 1. Install LogMiner The following two scripts run as SYSDBA) @$ORACLE_HOME\rdbms\admin\dbmslm.sql;@

Create SPFILE By default, ORACLE uses PFILE to start the database. SPFILE must be created by PFILE. The newly created SPFILE will take effect the next time the database is started. create spfile requires SYSDBA or SYSOPER permissions: Create spfile [

Multiple ORACLE databases physically stored in the network can be logically considered as a single large number.Database. Users can access data in remote databases through the network at the same time, whileCollaborative processing is completely

 We know that Oracle, as a large database, is widely used in financial, post and telecommunications, electric power, civil aviation, and other important sectors with huge data throughput and extensive computer networks. For system administrators, it

Data structure used for backup and recoveryBoth Oracle and DB2 UDB have a group of components that form backup and recovery mechanisms. The architecture diagram shown in figures 1 and 2 gives an overview of the main components that provide Oracle

Oracle Advanced Replication, also known as symmetric replication. Unlike other Oracle functions, Oracle Advanced Replication is not plug-and-play. Users must have a deep understanding of how it works and the advantages and disadvantages of various

Oracle 8i Database Server is a highly optimizable software product. Regular adjustments can optimize system performance and prevent data bottlenecks. By adjusting the database system, we can achieve optimal performance to meet user needs. Below, I

Developers often use Access as the prototype or use Access to develop applications that are not critical. However, as the company's business grows, the problems to be solved will become more and more complex, and the Access environment may not meet

Step 1: Download ids 9.4 for linux Ftp://ftp.youngcow.net/Special/Database/DatabaseServer/Informix/InformixDynamicServerVersion9.4/IIUG-IDS-9.4-linux.zip This thread has limits on http: // 202.96.110.20./ informix/ids9.4/IIUG-IDS-9.4-linux.zipCsdk

I. Multi-resident Multiple Residency) means to run Multiple OnLine instances on the same host. Each OnLine instance has and manages its own processes, shared memory, and disk space. Multi-resident does not mean to install OnLine software to multiple

######################################## The input amount of this function, returns the amount of uppercase Chinese characters ### Bellchiu AT NanJing CITIC: em13 :#########################################FUNCTION F_CONV_GB (pf_money)DEFINE pf_money