Minimalistic Oracle

Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.

Tuesday, February 27, 2018

How to install APEX in an existing database

›
I have based my receipe on Tim Hall's instructions found at www.oracle-base.com , and I do not want to take credit for this. But the in...
1 comment:
Monday, February 26, 2018

How to set up End-to-End tracing

›
Based on Performing Application Tracing in Oracle Database 12.1 SQL Tuning Guide Add the following to your application code: ALTER SES...
Thursday, February 22, 2018

DST_UPGRADE_STATE set to DATAPUMP(1) when running preupgrade_fixups.sql

›
During the preparation for a 12.2 upgrade, I found that the preupgrade-tool reported about an incomplete DST upgrade, where DST_UPGRADE_STAT...
7 comments:

Roles necessary to administer and view the Unified Audit Trail

›
Oracle 12c provides two new roles for auditing purposes: AUDIT_ADMIN for audit configuration/administration AUDIT_VIEWER for viewing an...
Thursday, February 15, 2018

How to use dbms_application_info to create session details

›
The package dbms_application_info lets you add supplemental information in your session, which can be picked up in the V$SESSION view. A...
Wednesday, February 14, 2018

How to view default settings for dbms_stats

›
Thanks to the author of the blog " Thinking out loud " for writing this piece of code. It makes it easy to view the default sett...
Tuesday, February 13, 2018

Why doesn't dbms_stats.set_schema_prefs seem to work?

›
When trying to alter the default settings for statistics gathering on partitioned tables, I had troubles setting schema-level preferences us...
‹
›
Home
View web version

About Me

My photo
Name: Vegard Kåsa
My career as an Oracle DBA startet in 2001, when I acceptet a request to take on the responsibility as my current employer's DBA. From that point and onwards, managing Oracle databases has kept me busy and engaged. I enjoy my work, and particulary appreciate the constant learning and devlopment that comes with the job. From 2014, I am self-employed through my company Oric Consulting AS (Norway), and from 2024 Oric Consulting AB (Sweden) I currently live in Göteborg, Sweden, with my family.
View my complete profile
Powered by Blogger.