Oracle

1. Query V$database getSince Dbid has records in both the control file and the data file, the V$database view can be queried if the Mount database is available.Sql> ALTER DATABASE Mount;Database altered.Sql> select dbid from V$database;DBID----------

Modify Oracle Memory footprint? 1234567891011121314151617181920 # su oracle   $cd $ORACLE_HOME   $./sqlplus /nolog   >connect / as sysdba;    >show parameter sga; (查看内存占用情况)     NAMETYPE          VALUE  ------------------------------

Oracle Exercises:To create a table:CREATE TABLE Customer_info (ID int primary key not null,first_name varchar), last_name varchar, sex char (2), age char ( 3));Create a sequence: reference http://zhidao.baidu.com/question/82436743.html Create

DML statement Flow1 Get transaction Lock and ITL2 Locking candidate rows3 Generating Redo4 Generate Undo5 Generate redo record write to log buffer and change data blockTransaction commit1 assigning SCN2 Update the Transaction table to change the

There are three kinds of permissions for Oracle:Object Privileges Objects PermissionsRole Privileges Roles PermissionsSystem Privileges Systems Permissions(i), object permissionsIn general, object permissions are for a user access to certain tables,

On many occasions, we will need to use Oracle column merging, and Oracle provides methods for merging multiple rows of data from a column into a single row.First, 10G before using Wmsys.wm_concatWmsys.wm_concat separates the values of the fields

1, put the instantclient directly into the D packing catalogue2, Registry modification3, environment variable settings:Right-click Computer (My Computer) → advanced system settings → advanced → environment variablesIn the system environment variable

Common Oracle Functions Some of the notes I took when I was learning Oracle some time ago. Below are some of the notes for common Oracle functions. I will share other notes later. Please criticize and correct me.   1. Use of the to_date () function

Solving the ORA-02395: exceeding the call limits for I/O useThe PROFILE file of ORACLE is a method to restrict the resources used by database users. For example, you can control the CPU that can be used by sessions or SQL statements, and control

Oracle Database Backup Data missing Oracle databases have been used in the project. Since I have been focusing more on the ORM ing framework, I have barely paid attention to Oracle features, and I do not know many things, in addition, the

Detailed process of fixing Oracle11GDataGuardORA-16086 Problems1. Problem description: No redo logs are applied to the standby slave database.Tue JUNl 22 09:05:07 20142. View redo log information in the slave DatabaseSQL> show parameter

In the linuxoracle10g/11gx64bit environment, goldengate automatically starts with the OS.In linux and oracle 10g/11g x64bit environments, goldengate automatically starts with the OS.Background description:Goldengate is installed in the/u01/ggs

Determines whether a string is a valid time function. A function used to determine whether a string is a valid time. If it is a valid time, 1 is returned. If it is not a valid time, 0 is returned. CREATE OR REPLACE FUNCTION is_date(parameter VARCHAR2

Introduction to the nvl function of oracle, using lenvl Function Nvl functions of Oracle Nvl () function Returns a non-null value from two expressions. Syntax NVL (eExpression1, eExpression2)Parameters EExpression1, eExpression2 If the eExpression1

Use of alter constaints to modify the table structure in ORACLE, alterconstaints 1. Create a federated primary key Alter table name add constraints end name primary key (column name, column name ..); 2. New Characters Alter table name ADD

Oracle snapshot Management ---- Manually create an oracle SnapshotBEGINDBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ --- Delete a snapshotFor more information about snapshots, see DBA_HIST_SNAPSHOT. BEGINDBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_

Installing Oracle12c in OracleLinux6 After N installation attempts to vomit blood, I hope to help you and keep a note: Conclusion: preparations before installation are critical !!! Check and recheck! Reference:

Does the branchblock of the Oracle composite B * tree index contain non-pilot column key values? I haven't touched the underlying details of the database for a long time. A little guy came to me a few days ago and had to say that the compound B *

Relationship between OracleServiceXXX and Oracle instances in windows In fact, oracle in windows is completely dependent on OracleServiceXXX in the window service when the oracle instance is started. This XXX is the oracle Instance name (note that

Oracle user locked Sqlplus sys/password @ localhost: 1521/cmsx as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Monday July 21 13:33:13 2014 Copyright (c) 1982,201 0, Oracle. All rights reserved. Connect:Oracle Database 11g Enterprise