OPatch requirement for October 2013:
- OPatch 22.214.171.124.1 for Database PSU 126.96.36.199.1
- OPatch 188.8.131.52.2 for GI PSU (more...)
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 184.108.40.206 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...)
Just wanna test about Oracle Multitenant Self-Service Provisioning again. In this post, I wanted to test closing/reopening PDB. Previous post, I tested cloning PDB and some PDB (TESTPDB01) status = "READ ONLY.
Selected "Close/Reopen". Found below picture
It shows... Users can reopen as "READ WRITE" or "Close PDB"... Tested with (more...)
Previous post, I wrote about Multitenant Self-Service Provisioning (BETA) - Database 12c
. It's very useful.for learning PDB. After installatuon by using pdbss_ins.sql
script, "APEX" pdb was created.
[oracle@test12c pdbss]$ grep "create pluggable database" *
pdbss_ins.sql: 'create pluggable database APEX admin user PDB_ADMIN identified by ' ||
Today, I found some tweet message from @joelkallman
After checking, Oracle Database 12c Multitenant Applications: Multitenant Self-Service Provisioning - BETA
. The Oracle Multitenant Self-Service Provisioning system provides an interface to Oracle Database12c Multitenant and allows for the self-service provisioning of Pluggable Databases (PDBs). It's useful to learn about PDBs, Really? (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...)
In our earlier post on adaptive joins we explained how this new 12c functionality works and said we would follow up this post with a real-world demo. Instead of outlining the demo as a blog post, with screen shots, we thought it might be better to deliver the demo (more...)
- I belief people know Oracle Database is RDBMS and latest version is 12c (Cloud). Some people are interested in it and some people have used/maintained it as Database Administrator or Developer. Oracle Database is top RDBMS and many companies use it. So, it's good idea to learn (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...)