Oracle

VPD: Oracle Virtual Private Database, that is, [Oracle Virtual Private Database]. By applying some policies, you can only access the data that is allowed to be accessed. The principle is relatively simple. Oracle automatically adds a Where clause

Oracle instances mainly have three types of processes (in Windows, they are actually threads ):· Server process: these processes are completed based on customer requests. Server processes include dedicated servers and shared servers:

TRANSLATE ('Char ', 'From _ string', 'to _ string ')       The return value of TRANSLATE replaces each character in from_string with the string after the corresponding character in to_string. TRANSLATE Is a superset of the functions provided by

  Oracle's sequence implementation is very flexible, so it also brings about some usability issues. How to obtain the sequence value generated by the new inserted records is significantly different from other databases, this document introduces five

  POP3 is called Post Office Protocol version3, that is, Post Office Protocol version 3rd. It is used by the user agent to obtain the mail on the mail server. POP3 uses the C/S communication model, and the corresponding RFC file is RFC1939. This

  Software environment: 1. Operating System: win xp 2. Database: oracle 10.2 3. installation path: d: \ oracle 4. test the class Directory: d: \ test Premise: If you use an external call to the java program, make sure that the jdk under the oracle

  Materialized View is a special physical table. The Materialized view is relative to a common view. A common view is a virtual table, which has many application limitations. Oracle converts any View query to a view SQL statement query. This

PrefaceRecently, the company's technology and R & D have been asking me about how to set memory parameters to optimize oracle performance. So I took the time to sort out this document for reference. Purpose We hope to organize this document to give

Create a new ADP_13 password: ADP_13Use system to log on to PLSQL (password: system)In the selection box, select users and press enter to find the user directory. Right-click drop to delete the original user, and right-click new User. The user name

Using the Bind Variable can reduce SQL PARSE, but using the Bind Variable has a bad point: Incorrect execution plan may be used for a column with skew. Before Oracle 9i, if the WHERE condition contains all When binding variables, you can only use

# Log on to the Database Host using an oracle user (ssh or telnet)$ Ssh oracle @ Database Host IP# Log on to the database as sysdba$ Sqlplus "/as sysdba"SQL * Plus: Release 10.2.0.4.0-Production on Mon Oct 10 15:53:45 2011Copyright (c) 1982,200 7,

Oracle modifies the Name of TableSpace Before Oracle10g, the name of tablespace cannot be modified at will. It can only be dropped and re-built. However, after 10g, oracle added the modification function, except for the system and sysaux tablespaces,

Scenario: Concurrent request A reduces inventory items not submitted query inventory not changed request B first judge whether inventory is sufficient A not submitted, inventory is sufficient and execution is also set up to reduce inventory. in fact,

Actual Example of drop table and purge in oracle Database: create or replace procedure pro_droptable IS cursor cur is select table_name from user_tables where table_name like 'temptable % '; drop_ SQL varchar2 (1000); table_number number; begin

I. Set operation operator UNION: (UNION) returns the UNION ALL records of the Two sets that remove duplicate values. (UNION) returns the records INTERSECT (intersection) of the Two sets that remove duplicate values) returns all records of the two

If you do not enable index monitor, you can determine whether the index has been used. If you want to know whether an index has been used, the traditional method is to enable index monitor. However, this method has two shortcomings: (1) it will

Oracle11g R2 RAC uninstalling grid oracle version: oracle11.2.0.3 enter the grid user, cd $ ORACLE_HOM/deinstallE directory [grid @ xyy1 deinstall] $. /deinstallChecking for required files and bootstrapping... please wait... location of

How to release the Oracle server with too many connections will crash. After the client network cable with too many connections is pulled out, the user's connections will still be retained on the remote Oracle, and the user's connections will not be

What is the relationship between sequences, triggers, and stored procedures? I haven't used oracle databases for a long time. Today I reviewed oracle sequences, triggers, and stored procedures, previously, the concepts of triggers and stored

A brief description of oracle expdp impdp using the Data Pump expdp. impdp can import and export data on the server side, which is highly efficient without setting the environment variable NLS_LANG, by default, the database will go to the character