Oracle

Oracle EBS payment settings are flexible, and some settings are not clear yet. The specific parts are as follows: Cutoff day: from the end of the day, that is, beyond this day, will be in the next payment cycle Due DAYE: the number of days to be

In order to solve the memory leakage, the patch has been upgraded many times in the past few months, but it has failed many times, but it has finally been solved. In fact, the upgrade fails because some files are being used by other programs. The

1. Remove the HBA fiber of rac2, interrupt rac2 and storage cabinet, and find that rac2 reboot and Rac1 work normally. [Oracle @ racdb01 ~] $ Crs_stat-TOra. RAC. DB application online racdb01Ora... s1.inst application online racdb01Ora... s2.inst

 The Oracle component information can be viewed through V $ option and dba_registry:  -- View v $ option: V $ option displaysoracle Database options and features. typically, although not always, optionsmust be separately licensed, whereas features

    For details about how to use the expdp/impdp command, refer: Oracle expdp/impdp example Http://blog.csdn.net/tianlesoftware/article/details/6260138   Comparison between exp/IMP and expdp/impdp and some optimization items in

  Error: ORA-00845 after Oracle 11gr2 is started   Rac1:/home/Oracle> sqlplus/As sysdba; SQL * Plus: Release 11.2.0.3.0 production ontue Feb 14 09:11:41 2012   Copyright (c) 1982,201 1, Oracle. All rights reserved.   Connected to an idle instance.  

  In AWR, if some options are: nodata exists for this section of the report. It is normal.   For example:   Now let's look at an AWR with data:   The following figure shows the display conditions: (1) SQL orderedby sharable memory: Only statements

I plan to play RAC on the virtual machine, Google a pass, found that most of the information is based on this post (http://www.itpub.net/thread-1009235-1-1.html), using VMware Server to create bare device-based shared storage, oracle official

Bind peeking is a new feature introduced in Oracle 9i and continues until Oracle 10g R2. It is used to view the value of the current SQL predicate during hard Analysis of SQL statements. To generate the best execution plan. In versions earlier than

= [Static registration] = static registration can be configured through a graphical net manager. the configuration options in the net manager correspond to relevant files: Summary File sqlnet. ora service name tnsnames. ora listener listener.

 1. Official Website description 1.1 Processes 11gr2 documentation:   Property Description Parameter type Integer Default Value 100 Modifiable No Range of Values 6 to operating system

  In the patchset of Oracle 10g version, only one file disk1. the size of the patchset in Oracle 11.2.0.2 and 11.2.0.3 is greatly increased. The patchset of 11.2.0.2 and 11.2.0.3 is 5 GB. These 5 GB files are composed of seven files.     It is a

Adaptive cursor sharing adaptive cursor sharing or extended cursor sharing (Extended cursor sharing) is one of the new features of Oracle 11g. It is mainly used to solve previous versions In this example, the SQL statement cannot obtain the best

  In this document @ Oracle confidential (internal). Do notdistribute to mers MERs@ Reason: has internal information @ (Authwiz 2.5.1)   Applies: Oracle Server-Enterprise Edition-version:Information in this document applies to any platform.Oracle

1. If the DDL syntax is correct, implicit commit will occur even if the execution fails: Duzz $ Scott @ orcl> Create Table T1 as select * from Dept;   Table created.   Elapsed: 00:00:00. 03 Duzz $ Scott @ orcl> Update T1 set loc = 'xx' where deptno =

 I. Overview In previous articles: RAC concepts and principles Http://blog.csdn.net/tianlesoftware/article/details/5331067 Ocssd is the most critical process of clusterware. If an exception occurs, the system restarts. This process provides the CSS

I just tested a program and reported an error saying that the data was not found: Rochelle date1! = L_date2L_date1 = 26-May-11, l_date2 = 26-May-11 ...... It turns out that it was nls_date_format. Oracle uses built-in programs such as

When declaring the varchar2 variable, we can specify its maximum length unit as char: V1 varchar2 (2 char); or byte: V2 varchar2 (2 byte );, Most of the default values are not specified: V3 varchar2 (2 );. So what are the differences between the

  Update Oracle to 9.2.0.8. Check the invalid objects and find several invalid objects starting with odcxx. Check Oracle, saying that these objects are invalid due to unknown reasons in Versions later than 9.2.0.8. These objects have been deleted in

Program name: xblo (JSP + servlet + JavaBean + Oracle single user blog)========================================================== ======================================Program version: 0.1 (20100912)===================================================