Oracle

Database Current SCNCode to copy code as followsIdle> select checkpoint_change# from V$database;checkpoint_change#------------------271743118idle> Shutdown AbortThe ORACLE routine has been closed.Analysis of SCN in control fileHere we can see the

1. Query the number of connections to OracleSelect COUNT (*) from v$session;2. Querying the number of concurrent connections for OracleSelect COUNT (*) from v$session where status= ' ACTIVE ';3. View the number of connections for different

Oracle BIEE The final effect of a column specifying a cell for a merge display, see:The specific actions are:1. Set the Column Property-column format-value correction to disabled, at which point the BIEE will default to merge the cells with the same

The same database of the same host, there can only be one listener, when we configure multiple listeners, it will listen to the database on the other host, but this performance is not good.The Listener.ora configuration file explains:Listener

Win7 Bit64, the 64-bit client is installed.  1. Plsql Connection Database(1) Download Instantclient-basic-win32-11.2.0.1.0.zip extract to Oracle headlines now, and create a new Network/admin/tnsnames.ora (2) to configure the Plsql Oracle directory,

If you need to write a data dictionary when the project is delivered, you can use the following method to first run the line face SQL statementSELECT a.table_name as table name, a.column_name as field name, DECODE (A.char_length,

1. View the log file location;[email protected]>select inst_id,name,value from V$diag_info;inst_id NAME VALUE---------- -------------------- --------------------------------------------------1 Diag Enabled TRUE1 ADR base/u01/app/oracle1 ADR Home/u01/

Operating system platform: RHEL 5Shell Environment: BashOracle:10g2Function Description: Automatically switch to Oracle user at power-on, and launch multiple instances of Oracle. and record the startup of the database into a custom log

Each time a select is displayed as such:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/05/wKioL1Qnug6hHeV1AAC8jV6dou0256.jpg "title=" Oracle1.png "alt=" Wkiol1qnug6hhev1aac8jv6dou0256.jpg "/>The display page size should be

1. Points of problems encounteredUsing Sqldeveloper to connect to an Oracle database, when you test the connection, you are prompted "the network adapter could not establish the connection"2, the solution processConfigure the Listener and service

Wrote a stored procedure, which used a function, the function has a section of To_date (Datefrom, ' Yyyy/mm/dd '), after the run to find data insertion error, inserted data for "0001/9/14." Feel baffled, do not know why this is the data, after

Create LPN for OracleEBSZookeeper creates LPNPROCEDURE create_lpn (errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_organization_id in number, p_lpn_prefix IN VARCHAR2, p_lpn_suffix IN VARCHAR2, p_lpn IN VARCHAR2) IS BEGIN-- InitializeStruct (errbuf =>

Use OracleDBLink to access objects between databases Oracle comes with the DBLink function. It is used to logically think of multiple oracle databases as one database, that is, one database can operate on objects in another database, for example, if

ORACLE compilation failure objectInvalid ORACLE compilation objectsThere are many reasons for database object invalidation:1: when the structure of the referenced object is changed, the dependent object will be changed to the INVALID state.Objects

Detailed explanation of password expiration in Oracle 11g, oracle11g There are two possible causes for Password Expiration: 1. Because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle by default. 2. Because

Oracle export and import under the DOS command The command running in DOS can also be run with parameters in the SQL/PLUS EnvironmentSimple ExampleSingle Table backup (the structure of the prerequisite database is the same)Export:Start button-> Run-

Configure statspack in the OracleRAC Environment Statspack is a product of the Oracle 9i era. It has a cross-milestone significance for monitoring and analyzing database performance and is the predecessor of AWR. After 10 Gb of Oracle, AWR replaces

Practice: shell scripts for oracle tablespace Deletion #! /Bin/bash# Ocpyang@126.com# Drop tablespace If [$ #-ne 1]; thenEcho "Usage: $0 TABLESPACE_NAME"Exit 1Fi # Configure oracle env: about oracle envs, username and password ORACLE_SID =

Practice: Create shell scripts for oracle users #! /Bin/bash # ocpyang@126.com # create userif [$ #-ne 4]; then echo-e "\ e [1; 32 m ************************************** **************************************** * ** \ e [0 m "echo-e" \ e [1; 32 m

Solve the Problem of connecting 32-bit plsql clients to databases without 64-bit Oracle11gSince I installed 64-bit Oracle, plsql cannot be connected because it is 32-bit. There is a way to connect to the Internet; Download