Thursday, July 2, 2015

An explanation of what killing a process really does

Tonight I want to introduce My Oracle Support article "Kill A Process - Not able to clear session" via note ID 1493261.1 which will give you the commands to kill the process, and terminate it, but what happens when that still does not disconnect the session?  The article has a fairly detailed explanation of what the interaction between the DB and target session is, which may surprise you as there are steps where commands are not given and instead are interpreted as asking!!

Wednesday, July 1, 2015

JDBC query with bind variables can have performance issue

It seems like I am on a performance kick after finding this note on My Oracle Support "Poor Performance With Query Called From JDBC Using Bind Variables Compared To A DATE Column" from document ID 1557194.1 which teaches us about the reasons a JDBC query might not use the best access path/plan based on what kind of DATE or TIMESTAMP variables you use.

Tuesday, June 30, 2015

Missing Indexes on Foreign Keys?

In the interest of better performance, you may want to check out My Oracle Support article "Script to check for Missing Indexes for Foreign Keys" from document ID 16428.1 and then run the attached script looking for ways to possibly improve your system performance!

Monday, June 29, 2015

Hyperion Planning: Managed Server produces core dump after crash

Tonight check out document "Planning Managed Server Crashes and Creates Core Dump." from My Oracle Support document ID 2002962.1 to see what parameter you need to change in which .sh file in order to have this stop happening!

Sunday, June 28, 2015

Weekend Learning: Performance tuning PeopleSoft on Microsoft SQL Server

The article "Performance Tuning Advice For Microsoft SQL Server" on My Oracle Support found via note ID 2020083.1 does not say that it helps with PeopleSoft installations, but it links to several MSSQL documents including one specifically for PeopleSoft applications on MSSQL!

Saturday, June 27, 2015

Weekend Learning: Optimizer Filter Push Down

Are you trying to learn more about the Optimizer and how it can make decisions for predicates?  Then you may want to check out this document on My Oracle Support "Optimizer Filter Push Down" via article ID 1082122.1 to learn a bit more for your toolbox!

Thursday, June 25, 2015

Exadata: Fixes needed for ASM File System due to data corruption

Fresh off the presses, and on the heels of my post about ASM allowing disks of 2TB, is article "Important Fixes required to implement Oracle Automatic Storage Management File System (ACFS) on Oracle Exadata Database Machine" found on My Oracle Support via document ID 2022172.1 which explains there are multiple concerns of data corruption in ASM including one affecting disks which are larger than 2TB!

Wednesday, June 24, 2015

Leap seconds and Fusion Middleware

Since I have talked about the leap second in conjunction with Exadata and Linux OS, as well as Exalytics, I think the My Oracle Support document "Leap Second Vulnerability on Fusion Middleware Products" from article ID 2024181.1 is a great resource even if not on Fusion yet because of all the links it has about the issue!  While Fusion Middleware does not appear to be affect by this, the document DOES admit that there are certain reasons why you would need to address this issue with some of those relating to the precision required and if your application needs it as well.

Tuesday, June 23, 2015

Payables: Can you reimport an expense report?

I have never really seen a question like this before, but "Is it Possible To Reinstate an Expense Report That Has Already Been Imported Into Payables and Deleted As An Invoice?" on My Oracle Support from article ID 2023674.1 has several other notes available related to information on this subject AND it has details about the application which you may not have already known!

Monday, June 22, 2015

Exadata: DB/ASM I/O request hangs if one cell has a problem

Very similar to my post on LCK0 hanging, there is a specific slant to the My Oracle Support document "Exadata Database Or ASM Instance Hung On IO Request When Single Cell Is Having Problem" via note ID 2002084.1 is worth checking out because there are some log entries we can look for to alert us about the next time we have this problem PLUS there is the bug that we can patch our system with too to prevent it!

Sunday, June 21, 2015

The blog turns THREE!!

Last year I marveled at how I hit 20,000 views to the blog, but this year I am blown away by the fact that in just a year I have tripled that figure and will be hitting SIXTY thousand views in just a few days!

I have been lucky enough to cross off a few goals by presenting at additional conferences like RMOUG's Training Days and OAUG's COLLABORATE while this year I am excited to set goals for presenting at Oracle OpenWorld and becoming a member of the Oracle ACE community.  Over the past few months I have been working on several different projects at work that I am looking forward to sharing with all of you this year, but I also just received some news this week which excites me great a deal and I just CANNOT wait to share it with you soon!

I also have noticed how much I am depending on My Oracle Support the last few months, but I have also noticed that there is seldom an absence of good material on that site that successful Support individuals need to keep up with changes or bugs in Oracle hardware or software.  I will try to tap into some of my other sources for content, but right now I do not have a whole lot of extra time dedicated for the blog, so it will take some extra effort on my part.....but that is something I am not beyond doing and will look to do over the next few months!  I hope you are enjoying my blog posts, and welcome any kind of comments you have to share which will help me give you more content that you are looking for!!

Saturday, June 20, 2015

Weekend Learning: PeopleTools performance guidelines

If you have PeopleSoft and PeopleTools in your environment, then you should check out this 67 page "PeopleTools Performance Guidelines Red Paper" found on My Oracle Support from document ID 747389.1 in order to enhance your knowledge this weekend!

Friday, June 19, 2015

Global enqueue process LCK0 hangs causing ORA-29770 error and instance crash

Learn more about Oracle DB internals from MOS document "ORA-29770: Global Enqueue Process LCK0 .. Is Hung For More Than 70 Seconds" in note ID 2020465.1 so you can understand how PMON holds up other processes and what kind of wait events or DB log events that you need to be on the lookout for before your instance crashes!

Thursday, June 18, 2015

R12: Expense report with 25 lines produces error

Make sure you look at MOS article "Submitting 25 Line Expense Report Causes "Internal Server Error"" to see if you are encountering the issue described in note ID 1475137.1 and to get this added to your testing suites for future patches and upgrades!

Wednesday, June 17, 2015

R12 Payables: Positive Pay File does not show voids on output file

My Oracle Support document "R12: Positive Pay File is Not Showing Voids in the Output" by way of note ID 1396297.1 tells us that it is possible for the output file to show the wrong information because of incorrect coding within a template and since we know this can be wrong you need to be on the lookout for this in your testing suites now too!