This is a short article on converting existing non-container (non-cdb) 12c database as pluggable database (pdb) to existing container database (cdb).
Version of Non-CDB database = 22.214.171.124
Version of CDB database = 126.96.36.199
Following steps will plug-in non-cdb database into cdb as pdb and also will upgrade the version to 188.8.131.52
My non-cdb database name is deo12c
My cdb database name is deocdb
Somebody wants to know how you can write a PL/SQL solution that mimics the fall through of a switch statement because PL/SQL doesn’t support a switch statement. It’s a question that I found interesting because there wasn’t a need for it when I figured out what he wanted to accomplish. Essentially, he wanted to know how to implement a nested loop where the first loop runs in ascending order and the nested loop runs in (more...)
Oracle has come up with new feature called multitenant database. Using this feature we can have many pluggable databases plugged into single container database.
This article explains pluggable databases architecture and how to create them.
I am not covering administration part. Viewers can check the documentation mentioned in reference section to check administrative part for managing pluggable databases.
One of the high-profile new features of Oracle 12c Enterprise Edition(EE) is the multitenant option (more...)
The V$ASM_DISKGROUP_STAT view provides 12c ASM DiskGroup Performance Statistics for current DiskGroups. The data is extracted from the X$KFGRP_STAT source table. This view like all other ASM views are available in both the ASM and the Database instance. The data for this view accessed from the ASM includes information for all databases connected to the […]
The post ASM DiskGroup Performance Statistics appeared first on VitalSoftTech.
I demonstrated a number of SQL approaches to reading object types in Appendix B of the Oracle Database 12c PL/SQL Programming book. For example, the easiest one to construct and return the results from a
TO_STRING member function uses the
SELECT TREAT(base_t() AS base_t).to_string() AS "Text"
However, it seems that I could have provided one more. Here’s an example of how you can (more...)
If you’re not using Toad DBA Suite, it’s sometimes hard to find solutions. Somebody wanted to know how to find indexes that aren’t that aren’t indirect. Indirect indexes are those created for a primary key because a primary key column or set of columns are both not null and uniquely constrained. You can’t drop a unique index for a primary key without dropping the primary key constraint that indirectly created it.
The following query (more...)
One of the most wonderful things of Oracle Open World are the Demo-Grounds. When you want to learn more about a certain feature, this is the place to go to. The actual developers and product managers are there to answer your questions and more!
In a previous blog I had written about Temporal Validity in Oracle 12c and whether it would be possible to have multiple validity periods on one table. You can read that (more...)
This is the first entry in a series of random articles about some useful internals-to-know of the awesome Oracle Database In-Memory column store. I intend to write about Oracle’s IM stuff that’s not already covered somewhere else and also about some general CPU topics (that are well covered elsewhere, but not always so well known in the Oracle DBA/developer world).
Before going into further details, you might want to review the Part 0 of this series and also our (more...)
During a trial run for my presentation at Oracle Open World "Oracle 12c for Developers", you can find the slides on slideshare. there was a question regarding "Temporal Validity".
What is Temporal Validity?
The documentation says it best:
Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the start and end dates or time stamps of (more...)
Despite the title, this is actually a technical post about Oracle, disk I/O and Exadata & Oracle In-Memory Database Option performance. Read on :)
If a car dealer tells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically different from all the old ones. You don’t just get orders of magnitude (more...)
Oracle Database is one of the leading relational database management system and is used all over the world. It has various training’s, exams and certifications for its Database and other products. However due to regular update in Database, they have to redesign their trainings, certification and exams to add new features and to remove old […]
The post Oracle Database 10g Certifications to Expire in March 01, 2015 appeared first on VitalSoftTech.
Oracle OpenWorld is an annual conference organized by Oracle, which provides Oracle users and technologists a unique opportunity to learn and socialize. Oracle OpenWorld 2014 is scheduled to take place from September 28 – October 2, 2014 in San Francisco. The conference is designed to provide Oracle users a platform to find best suited Oracle […]
The post A Preview of Oracle OpenWorld 2014 appeared first on VitalSoftTech.
The EOUC (EMEA Oracle User Group Community) hosts a special session on sunday during Oracle Open World. This session contains twelve things about Oracle 12c. Each of these 12 things is hosted by a different speaker, so this means that each section is only five minutes long (Strictly guarded by Debra Lilley).
Thankfully I was chosen to be one of the speaker during this special session, very excited and also very scared. (more...)
Hi there, Last week, I spoke at AIOUG Tech Day at Hyderabad. All India Oracle Users Group (AIOUG) in association with TechMahindra organized one full day of techtalk event. Believe me, the Danube auditorium was a state-of-art facility with 500 capacity. Fabulous venue and huge crowd with similar interest. I thought of sharing my experience … Continue reading
While preparing for my session at Oracle Open World on "Oracle 12c for Developers" I ran into a little remarkable thing.
When sorting a dataset, the sorting is always done last. That is what I was taught anyway. There is probably some obscure way to detect the exact execution plan, but personally I never bothered to go and investigate.
When I was created some test scripts I found there was a way to see that (more...)
With Oracle 184.108.40.206, the largest performance enhancing features, the Oracle 12c In-memory database option, has been released. Learn more about how to enable it, the licensing costs, etc. Also read other about Oracle 12c In-Memory Database FAQ's here ...
The post Increase DSS Performance by 100x and OLTP by 2x. Learn more about Oracle 12c In-Memory Database. appeared first on VitalSoftTech.
Oracle 220.127.116.11 Patch 17694377 for Linux and Solaris has been released on Metalink and edelivery a few minutes ago. Happy upgrading!
The post Oracle Database 12c Release 1 [18.104.22.168] Patch Released appeared first on VitalSoftTech.
The long awaited Oracle Database Server 22.214.171.124.0 is available under Oracle Software Delivery Website https://edelivery.oracle.com
Currently the 126.96.36.199.0 is available for:
- Linux 64bit
- Solaris SPARC
- Solaris Intel 64bit
Happy download :-)
Hi Guys, As you all might have noticed from my social moves, we were running Multitenant Validation lab for ISV partners. Briefing on the program, the 2-day guided lab will enable the partners to test and validate their products/applications on Oracle 12c Multitenant architecture. Partners would be able to visualize and get hands-on with Multitenant … Continue reading