In Oracle 11G Release 2 segment allocation has been changed. When new table is created, the table segment creation is postponed till first row insert.
This functionality is enabled by default with new parameter DEFERRED_SEGMENT_CREATION set as default to TRUE
DEFERRED_SEGMENT_CREATION = TRUE | FALSE
This new feature allows to save initially a lot of space for newly created objects especially when you have thousands of partitions. However you need to remeber about careful space planing.
This article presents how to install Oracle 11G on Centos Linux 7.
Read following article how to install Centos Linux 7: Install Centos Linux 7 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).
Installation software is available on OTN, edelivery version 184.108.40.206 or Oracle support(old metalink) 220.127.116.11. In this installation I’m presenting installation for 18.104.22.168 but for previous version 11.2.0.X it shouldn’t be different.
Database software – 22.214.171.124
New interesting features are available in 11G related to statistics collection
- New statistics preferences
- Hash based sampling for column statistics
- Multicolumn statistics
- Expression statistics
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 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 126.96.36.199 or metalink 188.8.131.52. In this installation I’m presenting installation for 184.108.40.206 but for previous version 11.2.0.X it shouldn’t be different.
Check article for new release Install Oracle 12C Release 1 (12.1) on Fedora 20
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.
Configuration of network for virtualbox and RAC is always making a lot of trouble and raises many questions. In this article I’ll show how to setup network for RAC 11G, 12C using dnsmasq.
Objectives to complete:
- full network setup for RAC
- public network
- private network
- SCAN settings resolved by dnsmasq
- full access to internet from each RAC hosts
- configure dnsmasq
This article presents how to quickly install Oracle Database 11G Release 2 (220.127.116.11) and as Oracle Grid 11G Release 2(18.104.22.168) on Windows.
Check article for new release Install Oracle 12C Release 1 (12.1) on Windows 7, 8
- Oracle Database 11G Release 2(22.214.171.124) – 64 bit for Windows
- Oracle Grid 11G Release 2(126.96.36.199) – 64 bit for Windows
- Windows 8 Pro 64 bit
You can download Oracle Database 11G Release 2(188.8.131.52) and Oracle Grid 11G Release 2(184.108.40.206). You can download them on Oracle support formerly MetaLink.
p10404530_112030_MSWIN-x86-64_1of7.zip - database software
p10404530_112030_MSWIN-x86-64_2of7.zip - database software
p10404530_112030_MSWIN-x86-64_1of7.zip - grid software
Hardware and software requirements for database and grid software:
- at least 4GB ram as minimum, 20G space for binaries and 40G for ASM devices
- Windows Server 2003 – all x64 editions
- Windows Server 2003 R2 – all x64 editions
- Windows XP Professional x64 Edition
- Windows Vista x64 – Business, Enterprise, and Ultimate editions
- Windows Server 2008 x64 and Windows Server 2008 R2 x64 – Standard, Enterprise, Datacenter, Web, and Foundation editions
- Windows 7 x64 – Professional, Enterprise, and Ultimate editions
Windows 8 Support
Starting with Oracle Database 11g Release 2 (220.127.116.11), Oracle Database server and client are supported on Windows 8. Oracle RAC is not supported on Windows 8.
In case you are not planning to install grid 2GB ram is enough.
This installation was done for 18.104.22.168 on Windows 7 but with release 22.214.171.124 it’s possible on Windows 8.