If you want to load data in direct mode into a table you should set all dependent indexes in UNUSABLE state. Session parameter SKIP_UNUSABLE_INDEXES set to TRUE enables to ignore indexes with status UNUSABLE during direct load.
However If an index is used to enforce a UNIQUE constraint on a table, then allowing insert and update operations on the table might violate the constraint. Therefore, this setting does not disable error reporting for unusable indexes that are unique.
This article presents how to install Suse Linux Enterprise Server SP3 – service pack 3.
I assume you have already downloaded Suse Linux Enterprise Server SP3 64 bit(it’s about 4GB) and you know how to use VirtualBox 64 bit(100M). Create virtual machine with default settings for Suse openSuse 64 bit. 1GB ram(I set 4GB for future use) and 64G for disk is enough plus increase video memory to 128M and turn on acceleration 3D. Rest of options you can keep default.
In case you want to collect trace statistics you can do it in many ways in Oracle. One of the most popular method is by setting parameter event with value sql_trace on session level.
alter session set events 'sql_trace level <trace_level>'
This article shows how to load text or binary files into Oracle database table column using sqlldr tool. It’s very useful and common practices.
With 11g release 1 Oracle has introduced new package DBMS_HPROF. It’s very useful for DBAs and developers to analyze execution of PL/SQL code. It enables to gather, store and organize a lot of information about executed code.
Informations gathered by this package are supported by Oracle sqldeveloper which is another great news :).
The PL/SQL hierarchical profiler features:
- easy to install and use
- collect execution times for SQL and PL/SQL code
- keeps results in database tables
- Provides subprogram-level execution summary information, such as:
- Number of calls to the subprogram
- Time spent in the subprogram itself
- Time spent in the subprogram itself and in its descendent’s subprograms
- Detailed parent-children information, for example:
- All callers of a given subprogram (parents)
- All subprograms that a given subprogram called (children)
- How much time was spent in subprogram x when called from y
- How many calls to subprogram x were from y
It’s no new feature in 11g but it’s worth to describe it. Package DBMS_TRACE enables to trace execution of PL/SQL code in database.Oracle collects the trace data as the program executes and writes it to database tables.
New enhancements are added in 11g for dynamic SQL in PL/SQL :
- SQL statements that are larger than 32 KB are now allowed in native dynamic SQL
- CLOB can be used for DBMS_SQL.PARSE
- DBMS_SQL cursor can be converted to REF CURSOR and vice versa
- Mored data types(including object types, collections) are supported in DBMS_SQL
This article presents how to install Oracle 12C(184.108.40.206) Release 1 on Fedora 19.
Read following article how-to install Fedora 20 Linux:Install Fedora 20 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).
Software for 12CR1 is available on OTN or edelivery
This article presents how to install Oracle 11G on Fedora 20.
Read following article how to install Fedora 20 Linux: Install Fedora 20 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).
Installation software is available on OTN version 220.127.116.11 or metalink 18.104.22.168. In this installation I’m presenting installation for 22.214.171.124 but for previous version 11.2.0.X it shouldn’t be different.
Oracle software which I verified
New parameters and parallel behaviour are introduced in Oracle 11g that simplifies management of parallel DOP calculations just before execution of a query in database.
PARALLEL_MIN_TIME_THRESHOLD - any number > 0, AUTO(default)
PARALLEL_DEGREE_POLICY - MANUAL(default),LIMITED,AUTO
PARALLEL_DEGREE_LIMIT - any number > 1, CPU(default), IO, AUTO
PARALLEL_FORCE_LOCAL - TRUE,FALSE(default)
PARALLEL_IO_CAP_ENABLED - is deprecated and remapped
to PARALLEL_DEGREE_LIMIT set to IO
PARALLEL_THREADS_PER_CPU - is now hidden parameter
PARALLEL_AUTOMATIC_TUNING - is deprecated and should not
be used. It means should have default value FALSE.