Database Administrator

What is AOL? Oracle Applications are constructed and maintained using the Application Object Library (AOL). The Three main areas of AOL areApplications Security Operating Profile Concurrent Processing AOL Stands For "Application Object Library". AOL

There are many optional gather _ *** _ stats in Dbms_stats. For example, cascade/estimate_percent, You can manually modify its default value.10G provides set_param for modification, but it can only be used for global modification. 11G provides a lot

The master-slave replication configuration of apsaradb for redis is quite simple. Only two sentences are required. Through master-slave replication, multiple server Load balancer instances can have the same database copies as the master server. The

In fact, if you want to have a deep understanding of the architecture, You need to cooperate with subsequent backup and recovery experiments and principles. But no matter what it is, first take a look.The control file is a fairly small binary file,

Oracle storage structure, which can be divided into physical and logical structures. The latter is born to facilitate management of the former. Oracle stores data in tablespaces logically and physically in data files.There are two views that we may

Assume that the data in the test database is to be synchronized, but the test. secret table is not synchronized. A. Perform the backup operation and refresh the log on rdb1.Mysqldump -- flush-logs-uroot-p $ pwd -- default-character-set = gbk --

Use sqlldr to import data: 1. Write the control file:Load dataInfile 'e: \ netbu.csv'InsertInto table temp_zhuren_needFields terminated ','Trailing nullcols -- when the table field does not have the corresponding value, it can be blank (space, blank,

ORA-2020 errors occur when the number of dblinks used by a distributed transaction exceeds the threshold defined by the open_links parameter:Oracle @ ibmvs_a @/oracle $ oerr ora 2020.02020,000 00, "too connected database links in use"// * Cause: The

I encountered this usage while reading the code, but I don't quite understand it. I Googled it. The meaning of this statement is that if the "on duplicate key update" statement is formulated at the end of the insert statement, when the insert row

View the Oracle database version· SQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release

When MySQL replication is configured, the following error is reported when slave is started: Mysql> start slave;ERROR 1201 (HY000): cocould not initialize master info structure; more error messages can be found in the MySQL error logMysql> I

Oracle faults ORA-27054 NFS file system where the file is created or resides is not mounted with correct options During the data backup process, the NFS file system is used, so a BUG occurs during the import. The error is as follows: ORA-39001:

There was a long question: Why should Oracle create two dirty lists: one Checkpoint Queue and the other Lruw? Now you can give a periodic answer: The purpose of the two linked lists is different. The Checkpoint Queue is sorted by the time the data

I have previously written an article titled PostgreSQL 9.1.3 plpgsql debugger module, which is set up in the PostgreSQL function debugging environment. The source code is old. Many PG code has been moved to github, including pldebugger, this BLOG is

Redis is a distributed NoSQL Database System Oriented to "key/value" pairs of data types. It features high performance and persistent storage, and is suitable for high-concurrency application scenarios. It started late and developed rapidly. It has

If you start Oracle database-based application development, you may think about this problem. How to Create a database user that meets the requirements of the production environment and what permissions should be granted to the user. It is necessary

CRS provides many commands to manage and view the cluster service status. Common Commands include crs_stat, crs_start, crs_stop, and crsctl.  1. view the cluster statusYou can run the crs_stat command to view the status of all resources in the

1. display the lock information in the Linux Database Select sid, addr kaddr, type, lmode, block from v $ lock; SID KADDR TY LMODE BLOCK------------------------------------------------3 0000000077459298 XR 1 03 0000000077459368 RD 1 03 00000000774594

Premise: You have a database account for apps and want to know the password of a user. Because the password in fnd_user is encrypted, you cannot understand it. You can try the following method to view the user password. SQL>DescFnd_user;

Oracle 9i provides the dbms_redefinition package to implement online redefinition of database tables. In practical applications, we can use this package:(1) convert heap tables and partitions. (2) recreate the table to reduce HWM. 10 Gb shrink, 9i