Oracle Database 12c introduces a
SEARCH_CONDITION_VC column to the
USER_CONSTRAINTS views. The
SEARCH_CONDITION_VC column is a
VARCHAR2 data type equivalent to the search condition in the
LONG data type
SEARCH_CONDITION column. Unfortunately, Oracle Database 11g and earlier versions requires you to convert the
LONG data type to a
VARCHAR2 for the equivalent behavior. This post provides you with a function to help you do that in (more...)
Oracle Database 12c introduces a
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).
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.
When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN. Without knowing the password for SYSMAN, how can I access the EM 12c interface? The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Before changing the SYSMAN password (more...)
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 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...)
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 220.127.116.11, 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 18.104.22.168 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 [22.214.171.124] Patch Released appeared first on VitalSoftTech.
Replicating data can be a time consuming process to setup. Fortunately, Oracle GoldenGate provide a few tools to help ease the complexity of setup. One of these tools is the “macro”. Macros are used to simplify and automate the work associated with setting up and replicating data. So what exactly is a macro? Oracle defines a macro as:
A macro is a built-in automation tool that enables you to call a stored set of processing (more...)
Currently the 126.96.36.199.0 is available for:
- Linux 64bit
- Solaris SPARC
- Solaris Intel 64bit
Happy download :-)
The JOB record is a the heart of HCM. It is both effective-dated and effective sequenced. I will use it (more...)
Enkitec folks have been beta testing the Oracle Database 12c In-Memory Option over the past months and recently the Oracle guys interviewed Kerry Osborne, Cary Millsap and me to get our opinions. In short, this thing rocks!
We can’t talk much about the technical details before Oracle 188.8.131.52 is officially out in July, but here’s the recorded interview that got published at Oracle website as part of the In-Memory launch today:
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c. Related Articles • Oracle 12c: Data Redaction Unified Auditing Extended SHA-2 […]
Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox
If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.