(Christian Antognini) I finally managed to install and test patch 22652097 (PROVIDE SEPARATE CONTROLS FOR ADAPTIVE PLANS AND ADAPTIVE STATISTICS FEATURES).
Tag: Oracle
Skip LOV Validation for ADF BC Bulk Insert
(Andrejus Baranovskis) This post is about ADF BC LOV. I will describe how you could optimize bulk insert of new rows into VO, when some of the attributes are assigned with LOVs.
Using Index-Organized Tables in Oracle
(David Fitzjarrell) Since version 9.2, Oracle has provided an interesting construct called the Index-Organized Table, or IOT. Such tables are basically indexes with the leaf nodes as the actual table data.
Scanning an Index
(amitzil) The internet is full of information about indexes, and for a reason. Indexes in a database is probably the most important performance related topic. There are so many cases, properties, and different ways to use indexes that there is simply a lot to write about.
A Guide to the Oracle UPDATE Statement
(Ben) Have you ever needed to update data that was already in a table in Oracle? Learn how to do this with the Oracle UPDATE Statement.
Performance problems with OEM AWR warehouse
(John Hallas) The Enterprise Manager AWR Warehouse is designed to hold performance data from multiple databases for long-term analysis. It promoses that it will save storage and improve performance on your production systems.
node-oracledb 1.12.1-dev can fetch CLOBs as JavaScript String
(cj) A preview of node-oracledb 1.12.1-dev is available on GitHub and can be installed with:
Quick SQL – A New Way to Generate Objects in APEX 5.1
(Jeff Smith) Oracle Application Express on APEX.ORACLE.COM was upgraded to v5.1 last week.
Permanent Re-Login for WebLogic Consoles for multiple WebLogic Domains on one Server
(Dirk Nachbar) In case you have multiple Oracle WebLogic Server Domains on one Server running, you might realise the following problem:
A Guide to the Oracle ALTER TABLE SQL Statement
(Ben) The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide.
