The 10 days of Blogging past - 2015 Edition: Day 10

On the final day of our feature the article with the most views all time here is R12: Application server craziness with 1719 page views and a closing ratio of 1:3.15!  Close on the heels of the overall winner this year is Leap seconds, Exadata, Oracle DB and Linux OS we featured yesterday as the second overall post with 1484 views and is clearly the winner this year with over a THOUSAND more views than the post before it!

The major thing I have taken away from this review is something that Jeff Smith brought up a few days ago on a LinkedIn post and he mentioned the notion of evergreen posts that retain their value for a great deal of time after they were posted.  Of the 10 overall posts I reviewed, 6 were about R12, 2 about Concurrent Manager, the other 2 were about DB issues, and only a single post was from this year!  Also from an overall total views perspective, last year I had just passed 40,000 and just a few days ago I passed 80,000 so still growing and more room to grow as well!

Overall view "winners" from past years on this day:

• R12 Payables: Invoice Workbench error APP-SQLAP-10108 when committing
• Database FLASH exhaustion

The 10 days of Blogging past - 2015 Edition: Day 9

We are almost done with our "The 10 days of Blogging past" for this year!  What an amazing journey huh?  Well tonight, we get to the post Leap seconds, Exadata, Oracle DB and Linux OS with an astonishing 1484 views over the past 9 months to take the runner-up spot in our overall view count contest!  If you are interested in the ratios, we are almost exactly 1:3 compared to last year so you can see the growth at the top end of the more popular articles on the site year over year.

Talking about just this year, the post 12c: High memory and CPU usage with ocssd.bin takes the runner-up spot with 415 views and I know a few views were actually one of my co-workers trying to investigate an issue they were having on a non-AIX system, and asked me for some insight on their issue since this was posted on my blog!  That was a nice little thrill, because I actually had somebody search for an issue and find my information as a top relevant hit on Google and I saw it right there on their screen!

Overall view "winners" from past years on this day:

• What happens when your Concurrent Manager goes crazy?
• Concurrent:Active Request Limit (or how I finally learned to know what my system was saying)

The 10 days of Blogging past - 2015 Edition: Day 8

Tonight we start to kick the blog into high gear as the post R12 Payables: Invoice Workbench error APP-SQLAP-10108 when committing has received 1384 hits which compared to last year at this time is a ratio of 1:3.1 that clearly surpasses the 1:2 ratio we've been hovering around for most of the overall posts this year!  While we look at the posts from just this year the post Global enqueue process LCK0 hangs causing ORA-29770 error and instance crash had 280 hits which is quite low compared to the post on this day last year as our ratio looks like 1:.77 while 1:1 is what we had been averaging until the last few days BUT last year that post had been up for 10 months while this post had been up for less than 6 months!

Overall view "winners" from past years on this day:

• Disconnected Concurrent Manager
• duration not active: A Tale of Two Articles

The 10 days of Blogging past - 2015 Edition: Day 7

Tonight we see our 1:2 ratio compared to last year's overall post dip just a bit to 1:1.95 with the article Disconnected Concurrent Manager getting up to 851 hits and looking at just posts from this year R12: NACHA format problem drops leading zero comes in 7th today with just 273 views which is slightly lower than what we had in the yearly post for 2014!

Overall view "winners" from past years on this day:

• R12: Hiding the DQM Serial Sync Index Program
• Learning more about DBA_ALERT_HISTORY

The 10 days of Blogging past - 2015 Edition: Day 6

The post What happens when your Concurrent Manager goes crazy? with 837 overall views sees our year-to-year ratio drop down just a bit to 1:2.1 from the 1:2.3 we saw yesterday and the yearly post Weekend Learning: ExaWatcher utility for Exadata received only 254 views which is a few views less than a 1:1 ratio compared to last year on this day in review!

Overall view "winners" from past years on this day:

• R12: Application server craziness
• Concurrent Manager holding lock on a report

The 10 days of Blogging past - 2015 Edition: Day 5

With tonight's overall post winner R12: Hiding the DQM Serial Sync Index Program having 828 views I am starting to see a upward trend compared to the overall numbers from last year as we are now with a 1:2.3 ratio instead of 1:2 like the past few days, so it will be interesting to see if that ratio keeps going up!  For the yearly post winner, Exadata 12.1.2.1.1 has been released! I still see a 1:1 ratio compared to last year with 220 views this year and we will see if that continues for the rest of the year!

Overall view "winners" from past years on this day:

• ASM Alert: RAC ASM disk offline after rebalance
• Supplier issue in Expense Report Import

EDIT 12/27:  Minor formatting update.

The 10 days of Blogging past - 2015 Edition: Day 4

I hope you all got the presents you were looking for today on Christmas!!  Tonight, I'll make it short and sweet with the articles R12: Problem with Expense Report Export Program and Weekend Learning: EBS R12.2.4 and OAF applications posts with 786 overall views and 213 views this year!

Overall view "winners" from past years on this day:

• Database FLASH exhaustion
• Your Oracle DB not playing nice with Hyperion products

The 10 days of Blogging past - 2015 Edition: Day 3

Continuing the year end review, the post with 696 overall views so far is R12: Credit Card Information and looking at just the past year we have the article ZFS Storage Appliance and Solaris can see write performance degradation when filesystem is almost full having been viewed 179 times this year where we see the same trends mentioned yesterday with the overall increasing twofold while the yearly count is trending slightly lower than last year

Overall view "winners" from past years on this day:

• R12: Bouncing Workflow agent process
• System Wait Events Part 2

The 10 days of Blogging past - 2015 Edition: Day 2

Visting our overall statistics tonight we have the post Why the wait event "SQL*Net message from dblink" can suddenly increase for no reason with 623 views and if we were just looking at this year the post of the day would be Exadata: ExaWatcher archives new files instead of old files having just 166 views!  What kind of lesson am I taking away from this?  On this day last year I had half as many hits for the overall, but the yearly hits actually went down just a tad, so there are multiple trends here which will be interesting to see how they hold up as we go through the next few days!

Overall view "winners" from past years on this day:

• R12: Problem with Expense Report Export Program
• Disconnected Concurrent Manager

The 10 days of Blogging past - 2015 Edition: Day 1

Coming back from a small hiatus, I return to a classic feature here at the blog with "The 10 days of Blogging past" and on our first night is the post R12: Bouncing Workflow agent process with 591 views which has actually been slipping down in the rankings as it was on the 5th night in 2013, 3rd night in 2014, and now the very 1st night this year!  What if we just looked at posts from this year you ask?  Well, the article Oracle Linux: No buffer space available would be the post tonight with just 141 views so far this year!

Overall view "winners" from past years on this day:

• Concurrent:Active Request Limit (or how I finally learned to know what my system was saying)
• R12: Credit Card Information

The 10 days of Blogging past - 2014 Edition: Day 10

As I conclude "The 10 days of Blogging past" feature today with the article "R12 Payables: Invoice Workbench error APP-SQLAP-10108 when committing" that was posted just 9 short months ago but already has rocketed up to the top spot with 545 views!  It goes without saying that this post was the top for the year of 2014 as well too!  What did we cover last year on this day?  It was "Database FLASH exhaustion" that had an amazing (at that time) 170 views and it is very interesting that the past few days we have seen a drop off from the 5:1 ratio to this being just above a 3:1 ratio comparing last year with this year.

What will next year look like during our end of year review?  I do not rightly know, but it is awesome to see that 5:1 ratio discussed over the last few days reflected in the overall stats for the blog as I ended 2013 just under 8,000 views and 2014 sees the pageviews up over 40,000!

The 10 days of Blogging past - 2014 Edition: Day 9

Getting almost completed with "The 10 days of Blogging past" today we review the post "What happens when your Concurrent Manager goes crazy?" which has been online for only 15 months but has gathered a massive 496 views.  This shows me that even established technology like the Concurrent Manager can experience changes and the amount of details included in the post help to piece together some things that could be classified as mysteries if the post was not around to be searched on.  Contrasting the article that was covered on Day 9 last year, "Concurrent:Active Request Limit (or how I finally learned to know what my system was saying)" that was around about 16 months and had 126 views which only reaches a 4:1 ratio comparing that last 2 years.  Again, if we just think about what would have been in my top 10 for just posts from 2014 we would have "R12: Hiding the DQM Serial Sync Index Program" listed instead with 436 views and I am sure you noticed this was the post spotlighted on Day 7 of "The 10 days of Blogging past"!

The 10 days of Blogging past - 2014 Edition: Day 8

The post "Disconnected Concurrent Manager" with 446 views may look familiar if you have been reading the last few days during "The 10 days of Blogging past" as it was featured on Day 2 from being 8th overall last year.  I would say it is obvious from the popularity of this post that other people and companies have network outages or other issues that wreck havoc with their EBS application from time to time.  Last year we had the post "duration not active: A Tale of Two Articles" with 91 views and while a bit under, it is very close to the magic 5:1 post ratio!  Speaking of flashbacks during "The 10 days of Blogging past", I covered "ASM Alert: RAC ASM disk offline after rebalance" on Day 5 this year since it was 6th overall blog posts but would have been 3rd overall for 2014 blog posts.

The 10 days of Blogging past - 2014 Edition: Day 7

Continuing "The 10 days of Blogging past" we find article "R12: Hiding the DQM Serial Sync Index Program" on Day 7 with 436 page hits which meets our 5:1 ratio between the article covered last year on this day "Learning more about DBA_ALERT_HISTORY" that had 86 views.  This year's article is yet another instance of an unintended "feature" of R12 which likely has caught a lot of other Support individuals off guard so it is quite exciting to be leading the charge to shine light on these dark corners of the application!

How does this compare to last year?  Well the post "R12: Problem with Expense Report Export Program" would have the 4th highest hits of 2014 with 311 views and if it seems familiar to you that could be it was listed on Day 2 of the "The 10 days of Blogging past" feature just a few days ago!

The 10 days of Blogging past - 2014 Edition: Day 6

On the other side of halfway for "The 10 days of Blogging past" we visit the post "R12: Application server craziness" which continues the trend we have been seeing with R12 ruling the top 10 lists this year and last.  While it was not the first issue I found with R12, it was the first problem I had with R12 in our PROD environment, and from the 404 views it has received since I am guessing other people have had a problem with this in their implementations as well!  As stated, R12 rules around the blog lately and it continues with "EBS R12.2.4 Release Notes" that would have been in this spot with 269 views if we were focusing on just 2014 posts.  Compared to last year's post the article "Concurrent Manager holding lock on a report" held down the spot on Day 6 with 82 views which is almost dead on the mark for the 5:1 ratio that I have been mentioning all during this feature comparing the last 2 years.

The 10 days of Blogging past - 2014 Edition: Day 5

Tonight we continue "The 10 days of Blogging past" after yesterday's Christmas article with "ASM Alert: RAC ASM disk offline after rebalance" with 363 page views!  This was one of those articles where I was able to find references on My Oracle Support which corresponded to something that had just happened at work so not only did it make more sense to me about that incident, but what I found could help us (and everybody else) avoid future issues!

If we counted just the posts from this year, we would have "R12: FND_LOG_MESSAGES" in our countdown today with only 218 views.  I thought it was pretty interesting that this post did not get more hits, because it seems like EVERY implementation of R12 is going to have this bloat and later on in the year I found more reason that this table needs a lot of attention!  While on the list last year in this spot we had "Supplier issue in Expense Report Import" with 81 views and while you can see there is a drop off from the 5:1 ratio, it is still up there around that range.

The 10 days of Blogging past - 2014 Edition: Day 4

In today's Christmas edition of "The 10 days of Blogging past", we cover the article "Database FLASH exhaustion" with 359 hits!  This compares to last year when it was the TOP article for the blog last year with 170 views but again if we were just comparing this year it would be the post "Hotsos Symposium 2014 - Day 1" that would take this spot on our list with 205 views!  This is awesome because it is another example of how much presenting at conferences can enhance your "brand value" or just general recognition in the blogging ecosystem and I know that I have been getting more views as a result of each opportunity I get to present!

Last year in this spot we had "Your Oracle DB not playing nice with Hyperion products" from mid 2013 with only 72 views and again we see an almost 5:1 ratio between the entries on this list from last year and this year.

The 10 days of Blogging past - 2014 Edition: Day 3

As we continue on our feature "The 10 days of Blogging past" day 3 brings us the post "R12: Bouncing Workflow agent process" with 358 since it was posted in 2013.  This was not on the top 10 list last year, but it skyrocketed up the charts because I think this showcased a clear change in Support operations from the previous EBS version to R12 so a lot of other people were probably blindsided by this too.  This also continues a theme I posted about yesterday where changes in R12 are driving a lot of traffic to the blog as the 3rd entry in our list last year was "System Wait Events Part 2" with just 71 views.

If we count just this year, we continue the same trend of R12 ruling all as the entry "R12: Changes in GL_DAILY_RATES table" was a very simple update but it would have been listed today on the top 10 list of 2014 as it has received 201 hits since May!  This is an average of around 30 hits a month which you can see is roughly 1 hit per day since it was posted.  I have already learned that R12 seems to be very popular around here, but this also shows me that even the smallest changes can have a ripple effect out there in the community since there could be a lot of reasons this is impacting people and information is really important to spread out into the ecosystem!

The 10 days of Blogging past - 2014 Edition: Day 2

Continuing the 2014 edition of "The 10 days of Blogging past" we have today the blog post "R12: Problem with Expense Report Export Program" having 316 views already this year with it being put online February 2014!  What did I take away from this post, and the success of it?  There are a lot of R12 features (or bugs) which have not been shaken out of our system, and that a lot of other people are interested in!  Why so much interest?  Are people searching for potential problems ahead of implementation, are they encountering the bugs live like we are here, or is there a combination of both?  Just as with some of the new things I find with recent upgrades like NFS, Exadata, or 11.2.0.3, R12 is no different with the larger community pooling our resources and always searching out other solutions or problems that have been identified. 

Last year on the top 10, we had the post "Disconnected Concurrent Manager" with just 61 views so you can see a continued trend of more traffic to the blog this year but if we were measuring just 2014 posts then the article "Purge Inactive Sessions and HWM expectations" would be on our second day with 199 views.  This post was the result of some investigation on my part in QA about what I wanted to do in PROD, related to what my expectations were regarding how I thought purging data out and the HWM (High Water Mark) would be interacting.  It was really interesting because things did not happen the way I expected them to so I had a lot to say in the post as I learned quite a bit and obviously I think others are dealing with high volumes related to inactive sessions too!

The 10 days of Blogging past - 2014 Edition: Day 1

This year I am going to dust off my top 10 posts review feature "The 10 days of Blogging past", and 289 views gets the article "Concurrent:Active Request Limit (or how I finally learned to know what my system was saying)" as the first post, which is LAST place, on the top 10 list for 2014!  How does this compare to last year?  Well last year the top post of the year had only 170 views with this post being number 7 on the top 10 with just 126 views!  This post was a good learning lesson to start writing down even "simple" things I was running into on a daily basis, which also led me to stop taking things for granted and start researching these types of items.

What was the last post on the top 10 list last year?  I am glad you asked!  It was "Purging concurrent and Fixed Assets" and had only 60 views, so you can see how far the blog has come if there is an almost 5 time increase in page hits for #10 on the list last year compared to this year.

Speaking of this year, what was #10 on the list if I just had counted posts done this year?  The article "Selecting from too many tables hits Oracle DB bug on 11.2.0.3" would have taken the cake with 176 hits this year!  What is my take away from this article being on the pseudo top 10?  The famous ORA-600 error message either attracted a lot of attention, a lot of other people had the same idea I had to select from too many tables, or maybe people are upgrading to 11.2.03 and looking for future bugs.