Oracle

After the oracle listener service is started, the solution is stopped. oracle version 10.2.0.1.0 enables OracleOraDb10g_home1TNSListener in Computer Management. After the service is started, the listener file directory is stopped. D: \ oracle \

Information Enterprise Manager Database Control URL after oracle Installation-(orcl): http: // PC-20120503DVQT: 1158/em Database configuration file has been installed to F: \ oracle2 \ product \ 10.2.0, other selected installation components have

Knowledge about volume El locks 1. view which session locks: SQL statement: select 'alter system kill session ''' | sid | ',' | serial # | '''; 'From v $ session where sid in (select sid from v $ lock where block = 1); SQL> select 'alter system kill

To install oracle in win7, You need to modify the configuration items. 1. Set the fixed ip address, set the installation program compatibility (windows XP Sp3), and run it as an administrator. 2. Add the following to database \ stage \ prereq \ db \

Oracle 10 Gb installation procedure1. decompress the file 10201_database_win32.zipand double-click setup.exe under the project. The installation interface is displayed as follows:2. Enter the password and confirm the password, for example, password.

What is the problem when the sequence reaches the maximum value in Oracle? The sequence is a database object provided by oracle to generate a series of unique numbers. The sequence will automatically generate an ascending sequence number, to

In the EBS oracle production environment, the database backup script is saved as the sh script respectively below. The first one is that the backup speed of the compressed backup is extremely slow, and it takes 10 hours to GB, however, after the

The data in the ORACLE Stored Procedure table is overwritten and restored. The old Stored Procedure overwrites the new stored procedure. As a result, all the previously used functions are 0. Therefore, the stored procedure is restored by performing

Oracle users01.dbf is getting bigger and bigger. After oracle deletes data, the tablespace is not released, and the dbf file is getting bigger and bigger. You can use: SQL> ALTER DATABASE DATAFILE 'C: \ oracle \ product \ 10.2.0 \ oradata \ orcl \

In Oracle, The String Conversion format of the to_char () function is summarized as follows: to_char (var [, format]) Function Conversion format description: 1. [format] '000000' N indicates the number of numbers in the converted format.If the

ORACLE needs to create multiple cursors and nested loops: The data of cursor 1 is traversed each time the record of cursor 2 is traversed, insert the temporary table create or replace procedure testq is DownDictate VARCHAR2 (200) DEFAULT '';

Single quotation marks and double quotation marks can be used in column values. For example, the following INSERT statement specifies that the new customer's surname is O 'Malley. Note that the letter O in the surname is followed by two single

The common dynamic performance view V $ FIXED_TABLE in ORACLE is used to list all available dynamic performance views and dynamic performance tables. V $ INSTANCE is used to obtain detailed information about the current routine. V $ SGA is used to

In ORACLE, the insert into and select into statements are compared. In oracle databases, we commonly use the insert into TableName (column1, column1,...) statement to insert Table data ,...) values (value1, value2 ,...), this is the most basic table

Changing the validity period of the oracle password may cause exceptions in several existing projects due to a bug in the project. Bug Description: oracle11g. After the silent installation, the user's password is set to 180 days by default. after 180

[Oracle] Kill Session experience is summarized in the daily maintenance of Oracle. We often encounter the following two situations that require DBA kill session: 1. the App complained that their application hang was in use and found that their

Postgresql pgbench tool pgbench is a benchmarking tool for PostgreSQL. pgbench is a performance benchmark tool provided by postgresql. You can use pgbench -- help to check the parameter Usage: pgbench [OPTIONS]... [DBNAME] Initialization options:-I

GoldenGate Series 1: quick setup of one-way synchronization GoldenGate environment 1. Environment preparation (1) download the installation package and decompress it to ORACLE_BASE (2) modify the environment change [plain] [oracle @ irms156ogg] $ vi

Use expdp/impdp to import data from one database to another. 1. create DIRECTORY (the DIRECTORY must be created under the Database User) SQL code sqlplus system/manager create directory test_dir as '/home/orauat/zzj'; 2. Authorize SQL code Grant

Materialized View and job timed update example -- create test table create table test_dm_rep_m_gw_user as select * from dm_rep_m_gw_use t where t. month_no