If you want JSON support in your Oracle database today you can use PL/JSON, an open source JSON parser written in PL/SQL.
However, as Marco reported from Oracle OpenWorld, native JSON support may be an upcoming new feature in Oracle Database 12c.
This new feature allows the storage of (more...)
Bug about which i wrote previously is fixed now in 12.2, and patch 16516751 is available now for 188.8.131.52 Solaris64.
1. CBO can consider filters in such cases now
2. Hint NUM_INDEX_KEYS fixed and works fine
Jonathan Lewis explains the recently announced Oracle Database 12c in-memory option:
The in-memory component duplicates data (specified tables – perhaps with a restriction to a subset of columns) in columnar format in a dedicated area of the SGA. The data is kept up to date in real time, but (more...)
JDeveloper comes with a nice audit framework, one of the great things about this framework is that you can write your own code to check for specific standards or fire specific rules you want to check. If you want to write extensions in 11g I recommend one off the two (more...)
At Derbycon 3.0, László Tóth and Ferenc Spala gave a a new presentation “What’s common in Oracle and Samsung? They tried to think differently… ” (Video). The main focus of the presentation was the Samsung encryption and a new framework called sandy but there was also a small (more...)
April last year I blogged about TOP-N reporting using Top selling items
as example. In Oracle 12c we now have a new FETCH FIRST syntax, so in this post I'll revisit the Top selling items example showing where and how FETCH FIRST can be used and where you still need (more...)
Why I try to post about Database Sizes on Oracle Multitenant Self-Service Provisioning. When I create New Database(PDB), I want other Maximum Storage sizes.
My idea is 500 GB and 2 TB... How to do? On "Self-Service Administration" - First, select "Self-Service System Configuration". Then select "Database Sizes".
A user can create notifications on Oracle Multitenant Self-Service Provisioning page. Notifications are displayed on the home page of this self-service application to communicate with users of this self-service system. Notifications are managed by application administrators but viewable by all users.
First, select "Administration", then select "Notifications".
Then, select "Add (more...)
On Oracle Multitenant Self-Service Provisioning page."Request an Account
", I thought that's very interesting for testing how it work.
Select "Request an Account
" and Fill in as below picture(Please fill in available email).Note: User are created by "Request an Account". They have Pluggable Database Administrator (more...)
It's too easy for dropping PDB on Oracle Multitenant Self-Service Provisioning. Just select "Drop", then select Datafiles - whether Including Datafiles (will remove datafiles)
or Keep Datafiles
Wow! ...Related Posts:Multitenant Self-Service Provisioning (BETA) - Database 12cMultitenant Self-Service Provisioning - Clone PDBMultitenant Self-Service Provisioning - Close/Open PDB (more...)
When use PDB, users want to plug & unplug PDB. I just wanted to unplug PDB on Oracle Multitenant Self-Service Provisioning. If PDB mode = OPEN, users must close PDB before.
After PDB mode = "Mounted", then started with "Unplug" again.Don't Forgot to remember - Unplug Path
Checked on (more...)
What? Fixed? Problem? Huh?
While going through and checking and updating my Oracle Performance Firefighting
course for Oracle Database 12c, I once again compared session level CPU consumption from v$session and v$sess_time_model. In the past v$sesstat server process CPU consumption could
be significantly less than what is shown in v$sess_time_model. Also, (more...)
The maximum size for VARCHAR2, NVARCHAR and RAW columns has been extended to 32767 bytes with the Oracle 12c Database. However, indexing such columns with standard indexes comes with some challenges. These extended data types are not enabled by default within the database but can easily be done so by (more...)
Thank you all who attended my sessions at NYOUG Fall Conference this morning. I appreciate spending you most precious commodity - your time
- with me. I sincerely hope you found both the presentations enlightening as well as entertaining.
Please see the details of the sessions below along with the (more...)
Preparing for OpenWorld, I’m updating all my demos to 12c. Unfortunately, my conclusion so far is that nothing works.
The BC tester (now renamed ADF Model Tester) crashes JDeveloper and doesn’t take bind variables. A simple ExecuteWithParams example ignores my parameter value. The list goes on…
Oracle tries to imply (more...)
I have finished now my work on integrating last PMD version 5.0.5 into JDeveloper.
This is available now for JDeveloper 184.108.40.206 upwards, 11.1.2.x. and 12.1.2. There is no new functionality, as the most work intensive part was the rewriting for (more...)
Working on the chapter that covers best ways of manipulating with object collection. Of course, if you talk about pagination of the rowset, it is very tempting to test Oracle 12c new feature - OFFSET…FETCH.
Unfortunately, immediately got an issue. It seems to me that passing a variable to FETCH (more...)
I Know That's Not A Fair Question
Is 12c faster than 11g? Yeah, I know that's not a fair question. But I do want to know if 12c can process 1000 buffer gets
faster than 11g... don't you?
I want to know how much CPU time is consumed when Oracle (more...)