Database Administrator

Install Oracle on bare devices on AIX Recently, new systems have been released. I have not prepared documents for installing Oracle on AIX. I have prepared a document for future reference. The simple steps are omitted here. 1. view the system

[RMAN] use duplicate to copy the database locally Task: the same host uses RMAN duplicate to copy the database. In the linux operating system, there is a set of running database aux after enmoedu replication. Tutorial steps: 1. master database RMAN

EM database reconstruction manual deletion of Database Because the original database has been deleted, you need to use the listener when redoing the oem. At this time, the following error is reported: [Oracle @ localhost ~] $ Emca-repos recreate Jul

Oracle automatic backup solution in Linux As a DBA, every full-Database Backup can be performed only when others do not use the database (I know there are other methods, this article only considers export ), with the following two parts, you can

Oracle backup and recovery Series Tutorial Environment Introduction:Create a test user snow. The user has a table and a stored procedure. A task takes effect easily by simulating a user inserting a timestamp every minute like a database to generate

Why MySQL transactions cannot be rolled back When using MySQL, if you find that the transaction cannot be rolled back, but the Hibernate, Spring, JDBC and other configurations do not have obvious problems, don't worry, first check whether the table

DETERMINISTIC and deterministic in Oracle I have been confused when I saw DETERMINISTIC for many times. I did an experiment today. We assume that ORACLE is a DETERMINISTIC function, which is called only once in SQL. If DETERMINISTIC is not used, the

Create a MySQL database using Python to dynamically add fields and insert data. Application scenarios: We need to design a database to save the keywords of each document in multiple documents. Assume that each document contains more than 1000

Computing cost -- full table scan, computing cost -- table Scan The following describes how to manually calculate the cost value in the oracle execution plan. The cost is calculated as follows:Cost = (# SRds * sreadtim +# MRds * mreadtim

Performance Optimization-mysql database and performance optimization mysql I. mysql Common commands 1. Open the log 1) show global variables like "% genera % "; 2) set global general_log = on; 3) set global general_log = off; 2. If set autocommit =

Basic Summary of MySql (1), basic summary of mysql I have read MySql for the second time. The main purpose of this time is to sum up the MySql system. I used to write my notes on MySql before, but I don't want to always take it with me in the future,

An error in ora-12170, mosora-12170 is reported when a remote machine is connected to a db on windows.Error ora-12170 reported when connecting to db on windows from remote machineReference Original:Windows: ORA-12170 Attempting to Connect from

[Translated from mos] maximum size of Oracle GoldenGate (OGG) trail file, mosgoldengateMaximum size of Oracle GoldenGate (OGG) trail fileReference Original:What's the OGG trail size limit? (Documentation ID 1348080.1)Applicable:Oracle

SQL * loader Experiment 1: SQL * loader Experiment Objective: To import txt data to a database table Step 1: scott creates an empty table Create table family (id number (10), name varchar (20), sal number (20), total number (30 )); Step 2: Create a

Tanabata gift --- Mysql password modification steps (figure), gift --- mysql 1. Stop mysql Service 2. Go to the bin directory of the mysql installation path. 3. Modify the mysql root User Password: 4. SQL statement for changing the

Analysis of PostgreSQL pg_cmd.conf file, I recently tried PostgreSQL 9.04 and shared my experiences with pg_mirror.conf configuration. Pg_cmd.conf is the configuration file for client authentication, which defines how to authenticate the client. The

Oracle UNDO monitoring and oracleundo monitoringOracle 10 GB and later versions have a new feature, that is, automatic adjustment of the undo retention time, which greatly simplifies management. For the undo tablespace of autoextend on, the

Buffer pool and shared pool (1), buffershared [In-depth analysis-eygle] Study Notes 1.1 buffer pool Principle Buffer Cache is an important part of Oracle SGA. Generally, data access and modification must be completed through BufferCache.When a

ADO. NET 7-use the Command object to find database records --- ShinePans, Query the number of data in the data path: Code: Using System; using System. collections. generic; using System. data; using System. data. sqlClient; using System. linq;

The updated or deleted row values cannot make the row unique, or change multiple rows and multiple When I tried a table, I added several pieces of data to it. Later I found that the values of the fields originally intended as primary keys are "NULL"