Last week I was at Collaborate 14 speaking in two sessions; one of the sessions I had done a couple of times before. The other session was about the different ways of monitoring Oracle GoldenGate (If you are curious about the presentation it can be found here). While at the conference I ran the idea of monitoring GoldenGate from SQL Developer by a few peers and there seems to be interest. (more...)
The manager was proudly showing off his new IT classroom.
“Where is the projector?” I asked.
“Oh, we don’t need a projector. The instructor can just take over everybody’s screens.”
I have been teaching in environments like this, and it does not work well. When I have a piece of information or a computer screen projected in large format in front of everybody, the class has a common focus on the task. If (more...)
With DBMS_JOB I would write something like this in repeat interval:
(CASE WHEN TO_NUMBER(TO_CHAR(SYSDATE,'HH24')) IN (8,9,10,11,12,13,14,15,16,17)
ELSE TRUNC(sysdate,'HH')+1/24 END)
In DBMS_SCHEDULER I will create two schedules (“WORK”,”NIGHT”) and main schedule ("MAIN_DAY") which will combine those two for job schedule.
After installed it, I tested some a little bit.
[root@ol7beta ~]# cat /etc/oracle-release
Oracle Linux Everything release 7.0 Beta
[root@ol7beta ~]# uname -r
Users can choose to (more...)
This week we have a guest-post from Richard Yip. Richard is a PeopleSoft HCM & Payroll Technical Consultant at Santander Bank here in the UK. He is a long-term PeopleSoft techie and a regular at the UKOUG conferences. I’m delighted to be able to give him a conduit through which to share some of his good work.
(using getElementById.focus(), getElementById.submit(), submitAction_win0(this.form,this.name) and window.showModalDialog)
This example (more...)
In a post a couple days ago, I promised to provide a best practice approach to reading external files with the
UTL_FILE package. My first assumption is that you’re reading unstructured data because structured data is best read by external tables because external tables can read data much faster with the
My second assumption is that you’re you don’t know how to use or choose not to use the
DBMS_LOB package; specifically, (more...)
Heartbleed leads to ‘heartattack’ during earlier this week to all Internet users and companies due to the OpenSSL Security vulnerability. Thought to share Oracle’s take on different Oracle Products depend on OpenSSL, you can go through following docs: OpenSSL Security Bug-Heartbleed (Doc ID 1645479.1) And public link of the info provided by Oracle: http://www.oracle.com/technetwork/topics/security/opensslheartbleedcve-2014-0160-2188454.html other […]
We’ve got a great selection of presentations at the two upcoming Rittman Mead BI Forum 2014 events in Brighton and Atlanta, including sessions on Endeca, TimesTen, OBIEE (of course), ODI, GoldenGate, Essbase and Big Data (full timetable for both events here). Two of the sessions I’m particularly looking forward to though are ones by Maria Colgan, product manager for the new In-Memory Option for Oracle Database, and another by Andrew Bond and Stewart Bryson, (more...)
In mei geeft Oracle ACE Luc Bors weer een ADF 11g training. Deze training wordt gegeven in het kantoor van AMIS in Nieuwegein. In deze training leer je de basis van ADF. Een training op basis van presentatie, demonstratie en hands on, doorspekt met best practices en voorbeelden uit de dagelijkse praktijk.
De training is bedoeld voor ontwikkelaars die net met ADF 11g aan de slag zijn of aan de slag willen gaan.
ADF for the Enterprise and beyond – 3-day conference for senior developers and application architects
On May 21st, 22nd and 23rd – AMIS and Oracle join forces for a three day event around enterprise application development with Oracle Fusion Middleware. The event targets senior (ADF) developers and application architects. It addresses many of the themes currently or shortly relevant to any organization: multi device UI, mobility, security, agile & automated software engineering, performance & scalability, user experience, web & mobile oriented architecture and cloud. It will discuss and demonstrate Oracle’s (more...)
I got the newly available Kaplan test prep software for the Oracle 12c OCP upgrade exam.
I took the test in certification mode when I was tired at the end of the day some day last week and got 44% right – fail! I usually wait until I get all the questions right before taking the real test so I have a ways to go.
The practice test software has been useful in terms (more...)
Mark Hurd’s Latest Blog Explains Why Customer-Obsessed Marketing Is Your Next Competitive Edge
Oracle President Mark Hurd has posted his latest LinkedIn Influencer blog, “Customer-Obsessed Marketing Is Your Next Competitive Edge.”
Oracle Far Sync is an Oracle 12c new feature for Oracle Data Guard. This feature is meant to resolve the performance problems induced by network latency when you maintain a standby database geographically distant of the primary database. In this type of situation you sometimes have to make a compromise between performance and data loss. [...]
Back in March of last year I wrote an article on the five frequently misused metrics in Oracle: These Aren’t the Metrics You’re Looking For.
To sum up, my five picks for the most misused metrics were:
- db file scattered read – Scattered reads aren’t always full table scans, and they’re certainly not always bad.
- Parse to Execute Ratio – This is not a metric that shows how often you’re hard parsing, no matter how (more...)