Database Administrator

In ORACLE10G, the default archiving path is $ ORACLE_BASE/flash_recovery_area. For this path,ORACLE has a limit that only 2 GB of space can be used for archiving logs by default. You can use the following two SQL statements to view the limit.1.

Online Job migration: migrate jobs from GP to Hadoop and find that some jobs have been running for 2-3 minutes to Hadoop for about 10 minutes. This will affect the migration performance; an obvious Query is as follows: Insertinto table_big

Lab 1): Mainly familiar with database parameter file operationsThe experiment shows the following knowledge points:1. Use altersystem to modify parameters, which takes effect immediately in spfile.2. The spfile and pfile can be converted to each

After mysql is installed in Linux, table names are case-sensitive by default, but column names are case-insensitive; After logging on with the root account/Etc/my. cnfAdd lower_case_table_names = 1, Restart the MYSQL service. The setting is

Server: 1. Establish nfsvg, file system/nfsserver on the P670 Server 2. # mount/nfsserver 3. Edit the/etc/hosts file on 670 and add NFS client information. 10.60.64.41 IRIS 4. edit/etc/exports /Nfsserver-rw, root = IRIS, access = IRIS 5.

1. Write down your notes and go to the official website each time. It takes a long time to install and save time for yourself. Mysql 5.1.45. /configure -- prefix =/usr/local/mysql5 -- without-debug -- without-example -- without-docs --

The simplest installation file is. Bff file, cainiao's favorite. I have been looking for a long time, now contribute: http://www.bullfreeware.com/ 1. Download samba-3.0.4.0.bff 2. Place files in the temporary installation directory of the AIX system,

1) view log files sys@CISCOSYS> col member format a60sys@CISCOSYS> select group#,member,type from v$logfile;GROUP# MEMBER TYPE---------- -----------------------------------------------------------

10 is the primary node, and 6 is the slave node. Use a script to back up the database of the host. [root@qianzhidb01 shell]# cat exprot_3306.sh#!/bin/shset -xdata=`date +%Y%m%d%H%M`mkdir

The actual size of the Instance contains fragments)SELECTROUND (SUM (data_length)/1024/1024/1024), 5) ASDATA, ROUND (SUM (index_length)/1024/1024/1024), 5) ASidx, ROUND (SUM (data_length + index_length)/1024/1024/1024), 5)

DML statement restrictions: 1. If the DML statement uses the degree of parallelism, you must set the alter session enable parallel dml for both HINT and directly set the degree of parallelism on the table. This step is essential! 2. If the

Summary: 1. The database name is case-sensitive and cannot be configured with Parameters 2. The table name is case sensitive (lower_case_table_names can be configured with parameters), and the table alias is case sensitive. 3. The column name and

At present, all major portal websites tend to use mysql to a certain extent. In addition to the I/O/E campaign advocated by the Alibaba system, we must correct the earlier view that we have always despised mysql, as a database practitioner, we must

Oracle 11.2.0.3 is selected for this installation. A total of seven installation packages are downloaded. The first two installation packages must be used for separate database installation. The installation steps are as follows: 1. Copy the

According to the company's plan recently, we need to incrementally fetch data from some tables in the previous SQL Server database to the ORACLE database and decide to use the newly added CDC Change Data Capture function in SQL Server. The procedure

In the previous article, I analyzed a specific implementation idea, mainly using Chinese Word Segmentation and Unicode encoding to solve the problem that mysql full-text indexes cannot be used for Chinese search, this article describes how to

I received a monitoring text message saying that the threshold value was updated and inserted, So I logged on to mysql-monitor to view the alarm, 650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131229/19412211N-0.jpg

Repair of oracle11g Bad blocksI. a brief introduction to the bbed command. Later, we will use this tool to construct the block checksum and do not express it to simulate Bad blocks. Show all current configuration optionsInfo: list the files that can

Someone asked why SQL Server data has changed, but why is the best modification date of database files and log files not changed. In fact, this is a normal behavior.   The modification date of the SQL Server File is when the SQL Server closes the

 Several common Mysql errors and solutions: 1. Problem: mysql DNS Reverse Solution: skip-name-resolve   The error log has a similar warning: Click (here) to fold or open 120119 16:26:04 [Warning] IP address '192. 168.1.10 'cocould not be