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.

Wednesday, February 20, 2019

How to check if fine-grained auditing (FGA) is enabled in your database

›
Use the view DBA_AUDIT_POLICIES, which "describes all fine-grained auditing policies in the database. Its columns are the same as th...
Monday, February 18, 2019

Find audit information about dropped users

›
If you have created your database with dbca, or have manually run the secconf.sql script after your database was created, the "DROP U...
Thursday, February 14, 2019

What is the 100046 trace event anyway?

›
The 100046 event is a Process Trace event. These trace certain system operations continuously until the tracing is canceled. The results ar...

Syntax for using the dbms_stats.gather_index_stats procedure

›
How to analyze an index using dbms_stats: BEGIN SYS.DBMS_STATS.GATHER_INDEX_STATS ( OwnName => 'SCOTT' ,...

How to solve ORA-02017: integer value required when trying to adjust parameters

›
I was trying to rectify an issue where the alert log of the database kept throwing errors like this: ORA-01013: user requested cancel of ...
Tuesday, February 12, 2019

How to solve ORA-01031: insufficient privileges when creating a cross-schema fk constraint

›
Scenario: you want to create a cross-schema Foreign key constraint: ALTER TABLE JIM.TRANSACTION ADD ( CONSTRAINT TRANSACTION_FK ...

How to remove a job from the job queue

›
Today I saw the following error message in the alert log of my database: 2019-02-12T13:27:30.506714+01:00 Errors in file /u01/oracle/diag/...
‹
›
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.