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 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
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
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
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.
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.
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.
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.