The PeopleSoft stuff is at blog. This is the non-PeopleSoft Oracle Blog. Monday, March 05, 2018. The changing literal values mean that every SQL statement has a different SQL ID. SQL Baselines are not viable here. No one plan produces optimal performance, so a traditional SQL profile proscribing a particular plan is not the answer. Oracle moves between three adaptive plans depending at least partially upon the number of rows in the elimination table. I found it was .

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.

Data, Databases, Cloud, Hadoop. The slides are in Slideshare.

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.

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.