Search

Top 60 Oracle Blogs

Recent comments

support

Oracle Support: Easy export of SQL Testcase

By Franck Pachot

.
Many people complain about the quality of support. And there are some reasons behind that. But before complaining, be sure that you provide all information. Because one reason for inefficient Service Request handling is the many incomplete tickets the support engineers have to manage. Oracle provides the tools to make this easy for you and for them. Here I’ll show how easy it is to provide a full testcase with DBMS_DIAG. I’m not talking about hours spent to identify the tables involved, the statistics, the parameters,… All that can be done autonomously with a single command as soon as you have the SQL text or SQL_ID.

In my case, I’ve reproduced my problem (very long parse time) with the following:

Expert Advice: Get Started on Your New Website

Starting a new website can be a bit overwhelming but we’re here to help! Beginning Monday, April 20th, WordPress.com will host free, 30-minute live webinars to cover those initial questions that come up as you start to build your website. Each day will cover a different topic, all designed to give actionable advice on how to create the type of website you want. 

Date: Starts April 20, 2020 and repeats daily Monday thru Friday

Weekly Schedule:

  • Mondays – Getting Started: Website Building 101
  • Tuesdays – Quick Start: Payments (Simple and Recurring)
  • Wednesdays – Quick Start: Blogging
  • Thursdays – Quick Start: WooCommerce 101
  • Fridays – Empezando: Construcción de Sitios Web 101

Time: 09:00 am PDT | 10:00 am CDT | 12:00 pm EDT | 16:00 UTC

How to Move Your Classes Online — and Charge for Them

We are proud to host many websites for language tutors, yoga schools, and personal fitness coaches around the world.

It’s exciting to see how educators and consultants across different industries are getting creative with their online offerings: language teachers conduct 1:1 sessions to help students hone pronunciation, yoga studios livestream group sessions, and instructors lead writing boot camps via Zoom breakout rooms. Even my own strength coach is monitoring my workouts — I launch the camera on my phone, place it against the wall, and do deadlifts while he supervises.

Last year we launched Recurring Payments to support creators, consultants, small businesses, and other professionals in establishing dependable income streams. We were very pleased to discover that online educators using this feature are thriving as well!

Expert Advice: How to Make a Great Website for Your Small Business – Webinar

Whether you already own a small business or are exploring the idea of starting one, you’ll come away from this free, 60-minute live webinar with a wealth of actionable advice on how to maximize your digital presence.

Date: Thursday, April 2, 2020
Time: 11:00 am PDT | 1:00 pm CDT | 2:00 pm EDT | 18:00 UTC
Registration link: https://zoom.us/webinar/register/4215849773038/WN_at0PB64eTo2I0zJx-74g2Q
Who’s invited: Business owners, freelancers, entrepreneurs, and anyone interesting in starting a small business or side gig.

kglLock()+1406<-kglget()+293<-qostobkglcrt1()+498<-qostobkglcrt()+248<-qostobkglcrt2()+412<-qospsis(…

kglLock()+1406<-kglget()+293<-qostobkglcrt1()+498<-qostobkglcrt()+248<-qostobkglcrt2()+412<-qospsis()+2511 <-qospPostProcessIStats()+2765<-qerltFetch()+1544<-qerstFetch()+449<-insdlexe()+364<-insExecStmtExecIniEngine()+1810<-insexe()+2283<-atbugi_update_global_indexes()+1656<-atbFMdrop()+3088<-atbdrv()+7719

Sorry for this title, but that’s exactly the subject: this short stack gives me enough information to understand the issue, reproduce it, open a SR, talk with friends, find a workaround,…

A Friday afternoon story

Here is how this started, on a database just migrated from 11g:

kglLock()+1406<-kglget()+293<-qostobkglcrt1()+498<-qostobkglcrt()+248<-qostobkglcrt2()+412<-qospsis(…

kglLock()+1406<-kglget()+293<-qostobkglcrt1()+498<-qostobkglcrt()+248<-qostobkglcrt2()+412<-qospsis()+2511 <-qospPostProcessIStats()+2765<-qerltFetch()+1544<-qerstFetch()+449<-insdlexe()+364<-insExecStmtExecIniEngine()+1810<-insexe()+2283<-atbugi_update_global_indexes()+1656<-atbFMdrop()+3088<-atbdrv()+7719

Sorry for this title, but that’s exactly the subject: this short stack gives me enough information to understand the issue, reproduce it, open a SR, talk with friends, find a workaround,…

A Friday afternoon story

Here is how this started, on a database just migrated from 11g:

The Second Edition of Our “Learn User Support” Workshop Is Open for Signups

Back in January, we partnered with Support Driven and launched the first version of the Learn User Support Workshop, which helps women in the Asia-Pacific region develop the skills they need to succeed in a technical support role. We had 24 students enrolled in our first cohort.

Today, we’re happy to share that the next edition of the Learn User Support Workshop will launch on August 19, 2019. The course is entirely web-based — there’s no need to travel anywhere to attend — and completely free. So if you identify as a woman, are based in the Asia-Pacific region, and are serious about a career in user support, this might be a perfect match for you.

Patch conflicts

My last post was about patching my home databases from 18.3 to 18.5 on Windows, and how I encountered a patch conflict when I tried to patch the JVM. I thought I’d give a little bit of info for anyone who runs into patch conflicts from time to time. It can be stressful especially if unforeseen, or you are in the middle of limited time outage window etc.

So before you jump into applying a patch, a nice little tool you might like to explore is the patch conflict checker on My Oracle Support. You can get it via:

https://support.oracle.com/epmos/faces/PatchConflictCheck

It is straightforward to use, you simply fill in the platform and your current patch inventory details, and then list out the patches you intend to apply.

Enterprise Manager 13c and AWS

This posting is to try to clarify what is supported when using Enterprise Manager Cloud Control 13c (EM13c) and Amazon Web Services (AWS). The question came from some of our sales consultants who were finding confusing information about what is actually supported when using EM13c and AWS, so I have asked our Support folks to write a support note to provide the definitive answer on this. While that is being written, I thought I would post a quick blog that could be used to help clarify matters.

So let’s look at what the different scenarios are:

[Oracle] Researching internal latch implementation (ksl_get_shared_latch, kslfre, kslgetsl_w) and crashing PMON

Introduction

Last week the DOAG 2014 conference took place in Nuremberg and it was a blast with a lot of useful presentations and especially great conversations and meet ups with Oracle friends. I had a nice talk about the Oracle latch implementation with a participant, who told me that his instance crashes every time, if he (manually) sets a shared latch in exclusive mode and tries to release it afterwards. It sounded really interesting as i have done this so many times without ever noticing such an issue. He also told me that this issue is reproducible at least on Oracle 11g R2 and 12c R1. I had no immediate answer or clue about the described issue and needed to research it furthermore.