Usually I give you homework for the weekend, but this time I'm giving you a boat load of articles from Atul Kumar of onlineappsdba.com to go through during the upcoming week so you can digest them some!
Here he shares some issues encountered while using the OEM in 12c to manage Oracle HTTP Server, which includes links to several other articles on how to configure the monitoring of Oracle Fusion Middleware with OEM like this one about some lessons learned.
Another plug (yes, pun intended) for reading Oracle's whitepaper on Oracle Multitenant.
A good listing of the changes and new features for WebLogic with 12c.
Finally, Atul shows you how to monitor the Oracle Identity Connector Server with OEM in 12c which isn't exactly something we use or would be relevant except for the fact that he shows some very generic information that you can use to monitor other services as well.
Sunday, September 15, 2013
Saturday, September 14, 2013
12c September - Kyte, Osborne & Poder
Sounds like a law firm right? No, it's just three of the smartest individuals around if you have Oracle issues (one of which will be featured soon) so it makes sense I'd put together their posts today on 12c features.
I'm going to start with Tom Kyte sharing the CBAC (CODE Based Access Control) feature introduced with 12c which pretty much just blew my mind. I loved the conversation that took place in the comments too!
Yesterday I did share what Tim Hall talked about, but Tom goes over the Implicit Results sets with some additional insights into why it was implemented as well as showing examples too.
Do you know what new bells and whistles that have been added in 12c? Tom does, and now so can you. Oh and you might learn something about invisible columns as well!
Another one of the game changer type of features being introduced with 12 is the concept of white listing your code. You seriously need to see what Tom shares about this!
Here we are introduced to a new bug with using SQL Translation Framework by Kerry Osborne, and to the actual SQL Translation Framework feature itself which appears to have been created to allow us to address performance issues without changing the code!
Then Kerry helps us understand how to control the dial for automatic degree of parallelism.
Last, but not least, is Tanel Poder showing us how the CBO in 12c transforms scalar subqueries that are being used in the SELECT statement.
I'm going to start with Tom Kyte sharing the CBAC (CODE Based Access Control) feature introduced with 12c which pretty much just blew my mind. I loved the conversation that took place in the comments too!
Yesterday I did share what Tim Hall talked about, but Tom goes over the Implicit Results sets with some additional insights into why it was implemented as well as showing examples too.
Do you know what new bells and whistles that have been added in 12c? Tom does, and now so can you. Oh and you might learn something about invisible columns as well!
Another one of the game changer type of features being introduced with 12 is the concept of white listing your code. You seriously need to see what Tom shares about this!
Here we are introduced to a new bug with using SQL Translation Framework by Kerry Osborne, and to the actual SQL Translation Framework feature itself which appears to have been created to allow us to address performance issues without changing the code!
Then Kerry helps us understand how to control the dial for automatic degree of parallelism.
Last, but not least, is Tanel Poder showing us how the CBO in 12c transforms scalar subqueries that are being used in the SELECT statement.
Friday, September 13, 2013
12c September - Tim Hall
When he's not traipsing around Latin America, Tim Hall has had some really great 12c related posts on his blog recently.
He has created some articles on Implicit Statement Results and Extended Data Types with 12c, even if he wasn't excited about them at all!
Then he goes over Identity Columns and DEFAULT Values in his post here, and also has to update an old post on AutoNumber too.
Even more new features are covered in several articles on row limiting for Top-N queries and Multithreaded Model using THREADED_EXECUTION which also required him to re-write other articles as well. You really need to read some of the articles on this page about killing sessions/threads if you are going to 12c, as I've learned some new tricks for our environment and some are absolute killers (pun intended) for 12c!
Tim even helps us understand the WITH clause and how it has been enhanced with 12c, so if you are excited about that then finding out what the new tricks the DBFS is up to in 12c will probably knock your socks off!
Other than some good links to certification for 12c, this post outlines some "issues" he has found with the upcoming exams as well as a good general article about Oracle certification.
He has created some articles on Implicit Statement Results and Extended Data Types with 12c, even if he wasn't excited about them at all!
Then he goes over Identity Columns and DEFAULT Values in his post here, and also has to update an old post on AutoNumber too.
Even more new features are covered in several articles on row limiting for Top-N queries and Multithreaded Model using THREADED_EXECUTION which also required him to re-write other articles as well. You really need to read some of the articles on this page about killing sessions/threads if you are going to 12c, as I've learned some new tricks for our environment and some are absolute killers (pun intended) for 12c!
Tim even helps us understand the WITH clause and how it has been enhanced with 12c, so if you are excited about that then finding out what the new tricks the DBFS is up to in 12c will probably knock your socks off!
Other than some good links to certification for 12c, this post outlines some "issues" he has found with the upcoming exams as well as a good general article about Oracle certification.
Thursday, September 12, 2013
Thursday Twitter!
Interrupting our 12c weeklong coverage, I introduce a new feature where I share 5 tweets that I've favorited:
https://twitter.com/oakies_blog/status/376434736019038208 - Karen Morton will have a new webinar on the 17th!
https://twitter.com/thatjeffsmith/status/376695554723438592 - Jeff Smith (yes, THAT Jeff Smith) shares how to organize connections into folders for SQL Developer.
https://twitter.com/martindba/status/375915850198298625 - Martin Bach helps show us some scripts from Enkitec.
https://twitter.com/dbakevlar/status/374971089530523648 - Kellyn Pot'Vin reminds us to think about how our SQL profiles on a regular basis, and makes me think about how to alert based on it.
https://twitter.com/oraclepdb/status/375693383399776256 - Tom Kyte in a video talking about Oracle Multitenant.
Wednesday, September 11, 2013
12c September - Jonathan Lewis
Jonathan Lewis deserves his own week-long blog spotlight, but until I do that, he gets a mini-spotlight today on several 12c related articles he's written lately!
Here he investigates the differences between 11g and 12c where a new type called "Top-N" is being introduced, in part two he compares simple frequency histograms and Top-N histograms (and goes quite a bit above my head), then he compares some previous histogram issues to explore if they have been resolved with 12c.
In 12c there are several changes to subquery factoring that he shares, and also details the changes to join views too!
While even though the title says "Manuals", this article has some interesting discussion in the comments about what the true maximum services per instance are versus what Oracle has documented.
Here he investigates the differences between 11g and 12c where a new type called "Top-N" is being introduced, in part two he compares simple frequency histograms and Top-N histograms (and goes quite a bit above my head), then he compares some previous histogram issues to explore if they have been resolved with 12c.
In 12c there are several changes to subquery factoring that he shares, and also details the changes to join views too!
While even though the title says "Manuals", this article has some interesting discussion in the comments about what the true maximum services per instance are versus what Oracle has documented.
Tuesday, September 10, 2013
12c September - Features
Yesterday I promised a week of 12c content, and today is a focus on new features of 12c!
SQL for Pattern Matching is an extension of the SELECT command using MATCH_RECOGNIZE which allows you to look for patterns across your results.
A whole slew of data mining functions are being introduced or updated with 12c!
The parameter RedoRoutes has been introduced for Data Guard in 12c, among other additional enhancements, with a great example that was found via the Log Buffer.
Charles Hooper lets us know that deadlock changes are ahead in 12c with an interesting walkthrough.
Did you know that network recovery with RMAN is now possible with 12c?
Some resources to make your installation of 12c on Oracle Linux easier.
The Flashback feature in 12c is now available for all versions of the database and gets more enhancements as well via ArchBeat!
The tables DBA_USERS and DBA_ROLES have the new field ORACLE_MAINTAINED added in 12c, found via Log Buffer.
SQL for Pattern Matching is an extension of the SELECT command using MATCH_RECOGNIZE which allows you to look for patterns across your results.
A whole slew of data mining functions are being introduced or updated with 12c!
The parameter RedoRoutes has been introduced for Data Guard in 12c, among other additional enhancements, with a great example that was found via the Log Buffer.
Charles Hooper lets us know that deadlock changes are ahead in 12c with an interesting walkthrough.
Did you know that network recovery with RMAN is now possible with 12c?
Some resources to make your installation of 12c on Oracle Linux easier.
The Flashback feature in 12c is now available for all versions of the database and gets more enhancements as well via ArchBeat!
The tables DBA_USERS and DBA_ROLES have the new field ORACLE_MAINTAINED added in 12c, found via Log Buffer.
Monday, September 9, 2013
12c September catch up
Last week I promised some content on 12c, but over the few months I had gathered SO much information that it deserves it's own week with over 50 different articles reviewed and linked for you! Today I start with content about the announcement, or other general "new" type of information which didn't fall under any other categories I put the posts in for this week.
Why should you be running 12c on Oracle Solaris? Find out with an article that has several links to whitepapers, videos and deep dives!
Maria Colgan, via her Oracle Optimizer blog, announces new details that 12c brings to the Optimizer.
Ric Van Dyke helps announce the new version of the database too!
The full press release is linked here.
A glowing report on 12c from Ovum, which Oracle has hosted for us.
Tanel Poder helps to announce 12c as well, his article with a link to the documentation in case you haven't found it yet.
Pythian's Rene Antunez shares their first five minutes with 12c, which is from a DBA perspective about some of the new features/terminology.
Since 12c was available for Windows, Tim Hall decided to install it on Windows Blue 8.1!
Why should you be running 12c on Oracle Solaris? Find out with an article that has several links to whitepapers, videos and deep dives!
Maria Colgan, via her Oracle Optimizer blog, announces new details that 12c brings to the Optimizer.
Ric Van Dyke helps announce the new version of the database too!
The full press release is linked here.
A glowing report on 12c from Ovum, which Oracle has hosted for us.
Tanel Poder helps to announce 12c as well, his article with a link to the documentation in case you haven't found it yet.
Pythian's Rene Antunez shares their first five minutes with 12c, which is from a DBA perspective about some of the new features/terminology.
Since 12c was available for Windows, Tim Hall decided to install it on Windows Blue 8.1!
Sunday, September 8, 2013
Exadata IORM analysis
Carlos Sierra shared an excellent article from a co-worker of his on tracking down a big problem involving Exadata, multiple databases, I/O throttling, and several wait events like "cell smart table scan" and "cell single block physical read". It's a great read not only because it shares how to walk through a problem like this, but it introduced several new tools starting with the My Oracle Support note that is included in the article, and has me more knowledgeable about what IORM is.
Saturday, September 7, 2013
Keeping Exadata nodes maintained
From an interesting article I ran across on LinkedIn, Mike Chafin gives a step by step for how to create disk monitoring for Exadata Compute node disks with Enterprise Manager. I need to get this over to our DBAs as they are the primary users of EM in our shop, since we could always use more alerting and Mike's article includes that as well for us!
Friday, September 6, 2013
Weekend Reading: Exadata & DB Storage
The weekend has just begun, but that doesn't mean you can escape without getting homework assigned! I think these go together well, and soon I'll be devouring them when I get a chance to sit down for a few hours and catch up on my reading. First, is Database Storage for Dummies; no seriously I can't make this up! Then next up is the first entry in the Exadata Workbook series that covers planning, installing, operating and maintaining an Exadata platform so I want to go through this looking for opportunities to enhance the support of the platform.
As an extra bonus this weekend, you should also read the article at My Oracle Support 1274322.1 on Exadata High Availability best practices too!
As an extra bonus this weekend, you should also read the article at My Oracle Support 1274322.1 on Exadata High Availability best practices too!
Thursday, September 5, 2013
Oracle Advanced Compression highlights
Did you know that Oracle Database version 11g brings with it a host of new features, one of which is Oracle Advanced Compression? If you didn't, you may want to browse this article which has a testimonial on how this feature allowed a customer to reduce their footprint by 50 percent. Or, you can skip to the next article to see how another client reduced their database resources by 400 percent and you can find tools that let you self-assess your savings with and without compression.
Wednesday, September 4, 2013
Statspack bug(s) and fix(es)
This article highlights a bug (and fix) with the STATSPACK package, which reminds me of another bug we have encountered and are going to be fixing if it still exists after our upgrade to R12. Currently in our 11.2.0.3 environment, and the bug exists in 11.2.0.2 as well, we encounter the following entry in the database log file every week when a job tries to run:
ORA-12012: error on auto execute of job "PERFSTAT"."STATSPACK_PURGE_61"
ORA-04063: package body "PERFSTAT.STATSPACK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PERFSTAT.STATSPACK"
ORA-06512: at line 2
You can see with this script, that several objects are marked as INVALID:
select object_name, object_type, status from dba_objects where owner = 'PERFSTAT' and status = 'INVALID'
The document you want to see to fix this on My Oracle Support is 1337034.1, and if you want to apply the patch and fix it I'd be interested to hear from you!
ORA-12012: error on auto execute of job "PERFSTAT"."STATSPACK_PURGE_61"
ORA-04063: package body "PERFSTAT.STATSPACK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PERFSTAT.STATSPACK"
ORA-06512: at line 2
You can see with this script, that several objects are marked as INVALID:
select object_name, object_type, status from dba_objects where owner = 'PERFSTAT' and status = 'INVALID'
The document you want to see to fix this on My Oracle Support is 1337034.1, and if you want to apply the patch and fix it I'd be interested to hear from you!
Tuesday, September 3, 2013
An old emperor in new clothes
As many of us are returning to work today, I wanted to share an interesting situation from last week to re-energize you for the short week! I've mentioned that we've hit a nasty database bug which affected our 11.2.0.2 environment, and still affects the database even after upgrading to 11.2.0.3, so we've created an alert for it and know how to handle those situations. The other day, we had another situation where it appeared that the inactive transaction branch bug was now affecting internal database transactions which did not go out over a database link at all. Very interesting, and very scary prospect!
I did some poking around but couldn't really come up with anything proving that this session wasn't going out over a database link, so I talked with one of our top developers about it since he usually has some really great assistance and guidance on issues like these, and he said he'd take a look. A little while later, he came back to me and just about knocked my socks off; the session was not internal, and it was going over a database link. We had saw the following script in gv$sqlarea:
select sequenceX.nextval from dual
which doesn't appear to be using any database links, right? Well the developer had found that the object had a synonym created, with the entry in DBA_SYNONYMS pointed across the database link so when we looked into the gv$sqlarea on that database with the same sql_id we found the same SQL being run! This proves out that what appeared to be a local session was in fact NOT a local session after all, and that is why it was possible for the session to be stuck in the "inactive transaction branch" wait event class.
I did some poking around but couldn't really come up with anything proving that this session wasn't going out over a database link, so I talked with one of our top developers about it since he usually has some really great assistance and guidance on issues like these, and he said he'd take a look. A little while later, he came back to me and just about knocked my socks off; the session was not internal, and it was going over a database link. We had saw the following script in gv$sqlarea:
select sequenceX.nextval from dual
which doesn't appear to be using any database links, right? Well the developer had found that the object had a synonym created, with the entry in DBA_SYNONYMS pointed across the database link so when we looked into the gv$sqlarea on that database with the same sql_id we found the same SQL being run! This proves out that what appeared to be a local session was in fact NOT a local session after all, and that is why it was possible for the session to be stuck in the "inactive transaction branch" wait event class.
Monday, September 2, 2013
About 30 times a day
Since today is a day off for many of us, it's a time to reflect on the things that are going on in our lives and that is what this blog post is about. Last month, I had the pleasure of seeing the blog having the highest traffic volume in total and hits per day, so that the site fell just a single post away from having 930 hits for the month and exactly 30 times a day for the month of August.
Seeing the site take off like this is really an amazing experience and I couldn't do it without all of you out there, so thank you!! This coming week should be an exciting series of posts as I'll be highlighting Exadata, 12c, and other "advanced" technology items which just may include some bugs. :}
Seeing the site take off like this is really an amazing experience and I couldn't do it without all of you out there, so thank you!! This coming week should be an exciting series of posts as I'll be highlighting Exadata, 12c, and other "advanced" technology items which just may include some bugs. :}
Sunday, September 1, 2013
EBS Workflow
In closing our spotlight for the EBS Support blog, are some articles about the Oracle Workflow module which as you know is something I've spent some time with recently! First, is an article on a subject that I addressed in my presentation and whitepaper about what happens when data is left in your tables after purging but from a new angle with PO Purge Workflow script that I need to try out at work. Next up is a post about the Workflow Product Information Center and some of the common information you can find out at this PIC which is a great reminder about some other sources of information that Oracle has and I need to tap into more often!
Subscribe to:
Posts (Atom)