Database Administrator

ORA-00604 ORA-21700 error handling Delete SDE user (GIS map data user) report ORA-00604 ORA-21700 today, detailed steps are as follows: SQL> drop user SDE cascade; ERROR at line 1:ORA-00604: error occurred at recursive SQL level 2ORA-21700: object

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, while the collaborative processing between servers It is

Compare the impact of a single COMMIT and multiple COMMIT on the waste of log space while changing the data volume. The LGWR process writes online logs in sequence and does not skip in the middle, and the LGWR process does not write twice in the

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster.

In addition to the tangle of queries, the rest are relatively simple! In fact, when I learned how to add, delete, modify, and query mongodb command lines, I also tried it one by one based on the examples on the official website, so please feel free

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. there's much wisdom in that statement. of all the things you are responsible for as a database

Question: In my daily work, I think MySQL plus is used in 99% to log on to the database and manage, optimize, and configure the database. If there are many databases, all of them are unified SQL after connection>, it may happen that we do not know

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all oracle data dictionaries in sys are stored in sys users. These base tables and views are

I. Back up the database1. Open SQL Enterprise Manager and click Microsoft SQL Server in the root directory of the console.2. SQL Server group --> double-click to open your Server --> double-click to open the database directory3. Select Your Database

Oracle databases differ significantly from MSSQL data operations, but there is an analogy in image operations. This article describes how MSSQL database images are implemented in Oracle databases. What are the differences between them.First, the

The Oracle installation and configuration process is closely related to the operating system, storage, and network. Especially in Linux and AIX environments, the configuration process is relatively complex. A link error may cause a series of faults

Autocommit = {0 | 1} sets whether MySQL transactions are automatically committed. 1 indicates immediate submission, and 0 indicates explicit submission. Global or session is a dynamic variable that can be used in the configuration file (but not in

Innodb_adaptive_flushing= {ON | OFF}Set whether to allow the MySQL server to dynamically adjust the dirty pages in the InnoDB buffer pool based on the workload. The purpose of dynamically adjusting the write speed is to avoid IO activity spikes. The

With the concept of big data gradually increasing, how to build an architecture system that can collect massive DATA is in front of everyone's eyes. How to achieve what you see is what you get, how to quickly structure and store irregular pages, how

Ibm ids-Informix Dynamic Server is a key-type general-purpose OLTP database for enterprises and working groups. Large and small enterprises that need transaction databases are now deploying IDS to solve real-world business problems.* Enterprise

Judging the total number of records in a table is the most common thing for a developer. I think the common practice is: Select count (*) from table name; This is not done. I am mainly talking about efficiency issues here. When the number of

This function will be deleted in the next version of Microsoft SQL Server. Do not use this function in new development work, and modify the application that is currently using this function as soon as possible. Address Window Extensions (AWE) Allow 3

Oracle is a relational database management system with powerful functions and excellent performance. It plays an important role in today's large database management systems. Under normal circumstances, the Oracle database ensures data security and

Using script files to manage Oracle databases has great advantages. For example, you can reduce the command input. For example, you can save the commands that pass the debugging test so that you can use them again when needed. For example, you can

The High Level mark (HWM) for the DB2 database management (DMS) tablespace refers to the maximum number of data pages that have been used in the tablespace. If you use: Db2 list tablespaces show detail If you see that the number of used