Find a full table scan SQL
select sql_text from v $ sqltext t, v $ sql_plan p Where t.hash_value = p.hash_value And p.operation = 'INDEX' And p.OPTIONS = 'FULL SCAN' Order by p.HASH_VALUE, t.piece;
11g r2 reconstruction em
11g r2 reconstruction em C: \> emca-deconfig dbcontrol db EMCA began 2010-7-16 9:29:21 EM Configuration Assistant, 11.2.0.0.2 official version Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: or ...
ORA-16116: no work available
sqlplus "/ as sysdba" SQL * Plus: Release 10.2.0.4.0 - Production on Fri Jul 16 19:18:24 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production ...
Centos 5.2 install oracle11g
Centos 5.2 install oracle11g Existing machine configuration: CPU: Intel Dual Core 1.8G RAM: 3G HDD: 220G To prepare recommendations before installing the hardware: Swap partition must be more than 3G, the best allocation when the installation CentOS5 ...
Sqlplus in Linux, can not be used when the solution vi
Sqlplus in Linux, can not use vi Can not use vi The sqlplus in Linux, if you use the edit to edit the current script, then call the default editor ed, if you want to use vi as the default editor, you can edit the file $ ORACLE_HOME / sqlplus / admin / glo
Cross-border value of the query plan may affect the implementation of ORACLE
One problem: there is no value on the query plan may affect the implementation of ORACLE. Problems reproduced as follows: SQL> conn ysp / ysp Connected. SQL> DROP TABLE TEST PURGE; Table dropped. SQL> CREATE TABLE TEST (ID CHAR (8), COLNO VA ...
Oracle 11GR2 bad blocks automatic recovery
Oracle 11GR2 bad blocks automatic recovery Spent some time testing a bad block 11G bad about fast automatic recovery function, for your reference Study: george.ma, http://blog.chinaunix.net/u/12521/ Background: Data file must have a lot of bad blocks ...
Oracle database management script description
Oracle database management script description Oracle data dictionary is a database in a very important part in providing the relevant information in the database, it is all Oracle users (from the application end-user, application developer to design ...
The misunderstanding of the system rollback segment
Has been that the system rollback segment is used to sys user, occasionally found in the experiment is not the case. Implementation using sys user login dml statement SQL> insert into t select * from scott.emp; 14 rows created. SQL> show user U ...
Oracle 10g lightweight client installation in mind
Transfer from http://www.blogjava.net/x-29/archive/2007/11/14/160479.html ◎ Oracle 10g lightweight client installation in mind 1, pressure from several places http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html download th
Oracle10gR2 ORA-3136 error solution
The new on-line database Oracle10gR2 warning log file (alert.log) continued the following error: Tue Jul 18 23:09:22 2006 WARNING: inbound connection timed out (ORA-3136) Tue Jul 18 23:09:23 2006 WARNING: inbound connection timed out (ORA-3136) Tue J ...
Summary oracle index of knowledge (transfer)
Index Overview <br /> index is a relational database used to store a record of each object, the main purpose is to speed up the data read speed and integrity checking. Indexing is a technical demanding work. General in the database design stage ...
Temporary table global temporary table
Two types of temporary tables: Transaction-based: on commit delete rows, the default session-based: on commit preserve rows Temporary table in the block will not be locked in the temporary table DML DML statement is executed, will not generate REDO, ...
Index extended overflow
Night duty database error: Error: ORA-01632: max # extents (121) reached in index STDBA.I_INVENTORY_ITEMS Interim Review: Summarized as follows:
Unable to connect SQLState = 08004
PowerDesigner12.5 connect Oracle data, you need to configure ODBC, the emergence of this exception! Unable to connect SQLState = 08004 [Oracle] [ODBC] [Ora] ORA-12154: TNS: could not resolve connect identifier specified Cause: The service name Li Dai ...
Maxtrans parameters on inittrans and understanding
inittrans: initial transaction number, the default is 2 maxtrans: the maximum number of transaction, the default is 255 These two parameters mark the number of block concurrent transactions, inittrans initial value, distribution blocks allocated spac ...
Oracle em button appears garbled practical solutions
Oracle EM buttons appear garbled in the actual application is often in the actual operation to bring a lot of inconvenience, the following article that describes Oracle em button appears garbled practical solutions, the following is the detailed desc ...
Oracle10.2.01 after 248 days in boot hang Bug 4612267 patch install
1, bug symptoms and description Symptoms: When the host running time up to 198 days or 248 days, cpu utilization suddenly 100%. At this point the operating system commands can be performed, but Oracle's command as lsnrctl, sqlplus, dbca, etc. wil ...
Linux, Oracle sqlplus Chinese garbled in problem solving
Sqlplus in Windows, completely normal, but that under Linux, sqlplus Chinese display on the problem, and always show "??", this problem, how to solve it? After the network to find information, and try to get the solution as follows: Is very ...
the following processes need to be shutdown before
APPLYING 10.1.2.3 PATCHSET FAILS WITH "THE FOLLOWING PROCESSES NEED TO SHUTDOWN BEFORE CONTINUING: JAVA" [ID 975597.1] This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not bee ...
Trigger. Process. Functions to create scripts
desc user_source user_triggers
Oracle's initial password after installation
internal / oracle sys / change_on_install system / manager scott / tiger sysman / oem_temp
upgrade oracle 32bit database to 64bit & dataguard
Yesterday, asked a question, how to upgrade a database to 64bit 32bit database. If you use DBUA, run after the completion of the conversion is complete. If you do manually, you need to copy the files to the appropriate location, will start to upgrade ...
Remove non-JOB under current user
A few days ago when use of dbms_job.remove remove the job encountered ORA-23421 error: ORA-23421: job number string is not a job in the job queue Cause: There is no job visible to the caller with the given job number. Action: Choose the number of a j ...
I ask how to identify where a user is a machine landing ORACLE
Where a user is a machine landing ORACLE's? SELECT machine, terminal FROM V $ SESSION
exp, imp problem caused JOB
JOB when comparison in import and export special, met today did not expect a problem, just about collate records. JOB Oracle generated the id in the database is unique. All information is stored in the SYS JOB's JOB $ table, primary key ID genera ...
Remove non-JOB under the current user
A few days ago when use of dbms_job.remove remove the job encountered ORA-23421 error: ORA-23421: job number string is not a job in the job queue Cause: There is no job visible to the caller with the given job number. Action: Choose the number of a j ...
fast parse, soft parse, hard parse the difference between
fast parse, soft parse, hard parse the difference between Oracle released a SQL statement processing: 1, the statement into the equivalent number of ASCII code; 2, the ASCII code passed to an equivalent number of hash algorithms, by the hash algorith ...
Issues beyond the borders of the base estimate
In 10GR2, with regard to the choice of values beyond the borders of the degree of the problem, ORACLE changed the algorithm. Note: The following test case in the absence of the histogram. SQL> CREATE TABLE T (ID INT); Table has been created. SQL&g ...
ONLINE index rebuild global impact in mind
A few days ago a problem, rebuild the index when a table, even with the more than eight hours. Then double-check a bit slow to create the index, find all the global index and the basic methods are ONLINE reconstruction, the reconstruction of each dis ...
Po price is NOT equal to RCV price and MMT price
The issue occurs twice again, the problem should be a bug [patch 5256307]. Solution: -------------------------------------------------- --------------------------- Step1> update po's unit price to the price that it has been used by receiving; ...
oracle stream configuration files
Operating Environment: Primary database: OS: Centos 5 IP Address: 193.168.1.142 Database: Oracle 11.1.0.6.0 ORACLE_SID: down global_name: down From the database: OS: Centos 5 IP Address: 192.168.1.4 Database: Oracle11.1.0.6.0 ORACLE_SID: download Glo ...
num_distinct.density and selectivity issues
When calculating the Cardinality, ORACLE will first use the DENSITY. If you manually modify the NUM_DISTINCT DENSITY then change will follow. However, in turn, if modified DENSITY, NUM_DISTINCT will not change. SQL> SELECT * FROM V $ VERSION; BANN ...
oracle network configuration concepts
oracle network configuration concepts Network configuration file default directory in the $ ORACLE_HOME / network / admin directory sqlnet.ora sqlnet.ora file decided to find a way database server alias Parameters SQLNET.AUTHENTICATION_SERVICES = (NO ...
oracle modify the host name or IP
oracle modify the host name or IP Modify the host name will affect the following two 1, the network parameters 2, file directory name or file name \ Oracle \ product \ 10.2.0 \ db_1 folder (Your name) _orcl To \ Db_1 \ localhost_orcl \ Db_1 \ hostName_orc
init.ora in Remote_Login_Passwordfile impact on authentication
init.ora in Remote_Login_Passwordfile impact on authentication Three optional values: NONE: default value, indicating Oracle system does not use a password file for authentication by the operating system privileges users have SYSORA and SYSOPER privi ...
How to customize document type layout for standard
How to customize document type layout for standard PO? File: How to customize document type layout for standard PO.pdf Size: 343KB Download: Download
Modify the parameters of a process share pool
System environment: redhat-as4.7 oracle10.2.0.4-RAC Why changes? Recent applications have three temporary database problem can not connect, check all nodes alter the log each time a problem was found when a node is recorded alarm log: Tue Jul 6 14:44 ...
Access to bind variables
The SQL statement with bind variables, ORACLE, when the first execution will be carried out bind variables PEEK. Whether it implied parameters _OPTIM_PEEK_USER_BINDS PEEK control, default is TRUE.. ORACLE in the first PEEK, the value of the variable ...
Oracle WebLogic 11g for RHEL5 Installation
[Oracle @ tpark weblogic] $ java-d64-jar wls1033_generic.jar Can not instantiate GUI, enter the console mode by default. Extracting 0 %............................................... .................................................. ... 100% <--- ...
Oracle Temp temporary table space address
Oracle Temp temporary table space Favorites Temporary tablespace is the oracle in the temporary table space and temporary table space for the main purpose is to sort the database operations, management, indexing, access to views and other operations, ...
oracle 10G installation script
ORACLE 10G to some pre-pre-installation configuration, including system parameters, file modification, creation of users and groups such as the use of the script can be a step counter bit, but before running the script to your hardware configuration ...
oracle 10G installed scripts
ORACLE 10G to some pre-pre-installation configuration, including system parameters, file modification, creation of users and groups, etc., use this script to step in trans, but before running the script based on your hardware configuration changes th ...
Re-positioning data files
ORACLE management in the process, sometimes run into more than one disk in the system, but there is no reasonable arrangement to create the database when the data file storage location, or run the process in the excessive growth of certain data files ...
Online redo log file processing
Online redo log files recorded during the operation of all important database operations, for the database instance recovery or media recovery. By default when you create a database online redo logs generated three groups, each group member (in respo ...
Oracle change the user name
Project has built a database table, but suddenly need to change the user name. The form of client interface through the plsql is not reform. So change the system user $ table directly in the user name. To change the user name check SQL> select use ...
Oracle user name change
Project has built a database table, but suddenly need to change the user name. The form of client interface through the plsql is not reform. So to change the system user $ table directly in the user name. Query to change the username SQL> select u ...
OEM Explorer, web pages can not start treatment failure
To open the OEM's web manager, you must first start the Database listener, then start Datebase Control port monitoring program, but encountered the following situation Question: [Oracle @ localhost OC4J_DBConsole] $ emctl start dbconsole TZ set t ...