dba

If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is absolutely suitable for you. On the database backup recovery principle, we are more or less familiar with.

Oracle If you go to a computer bookstore now, you'll find that books related to Oracle technology will occupy a lot of space in bookstores. In these books there are many fine, but certainly some dross mixed with, for fine, we might as well read, for

Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool

This article describes 8 commonly used monitoring data shell scripts. First, we reviewed some of the UNIX commands commonly used by DBAs, and explained how to execute the DBA script regularly with Unix cron. Online also has good Many similar

server| Recovery | data | database No database system can avoid a crash situation, even if you use a clustered, two-machine hot standby ... It is still not possible to completely eradicate the single point of failure in the system, and for most

Many technicians can easily discuss the details of DB2 technology and confidently talk about query parallelism, data compression, WebSphere MQ integration, large object management, JDBC and ado.net drivers, data sharing on mainframe Parallel Sysplex,

In the process of using a database, you often experience the problem of database migration or data migration, or if there is a sudden database corruption, you need to recover directly from the backup of the database. However, there are problems, and

Quick Start A summary of Toad function During the development of Oracle applications, accessing database objects and writing SQL programs is tedious and time-consuming, and the day-to-day management of the database requires a lot of SQL scripts to

In a Microsoft SQL Server 2008 system, the database administrator (DB administration, referred to as DBA) is the most important role. The goal of the DBA is to ensure that the Microsoft SQL Server 2008 System runs normally and efficiently. The work

Core|oracle Morning spent a little time to complete the first Linux platform installation (:P, a bit embarrassing to say, only the first time), mainly refer to the Http://www.oracle.com/technology/global/cn/pub/articles/smiley_ Installation

1. What is IMU? What is the main role of IMU, that is, to solve the problem? IMU--->in Memory undo,10g new features, the database will open up separate memory areas in shared pool to store the Undo information. Each new transaction is assigned a

MySQL is a relational database management system, developed by the MySQL AB Company in Sweden and currently belongs to Oracle Company. MySQL is a relational database management system in which the associated database keeps data in different tables

In Oracle 10G, the concept of a Recycle Bin (recycle Bin) is introduced. 　　 The Recycle Bin, in principle, is a data dictionary table, where the user drops the database object information. The object that the user is dropping is not deleted by the

The automatic import and export of Oracle database has been widely used in many places. For example, once an Oracle database application system is developed, it is necessary to import the initial data into the user's Oracle database if the system is

Oracle's article, published on Oracle's Web site, is a guide for installing oracle9i database. Author: Abhijeet Kulkarni Database version: Oracle9i R2 (9.2.0.1.0) 1. Create users and Groups: ------------------------- Switch to the Root user and

--found that/home/oracle/database space utilization is too high $ df-g File system GB blocks can be installed in%used iused%iused /DEV/HD4 1.00 0.15 85% 7459 18%/ /DEV/HD2 6.00 3.35 45% 52805 7%/usr /dev/hd9var 1.00 0.86 15% 1170 1% /DEV/HD3 8.

Three              Where the freelists is stored freelists stored in the header block of each segment, we can get a clearer idea by dump. Dump usually plays an important role in the study of Oracle's internal mechanisms. Let's say we create a

Database version 11.2.0.4 The experiment idea is:--The trace information of the database open, can refer to: http://blog.csdn.net/q947817003/article/details/17025489 File#1 block#1==>root dba==>struct Ktetb That is, start with the system's data

The analysis of logical reading of T1 table full table scanning Do an experiment to show you: Take table T1 as an example, to the segment T1 do dump 1, T1 table on a piece of data Gyj@ocm> select * from T1; ID NAME ---------- ---------- 1 AAAAA 2,

Oracle Purpose: Install Oracle 9i on Linux 8.0 to ensure database security and stability Software Environment: Linux 8.0 (three CDs) Oracle 9.2.0.1.0 for Linux (three CDs) Hardware environment: P4 2.4, Memory 512M, hard disk 80G high RPM, 16x_dvd