dba

Part Two: The practice of Dynamic Business application construction--The story of two adaptive systems Productivity improvement is the basic component of the improvement of living standard. The experience of the United States shows that the strong

The DBA will periodically check the connection to the database to see if the number of sessions established with the database is normal, and if too many connections are established, the resources of the database are consumed. At the same time, some "

Most WEB applications today need to adopt at least some basic security policy. For example, a Web site that provides password-protected content, only Web sites with admin backend, blogs and personal magazines, E-commerce sites, intranet, and so on.　　

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

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

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

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

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

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

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

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

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:

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

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

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

　　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

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