view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

How to install and manage a Kerberos Server

For some time now, I have been working on how to set up a Single Sign-On (SSO) solution in my company. As a big fan of Open Source solutions, I have obviously proposed the implementation of a solution based on Kerberos. What I mean by that is a solution based on the true Kerberos, i. e. MIT Kerberos. Indeed, Kerberos was originally a research project at the Massachusetts Institute for Technology (MIT) in the early 1980s.

explain plans... when running in prod and dev why am I getting different results?

Hello...... I ran an explain plan on the same statement in both PROD and DEV here are the results… why are they different? Thank you in advance!

DEV:

EXPLAIN PLAN SET STATEMENT_ID = 'LRH' FOR SELECT A.EMPLID FROM PS_JOB A
WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOB B WHERE B.EMPLID = A.EMPLID)
AND A.EFFSEQ = (SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EFFDT = A.EFFDT);

1 select lpad(' ',2*LEVEL)||operation||' '||options||' '||object_name execution_path
2 from plan_table

Collaborate14 Session: The Art and Science of Tracing

Thank you all for coming to my session "The Art and Science of Tracing" at Collaborate 2014. As I mentioned, I prepared a full session even though this is supposed to be a quick tip. I hope you enjoyed it and get the value from the full presentation deck.

You can download

The slide deck
The scripts (this is a zip file. Right click and then Save As ...)

How to find out a table type in Hive Metastore.

Hi All

As Hive metastore is getting into the center of nervous system for the different type of  SQL engines like Shark and Impala. It getting equally difficult to distinguish type of table created in Hive metastore. Eg. if we create a impala table using impala shell you will see the same table on hive prompt and vice versa. See the below example

 

Step 1 : “Create Table” in Impala Shell and “Show Table” On HIVE Shell

IOUG Collaborate 2014 presentations are online!

This is a small announcement that the slides of all of my four presentations for IOUG Collaborate 2014 are online in the ‘whitepapers and presentations’ section of this blog.

New Oracle DBA online batch from 14th Apr

  Kanna Technologies Proudly announces next Online Oracle Dba batch. Below are the course details: Faculty: Vikas Demo: 11/4/2014 Start Date: 14/4/2014 Timings:8:00 to 9:30 Am IST Duration: 1:30 Hour Demo Link:https://global.gotomeeting.com/meeting/join/366262069 Registration Link: http://dbatalent.com/index.php/store/product/45-oracle-dba-11g-12c Coupon Code: DB@T@L3NT Note: Early Bird Registrations will get 10% Discount.

New Oracle RAC online batch from 14th Apr

Kanna Technologies Proudly announces next Online Rac DBA batch. Below are the course details: Faculty: Vishnu Pavan Demo: 11/04/0214 Start Date: 14/04/2014 Timings:07:00AM – 08:30AM IST Duration: 30 days Demo Link:https://global.gotomeeting.com/meeting/join/395232469 Registration Link: http://dbatalent.com/index.php/store/product/48-oracle-rac-11g-12c Coupon Code: DB@T@L3NT Note: Early Bird Registrations will get 10% Discount.

What Happens in Vegas, Doesn’t Stay in Vegas – Collaborate 14

IOUG’s Collaborate 14, is star-studded this year with the Pythian team illuminating various tracks in the presentation rooms. It’s acting like a magnet in the expo halls of The Venetian for data lovers. It’s a kind of rendezvous for those who love their data. So if you want your data to be loved, feel free to drop by at Pythian booth 1535.

SLOB Logical I/O testing: Check if your benchmark delivers the maximum

With this post, I would like to share one tip related to SLOB Logical I/O testing when you need to find out the maximum “Logical read (blocks) per second” your “benchmark” is capable of.
The tip is the rule number two, but let’s describe the well known rule number one first.

view counter