SPM and GTTs
-
Howdy, I'm wondering about how SPM and things like
https://blogs.oracle.com/optimizer/post/what-is-add-verified-spm would be
impacted by the presence of gl...
Pickleball Übung: Drop Spiel 7-11
-
Einer der wichtigsten Schläge im Pickleball ist der 3rd Shot Drop – also
der dritte Schlag einer Rally, wo das aufschlagende Team mittels eines
kurzen Ball...
Locate an Error in Wrapped PL/SQL
-
I had a conversation a few weeks ago with someone who asked me how to find
a missing table when you have a wrapped PL/SQL file and cannot see the
source co...
How to Use Databases Inside GitHub Actions
-
GitHub Actions is a platform that automates the build, test and deployment
pipeline of your GitHub projects. Since its introduction, GitHub Actions
has bee...
How To Validate/Rebuild Domain Index?
-
Hello, While rebuilding Domain index online failed with following errors:
alter index HR.HR_LOCATIONS_SPT rebuild online ; alter index
HR.HR_LOCATIONS_SPT ...
Index Usage – 1
-
In 12.2 Oracle introduced Index Usage Tracking to replace the previous
option for “alter index xxx monitoring usage”. A recent post on the Oracle
database ...
Ubuntu Pro Upgrade?
-
There wasn’t a choice when I chose to update the Ubuntu instance. I was
compelled to upgrade to Ubuntu Pro. According to the upgrade I have five
free insta...
Le chiffrement Oracle : native network encryption
-
Pour continuer dans la série “chiffrement et bases de données”, nous
allons évoquer le sujet “native network encryption” et “data integrity”
dans le ca...
When is an Oracle ACE not an Oracle ACE?
-
As of this week (11th March 2024) I am no longer a proper Oracle ACE – and
this is exactly as it should be. I am now an ACE Alum (I would prefer
Alumnus bu...
When is an Oracle ACE not an Oracle ACE?
-
As of this week (11th March 2024) I am no longer a proper Oracle ACE – and
this is exactly as it should be. I am now an ACE Alum (I would prefer
Alumnus bu...
Building a high-performance API using GPT-4
-
Can the power of GPT-4 be leveraged to build a high-performance API? In
this article we will instruct GPT-4 to build a high-performance API in
GoLang usi...
PostgreSQL Index Types
-
Introduction In this article, we are going to analyze the PostgreSQL Index
Types so that we can understand when to choose one index type over the
other. ...
AI Prompt Engineer (AI-fu). The new Google-fu?
-
The other day I came across the term AI Prompt Engineer. It was in the
context of being the next big thing in the job market. I did a bit of
Googling and...
Bitten by the leap year?
-
Leap years are those things that for the most part go unnoticed, but
occasionally in niche circumstances they can bite you when you least expect
it. Consid...
Bitten by the leap year?
-
Leap years are those things that for the most part go unnoticed, but
occasionally in niche circumstances they can bite you when you least expect
it. Consid...
Installing and Running DBSAT on 21c
-
DBSAT is Oracle's "Database Security Assessment Tool" that you can get
from Oracle Support Document "Oracle Database Security Assessment Tool
(DBSAT) (D...
IF OPatch is angonizingly SLOW…….
-
OPatch Apply And Rollback Getting Slower After Oneoff Or RU Patch Numbers
Increased (Doc ID 2946849.1) Applying Oracle CPU patches was taking over 30
minut...
Moh_Create Standby DB
-
------------------------------------------------------------------------------------------------------------------------------------------
-- Prepare the ...
Archivelog Space Needed Python Script
-
I wrote a script called archivelogspace.py to help size our Oracle archive
log filesystems to support replication tools such as Fivetran, DMS, or
GoldenGat...
Citus as a distributed database plugin hands-on
-
Preamble Citus is an excellent columnar storage that fits perfectly in a
Business intelligence instance as we have seen in a previous post (link).
Citus ...
Oracle 19: Сравнение Query Block Registry
-
Для ускорения/оптимизации выполнения запроса коллега Сергей Перегудин
проанализировал и предложил поправить/зафиксировать план важного, но
замедлившегося з...
reading a LOB in another session
-
Reading a LOB in Oracle is often quite easy: it's just a column in the
query and all the libraries available today are doing the work necessary to
make...
Oracle 23c Boolean Data Type
-
In Oracle 23c release you can now have a boolean data type in your table
column, to illustrate: I will create a dummy table and insert different
values…not...
sql
-
set pages 999 lines 220
col username for a15
col object_owner for a15
col OBJECT_NAME for a25
col OS_USER_NAME for a18
col LOCKED_MODE for a15
TTI...
How the bad guys are using AI
-
This week’s AI Week highlighted some of the ways that bad actors are
already using AI, and ways they’re expected to use it more. Bad guys using
AI: Cybercr...
NMLS Exam Prep Practice Questions
-
1) Do all licensed loan originators need surety bond for each state in
which they are actively licensed? a) Yes, they need surety bond for each
state b) No...
Critical Patch-Updates: Statistiken für 2024
-
Diese Woche hat Oracle die Critical Patch Updates für Januar 2024
veröffentlicht. 389 Patches für 132 Produkte, darunter 3 Patches für die
Oracle Datenbank...
A misunderstanding about the Materialize hint
-
I think I have found out why some folks are resisting using this hint when
defining a CTE (Common Table Expression). There apparently is a
misunderstand...
New views in Oracle Data Guard 23c
-
Oracle Data Guard 23c comes with many nice improvements for observability,
which greatly increase the usability of Data Guard in environments with a
high...
AWS CLOUD STORAGE OVERVIEW
-
There are three types of cloud storage: object, file, and block. Each
storage option has a unique combination of performance, durability, cost,
and interfa...
The converged Christmastree
-
With this year’s converged Christmas tree, we achieved a particularly
special variety. It not only contains the Multifir Christmas tree (...)
Der Beitrag...
The converged Christmastree
-
With this year’s converged Christmas tree, we achieved a particularly
special variety. It not only contains the Multifir Christmas tree (...)
Der Beitrag...
PGIO Update
-
PGIO is the SLOB method for PostreSQL. An old friend of mine, Bart Sjerps,
has implemented a modified PGIO in Python and posted it on Github:
https://githu...
My Personal Conference Review 2023
-
In the last two weeks I was very busy: three conferences in ten days are
exhausting – but it was a lot of fun. The last conference for this year is
over no...
What punch cards teach us about AI risk
-
I (finally) read Edwin Black’s IBM and the Holocaust, and I can’t recommend
it strongly enough. This book had been on my queue for years, and I put it
off ...
Whatever happened to SydOracle
-
So I haven't posted in *mumble* years. What happened ?
Firstly there was this thing called Twitter. There seemed to be less
blogging and more twee...
Valdosta State Endorses Low Code Solutions
-
Valdosta State continues to use Oracle APEX for stand-alone applications as
well as enterprise-level applications with thousands of daily users.
Arthur Ri...
Pressing Pause on APEX #JoelKallmanDay
-
To honour this year's #JoelKallmanDay, I'd like to use this as an
opportunity to speak about mental health, rather than get technical like I
have done in...
Bitcoin Halving
-
Bitcoin halving is a significant event on the Bitcoin network every four
years. During this event, the block reward that miners receive for
verifying tr...
HTAP: Well, How Did We Get Here?
-
I’m speaking at an HTAP Conference put on by PingCap, (the folks
responsible for TiDB). As usual, I’m the only one with a cap. 🙂 By now
the event is s...
Oracle Database Service options for Azure Customers
-
We saw Larry Ellison visit Redmond for the first time to make an important
partnership announcement with Satya Nadella. Yesterday’s announcement shows
we h...
Sqlstat History
-
Oracle Diagnosics pack purchased? AWR reports reveal many aspects of
database usage and behavior. In addition to Enterprise Manager Cloud
control pages the...
How to add Datafile in ASM?
-
Adding a datafile to an Oracle ASM (Automatic Storage Management) database
involves several steps. ASM is a feature of Oracle Database that manages
storage...
Adding PDBs is Easy also in v23c.
-
TL;DR: Success! I've got several PDBs plugged in a CDB, all created "just
from scripts", no "template-recovery". From here on it is all is
Dead-Simple. O...
SQL Stats Analytics (from SQL*Plus!)
-
If you have access to some other graphical tool that displays time series
on multiple dimensions for one or a set of SQL statements from an Oracle
database...
Out of Place (OOP) Patching of Oracle Restart 21c
-
Previous post showed OOP for 19c Oracle restart. Things are much simpler in
21c and can expect the same for 23c once released. The -switchGridHome
option i...
Oracle Database Online Migration to ASM
-
We were recently migrating one of our non-production databases to Oracle
ASM. Previously, we used the Linux files system EXT4. We wanted the
flexibility ...
APEX (Multi) Application Settings
-
Most applications need some sort of "configuration" table. A simple
key-value store where you can put values that might change on a different
environment, ...
Oracle AVDF Installation and Setup Document
-
This blogpost will provide you detailed information about Oracle Audit
Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a
comprehensive Data...
Roll Forward Standby with 1 Command
-
I have a testbed that I use for research purposes. This testbed consists of
a 2-node RAC primary database (RESP) and a 2-node RAC physical standby
database...
Designing a secured Landing Zone in AWS
-
When adopting cloud computing, securing your cloud infrastructure should be
a top priority. Starting with a landing zone provides the foundational
infras...
APEX Interactive Grid: Cell Selection as Default
-
When you want to copy a specific value from an Interactive Grid, you would
need to change Row Selection to Cell Selection in the Actions menu.
When you do...
SPM baseline and historical execution plans
-
I have often wondered why when we consult a past execution plan that is
protected by an SPM baseline, there is no Note at the bottom of that
execution plan...
SPM baseline and historical execution plans
-
I have often wondered why when we consult a past execution plan that is
protected by an SPM baseline, there is no Note at the bottom of that
execution plan...
GoodBye 2022, Hello 2023
-
2022 has been a peaceful and kind year both professionally and personally
for me. I began the year as an AWS Data Lab Solution Architect, helping
external ...
ALTER TABLE NOCOMPRESS
-
What a difference three words can make. No, not those ones, these ones
MODIFY DEFAULT ATTRIBUTES.
https://docs.oracle.com/en/database/oracle/oracle-databas...
ALTER TABLE NOCOMPRESS
-
What a difference three words can make. No, not those ones, these ones
MODIFY DEFAULT ATTRIBUTES.
https://docs.oracle.com/en/database/oracle/oracle-databas...
PMP Success Journey of Melanie Project Manager
-
Melanie Lorenzo, PMP® achieved PMP with all above target in all Domain. She
attended 1-1 training with me few months back. I'm confident, she will
excel in...
Rebuild index candidates
-
Recent reminder on Oracle on line course "Understanding Explain Plans &
Index Utilization" by Dan Hotka and problems that I faced in real
professional life...
World Cup 2022 Challenge online!
-
For the last 16 years, with every big football tournament (World Cup and
Euro Cup), we've launched an Oracle APEX app where you can predict the
scores of...
CBO and Partial indexing
-
Oracle 12c introduced Partial indexing, which works well for simple
partitioned tables with literals. However, it has several significant
issues: For insta...
DECODE With Ranges
-
Tim Hall wrote this post yesterday (as part of Joel Kallman Day 2022) with
some examples for “the old way” vs. “the new way” to do some stuff. One of
the...
New works by John Williams Waterhouse “discovered”
-
Is there an artist you liked, but would love to have seen more works by? I
always liked John William Waterhouse and wished there were more pieces. You
may ...
Difference between ROWNUM and ROWID in Oracle
-
First let us examine what is ROWID and ROWNUM Both ROWID and ROWNUM are
Oracle’s pseudo-columns ROWID The ROWID pseudo-column returns the address
of the ro...
VS Code: Removal of Trailing Spaces
-
The Windows\Linux keyboard shortcut for removing trailing spaces in VS Code
is: Ctrl + K Ctrl + X On macOS it is: ⌘ + K ⌘ + X Alternatively you can
access ...
ORACLE PIVOT FUNCTION & ORA-00918
-
First we create a view *v_emp*
create or replace view scott.v_emp as
select a.empno,a.sal,b.dname from scott.emp a, scott.dept b
where a.deptno=b.deptno;
...
Building and Using an APEX Item Property Matrix
-
I’ve recently been involved in some APEX development. One of the
application form had a bunch of input items whose visibility and mandatory
aspects depend ...
How much storage am i using?
-
We were recently asked how much Azure storage we are actually using -
initially I thought this was going to be a simple thing to find out - but
actually ...
OJVM and DBA_REGISTRY_SQLPATCH
-
I woke up this morning and did what I do most days - doomscroll through
twitter. One of the benefits of being in the US is that there are usually
some inte...
I have retired
-
I have now retired from work as of June 2021 and will no longer be updating
this site. I had been doing a different role in the 18 months prior to
retireme...
Fun - Query Generated Calendar
-
Here's a query that will generate a full year calendar given any year.
Enter the 4-digit year in the first line and execute the code.
WITH year...
Oracle to Postgres Migration Issue with Commit
-
If you have some PL/SQL, Oracle allows you to include *commit* statements
between a *begin* and *end*. Assuming this is appropriate for your
application,...
Puppy remembrance virtual goodbye session
-
Our dear friend Pieter left us unexpectedly in July, a lot of people
couldn't say goodbye yet.
Therefore we organise a virtual goodbye ceremony
We wi...
Dulcian Presentation Archive
-
Dulcian personnel are active participants in Oracle conferences and user
group meetings. Use these links to view slides presentations given at
various Or...
Moving Databases from ASM to ZFS on Exadata
-
Exadata is the best database machine available to run every Oracle database
workload. But many times, within Exadata proliferate a large number of test
a...
Video: Updated Tour of Database Actions & JSON
-
Video tour and demonstration of our latest JSON interface in Database
Actions (formally SQL Developer Web) for the Oracle Database.
The post Video: Updat...
pgbouncer and slow server pool increase
-
This post is about an issue I ran into when trying to use pgbouncer in
front of Yugabyte YSQL, the postgres layer yugabyte reuses for handling
relational d...
Certification Tests – A Necessary Evil
-
Originally posted on Mike Gangler's Musings:
In today’s database market, getting certified is becoming more of a
requirement than previous years.?? The cur...
Certification Tests – A Necessary Evil
-
Originally posted on Mike Gangler's Musings:
In today’s database market, getting certified is becoming more of a
requirement than previous years.?? The cur...
Autonomous Database Newsletter - March 8, 2021
-
March 8, 2021
Newsletter For
Autonomous Database
on Shared Exadata Infrastructure
Welcome to our latest customer newsletter for Autonomous Databa...
ANY_VALUE and FIRST/LAST (KEEP)
-
The FIRST and LAST (a.k.a. “KEEP”) aggregate functions are very useful when
you want to order a row set by one column and return the value of another
col...
Celebrating 25 Years of Java
-
Twenty-five years after its initial premier, Java is still the most widely
used development language in the world. It continues to be a favorite
technolo...
-
Cloning a database where source Oracle Home has a higher DST patch than a
destination Oracle home
Example: Source database has a DST patch version 23, and ...
Am I running from inside a (DBMS_SCHEDULER) Job?
-
I’ve talked about improving your code instrumentation in the past, in
particular how to use conditional compilation for your extra logger calls.
See Debugg...
-
*Scenario Planning: Pivoting from Pandemic to Proactive*
On a scale of 1-10, how far off was your 2020 budget? Feel free to go as
high as 14.
We star...
Security
-
"WIn16 :Z:\ Module 02 Footprinting and Reconnaissance\Website Mirroring
Tools\HTTrack Web Site Copier and double-click httrack_x64-3.49.2.exe to
launch the...
How to perform groupby using Python Itertools
-
Original Post can be viewed at How to perform groupby using Python Itertools
Itertools is a powerful module and is part of python standard library. It
pr...
-
"ORA-02020: too many database links in use "
Cause: The current session has exceeded the INIT.ORA open_links maximum.
To find:
---------
SQL> show ...
ORA-65140: invalid common profile name
-
How to solve if you get an error “ORA-65140” while creating a profile on
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 . Let us see how
we can ...
Segment Tunning.
-
Segment Tuning:
################
what is Fragmentations in a table.
when there is huge delete operations done on a table,
The blocks which occupied t...
Read [PDF] Suits A Woman on Wall Street
-
*Download PDF Suits A Woman on Wall Street*
*Download*
PDF EPub Doc EBooks Rtf Mobipocket Kindle
FREE
UNLIMITED BOOKS, ALL IN ONE PLACE.
FREE TO TRY FREE...
Hardening Apache ZooKeeper security using zkpolicy
-
Apache ZooKeeper is an open-source server which enables highly reliable
distributed coordination. Distributed applications can use it to maintain
configu...
Oracle Cloud & Third party tools
-
There have been several buzz words and offerings since the invention of
Cloud concepts. We have been hearing of Private Cloud, Public Cloud, Hybrid
cloud a...
Advance Your Career with New 2020 Credentials
-
We’re excited to announce the release of many new 2020 certification exams.
Being certified on the latest release ensures you stay current on Oracle
te...
BUG in INSERT … SELECT with nested objects
-
I came across a very nasty bug in Oracle SQL engine while working on some
new code. It took me a while to figure out what the problem is as the SQL
code I ...
Updated Monitor Server Disk Space
-
Monitoring of potential issues includes knowing when any volumes reach a
certain capacity. It can take time to add space or free it up so being
notified be...
MySQL trading latency for throughput(not)
-
MySQL again. The goal: use binlog_group_commit_sync_delay setting to reduce
IOPSes. The idea is to set binlog_group_commit_sync_delay to a large value
like...
How to create signed url on google cloud storage?
-
A signed URL is a URL that provides limited permission and time to make a
request. It's good to be used by someone who does not have a Google
Account. I ca...
Succinct Study of Oracle SQL BI API as Evolution
-
SQL API Evolution
from Oracle9i through Oracle19g
This is a visual summary of my presentation at Oracle USA for the NYOUG
2019 Winter General Meeting. ...
Snapshot Too Old Too Soon
-
What could cause a SQL statement to fail with ORA-01555 after 1 second? The
answer appears to be related to a limitation of Active Data Guard that
makes me...
Cloud Native Event Message Transformation
-
When designing a cloud native architecture on an enterprise scale it is
most likely that you cannot start with a green-field situation. In all
reality it i...
Row Prefetching et PL/SQL
-
J'avais écrit il y'a plusieurs années déjà un article qui présentait le row
prefetching avec en illustration un problème de performance d'une requête
SQL o...
Logical Domains and Micro Partitions
-
Consolidation of different workloads often involves the use of
virtualization technologies and/or partitioning of a physical server
platform. Scenarios ...
Welcome
-
This site contains links to material relevent to my professional life. I'm
an IT professional with experience in a range of disciplines and
technologies ...
TIP 120 - How much memory my Linux process is using
-
_uacct = "UA-2338271-1"; urchinTracker(); Just came across some notes
regarding Linux memory and I thought to share the below tip on how to find
out memory...
Security Alert CVE-2019-2729 Released
-
Oracle has just released Security Alert CVE-2019-2729. This vulnerability
affects a number of versions of Oracle WebLogic Server and has a CVSS Base
Sco...
Dbvisit Standby Version 9 has landed!
-
Dbvisit Standby, Disaster Recovery, Oracle
[image: Dbvisit blog preview image]
Dbvisit Standby Version 9 has landed!
Wow what an exciting time at Dbvisit ...
Petit lexique du BigData
-
Avec l’importance grandissante des technologies BigData, les entreprises se
sont retrouvées confrontées à une multitude de nouvelles notions, qu’elles
on...
CDB Fleet in Oracle Database 18c
-
RSS content
Oracle database 18c introduces a new CDB Fleet feature which allows many
CDBs to be managed as one. A CDB fleet is a collection of CDBs and...
Update
-
I’m an applied researcher at RStudio, where I contribute to the
r-tensorflow family of packages (e.g., tfprobability). I write about doing
deep learning fr...
Oracle Certification Highlights – March
-
Oracle Certification highlights provides insight on new exams, exam
preparation, exams that are retiring, program announcements, and all the
great things t...
OS-Level Stalls, NAS and LD_LIBRARY_PATH
-
Although there are many posts about the evils of using LD_LIBRARY_PATH, at
times it's required when working with Oracle, specifically with Oracle
Golden ...
Statspack Documentation
-
There is a lot of information on Statspack on the web but I have not found
the official Statspack documentation except for Oracle 9i. As of Oracle 10g
the ...
Why JAVA Is A Top Career Option for Beginners
-
There are multiple platforms and streams for developing a product or
application. When we talk of technologies and programming languages, Java
is the most ...
Sangam 18: Presentations, Scripts and More
-
Many, many thanks to those who came to my three sessions at Sangam 18, the
largest meeting of Oracle technologists in South Asia.
As I promised, you can do...
The Ultimate guide to DevOps Tools Part #4 : Docker
-
In this series that related to DevOps Tools that helps you as DBA to
automate your work and make it easier for you , this will be the last part
for Docker....
#OOW18 is almost there
-
Oracle Open World 2018 and Oracle Code One 2018 is just around the corner.
This will be my 8th time in Oracle Open World and again I will be heavily
busy w...
#OOW18 is almost there
-
Oracle Open World 2018 and Oracle Code One 2018 is just around the corner.
This will be my 8th time in Oracle Open World and again I will be heavily
busy w...
How people ask DBAs for tuning …
-
How people ask for database tuning, in the form of a more well-known
analogy … Hey I hear you’re a mechanic. Cool. Can you fix my vehicle? No, I
don’t know...
Renaming a RAC cluster
-
Introduction Renaming an Oracle RAC cluster is not an easy thing,
unfortunately for me I had to do this today because the name chosen for the
newly insta...
Explorative Information Visualization
-
The power of data visualization At the moment I am taking the course
Explorative Information Visualization at Aalto University. This course
focus on the pr...
MySQL 5.6 vs 5.7
-
Whitelist preview of Performance Insights has just started on RDS MySQL and
it gave me a chance to visually compare load profiles of MySQL 5.6 and 5.7.
I f...
Oracle Database 18c - Install On-Premises for Linux
-
Oracle Database 18c was available on Oracle Cloud. Now everybody can
download Oracle Database 18c On-Premises for Linux (
*LINUX.X64_180000_db_home.zip)*
O...
Date and Time Format in ASMCMD for File Listing
-
This is a short blog post to give you an idea how you can define your own
custom date and time format for “ls -l” command in ASMCMD. If you use
ASMCMD qu...
Blogging v2
-
So the last post here was in 2011…seven years later I should probably post
again, just to point random Google visitors to : My new blog
: https://rmoff.net...
SQL Server Indexes best practices
-
SQL Server Indexes best practices Below are some of the SQL Server Indexes
best practices or points to keep in mind while creating SQL Server Indexes.
1. A...
Good bye and thanks for the memories!
-
Hello fellow reader, 8 years ago I set up a goal to share my knowledge with
fellow database engineers via this blog. This resulted in 36 (hopefully,
decent...
Oracle Solaris 11.4 Public Beta Released
-
Yesterday the Oracle Solaris 11.4 Beta was released to the public. You can
download it from OTN to have your go with it. Please read the documentation
to l...
ContractOracle.com is for sale
-
If you would like to purchase this domain, email
Robert.Geier@ContractOracle.com
This domain is perfect if you are a contractor working with Oracle
softwa...
Mmm, π
-
Young *rz.He* over on Stack Overflow has a question about why SQL*Plus
doesn't parse every line of a PL/SQL block in case it's a comment in order
to avoi...
My Internship Experience at Pythian
-
I remember nervously walking out of one of King’s Cross St Pancras
Station’s numerous exits searching for the 7 Stanley Building. I wandered
through the mo...
Windows and .NET sessions at Openworld
-
Interested in Oracle Database on Windows performance and security, Active
Directory, or .NET development topics? At Oracle Openworld SF next week
there's a...
Oracle Open World 2017 presentation
-
Hi, I will be presenting about ASM internals in Oracle Open World 2017
conference on Sunday October 1st. Following are the details: Session ID:
SUN5682 Ses...
Demo App for REST enabled SQL
-
Getting Started The new Oracle REST Data Services SQL over REST. How to
enable that is on my last blog post
here: http://krisrice.blogspot.com/2017/09/or...
Unable to locally verify the issuer's authority
-
Chuka pinged me when he got this error in Qualys logs after installation of
qualys agent on a server
2017-07-24 15:23:08.363
[qualys-cloud-agent][232147]:...
Why Education-to-Employment is such a Hard Road
-
When you are young, things change from one year to another in both
education and personal life. That’s why, some like to call youth *the
period of many t...
Using DML with ADRCI
-
The Oracle Database has some useful debugging and diagnostics features. One
such utility called the Automatic Diagnostics Repository Command
Interpreter or...
Exadata 12c PX Adaptive Offloading
-
Here is yet another case when you may not see as much offloading on your
Exadata as you expect.
I was recently investigating a simple *select count(*)* qu...
CSV parsing and tokenizing strings
-
Most of you will be familiar with the “Comma Separated Values” data format.
It is used in spreadsheets and other places to store ordered lists of
character...
MySQL Cluster 7.6: The First Milestone
-
The first Development Milestone Release (DMR) of MySQL Cluster
7.6--7.6.2--is now available! You can see the full changelog for 7.6.2 here.
But before we...
Oracle VM Features: Distributed Resource Scheduler
-
One of the handy management features of Oracle VM is the Distributed
Resource Scheduler (DRS). DRS lets administrators load balance CPU and
network resou...
User-based filters in query zones
-
whilst developing query zones is relatively well documented, the ability to
filter output based on the currently logged on user is less well defined,
and...
AWS Solutions Architect – Associate Certification
-
Hi All, I am glad to announce that I have completed AWS Solutions Architect
– Associate Level certification This is a completely new world with lots of
opp...
Do you suffer from Storage Stockholm Syndrome?
-
The last year at DSSD (now a part of Dell EMC) has been an extremely
interesting one for me, and I’ve learned a great deal, which is always
good. Some of t...
On issuing commit from database PL/SQL
-
There was something of a storm on Twitter on 12-Oct-2016. Twitter is a nice
medium for, say, showing a photo to your followers or referring them to an
in...
#doag2016 and we are presenting!!
-
Portrix Systems will be at #doag2016… and we will be presenting too!! Each
day of the conference, members of the Portrix Systems staff will be active!
On T...
Reasons to upgrade to Enterprise Manager 13.2
-
Before, during and after the Open World, I have received numerous queries
on the release of Enterprise Manager 13.2. This is an important release for *En...
Favor Skeletal Implementation in Java
-
Skeletal implementation is a design by which we can use the benefits of the
interface and abstract class together.
The Java Collection API has adopted th...
Segment Statistics
-
rem******************************************************** rem Show
Segments with the highest Lock waits rem André Karlsson rem
https://www.protractus.com...
SQLfail? SQLwin!
-
update sqlfail set last_posting_date = date'2016-08-18'; It’s been a while
since I’ve published here. You see, I’ve been kind of busy. Back in January
2015...
Temporary tablespace takes ages to drop
-
A simple command like 'DROP TABLESPACE TEMP;' in a regular database can
become excessively slow. The reason behind this is quite simple, even if
the users...
30 Useful Linux Commands for System Administrators
-
In this article we are going to review some of the useful and frequently
used Linux or Unix commands for Linux System Administrators that are used
in their...
Test Drive Oracle APEX 5.1 Early Adopter 1!
-
It’s here! Oracle Application Express 5.1 Early Adopter 1 is available at
https://apexea.oracle.com/ and we are really looking forward to get your
feedback...
Get the Familiar Database You Trust, In the Cloud
-
With Oracle Database Cloud, you can have up to 3x mirroring of storage for
data redundancy, 100% system backup and restore, plus data centers in
multiple...
Moving Sideways
-
The past two years have seen a lot of change in my life :-
- I moved to Singapore thinking it would be for a year or two at least
and is now looking ...
Moving Sideways
-
The past two years have seen a lot of change in my life :-
- I moved to Singapore thinking it would be for a year or two at least
and is now looking ...
Become a Master of Oracle 12c
-
Oracle Database 12c: Administrator Certified Master Technology moves on,
and to keep pace with it, so should you. If you are an Oracle Certified
profession...
Become a Master of Oracle 12c
-
Oracle Database 12c: Administrator Certified Master Technology moves on,
and to keep pace with it, so should you. If you are an Oracle Certified
profession...
Tech15
-
Last December I presented at Tech15, the largest Oracle conference in the
Europe. Many thanks to the organizing team of this great conference. Here
is my p...
OCI Client-Side Deployment in 12C
-
The 12c version has introduced a new features called “OCI Client-Side
Deployment Parameters” this feature gives you the possibility to override
some OCI pa...
Moving my blog!
-
Hi All! I just wanted to let you know I’ve moved my blog to
https://me-dba.com I’m going to hide all content from this site as it will
be available from th...
Oracle Data Integrator 12c new Features Overview
-
Merhaba,
Bu yazımda Cloud teknoloji ile hayatımıza giren Oracle 12c ile
kullanıcılara sunulan *Oracle Data Integrator 12c *nin getirdiği yeni
özelliklerin...
Docker Containers and Delphix Architecture
-
I use wordpress for my personal blog. Works fine on it’s own. It is just me
making a few posts here and there. Occasionally there are problems like an
upgr...
Mount Clone Database in TSPITR
-
"alter database mount clone database" is a statement that forces all
datafiles to be put OFFLINE when mounting the target instance. You'll see
it's being u...
Oracle Clusterware - Startup (Internals)
-
It's an long standing post for me to share how the CRS start-up works.
Hope every one known with pictorial representation of CRS start-up provided
in orac...
Mystats utility
-
A variation on Jonathan Lewis's SNAP_MY_STATS package to report the
resource consumption of a unit of work between two snapshots. Designed to
work under co...
Grants to retrieve SQL_MONITOR
-
A quick post as I have been struggling to get the full list of object level
grants to be able to retrieve the output of
DBMS_SQLTUNE.REPORT_SQL_MONITOR. 1 ...
-
Tip of the day – Grouping and counting continuous entries
Problem:A colleague of mine had the problem to group continuous entries of
same type to be able t...
Automation for DBA - Ansible part 1
-
Hello,
In this post I would like to move forward with software provisioning and
configuration. In my last post I covered a ways to build a "core VM" and
n...
Client Connection Fails to Instance on Linux
-
I faced with a problem which clients were failing to connect to a DB2
instance on linux. To check it out I logged on to the system as root and
tried to "s...
Fill the Glass Episode 4 with Jorge Rimblas!
-
Measuring software performance in the real world Featured Speaker: Jorge
Rimblas September 11, 2015 | 10:00am–11:00am CST Jorge is your Been There
Done Tha...
Xeoma Review
-
I decided to write a CCTV review after our bank mail started to disappear
from our mailbox. I have learned quickly that simply purchasing cheap
camera won’...
Printing a large XMLTYPE value using DBMS_OUTPUT
-
As a sort of primitive debugging-method I wanted to show the contents of an
XMLTYPE variable using DBMS_OUTPUT.PUT_LINE. When you want to extract the
conte...
Sorry about late approval of comments....
-
Just wanted to apologize about the late approval of a couple of comments. I
thought I'd approved them but when I got on to do a blog entry I found that
t...
Another blog on Oracle Standard Edition
-
Recently I found a blog dedicated on Oracle Standard Edition too. It’s from
Ann Sjökvist and it’s available at this URL: http://www.sejustloveit.com/.
...
New blog to handle the PJC/Bean articles
-
Here is the link to another place that stores the PJCs/Beans article
without adds. http://forms.pjc.bean.blog.free.fr/ Francois
Oracle Database In-Memory Advisor Released
-
Oracle Database In-Memory option was released with Oracle Database 12c
(12.1.0.2) and the In-Memory Advisor (IMA) has been much awaited since
then. The Or...
12c New features
-
1.1 Advanced Index Compression
Advanced Index Compression works well on all supported indexes, including
those indexes that are not good candidates for the ...
Continuing the story
-
One of my 2015 new year's resolutions, was to finish the story I started
on this blog. The story being a talk that I had delivered a couple of times
3-4 y...
No Write Permission on ACFS Mount Point
-
Last night, I managed to create the ACFS Mount Point after resolving the
issue *"ACFS-9459: ASVM/ACFS is not supported on this os version"*. But,
after c...
brew install sqlplus
-
Gee, that didn’t work. For those of you wondering about the title of this
post, I’m referring to the brew package manager for Mac OS — a nice utility
for i...
On Error Messages
-
Here’s a pet peeve of mine: Customers who don’t read the error messages.
The usual symptom is a belief that there is just on error: “Doesn’t work”,
and tha...
Step by Step Creating Asm instance and database
-
Click Add Button
Click Next Button
Click Next Button
Click ide and next Button
Size 3gb
Click Next Button
Click Finish Button
Add another one disk 3g...
Visit and Bookmark the My Oracle Support Blog
-
Untitled Document
[image: MOS Icon] The My Oracle Support Blog continues the "Get Proactive"
discussion and covers all topics related to My Oracle Suppor...
A New Challenge
-
About two years ago Joyent began offering Linux instances, running under
KVM, stored on ZFS, and secured by Zones (“double hull virtualization”).
Since the...
Upcoming Events...
-
I took some time off from the road at the beginning of 2014 - getting ready
to get back on the road again, lots of trips scheduled from February till
the e...
How to find out all default values in init.ora?
-
This small test case shows it. [oracle@node1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.3/dbhome_1 [oracle@node1 ~]$ cd
$ORACLE_HOME/dbs [oracle@...
Auditing a user in Oracle
-
Do you need to audit a user in your Oracle database? AUDIT ALL BY JOEUSER
BY ACCESS; AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY
JOEU...
Yeni Blog
-
Kendime ait blog adresim http://zekeriyabesiroglu.com . Bundan sonraki
yazılarımı http://zekeriyabesiroglu.com den takip edebilirsiniz.
Teşekkürler.
User defined locking with DBMS_LOCK
-
User defined locks with DBMS_LOCKS often brings up unexpected results,
especially when it occurs within a mix of transactions in an application
layer. Ther...
12C ADG Enhancements
-
- *Explain plan now works on Standby*
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
SQL> select ...
latency heatmaps in D3 and Highcharts
-
See Brendan Gregg’s blog on how important and cool heatmaps can be for
showing latency information and how average latency hides what is really
going on: ...
oratop from MOS
-
This is just a pointer post to a tool which I discovered today. It is
ORATOP, to monitor databases real time like top of unix flavours. It is
pretty much l...
Something for the future
-
A nice little feature in Oracle Database 12c is to query patching
information via SQL. You can do this from SQLPlus or any other SQL
interface jdbc/odbc ...
How to Move USER_SDO_GEOM_METADATA like a Grandpa
-
Sometimes moving a small amount of data in Oracle database requires more
work than the actual task you need to complete. DBAs always have their
tools (PL/S...
Hotsos 2013 A personal Touch 3/4 – Third Day
-
After having a good sleep I attended the first session in the morning from
George Djerdj Srdanov with a presentation called “How to Get the Most Out
of You...
Profile Baselines Patches
-
Whats the difference … I should have written this one earlier but better
late than never. So, lots of DBA’s might me thinking, why oracle has 3 ways
to acc...
Add Code w/ Syntax Highlighting to PowerPoint
-
…or any media that supports rich text or HTML. I often include
code-snippets or queries in technical presentations. I find them much more
visually appealin...
Hash Semi Right Join : Oracle Tuning Tip#27
-
*TOPIC:*
Hash Semi Right Join
*DEFINITION:*
As described semi-join in previous forum (Tip#25), a semi-join between two
tables returns rows from the outer ...
Identify memory leak in Java app
-
One important advantage of java is programer don't care memory management
and GC handle it well. Maybe this is one reason why java is more popular.
As J...
A secret treasure house of Oracle books
-
One of the most prolific publishers of Oracle technology and application
books - *Packt Publishing *just published its 1000 cover. Packt books are
written ...
The Two Ways of Doing a Job
-
Whether it's deployment, development, performance tuning, troubleshooting
or something else, there are two fundamentally different ways of doing your
job: ...
A look at System Statistics
-
- Till 8i Analyze command was used to collect statistics. However
Analyse has following Problems :
1).Doesn't support External Tables.
2...
Oracle database on IBM Power systems with LPAR
-
Quite often I have been involved into discussions on Oracle database tuning
or best practices for IBM AIX machines especially logically partitioned
(LPAR...
Waiting for “PX Deq Credit: send blkd”?
-
Occasionally I hear someone talking about how to reduce the waiting time of
the event “PX Deq Credit: send blkd”. And it’s not uncommon to also realize
tha...
AUDIT : principes
-
*Paramètres d'initialisation concernant l'audit :*
SQL> col name for a25
SQL> col value for a45
SQL> select name, value from v$parameter where name like '%...
Edition Based Redefinition Part 3
-
This is the third part in a series about the new Edition based Redefinition
functionality of Oracle 11gR2. The first two parts are here: Part 1 Part 2
In t...
Debug mode for MOS
-
Had an SR in which I learned about a debug mode for FLASH MOS (tried it in
HTML, no go *grin*). Hold down the Control key and click on the Oracle My
Oracle...
OraSRP 4.1.0
-
First time I've read about LOBREAD lines in 10046 traces in Vladimir
Begun's blog-post dated Jun 2, 2010. I've tried to reproduce such trace in
my environm...
The Last Post...
-
...at least here, on this blog as I’ve moved over to blog.lisadobson.com
now.I’ve copied all the posts from here across to the new blog, but I will
also be...
Interesting case of the restriction of global hints
-
One of my colleagues sent following test case, of which he couldn’t control
the join order with hints. 1. Create objects – table t1, t2 and t3 2. Now
Let’s...
Materialized View
-
+++++++++++++++++++++++++++++++++++++
MVIEW refresh Status on MASTER Site :
+++++++++++++++++++++++++++++++++++++
set pages 1000
set linesize 180
col SNAPSHO...
oow 2010 presentation slides
-
Here are the slides of the presentation I did yesterday: OOW2010 Christian
Bilien. The room was full and I noticed a number of people were standing at
the ...
Quick Tip: Counting Cursors
-
Counting the number of open cursors in a database instance can be a
confusing activity. Perhaps an application has received an "ORA-01000:
maximum open c...
Blog relocation
-
I've decided to move on from TypePad, and I'm now blogging at
www.guyharrison.net/blog (RSS
http://guyharrison.squarespace.com/blog/rss.xml ) See you there...
APP-FND-01564: ORACLE error 31202 in changepassword
-
We had this issue in our production this morning. Our dedicated sysadmin
team were not able to change any user password from frontend. They were
receiving ...
Having more than 4GB of RAM on x86 Linux
-
When you do some googling on having more than 4GB of RAM on a 32bit x86
Linux system you usually get a lot of responses like: it's not possible,
you won't ...
Moving to WordPress
-
Blogger irritates me. Let's see if Wordpress makes me happy.
http://oraclesponge.wordpress.com/
I've used the supplied import functionality to move over po...
Weirdness of v$datafile on a standby db.
-
Here are some oddities of v$datafile on a standby
Oracle gets content of v$datafile from controlfile, but on a standby
database "STATUS" column wouldn't ge...
create or replace view scott.v_emp as select a.empno,a.sal,b.dname from scott.emp a, scott.dept b where a.deptno=b.deptno;
Case One:
We get this error because we are pivoting multiple columns without giving alias for each column, we should give alias at least for one column.
Case Two:
In the second case, we still get the same error even if we have added an alias of at least of one of pivoted column.
The length of the name of the last department was 28 , Oracle reconstruct the name for column name as below : 'name_of_department'_NAME_OF_PIVOTING_COLUMN' ==> This gives
'S013456789013456789013456789'_SAL; it length is 34 . This will be truncated and get 'S013456789013456789013456789'_ with length 30 characters.
The max size of column is 30 characters.
Now try with department_name =S013456789013456789013456788
BUG 27268249 - ENHANCE INDEX NDK STATISTICS GATHERINGW
it's recommended by change the fix control to disable 27268249 either at the session level or the system level: alter session set "_fix_control"='27268249:0'; or alter system set "_fix_control"='27268249:0'; +++delete existing statistics: sql> exec DBMS_STATS.DELETE_TABLE_STATS ('<owner-name>','<table-name>', partname => '<part-name>'); ++ regather state++++ begin DBMS_STATS.gather_table_stats(ownname => '<owner-name>' ,tabname => '<table-name>' ,partname => NULL ,DEGREE => 1 ,CASCADE => TRUE ,no_invalidate =>FALSE ); end; / On Jul 1, 2022 oracle reference : Ref Doc ID 2611336.1 Patch 33427856: GATHERING STATISTICS FOR INDEXES ON LARGE TABLES MAY BE TIME-CONSUMING
Whenstats collection, assetbyassetbyDBMS_MVIEW_STATS.SET_SYSTEM_DEFAULT isTYPICAL, "select count(*)"queries are used tocollect cardinalities oftables andMVs.
This causes refresh slowdown.
Same behavior since upgrading from 12.2 to 19c.
Regarding this MOS "12.2: Drop Materialized View Is Very Slow or Hangs (Doc ID 2401976.1)" I had to disable the statistic collection and truncate the statistic tables. Now it works.
During monitoring of PROD long running reporting… I identified a query taking more than 17 000 sec.
The next day when I generated AWR covering its execution period, I found that this query had taken 2600 sec. I have checked dba_hist_sqlstat , there is only one row / one snap. The delta elapsed time was 2600 sec but the total elapsed time was exact / AWR report is based on delta columns.
Under dba_hist_active_sess_history, I get the exact number of snap_id, in fact , there are many missing rows under dba_hist_sqlstat .
I have identified the root cause. During these snapshots , we don’t have a final execution plan ( it was a complex query with more than 14 tables), it was executed with an adaptive execution plan.
I identified that this behavior happened with dozens of queries. I cannot share with you the real issue, I succeed in reproducing it.
1
2
3
4
5
6
7
8
9
Tested under 12.1.0.2.0 and 19.8
optimizer_adaptive_features =false
optimizer_adaptive_plans =true
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
FROM CHB_t1, CHB_t2 WHERE CHB_t1.id = CHB_t2.id AND CHB_t1.n = 666 AND burn
_cpu(CHB_t1.id/CHB_t1.id) = 1
I have worked on many cases where « wall clock time » >> real execution time of the query. ( file generation taking time par example) .
In that case , sum(DBA_HIST_SQLSTAT.ELAPSED_TIME_DELTA) =MAX(DBA_HIST_SQLSTAT.ELAPSED_TIME_TOTAL) and MAX(DBA_HIST_SQLSTAT.ELAPSED_TIME_TOTAL) << « wall clock time » I assumed that this query was executed one time.
In my case , the query is executed via PL/SQL function.
Another finding, the insertion into wrh$_sqlstat (DBA_HIST_SQLSTAT) is based on V$SQLAREA_PLAN_HASH . When the query is under execution , there is no row into V$SQLAREA_PLAN_HASH
1
2
3
4
5
6
7
insert into wrh$_sqlstat SELECT ...
FROM X$KEWRSQLIDTAB sie, X$KGLCURSOR_CHILD_SQLIDPH sql
WHERE (1 = 1)
AND sie.sqlid_kewrsie = sql.kglobt03
AND nlssort(sie.sqlid_kewrsie, 'nls_sort = binary') =
nlssort(sql.kglobt03, 'nls_sort = binary')
AND sie.pdbid_kewrsie = decode(sql.con_id, NULL, 1, 0, 1, sql.con_id)