Using the Secure External Password Store with Instant Client. There are several articles of how to use Secure External Password Store, e. Managing the Secure External Password Store for Password Credentials. However, the main utility. Is not a part of Instant Client package.

This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog. Wednesday, March 07, 2018. Fewer Platform Flags on Indexes from PeopleTools 8. I explained in a previous blog.

This is just a pointer post to a tool which I discovered today. It is ORATOP, to monitor databases real time like top of unix flavours. It is pretty much like MOATS.

Tuesday, November 28, 2017. Tuesday, November 28, 2017. Retrieve Oracle password from Toad for Oracle.

If you want to know what DDL optimisation is then you can read this article. I wrote a couple of years ago. So what the heck is this? After having ruled o.

I had a great time at DOAG 2016.

Just another blog on Oracle and possibly other geeky things. Check out my blogging friends. Create job control as part of the overall application.

Wednesday, April 09, 2014. Direct read decision statistcs driven, small table threshold and direct path reads on partitioned tables in 11. This is continuation of my last post. Regarding direct path reads on partitioned tables in Oracle 11. To recap, the behavior I observed is that direct path reads will be performed if number of blocks for all partitions that will be accessed exceeds small table threshold value. What is direct read decision statistics driven.

Avoid checking bind values in SQL. As SQL query developers, there should always be try to write and design simple sqls and not complex ones . Checking all the binds in the sql is way of writing generic code. Bind values which are passed in SQL are marked as bold.

Tuesday, July 14, 2015. Check out this post about inlining of code, inspired by me. Thursday, June 4, 2015. The difference mostly is in duration. I love what I do.