Database Administrator

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

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

1. Modify the kernelVi/etc/systemSet shmsys: shminfo_shmmax = 268435456The local memory is 512 M ) Set shmsys: shminfo_shmmin = 1Set shmsys: Sh minfo_shmmni = 100Set shmsys: shminfo_shmseg = 10Set semsys: seminfo_semmni = 110Set

This is a comparison I made when installing and starting to use Oracle 10g, PostgreSQL8, and MySQL 5. I will compare three types of databases from the following three artistic forms: Business vs. Academic vs. Internet model. This is a comparison

This article describes how to use IBM®DB2®Universal Database™Configure the concept and implementation of log transfer. As the database system becomes more and more important for the success of the enterprise, the demand for uninterrupted (24x7)

Oracle wait events are an important basis and indicator for measuring the operating status of Oracle. The concept of wait events is introduced in Oracle7.0.1.2, with approximately 100 wait events. In Oracle 8.0, this number was increased to

First, Oracle dictionary tables and views can be divided into three layers. 1.1 X $ table This table is the basis for running Oracle databases. It is dynamically created by Oracle Applications When the database is started. These sub-tables are

The general to_char is like this to_char (sysdate, 'yyyy-MM-DD hh: mi: ss am'), there are also a few vertices usage: To_char (sysdate, 'dd') Check the number of to_char (sysdate, 'ww ') Today. Check the week number of this month. To_char (sysdate,

Date Format Parameters Description D Day of the week DAY The name of the day, with a space of 9 Characters DD The day of the month DDD Day of the year DY Abbreviated name of day

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;@

BKJIA exclusive Article: This article mainly introduces language-level integrated query or referred to as LINQ, including what is and is not, A brief review of the language features is provided, and some practical examples of using LINQ are

This document describes the full-Database Replication procedure of Sybase. Copy server name: HRB_REP master database server and master database HRB_HB.maindb to backup database server and backup database HRB_HB_REP.maindb 1. The interface

Batch deletion of massive data is usually complicated and slow, and there are many methods, but the general concept is: Batch deletion and successive submission. The following is the deletion process. The data table can be deleted through the

Preface In the past decade, Oracle has become one of the world's most professional databases. For IT experts, IT is to ensure that their company's productivity is improved by leveraging the powerful features of Oracle. One of the most effective

SQL statement execution using SQL Server's query Analyzer: 1. Import Access data to SQLserver Run the following statement in SQLserver to import data from Table B04 in Access to the sqltablenaem table in SQLserver. Insert into sqltablename (sfield1,

1. Configuration Overview In this database configuration, the database system, database log, and database application system data are configured separately to optimize the database system. 2. Marketing System Database Configuration example 2.1 plan

Use shell to monitor the performance of informix and output it in html format, which is intuitive and convenient. It is suitable for monitoring system performance when informix systems are initially built. In this example, it is designed to run

Oracle databases store a variety of data, some of which will become larger over time. Such as dating chat logs, SMS sending and receiving logs, production system logs, dynamic website publishing system logs, and so on. This information is closely

Mysql versions later than 3.23.15 provide the database replication function. This feature allows you to synchronize two databases, master-slave mode, and mutual backup mode. The settings of the Database Synchronization replication function are

MySQL UDF is essentially a dynamic Connection Library * Nix, which does not need to be set as the entry point, is called a shared library ). You can call this method to debug a DLL. Now I will introduce a very simple and easy-to-use debugging method.