Monitoring Oracle Golden Gate from SQL Developer

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...)

Unfocused Learning

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...)

An introduction into Oracle VM (V3.x)

One other internal presentation that was presented by me, showed the technical architecture and production experiences regarding Oracle VM V3. It was based on demo of a Hands-On Lab (HOL-9870, Oracle VM) given during Oracle Openworld 2013. Based on this HOL, structures were explained and demoed for architects and database administrators. An introduction into Oracle

Read More...

An introduction into Oracle Enterprise Manager Cloud Control 12c Release 3

I have given some internal and customer presentations lately that you might find useful or like, so hereby a direct share to the presentation about Oracle’s Enterprise Manager Cloud Control (V3) An introduction into Oracle Enterprise Manager Cloud Control 12c Release 3 from Marco Gralike

Combining schedules with DBMS_SCHEDULER

Suppose I want to create job which will execute every 30 minutes in “working” hours, and at the rest of the day every hour.

For example:
8:00
8:30
9:00
9:30
..
..
18:00
19:00
20:00



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)
THEN TRUNC(SYSDATE,'HH')+30/1440
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.

(more...)

Read Oracle Linux 7 Beta 1

It might be too late posting about Oracle Linux 7 (Beta 1). Just came back from long holidays in Thailand. I think it's very interesting to learn something new in OL7. Users can download it by using OTN account.
Download.
Release Note.

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
3.8.13-31.el7uek.x86_64
Users can choose to (more...)

Interacting client-side JavaScript with server-side PeopleCode

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.

Richard Yip: How to interact client-side Javascript with server-side PeopleCode

(using getElementById.focus(), getElementById.submit(), submitAction_win0(this.form,this.name) and window.showModalDialog)

This example (more...)

Read Committed Isolation Level im SQL Server

Im SQLPerformance.com Blog hat Paul White einige interessante Punkte zur Implementierung des Isolation Levels Read Committed im SQL Server aufgeschrieben. Grundsätzlich gibt es im SQL Server dieser Tage zwei Implementierungen für Read Committed, von denen die ältere (zumindest vom Herrn White) als Locking Read Committed bezeichnet wird. Da der Autor einen weiteren Artikel zum Thema ankündigt, starte ich an dieser Stelle eine Aufzählung:

Best UTL_FILE Practice

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 PARALLEL option.

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...)

OpenSSL ‘Heartbleed’ and Oracle Products

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 […]

The post OpenSSL ‘Heartbleed’ and Oracle Products appeared first on ORAERP.COM - Blogs.

Preview of Maria Colgan, and Andrew Bond/Stewart Bryson Sessions at RM BI Forum 2014

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...)

Cannot show requested dialog. (SqlMgmt) Property Owner is not available…

I hit the following issue this morning when I tried viewing the properties of a SQL Server database using SSMS: Microsoft SQL Server Management Studio Cannot show requested dialog. ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database ‘[databasename]‘. This property may not exist for this object, or may not

Read More...

Training : Oracle ADF 11g Applicatie Ontwikkeling

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.
Dus:

    - (more...)

ADF for the Enterprise and beyond – 3-day conference for senior developers and application architects

SNAGHTML5d1bacOn 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...)

Complément : Régionales 2014 … les présentations

Retrouvez les présentations faites lors des Régionales 2014 :


Using test prep software to prepare for 12c OCP upgrade exam

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...)

Oracle Infogram 2014-04-15 12:52:00

Contributions by Angela Golla, Infogram Deputy Editor

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.” 

Mark Hurd
Mark Hurd,
President, Oracle
In this new blog, Mark writes, “Marketing executives are leading the charge to convince their organizations of the inherent danger in today’s highly digitized buyer-seller relationship. And they’re doing that by proving (more...)

Far Sync (Oracle 12c New Feature)

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. [...]

The post Far Sync (Oracle 12c New Feature) appeared first on Oracle DBA Scripts and Articles (Montreal).

How to Rename a Table

I tested this example in Oracle 12.1. First I created a table:

SQL> create table fred
  2  as select * from user_synonyms
  3  where 1 = 2
  4  /
 
Table created.

SQL>

Then I checked its object_id for later:

SQL> select object_id
  2  from user_objects
  3  where object_name = 'FRED'
  4  /
 
OBJECT_ID
----------
     92212

SQL>

... and described it:

SQL> desc fred
Name                       Null?    (more...)

Frequently Misused Metrics in Oracle

Lying Businessman

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:

Business Graph

  1. db file scattered read – Scattered reads aren’t always full table scans, and they’re certainly not always bad.
  2. Parse to Execute Ratio – This is not a metric that shows how often you’re hard parsing, no matter how (more...)