push_having_to_gby() – 2

Uncategorized
| Jan 3, 2020

THe problem with finding something new and fiddling with it and checking to see how you can best use it to advantage is that you sometimes manage to “break” it very quickly. In yesterday’s blog note I introduced the /*+ push_having_to_gby(@qbname) */ hint and explained why it was a useful little enhancement. I also showed a funny little glitch with a missing predicate in the execution plan.

Today I thought I’d do something a little (more...)

Where does the log writer spend its time on?

Uncategorized
| Jan 2, 2020

The Oracle database log writer is the process that fundamentally influences database change performance. Under normal circumstances the log writer must persist the changes made to the blocks before the actual change is committed. Therefore, it’s vitally important to understand what the log writer is exactly doing. This is widely known by the Oracle database community.

The traditional method for looking at log writer performance is looking at the wait event ‘log file parallel write’ (more...)

push_having_to_gby()

Uncategorized
| Jan 2, 2020

I came across an interesting new hint recently when checking the Outline Data for an execution plan: /*+ push_having_to_gby() */  It’s an example of a “small” change designed to reduce CPU usage by reducing the volume of data that passes through the layers of calls that an execution plan represents. The hint appeared in 18.3 but I’ve run the following on 19.3 as a demonstration of what it does and why it’s (more...)

Oracle REST Data Services (ORDS) 19.4 : A quick life update…

Uncategorized
| Jan 2, 2020

Almost 2 weeks ago I wrote about the release of Oracle REST Data Services (ORDS), SQLcl, SQL Developer and SQL Developer Data Modeler 19.4.

I spent the holidays playing around with it quite a bit, so I came back to work today and pushed it out across all Dev and Test installations.

As I’ve mentioned before, at work we run ORDS on Tomcat inside Docker containers. The build we use is very similar to (more...)

VirtualBox 6.1 : No compatible version of Vagrant yet!

Uncategorized
| Jan 1, 2020

VirtualBox 6.1 was released on the 11th of December and I totally missed it.

The downloads and changelog are in the usual places.

I spotted it this morning, downloaded it and installed in straight away. I had no installation dramas on Windows 10, macoS Catalina and Oracle Linux 7 hosts.

The problem *for me* was the current version of Vagrant (2.2.6) doesn’t support VirtualBox 6.1 yet. I can’t live without Vagrant (more...)

2019 : A Year in Review

Uncategorized
| Jan 1, 2020

Well, it seems 2019 was another slightly bizarre year for me.

I just looked back on last year’s review (here) and I’m guessing I had “resting bitch face” while I was reading it…

Conferences

One of the things I mentioned last year was I was taking a year off presenting. I had two events I had already committed to at the start of the year, then dropped off the face of the earth (more...)

Oracle Tidbits – December 2019 #OraTidbit

Uncategorized
| Dec 31, 2019
“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit DBA_AUTO_STAT_EXECUTIONS view in #db19c displays information about automatic optimizer statistics collection tasks, which …

The 2019 Year in Review

Uncategorized
| Dec 31, 2019

It’s that time of year where everyone is doing a “Year in Review” post and why not?

It’s good to gain perspective, plan for 2020 and celebrate all that was wonderful about 2019, (outside of politics, that was an utter failure on all fronts, pretty much most countries… :))

The DBAKevlar blog:

  • 46 published posts for 2019
  • Over 800 posts on the site
  • Over 600K in visitors for 2019
  • Daily views have increased steadily, with (more...)

Oracle wait event ‘log file parallel write’ change

Uncategorized
| Dec 31, 2019

This post is about a change in how the time is measured for the event ‘log file parallel write’. This is important for the performance tuning of any change activity in an Oracle database, because with the default commit settings, a foreground session that commits changes waits in the wait event ‘log file sync’, which is a wait on logwriter activity, for which the wait event ‘log file parallel write’ always has been the indicator (more...)

java.lang.SecurityException: User: ASADMIN authentication failed

Uncategorized
| Dec 30, 2019

When i trying to undeploy the REST service in UAT and deploy again, i am getting the below error.

 

java.lang.SecurityException: User: ASADMIN authentication failed

Solution :

verify the asadmin given credential correct and roles also.

Run the txkISGConfigurator.xml utility with “ebsSetup” argument.

refer :  Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Section 2: Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services

 

sysadmin user not logging in r12

Uncategorized
| Dec 30, 2019

I am trying to logging in sysadmin user of one of our UAT system, It’s simply loading but not logging in.

I checked the sysadmin user credentials valid. Yes it’s Valid.

 

select fnd_web_sec.validate_login(‘SYSADMIN’,’password’) from dual;

Y

Solution :

I checked any blocking session in database, Yes it’s there . So I kill those sessions afterwards  I can able to login.

select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2 (more...)

Configure Distribution Service between two Secure GoldenGate Microservices Architectures

Uncategorized
| Dec 30, 2019

Once you configure an Oracle GoldenGate Microservices environment to be secure behind the Nginx reverse proxy, the next thing you have to do is tackle how to connect one environment to the other using the Distribution Server.  In using the Distribution Server, you will be creating what is called a Distribution Path. Distribution Paths are […]

The post Configure Distribution Service between two Secure GoldenGate Microservices Architectures appeared first on DBASolved.

ADHD and Certification Tests- A Tale of Disaster

Uncategorized
| Dec 30, 2019

I don’t talk too much about my Attention Deficit Hyperactivity Disorder, (ADHD) brain outside of the occasional squirrel joke and more often view it as a super power, but when it is a challenge, I think it’s important to share what we go through.  You can’t solve a problem if you don’t know it is one.

ADHD and Autism

For those that aren’t aware, I was diagnosed with ADHD/on the spectrum for autism back (more...)

Scalar Subq Bug

Uncategorized
| Dec 30, 2019

This is an observation that came up on the Oracle Developer Forum a couple of days ago, starting life as the fairly common problem:

I have a “select” that runs quickly  but when I use in a “create as select” it runs very slowly.

In many cases this simply means that the query was a distributed query and the plan changed because the driving site changed from the remote to the local server. There are (more...)

File export not saved oracle apps r12

Uncategorized
| Dec 29, 2019

Suddenly We couldn’t able to save the file after we did export.

 

Solution :

 

Check your database any one of tablespace space issue in alert log file and add datafile.

Installing Nginx

Uncategorized
| Dec 28, 2019

With Oracle GoldenGate Microservices, you have the option of using a reverse proxy or not.  In reality, it is a best practice to install the recommended reverse proxy for the architecture.  The main benefit here is the security aspect of using it.  In Oracle GoldenGate Microservices, depending on the number of deployments you have per […]

The post Installing Nginx appeared first on DBASolved.

The Shepherd’s Crown

Uncategorized
| Dec 28, 2019

The Shepherd’s Crown is the last book in the Discworld series by Terry Pratchett. I really don’t like the finality of how that sounds, which is probably why I’ve waited a long time to read this book.

Having complained about how the female lead character was used in The Unicorn Project, I figured it was time to read this book and see it done properly again.

I’m not going to include any full-on spoilers, (more...)

Friday Philosophy – Community Means So Much

Uncategorized
| Dec 27, 2019

There have been a few things in the last month that have really brought home to me how much I personally receive from the Community. In my case, my Community is primarily the Oracle User Community – The end users who come together to share knowledge, the Oracle employees who support this, and the companies that support the end users. For most of you reading this, you are part of the Oracle User Community, but (more...)

Use Conda to Generate Requirements.txt for Docker Containers

Uncategorized
| Dec 26, 2019
pip is a standard package manager. Requirements.txt can be generated in one environment and installed by pip in a new environment. Conda replicates own installation. Pip produces a list of packages that were installed on top of standard library to make the package you wrote work.

Following are the steps to generate requirements.txt file to be used insdie Dockerfile for docker containers:



Go to your project environment conda activate

conda list gives you (more...)

Tools To Monitor and Work with Oracle on Azure

Uncategorized
| Dec 26, 2019

I’ve been studying for over a week for my certs.  It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what?  Most of what the certs are on are not in my technical area.  Yeah, this is not fun for me.  I find that my brain hits a limit on what it can absorb before the (more...)