Database Administrator

This document uses Oracle8i as an example:First install an oracle client,Retain the bin, network, and ocommon directories in the oracle directory, and delete all the other directories,Export HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE in the

I have just been in touch with Linux for less than a week. I just sorted out several videos from the Internet and watched and learned. If you have time to do something by yourself today, you can use a connection provider ------- to deploy the mysql

This article briefly records how to import and export common data involved in PostGIS. 1. Import osm data to PostGIS Osm2pgsql-c-d osm-l-E 4326-S/usr/share/osm2pgsql/default. style xxxxx. osm Here, pay attention to a few parameters. Whether to

Because we often perform a lot of changes to the mysql database, such as modifying fields, adding or deleting indexes, we put these operations into SQL statements and then log on to mysql, execute this SQL file using source. In order to keep

Symantec NBU backup Oracle 11g Backup log errors under/user/openv/ Recovery Manager: Release 11.2.0.3.0-Production on Mon Sep 17 14:36:11 2012 Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved. Connected to target database:

RAW-format tablespace Resizing in data. The procedure is as follows:View existing bare devices # cd/dev/raw # ls-rtlCheck the raw device size/View previous lvSize # blockdev -- getsize/dev/raw/raw3720488192 # blockdev -- getsize/dev/raw/raw3820488192

Oracle 11g RAC, internal time is synchronized through the ctss service, during installation, ntpd will be removed by default, using ctss.However, after running for a period of time, it is found that there is a time difference between the oracle

This section is translated from Oracle metalink doc: 167293.1. An example is provided to illustrate ORACLE audit usage. ORACLE audits can be performed at the statement, object, and permission levels. Similarly, SYSDBA and SYSOPER user behavior can

In Oracle 11g, the lock mechanism is further enhanced, mainly reflected in the following three aspects: Serializing Locks Locking Tables Explicitly Sharing Locks   Serializing Locks Some people also generalize this feature into DDL Wait

SQLite is organized by B-Tree in external databases. For details about B-tree, refer**** Donald E. Knuth, the art of computer programming, Volume 3:** "Sorting And Searching", pages 473-480. Addison-Wesley** Publishing Company, Reading,

Recently, sysbench has been used for many performance tests. It also summarizes its features and usage and precautions. Sysbench is a multi-thread performance testing tool that can perform performance tests such as CPU, memory, IO, and database.

-- View All sequences of current users Select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'username '; Note: 1. You must log on as an administrator; 2. sequence_owner must be in upper case, regardless of whether your user

I. Official Oracle description Oracle Database assigns each datafile two associated file numbers, an absolute file Number and a relative file number, that are used to uniquely identify it  Absolute: Uniquely identifies a datafile in the database.

In Oracle versions earlier than 11g, if you want to set the table to read-only, you can grant the SELECT object permission to these users, but the table owner still reads and writes the table. Oracle 11g allows the TABLE to be marked as read-only

1. DB_BLOCK_CHECKSUM parameter description Before Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE. In Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is

The big data mentioned here is relatively speaking. The data size used in the experiment is 4 GB... First, describe the situation. First, use vmware workstation 9 to create a virtual machine and install CentOS 6. Then, download the online

Principle: Each SQL statement has its execution plan, and the Execution Plan is placed in plan_table. plan_table contains the object_name column, which indicates the object name in the SQL statement. The execution plan is very interested in the

The materialized view aims to save some queries that take a long time to obtain results in advance, save the results of these queries to a local copy, and then query the results later, you can query data from the materialized view without querying

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and daily alert monitoring, and database backup, AWR report automatic mail, etc. This section describes

Start em (Enterprise Manager: Enter http: // ip address: 1158/em -------> Environment variable Oracle_SID not defined. Please define it. (Oracle_sid is not defined ); Define Oracle_sid: View the current Oracle_sid: Set Oracle_sid: set