dba

oracle| process System Preparation ======== Redhat8 Install the additional installation package by Server type: 1 contains an x system, it is recommended to use GNOME, 2 will develop toolkit develop tools selected, standard GCC tools and so on. 3 It

Today, what kind of code is bad code, how to find out these bad code. Quite a few apes in spit-rotten code. But what we're talking about today is not bad code, it just needs to change a little bit, get rid of its bad, he's still good code. And bad

Error | Address Today field staff report in imp a DMP file times exceeds the maximum number of cursors for errors, ora-01000:maximum open cursors exceeded. Asked about the basic situation, on the Metalink check, IMP did not mention any of the ORA-010

1.MySQL 5.1 stored programs and functions work on replication? Yes, the standard behavior performed in stored programs and functions is copied from the primary MySQL server to the from server. 2. Can the stored programs and functions created on

J2ee Two: Creating a DatabaseSmall test Oracle 8i (by the way we practice practicing) (for convenience, I will Oracle 8i abbreviated 8 i)8i and 9i are indeed somewhat different, but in the interface is not very different, or to my Oracle 8i as an

As an Oracle DBA, a number of problems with character sets are frequently dealt with at work. But when you really want to write something about it, you suddenly don't have a clue. After a half-day, or decided to use the two character set as an

oracle| Data Author: anon Source: InterNet Add Time: 2003-7-20 The following table collects almost all the views or aliases in the Oracle data dictionary, and for each view or alias field, use the ' Describe ' statement to query. Name Description:

The implementation of MySQL master-slave replication 1, the implementation of MySQL replication principle MySQL supports one-way, bidirectional replication, asynchronous replication, one server acting as the primary server during the replication

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.

1. Backup is more important than anything We need to know that the system is always going to crash, there is no valid backup just waiting for the day to die! I often joke that the only thing that will wake the DBA in a dream is that there is no

Oracle Introduction to the new features of Oracle 10G I release (i) by fenng 2003-6-8 Oracle (www.oracle.com) has long claimed that Oracle 9i databases are only a transitional product, and that real technological innovation is likely to be in

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 mainly introduces the installation of Oracle database and the creation of database in silent way. Create users, user groups and environment settings and graphical installation is the same, the specific setting of the way please refer to

In most cases, modifications to the primary database will be propagated to the physical standby database and applied without the need for additional operations on the physical standby side, except that, depending on the actual configuration, some

oracle| Skills | data | Database in an Oracle database, DBAs can make possible adjustment decisions by observing a certain table or view to see how the current space is being used. I. Free space in the table space By observing the free space of

Experiment content: The Redo Log Content format of the DML statement produced in the non-IMU mode is interpreted, the database version: 11.2.0.4 The most detailed explanation is update. Experimental environment Preparation The IMU feature is

　　This example, run in MySQL5.0 and above version. The simple format that MySQL gives user permission commands can be summarized as: Grant permission on database object to user 　　One, grant ordinary data user, query, insert, UPDATE, delete all

1. Introduction Today's IT environment is undergoing drastic changes, and companies that rely on a single relational database management system (RDBMS) to manage data are beginning to diminish. Analysts report that more than 90% of companies today

This article summarizes the database backup process of all possible errors, you can refer to the following. 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

Solve the problem ORA-01157 problem how to solve? Environment: Redhat 9 + Oracle 817 Question: After yesterday's sudden power off, the database was prompted for this error after it was started. The data is not archived, and the data file is also