Oracle

One-point discovery of ORACLE indexes (Requirements for indexes for different table join statements)Two different table join statements are written: (the same effect) www.2cto.com select * from T_FORM_ELEMENT t join t_form_resources t1 on t1.meta _

Install oracle10g + asm under rhel --- build su-root www.2cto.com mkdir/asmdisk = in unix/linux, all devices are files, so we can create several files to simulate multiple hard disks. Create several files with dd, the size is 1Gdd if =/dev/zero of =/

Personal Understanding of Oracle databases, instances, and configuration filesOracle configuration fileThis section describes the network configuration files of Oracle: listener. ora, sqlnet. ora, and tnsnames. ora. They are all stored in the $

Oracle inspection tool: RDA introduction (I) download RDA and decompress it: http://up.2cto.com/2013/0323/20130323110229534.rar [Plain] [oracle @ localhost vmshare] $ gunzip pull [oracle @ localhost vmshare] $ tar-xf rda_41_12.16.1-051205.tar

Background of index creation for some rows: if the data distribution of one column in a table is uneven, most of the data is 1, and a small part is 0, and the data that we often query is exactly 0, in this case, full table scan is a waste of

ORA-01157 error "cannot identify/lock data file" solve sqlplus access to the database as an administrator, error occurs at startup, as follows:> sqlplus "/as sysdba" SQL> startup ...... ORA-01157: cannot identify/lock data file 8-see DBWR trace

PL/SQL Chinese garbled correction (import or Update operations)I need to modify some fields of some tables in the database as needed. However, during the Update process, Chinese characters (Type field) are garbled ).At this point, I use a client,

Install Oracle 10g2 in CentOS 6.4. centos 6.4 desktop system, without built-in java7 and other unused software, without openoffice and other office and entertainment software. After installation, yum update updates the system to the latest version,

When updating or deleting a record, the operation cannot be performed, or the lock is fixed. Sometimes, when we perform update or delete on oracle, the operation result cannot be obtained at the previous time,The record is still being processed. At

Arcsde post oracle11g error solution environment: oracle11.2.0.3 and oracle10.2.0.1, Arcsde9.3.1 create an AB instance in oracle11.2.0.3, then use Arcsde9.3.1 post oracle11.2.0.3 to create the sde configuration and report an error during the post

Oracle Proxy Authentication (Proxy Authentication) First, let's take a look at the official Oracle Introduction: Oracle Proxy Authentication was first launched in Oracle8i, it is designed to provide more flexibility for application developers when

Oracle bitmap index B-tree index is a common index in Oracle. It is the default index type when creating an index. A maximum of 32 columns can be included. The bitmap index Oracle creates a bitmap for each unique key and saves the ROWID associated

PL/SQL calls JAVA to obtain the MAC address of the NIC. It is mainly used to learn how PL/SQL calls JAVA. platform: WINDOWS 1. first, use PL/SQL to create and compile the JAVA source file (JAVA source) until there is no error. note that when calling

Let's talk about fine-grained audit (DBMS_FGA) 1. the DBMS_FGA package is effective in the cost-based optimizer. unnecessary audit records may be generated in the rule-based optimizer. (Because audit monitoring can occur before row filtering)

RMAN Compressed Backupset: [plain] There is some CPU overhead associated with compressing backup sets. if the database being backed up is running at or near its maximum load, you may find the overhead from using as compressed backupset unacceptable.

64-bit Windows 7 ORACLE garbled by numbersFirst, plsql developer directly reports an errorNLS_LANG ErrorThe first step is to testC: \ Users \ XJY. xjy-PC> set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBKAfter SET NLS_LANG is foundThen check the

Manually uninstall the Oracle Database System Environment on Linux: Red Hat Enterprise Linux Server release 5.5 (Tikanga) Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 steps are as follows: 1. stop all Oracle processes $ sqlplus/as

Oracle experience 4 -- set query @ multi-table join in oracle @ Case study 1. A Brief Introduction to the union of query keywords in a set: union (returns all records of the Two sets after removing duplicate elements) union all (returns all records

Oracle SQL multi-Table query was a time when I was confused about oracle multi-table queries. The reason is that oracle's own syntax is mixed with the SQL international standard syntax. This article is only applicable to oracle cainiao...

How can I recover the Oracle database for the first time! I have been familiar with oracle for several years, but I have been engaged in development for a long time, and there are very few opportunities to back up data. Recently, the company's ERP