Oracle provides the OMR analysis tools EMDIAG and repvfy so we can perform detailed management repository analysis and maintenance just like the pros.
Werner de Gruyter (Yoda), the father and caretaker for EMDIAG, has provided a custom Information Publisher report that you can use to manage your system on a regular basis.
Create EMDIAG Report
EM CLI allows you to create an IP report by importing an XML definition of the report. Create and save the XML (more...)
This is a brief article about workload management in RAC. I tried to cover different components of workload management in RAC and how they are configured at client side or server side. I haven’t gone into details of configuration steps but just mentioned in brief about how it can be done.
Readers are advised to refer Oracle documentation to understand details about configuration of workload management.
Workload management on RAC
There are 2 major components (more...)
This blog post is inspired on work I have been doing on Standard Edition databases and the returning confusion about what is and what is not part of Standard Edition.
DBA_FEATURE_USAGE_STATISTICS is a tool in determining license usage for the Oracle database. It is good to understand the implications of each entry, know what is happening in your database and thus be able to have a substantial conversation about the usage of your license, being (more...)
Topic: this post is about investigating Oracle wait events using stack profiles and flame graphs extended with OS-process state and Oracle wait event details.
After having real work get in the way for a couple of weeks ( a major 9i->12c is proving 'interesting' at the moment - maybe even worthy of a talk at some point) I've been slacking a little on writing up any blog posts.
So lets make amends for that now with a short post on some mview creation quirks.
I've been working in the past day or so on a browsing system for our (more...)
Just a quick reminder, Oracle Midlands Event #12 is just around the corner.
This is the day after I get back from India, right after my first day back at work. It’s going to be really hard to drag myself there, but I know it will be worth it!
Oracle Midlands : Event #12 was first posted on November 16, 2015 at 3:59 pm.
©2012 "The ORACLE-BASE Blog". (more...)
I’ll give presentations at DOAG 2015 on Tuesday (tomorrow), and at the BGOUG Autumn Conference on Saturday. My presentation will be about EMCLI (Enterprise Manager Command Line Interface). I will try to explain the basics of EMCLI, its terminology, the important points, and how we can use it with bash for scripting. I’ll also speak about EMCLI Python scripting, very short but useful into to Python and then share some sample scripts. Because of the (more...)
I’ve lost track of the number of times I see this sequence (no pun intended) of actions in code:
SELECT my_sequence.nextval INTO :some_variable FROM dual; INSERT INTO my_table VALUES (:some_variable, ....);
My question is always “Why?” What was it that made you so desperate in need of that sequence value that you needed it before you inserted it ? It is simply, easier, and more efficient just to get it back from the insert (more...)
Oracle Executive Vice President John Fowler used the occasion of Open World 2015 to introduce Oracle's SPARC M7 processor, the fastest in the world. Learn more ...
The post Oracle SPARC M7 Processor Breaks the “Sacrifice Performance for Security” Rule and Much More appeared first on VitalSoftTech.
Oracle week is one of the biggest Oracle related events in Israel which has going on yearly for the past 22 years (!).
It’s a 5 days long event with about 2000 participants in total over 80 different day-long seminars.
The seminars are around 8.5 hours (9am to 4:30pm) and are basically a day long course on various Oracle technologies which is nothing like the 45-90 minutes sessions I’m used to in the (more...)
This article is about the Oracle 12c in-memory option, and specifically looks at how the background worker processes do IO to populate the in-memory column store.
Hardware: Apple Macbook with VMWare Fusion 7.1.3.
Operating system: Oracle Linux 6.7, kernel: 3.8.13-118.el6uek.x86_64.
Database version: Oracle 22.214.171.124
Patch: opatch lspatches
19392604;OCW PATCH SET UPDATE : 126.96.36.199.1 (19392604)
19303936;Database Patch Set Update : 12.1. (more...)
This Log Buffer Edition covers some of the niftiest blog posts from Oracle, SQL Server and MySQL.
- OBIEE 11g and Essbase – Faking Federation Using the GoURL.
- You can use one of these to link an exception name with an Oracle error number. Once you have done this, you can use the exception name in the exception block which follows the declaration.
- This is a short post to help out any “googlers (more...)
I worked with our support team to improve the performance of a PeopleSoft Financials update statement yesterday. The update statement had an index hint already in it but the index was not the best one of the available indexes.
Here is the original update statement:
UPDATE /*+ INDEX(B PSCPYMNT_VCHR_XREF) */ PS_PYMNT_VCHR_XREF B SET BANK_SETID = :1, BANK_CD = :2, BANK_ACCT_KEY = :3, PYMNT_METHOD = :4, BANK_ACCT_SEQ_NBR = :5, EFT_LAYOUT_CD = :6, STL_THROUGH = :7 WHERE (more...)
When performance tuning, it can be important to understand the statistics in the database. It is worth noting that every column records it lowest (low_value) and highest (high_value) values in DBA_TAB_COLUMNS when you gather stats, like a mini-histogram. If the optimizer believes it knows the range of values within a column, plus the number of different values (cardinality), it can make guesses about the suitability and cost of index access when a predicate references that (more...)
While preparing to teach a class this week I have had the time to look into the In Memory (cost) option a bit closer. I noticed a few interesting things along the way and would like to share one of these here.
One of the questions I was asking myself was:
“What happens if I scan segments that are within the IM area, and some are not?”
I was primarily thinking of joins in (more...)
Little Things Doth Crabby Make – Part XVIV: Enterprise Manager 12c Cloud Control 188.8.131.52 Install Problem.
This is a short post to help out any possible “googlers” looking for an answer to why their 184.108.40.206 EM Cloud Control install is failing in the make phase with ins_calypso.mk.
Note, this EM install was taking place on an Oracle Linux 7.1 host.
The following snippet shows the text that was displayed in the dialogue box when the error was hit:
INFO: 11/12/15 12:10:37 PM PST: ---------------------------------- INFO: 11/12/15 (more...)