Database Administrator

The common thing about a database is that it stores data in a warehouse, and our operations on the database can be the same as what we store or take out in a warehouse. If we need to access things from a warehouse, first we need to know where the

While I was unable to upgrade my laptop to 1 GB of memory, I was suffering from installing Sun Solaris 10 U3 + Oracle 10g R2 in my current book, I got a laptop for the competition, haha ...... Comfortable. The following is my Installation Record

Summary of Oracle parameter viewing methods and oracle parameter Summary Oracle provides a large number of system parameters. The following is a summary of the query methods.Current System Parameter The current system parameters involve these views:

WAS cluster series (7): Build a cluster: Step 5: Install WAS patch and cluster was Check the "Task Manager" before installation. If a java Process exists, disable it and disable WAS services. Find the WAS Update Wizard startup item in the Start Menu,

PL/SQL personal learning notes (2) and plsql personal learning notes IF condition DeclareCursor s is Select version from city_server t; S _ city_server.version % type; Begin Open s; Fetch s into s _; If s _> 2 Then DBMS_OUTPUT.put_line (s

Install postgreSQL + postGIS in the production environment The production environment is as follows: Operating System: CentOS release 5.5 (Final) Installation required: Postgresql address: http://www.postgresql.org/ftp/source/ PostgisAddress:

How to permanently delete an Oracle database to create a database with the same instance name and an oracle instance I chose the OMF method when creating the database today. The result file name is automatically named in Oracle. I cannot understand

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.

After the Oracle manufacturer recently installed the monitoring plug-in for OEM 12C in the primary database in the production environment, an exception occurred to the Oracle GoldenGate instance that has been synchronized to more than a dozen

Learning MongoDB 8: MongoDB index (index restrictions) (2), mongodb IndexI. Introduction In the previous article, we introduced basic index operations through db. collection. the createIndex (keys, options) syntax creates an index. We will continue

Oracle's traditional Export and Import are retained to 11 GB, and many enterprises still use Export and Import to back up and restore 9i and 10 Gb. Since Oracle 7.3, the traditional exp Export Program provides two Export Path methods: Conventional

Oracle learning path (4): oracle learning pathLOB type ORACLE provides the LOB (Large OBject) type for storing Large data objects. ORACLE currently supports the BFILE, BLOB, CLOB, and NCLOB types. NCLOBStores large NCHAR character data types.

1. Defining the TCP/IP connection of the MySQL Cluster is the default transmission protocol used by the MySQL Cluster to establish connections. Normally, no connection is required. You can use [tcp default] or [TCP] for definition. 1.

MySQL series: innodb source code analysis-redo log structure, mysqlinnodb In innodb Engine implementation, a redo log system is built to ensure transaction persistence. Redo log is composed of two parts: the memory log buffer and the redo log file.

Logon database Tiger causes the slave uard to be not synchronized. tigerdataguard When the slave uard upgrades the CPU, it finds that the master and slave databases cannot be synchronized and the log reports an error. Therefore, the script "@

S skills, Postgres skills If you need to add indexes when the business volume is large, you need to use CONCURRENTLY. Otherwise, your database will easily break down. For example create index CONCURRENTLY idx_order_records_bank_statist_uid on

The data models used at the logic layer are classified into two types: one is mainly used for database design, which can be understood by general users and is similar to the way people think. Such models include (ERM). The other is to model data

IntroductionEditor's note: in DBA's work, backup has gradually become a hard task that is not often considered. However, any good DBA can tell you that data should be restored when a system failure occurs, at this time, backup will suddenly become

INSERT Process Overview First, let's take a quick look at the processing steps when inserting a row. Each step in these steps has the potential for optimization, which will be discussed later. 1. prepare statements on the client. For dynamic SQL

From the perspective of users and developers, Windows Phone 7 brings us many new and exciting features. At the same time, the current Windows Phone 7 series does have shortcomings that disappoint many users. One typical pity is that Windows Phone 7