Home » Oracle
Category Archives: Oracle
While your database may be running “fine” and your DBAs could be understandably skittish about rocking the boat by upgrading, in truth there are many tangible benefits to gain from upgrading to Oracle Database 12c.
In this expert e-guide Brian Peasland, a DBA with over 20 years of experience, breaks down 10 reasons you should upgrade. Here are the first 3:
- Increased Oracle support
- Updated hardware and operating systems
- Security patches
Learn the remaining 7 inside now.
Thanks to TechTarget
Thanks to Oracle
Oracle Application Express 5.2 will focus on both new features and enhancements to existing functionality, and it is planned to incorporate the following:
• Remote SQL Data Access – Extend common components such as Interactive Grids, Classic Reports and Charts to interface with data stored in remote databases using ORDS and REST.
• REST Service Consumption – Provide declarative methods to define references to external REST APIs and generic JSON data feeds and to use these references as data sources for Interactive Grids, Reports and Forms.
• Declarative App Features – Introduce a new Create App Wizard that allows for adding components and app features to new and existing applications
• Interactive Grid enhancements – Add additional reporting capabilities such as Group-By and Pivot, support for subscriptions and computations, flexible row height and general UI improvements.
• Page Designer – Provide client-side wizards for the creation of more complex components like Dynamic Actions, Forms and Shared Components, User interface improvements.
• New REST Workshop – Provide declarative methods to support the development of ORDS enabled REST web services, taking advantage of the latest features and functionality of ORDS.
• Packaged Applications – Improved framework and enhancements to the packaged applications
Autotrace in SQL Developer
This is a step up over the SQL*Plus version. It displays the stats for every step of the plan. So for each operation you can see metrics such as:
- How many buffer gets it used
- How long it took to run
- How many disk reads and writes it did
For more information, please check the below.
Thanks to Oracle – https://blogs.oracle.com/sql/entry/how_to_create_an_execution
Hope the below is useful for your new developments, please check and take care.
Thanks to Oracle for introducing new open source products like this.
Thanks to Mr.Shiva and Author Mr.Abdellatif Abugharbieh, hope this will be useful for everyone.
Please use the below link to download/install at your own risk.
Wish you all the best.
Long waited Oracle forms and reports 12c is available, check and enjoy with the new features.
Thanks to Oracle
Thanks to Alex Nuijten
To refresh multiple Materialized Views you can use the DBMS_MVIEW package, with the procedure aptly named Refresh. One method is to provide a comma-separated list of Materialized View names, or you can use an DBMS_UTILITY.UNCL_ARRAY to achieve the same objective.
When using the latter method, I stumbled upon this oddity (which is not in the current documentation, or at least I couldn’t find it).
The procedure that I initially wrote was the following:
On line 4 a local variable is declared on the type DBMS_UTILITY.UNCL_ARRAY. The declaration of this type is
On lines 6 through 8 the array is filled with the names of the Materialized Views that I want to refresh.
The actual refresh is done on line 9.
When executing the code above, the following exception is raised:
After some googling I found some old documentation (from Oracle 9i) describing the functionality of the REFRESH procedure in the DBMS_MVIEW pacakge:
If the table contains the names of n materialized views, then the first materialized view should be in position 1 and the n + 1 position should be set to NULL.
This explains the exception that is being raised.
Adding line 9 in the code below fixes this problem: