Is Dave across the desk from you working at the moment? Or is he goofing off? You can’t see his screen but I reckon you can make a fair stab at what he is up to, without recourse to any sort of IT monitoring systems at all. How?
How fast is Dave typing?
If Dave is typing fast, he is almost certainly not working. He’s goofing. There are very few things you can do when (more...)
Here’s a question that appeared in my email a few days ago:
Based on the formula: “sreadtim = ioseektim + db_block_size/iotrfrspeed” sreadtim should always bigger than ioseektim.
But I just did a query on my system, find it otherwise, get confused,
SQL> SELECT * FROM SYS.AUX_STATS$;<
SNAME PNAME PVAL1 PVAL2
------------------------------ ------------------------------ ---------- --------------------
SYSSTATS_INFO STATUS COMPLETED
SYSSTATS_INFO DSTART 10-08-2014 10:45
SYSSTATS_INFO DSTOP 10-10-2014 10:42
SYSSTATS_INFO FLAGS 1
SYSSTATS_MAIN CPUSPEEDNW 680.062427
rlwrap is a nice little wrapper in which you can invoke commandline utilities and get them to behave with full readline functionality just like you’d get at the bash prompt. For example, up/down arrow keys to move between commands, but also home/end to go to the start/finish of a line, and even ctrl-R to search through command history to rapidly find a command. It’s one of the standard config changes I’ll make to any system (more...)
It is my assumption that inbound and outbound emailing has been configured – for example for a GMail account – as described in these two articles: GMail for inbound mail in SOA Suite 12c and GMail for outbound mail in SOA Suite 12c and that test mails can be sent and received.
The steps are:
- configure an email driver for SOA Suite for outbound and inbound emails
- configure an email address (one of the inbound (more...)
One of the most wonderful things of Oracle Open World are the Demo-Grounds. When you want to learn more about a certain feature, this is the place to go to. The actual developers and product managers are there to answer your questions and more!
In a previous blog I had written about Temporal Validity in Oracle 12c and whether it would be possible to have multiple validity periods on one table. You can read that (more...)
Do you write PL/SQL? Me too!
Trouble is, sometimes it's hard to decide how to structure your packages - particularly in an APEX project. Over at the PL/SQL Challenge
website run by Steven Feuerstein and friends there is a page dedicated to roundtable discussions.
I submitted my question not so long ago and hope to get some interesting responses. Why don't you give the site a visit and contribute? The discussions usually last for about (more...)
Some time back, I posted a blog entry about Metering and Chargeback in Enterprise Manager, where I covered the basic capabilities of the Chargeback Application. It’s taken me some time to get back to the promised followup blog post on setting up Chargeback, what with Oracle Open World getting in the way of things, but that’s what I’m finally doing now.
Chargeback can be setup in EM12c by any user with the EM_CBA_ADMIN role, or (more...)
At Oracle Open World I gave a presentation about the integration of Microsoft Sharepoint
and Oracle Application Express (APEX)
I see a lot of companies using Microsoft Sharepoint as portal for their intranet. For many people it’s the first place they go to when they start their day. But to do their job they make also use of other applications, some which are build in Oracle Application Express (APEX). This presentation will show the different (more...)
I previously wrote that I peeped the idea about showing the session information in terminal title from Timur Akhmadeev’s screenshots, and Timur wrote:
I’m using (a bit modified) Tanel Poder’s login.sql available in his TPT scripts library: http://tech.e2sn.com/oracle-scripts-and-tools
My title.sql and on_login.sql
Colored prompt is the one of many features of rlwrap.
Connected as simple user:
Connected as sysdba:
SQL*Plus on OEL through putty:
@inc/title “*** Test ***”
I ran the following query on an Oracle 220.127.116.11 database but it failed with an ORA-02020:
SQL> SELECT ppc.sttlmnt_dt day_date
2 FROM vrm_d18_ppc ppc,
3 meter_nhh mtr,
4 mtd_registers reg
5 WHERE ppc.tm_pttrn_rgm = reg.tpr
6 AND TO_NUMBER(ppc.stndrd_sttlmnt_cnfgrtn_id) = mtr.std_stlmnt_config_id
7 AND ppc.prfl_clss_id = mtr.profile_class_id
8 AND ppc.gsp_grp_id = mtr.gsp_group_id
I was just in Stockholm visiting a customer, and I noticed a new feature in my Volvo rental car: You could set the cruise control to a speed limit.
(apologies for the blurry picture, it was taken by my Narrative shirt pocket camera)
You drive the car as you would normally do, but when you approach the set speed, the car does not go any faster when you press the accelerator further. Unless you kick (more...)
After we upgraded our OMS environment we realized that our Harvester wasn’t uploading data to MOS anymore. Of course, you say, you just replaced your former ORACLE_HOME with a new home for 18.104.22.168.
1. Download p5567658_120030_Linux-x86-64.zip or the latest OCM installer for your environment. You’ll find a tab for downloading OCM on your front page in MOS. While you are there you should also download the Quick Start guide.
2. Unzip (more...)
This is quick. Saw it on Twitter this morning and it is just too funny to not share: Best slide of #Strataconf already? pic.twitter.com/hy8LnEnWhk — Matt Aslett (@maslett) October 16, 2014 Have a great day!Filed under: Big Data, Quotes, User Groups Tagged: #bigdata, quote, Strataconf
I’m super looking forward to next weeks DevOps Enterprise Summit in San Francisco. You might ask “Why?!” since I’m a database guy and not a DevOps guy. I can understand that reaction.
I don’t know about you, but when I hear the term DevOps I have to roll my eyes and think “oh, the latest greatest tech industry buzzword.” So why would I as a DBA care about DevOps? With DevOps, as with (more...)
In my earlier blog posting I listed the different Oracle Cloud Services. Due to the massive introduction of all cloud based solutions it is difficult to have an overview of all cloud based solutions and their roadmap for launching. I have drafted an overview of these items on the image below and listed the products and links to more information.
Oracle Cloud platform as a Service roadmap
Direct access to Oracle Cloud (more...)
Disclaimer: I’m not posting to make me look better, we’ve all written code that we’re later ashamed of, and I’m no different!
This is some code from a system I was maintaining some time ago. I’ve kept it since then because it illustrates a number of things NOT to do:
(in_password IN VARCHAR2)
-- do NOT copy this code!!! ...
RETURN VARCHAR2 IS
CURSOR cur_rules IS