Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)
-
Create a table out of nothing
-
sql table out of nothing
Il y a 2 heures
-
A Business-Oriented Primer on IEC 62325
-
*A Business-Oriented Primer on IEC 62325*
*Introduction*
This primer concisely overviews the IEC 62325 standard and its implications
for energy markets...
Il y a 2 heures
-
Querying the Alert log in RAC
-
Although v$diag_alert_ext works for a single instance, there is no
corresponding gv$ view for RAC.
However, the gv$ function can be used to execute a cu...
Il y a 5 heures
-
ASSM states
-
When the dbms_space_usage package came out reporting the “percentage free”
space in ASSM blocks with ranges like 0-25%, 25%-50%, etc. with flags FS1
to FS4...
Il y a 10 heures
-
OPatch – The “File In Use” error that wasn’t
-
Over the holiday break I took the opportunity to apply the latest RU to
some of my databases. On my 21c Windows instance, as I was running “opatch
apply” I...
Il y a 16 heures
-
OPatch – The “File In Use” error that wasn’t
-
Over the holiday break I took the opportunity to apply the latest RU to
some of my databases. On my 21c Windows instance, as I was running “opatch
apply” I...
Il y a 16 heures
-
How-To Create Lip Sync Video with AI - Change Any Video or Audio Locally
and Free
-
This video shows how to locally install Latent Sync AI model to lip sync
any video and audio for free and in private.
Code:
git clone https://github.co...
Il y a 19 heures
-
ORA-46373 - Correct Error number or Not?
-
I talked last week about an issue where I wanted to pre-create a unified
audit policy with no rules so that I could create a number of policies for
a custo...
Il y a 1 jour
-
Oracle 23ai new feature: INSERT INTO VALUES ACCEPT MULTIPLE ROWS
-
very useful new feature in Oracle 23ai is the ability to insert multiple
row values in one shot, unlike older releases where you need to repeat the
SQL com...
Il y a 2 jours
-
𝗦𝗣𝗢𝗨𝗚 𝗖𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆 - 𝙊𝘾𝙄- Zero Trust aplicado a OCI- ACED
Rolando Carrasco
-
𝗦𝗣𝗢𝗨𝗚 𝗖𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆 - 𝙊𝘾𝙄
💼El próximo 14 de enero, a la vuelta de Navidades, tienes una nueva cita
con SPOUG para este hashtag#webinar d...
Il y a 4 jours
-
Execution plans in Oracle SQL Developer for VS Code
-
An overview for all the different ways to get and view the plans for your
SQL statements in Oracle Database using the SQL Developer extension for VS
Code...
Il y a 5 jours
-
Calculating datetime differences
-
Finding the difference between two dates or timestamps is hard! I am not
fully satisfied with any of the solutions I have already proposed (or
read), but I...
Il y a 5 jours
-
Reflections on a year of biking for 2024
-
Since shortly after moving to Seattle in July 2022, I have not driven a
car. I’ve gotten around by bike and public transit. During 2023, I stayed
mostly in...
Il y a 5 jours
-
Happy New Square Year
-
At a family dinner a few days ago, we realized that the upcoming year –
2025 – is a square number 🤩 Promptly the kids checked and announced that
it’s th...
Il y a 6 jours
-
2024 – A Look Back
-
2024 was a pretty busy year for me. It was one marked with change as I
shifted the beginning of
Tags: year in review
Del.icio.us
Facebook
TweetThis
Digg...
Il y a 1 semaine
-
Automatic SQL Plan Management (ASPM) hands-on
-
Preamble Automatic SQL Plan Management (ASPM) is an extension of SQL Plan
Management (SPM) and is targeting at automating SPM on your workload by
inspect...
Il y a 1 semaine
-
SQL Insert
-
Inserting a new row into the dept table insert into dept (deptno, dname,
loc)values (10,'Apple','Boston') You can omit the column list in the insert
state...
Il y a 1 semaine
-
Evolution of a SQL Domain for Semantic Versioning
-
1. Introduction In my current project, I use an SQL domain to implement the
formatting and precedence rules for Semantic Versioning. I started with a
sim...
Il y a 2 semaines
-
Oracle 23ai, Domains, Enums and Where-Clauses.
-
TL;DR: In Oracle23ai, the DOMAIN type is a nice addition to implement more
sophisticated Constraints. Someone suggested the DOMAIN of type ENUM as a
colu...
Il y a 2 semaines
-
Install Oracle 23ai ASM on Linux from Exadata Sources
-
Why Oracle 23ai from Exadata? With Oracle Database 23ai being postponed to
a later date (“tba”) in November 2024, and many people not being part of
the Ora...
Il y a 2 semaines
-
Interval Search: Part 4. Dynamic Range Segmentation – interval quantization
-
Forums, mailing lists, and StackOverflow are all great resources for Oracle
performance discussions, but I’ve long thought it would be useful to have a
ded...
Il y a 2 semaines
-
Accessing values stored in a global context from APEX
-
Have you ever tried, within an APEX application, to retrieve a value from a
user-defined context accessed globally using function SYS_CONTEXT ?
Chances are ...
Il y a 2 semaines
-
La montée de version en zero-downtime : merci la réplication !
-
Introduction : Dans le monde des bases de données, garantir une
disponibilité continue est une exigence incontournable, surtout pour les
systèmes critiqu...
Il y a 2 semaines
-
Question about Merge and UDT
-
I'm using a UDT with dataset inside there as a table and i want to use that
UDT on Merge statement. When using that UDT, i put that UDT inside "ON ("
as fo...
Il y a 2 semaines
-
Outliers, high-entropy and flex columns in JSON-to-Duality
-
Fun fact: by coffee consumption by country in 2024, Finland is #1 in the
world. If you are familiar with JSON and still wondering about the meaning
of the ...
Il y a 2 semaines
-
Outliers, high-entropy and flex columns in JSON-to-Duality
-
Fun fact: by coffee consumption by country in 2024, Finland is #1 in the
world. If you are familiar with JSON and still wondering about the meaning
of the ...
Il y a 2 semaines
-
-
Running a Production-Ready Raspbery Pi Kubernetes Cluster at Home
-
In this guide, I’ll cover how to run a production-ready Raspberry Pi
Kubernetes Cluster using K3s. Background If you are like me, you probably
have a bunch...
Il y a 3 semaines
-
Unlocking the Power of ChatGPT for Coding: Insights, Tips, and Best
Practices
-
In the ever-evolving world of software development, efficiency is key. As a
developer / software architect, I’ve discovered that incorporating AI tools
l...
Il y a 3 semaines
-
Inspecting container checkpoints with checkpointctl
-
One of the newer features in Kubernetes (1.30 and later) is the Kubelet
Checkpoint API. This new API allows users to create a stateful copy of a
running co...
Il y a 3 semaines
-
High-Performance Java Persistence Newsletter, Issue 69
-
Introduction Welcome to a new issue of the High-Performance Java
Persistence Newsletter in which we share articles, videos, workshops, and
StackOverflow ...
Il y a 3 semaines
-
Containers are awesome, not only for stateless things
-
This post describes why using containers, even for database driven
applications, is very useful.
Il y a 3 semaines
-
UKOUG Discover 2024
-
Yesterday was the last day of the UKOUG Discover 2024 conference, and I had
two talks between 13:00-15:00. It’s been about 4 years since my last
face-to-...
Il y a 4 semaines
-
Using Python’s getopt
-
A couple of my students wanted me to write a switch and parameter handler
for Python scripts. I wrote it just to show them it’s possible but I also
show th...
Il y a 5 semaines
-
SQL Developer Tip: Exporting SQL Results to Excel by Default
-
I frequently use SQL queries to extract performance data from Active
Session History (ASH). I often then want to graph that data. Excel is a
very effec...
Il y a 5 semaines
-
Mr Blue Sky
-
Something significant has happened to the Oracle (and several other tech
and science) communities over the last week or so. Twitter is being
abandoned and,...
Il y a 1 mois
-
prepararea iaurtului de chefir
-
Pentru a pregăti chefirul, se pun 1-2 lingurițe de ciupercă într-un borcan
de sticlă de 200 mg și se adaugă 200-300 ml de lapte dulce. Se lasă să
fermen...
Il y a 1 mois
-
The Ten Commandments of Mindfulness
-
Translated into English by Tam Lac Jessica A. Tran 1. Yearn not for a
body free of disease and suffering, because without going through pain and
illne...
Il y a 1 mois
-
-
pre-post check script
-
#######################################################
#!/bin/ksh
# set the DB env and run
# Script to check PRE & Post checks Manually
#
# CB - -...
Il y a 2 mois
-
SAFE MLO NMLS Exam Practice Tests Free
-
NMLS Practice test offers questions and answers with detailed explanation
covering all topics of SAFE Mortgage Loan Originator Exam popularly called
as NML...
Il y a 2 mois
-
Automating Oracle Cloud Networking with OCI Service Gateway and Terraform
-
Oracle Cloud Infrastructure (OCI) offers a wide range of services that
enable users to create secure, scalable cloud environments. One crucial
aspect of a ...
Il y a 2 mois
-
Using PyTorch to Predict Host CPU from Date/Time
-
In my previous post I mentioned that I took a machine learning class based
on Python and a library called PyTorch. Since the class ended, I have been
worki...
Il y a 2 mois
-
Something fun to do, a word search!!
-
From days gone by. I had this in some of the courses I
wrote while at Hotsos as a filler for some blank pages.
Enjoy!
Il y a 2 mois
-
Microsoft Fabric
-
Data Factory (microsoft.com)
*Create a Data Flow*
Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft
Learn
Getting Started wi...
Il y a 2 mois
-
RDS Connectivity
-
I travel quite a lot for work. Most of it is in the US and Europe, but I
get around to other places as well. Most of the time, connectivity, while
not th...
Il y a 3 mois
-
negative regexp
-
if you want to grep anything except foo, use grep -v or negative lookahead
echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so
beautiful ...
Il y a 3 mois
-
Custom parameters in Method-R Workbench
-
Method-R Workbench is a leading tool to analyze many aspects of Oracles
SQL-Trace files.
It can use parameters in its commands and let users fill their ...
Il y a 3 mois
-
Restore Standby Database from Standby Backups
-
This post shows the steps for full restoring (controlfile + data files) for
a standby database using standby database backups. The same could be
achieved u...
Il y a 3 mois
-
ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database
-
When I am adding datafile to my 19C database facing the below error.
SQL> alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G;
alter table...
Il y a 4 mois
-
Reflections on Founder Mode
-
Paul Graham’s Founder Mode is an important piece, and you should read it if
for no other reason that “founder mode” will surely enter the lexicon (and
as G...
Il y a 4 mois
-
Особенности ASH против статистики V$SQLSTATS при использовании SQL Profile
для фиксации планов выполнения
-
После не очень удачной попытки фиксации очевидно более лучшего плана с
помощью SQL Profile: , наблюдал странность отображения выполнения запроса
(из генери...
Il y a 4 mois
-
„Silent Install“ der Oracle Grid Infrastructure
-
Ich sehe es immer wieder bei Kunden, dass die Oracle Software, insbesondere
die Grid Infrastructure, über die GUI installiert. X-mal klicken und dann
läuft...
Il y a 5 mois
-
Staging Tables in Oracle 23ai
-
Browsing through the Oracle 23ai New Features Guide, I once again
discovered a small, inconspicuous feature that I had previously overlooked:
There is a ne...
Il y a 5 mois
-
Caveat on index compression advanced low
-
The first time I played with the ADVANCED LOW option of index compression I
got burned. I’m still in the process of getting burned. I don’t have much
info ...
Il y a 6 mois
-
Blog Post Title
-
What goes into a blog post? Helpful, industry-specific content that: 1)
gives readers a useful takeaway, and 2) shows you’re an industry expert.
Use your c...
Il y a 6 mois
-
Client-side database connection timeout insanity
-
Attributed to Einstein but considered a dubious association, the quote is
something like “Insanity is doing the same thing over and over and
expecting diff...
Il y a 6 mois
-
Oracle EBS R12.1.3 autoconfig failed with Error - txkCfgUtlfileDir.sh
-
In one of our csutomer Environment during the Oracle E-Business suite
siwtchover activity we encounted the following error during exeuction of
autoconfig. ...
Il y a 6 mois
-
Modifying ORDS Jetty Parameters
-
Recently we were working on an issue that was occurring to developers in
Oracle Application Express’s (APEX) Page Designer. When we would attempt to
vali...
Il y a 7 mois
-
How to add new disk at Oracle Linux?
-
You may need to add disk to your server. Adding a disk to Oracle Linux
involves several steps, including identifying the disk, partitioning it if
necessary...
Il y a 7 mois
-
Pickleball & Longevity
-
Studien zufolge trägt die Trendsportart Pickleball in nahezu idealer Weise
zur Langlebigkeit bei! Wer möchte nicht sein Leben bei guter Gesundheit um
10 Ja...
Il y a 7 mois
-
Difference Between OCI Load Balancer & Network Load Balancer by A-Team….
-
So this is more of me putting this article for my own memory. Oracle’s
A-Team(www.ateam-oracle.com) has put together probably the best article on
the diffe...
Il y a 7 mois
-
AGI vs AI
-
One of my newsletter readers was asking me about the difference between
“AGI” and “AI”. In one issue of my newsletter last year, I put it this way:
Artific...
Il y a 8 mois
-
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...
Il y a 1 an
-
I Cannot Participate in the Genocide | I Quit Blogging on Oracle Products
-
Since Oracle declared its "*stand with Israel*", it puts me in a moral
dilemma, in one hand my main intention of blogging was to share the
knowledge with...
Il y a 1 an
-
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...
Il y a 1 an
-
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...
Il y a 1 an
-
Introducing the All New Data Vault Alliance Professional Membership
-
This is very exciting news to everyone interested is upping their
#DataVault 2.0 game with access to exclusive member benefits including
regular coaching a...
Il y a 1 an
-
enq: TM - contention Wait Event , Cause, Related SQL queries, Possible
Resolution
-
The "enq: TM - contention" wait event in Oracle indicates contention for a
table-level lock. This contention occurs when multiple sessions are
attempting t...
Il y a 1 an
-
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...
Il y a 1 an
-
Best model from UK clients to set-up offshore development centre in India
(IDC)
-
Introduction: Built to operate model generally is heard in the
infrastructure industry, nowadays IT businesses are also constantly seeking
innovative sol...
Il y a 1 an
-
The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”)
-
Of all my many Oracle blog posts, this particular post will remain with
me the longest, for not only is it the last blog post I’ve done in a while,
but i...
Il y a 1 an
-
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...
Il y a 1 an
-
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...
Il y a 1 an
-
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 ...
Il y a 2 ans
-
Sql2Odi - best practices for auto-generating your ETL content
-
I blogged a while ago about our Sql2Odi tool that converts SELECT (and WITH
as well) statements into Oracle ODI Mappings. (Blog posts 1, 2 and 3.)
Now th...
Il y a 2 ans
-
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...
Il y a 2 ans
-
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 ...
Il y a 2 ans
-
Use of packet capture and other advanced tools in network issues
troubleshooting
-
Introduction In this post I’m sharing my recent experience troubleshooting
a rather complex performance issue. The issue showed up during performance
test...
Il y a 2 ans
-
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...
Il y a 2 ans
-
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 ...
Il y a 2 ans
-
“Oracle Database Security with practice solution” books
-
Finally I would like to say I made it. First time in Azerbaijan , I
published “Oracle Database Security with practice solution” books. I
strongly recommend...
Il y a 2 ans
-
Running High Scale Low Latency Database with Zero Data In Memory?
-
I was talking to one of my oldest database colleagues (and a very dear
friend of mine). We were chatting about how key/value stores and databases
are evo...
Il y a 2 ans
-
The Biggest Gap In The Clouds? High Performance RDBMS
-
Over the course of the last few blog posts, we’ve looked at how an
increasing number of database workloads are migrating to the cloud, how
there is more th...
Il y a 3 ans
-
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...
Il y a 3 ans
-
How can Oracle help with Zero-Trust Security Model?
-
*An overview of Zero Trust Security Architecture*
Zero trust is an IT security approach to keeping sensitive data safe while
complying with new privacy r...
Il y a 3 ans
-
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...
Il y a 3 ans
-
A study of the Linux kernel PCI subsystem with QEMU
-
*Oracle Linux kernel engineer Dongli Zhang provides a cheat sheet on how to
utilize QEMU to study the Linux kernel PCI subsystem.*
The Linux PCI sub...
Il y a 3 ans
-
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...
Il y a 3 ans
-
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...
Il y a 3 ans
-
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...
Il y a 3 ans
-
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...
Il y a 3 ans
-
Sending Push Notifications from Oracle Notification Service with Oracle
Functions and Pushover
-
The Oracle Notification Service is an extraordinary service. I’ve blogged
about it in the past (see the Complete Guide to the Oracle Notification
Service...
Il y a 3 ans
-
Oracle Identity and Access Management 12c Upgrade Factory
-
Organizations want to reduce complexity and achieve more control across an
increasingly complicated technology landscape. The dynamics and logistics
are ...
Il y a 3 ans
-
Introducing Oracle Cloud Infrastructure Vulnerability Scanning Service
-
Oracle Cloud Infrastructure puts the security of critical workloads at the
center of our cloud infrastructure. This modern public cloud is built with
the...
Il y a 3 ans
-
Fusion Middleware Support Monthly Blog Index - March 2021
-
Welcome to the Monthly Index for March 2021
The following provides quick links to recent Fusion Middleware Proactive
Support Blog postings from over the ...
Il y a 3 ans
-
ANNOUNCING: Systems Engineering Forum - Modernizing Enterprise
Infrastructure with Oracle ...
-
Oracle Systems Engineering is hosting a webinar on Oracle Solaris and SPARC
systems in the North America time zone on April 13th, 2021. Join us live at
9...
Il y a 3 ans
-
ANNOUNCING: Systems Engineering Forum - Modernizing Enterprise
Infrastructure with Oracle ...
-
Oracle Systems Engineering will be hosting a webinar on Oracle Solaris and
SPARC systems in the North America time zone on April 13th, 2021. Join us
live...
Il y a 3 ans
-
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...
Il y a 3 ans
-
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...
Il y a 3 ans
-
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...
Il y a 3 ans
-
Upcoming talks UTOUG, INSYNC, and Uzbekistan INHA University.
-
March and April are booking up fast. Getting real busy and loving life.
Utah Oracle Users Group (UTOUG) March 17 – 18 Keynote: “Curves ahead:
Emerging tech...
Il y a 3 ans
-
Oracle ODA 19.10 Will Support KVM for Hard Partitioning of Oracle Databases
-
Major announcement made by the ODA team last week that this release will
be the last release to support 11.2.0.4. After this release, customers
will hav...
Il y a 3 ans
-
Optimizer Real-time Statistics Parameter in RU 19.10 Onwards
-
The Oracle Database 21c database initialisation parameter
*optimizer_real_time_statistics* has been backported to Oracle Database 19c
RU 10.
The real-ti...
Il y a 3 ans
-
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...
Il y a 3 ans
-
Oracle Database 21c Automatic In-Memory Enhancements
-
In Oracle Database 21c the Database In-Memory feature Automatic In-Memory
(AIM) has been significantly enhanced. I wrote a blog post about AIM when
it fi...
Il y a 4 ans
-
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...
Il y a 4 ans
-
How to solve ORA-19505: failed to identify file in RMAN?
-
Reason: Archive log is deleted from os level and catalog is not
synchronised.
Posted by Pavan DBA on January 18, 2011
DBA’s will feel bad when they got a...
Il y a 4 ans
-
-
"ORA-02020: too many database links in use "
Cause: The current session has exceeded the INIT.ORA open_links maximum.
To find:
---------
SQL> show ...
Il y a 4 ans
-
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 ...
Il y a 4 ans
-
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...
Il y a 4 ans
-
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...
Il y a 4 ans
-
3 Benefits of Migrating to Oracle Linux Virtualization Manager (OLVM)
-
3 Benefits of Migrating to Oracle Linux Virtualization Manager (OLVM) As
Oracle VM inches ever closer to its 2021 end of support date, Oracle VM
users have...
Il y a 4 ans
-
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...
Il y a 4 ans
-
New Performance Tuning batch from 25th May [demo on 23rd May]
-
*Oracle Performance Tuning batch from 25th May [demo on 23rd May]*
Duration: 20 classes Frequency: 5 days a week Timings: 7 – 8 AM IST Demo
date & time: 23...
Il y a 4 ans
-
Unix - Automatically notifiy when disk space is running low
-
It's good to be forewarned when one of your volumes or diskspace is running
low before it actually runs out (100% used). I have seen many databases
hang wh...
Il y a 4 ans
-
Following Various Legal Action Regarding “Oracle Cloud Revenue”
-
As a courtesy, I would like to provide a copy of the latest legal document
filed in an action being brought against Oracle leadership resulting from
allege...
Il y a 4 ans
-
New Parallel Distribution Method For Direct Path Loads
-
Starting with version 12c Oracle obviously has introduced another parallel
distribution method for direct path loads (applicable to INSERT APPEND and
CTAS ...
Il y a 4 ans
-
The "Practical Oracle SQL" book is available...
-
You all know I've been writing on this book called "Practical Oracle SQL",
right?
[image: Practical Oracle SQL front cover]
Well, now it's available for ...
Il y a 4 ans
-
SQL Puzzle - Calendar of Current Year
-
With this post, I want to share a SQL Puzzle to *Generate the Complete
Calendar of Current Year*. As you can see in the desired output
- Month names shoul...
Il y a 4 ans
-
ORA 29648 Error Java Mismatch
-
Error Msg = ORA-29548: Java system class reported: joxcsys: release
mismatch, 12.2.0.1.190716 1.8 in database (classes.bin) vs 12.2.0.1.200114
1.8 in execu...
Il y a 4 ans
-
Rankings for Logic Annual Championship for 2019
-
You will find below the rankings for the Logic Annual Championship for
2019, held in February 2020 on the Oracle Dev Gym. The number next to the
player's...
Il y a 4 ans
-
APEX Component Settings for Switch
-
While I point out a 'hidden' setting for Switch items in APEX, I want to
comment on two related item types found in Oracle APEX => radio buttons and
checkb...
Il y a 4 ans
-
ORA-12954
-
I went to Techfest 2019 in Brighton. While I was there I saw a presentation
by somebody from Pythian. He said that Oracle Database Express Edition is
now v...
Il y a 4 ans
-
Invalid ODCIPARTINFOLIST on Upgrade
-
I have been working on upgrading Oracle 12.1.0.2 databases to Oracle 19.3
when I ran into a problem that took me quite awhile to figure out. I did a
search...
Il y a 4 ans
-
INSERT … LOG ERRORS and SQL%ROWCOUNT
-
Oracle SQL has a really neat feature to log the rows that failed to be
processed during DML statement (INSERT / UPDATE / DELETE / MERGE ). This is
really g...
Il y a 4 ans
-
Exadata storage cell rolling restart caused datafile and redo log file
header block corruptions
-
24 hours passed – still at work. Struggling to start up the database which
was corrupted during cell storage rolling restart procedure. And I’ve never
seen...
Il y a 4 ans
-
DBMS_CLOUD : Loading a TEXT file without any DELIMITER
-
Recently I was working on an issue related to loading data from a flat file
on to Autonomous Data Warehouse using dbms_cloud api. While lot has been
writte...
Il y a 4 ans
-
Response to Make database simpler
-
I read an interesting and thought provoking blog this morning Make Oracle
database simple again Much of is is common sense and is really best
practise – n...
Il y a 4 ans
-
Getting an excel list of all Azure Virtual machines
-
Now i don't think i'm unique in getting frustrated that from some of the
Azure portal screens there is no download as csv option or a more effective
fi...
Il y a 4 ans
-
Get toast chunk_id from the user table tuples or from the toast index
thanks to pageinspect
-
Introduction TOAST stands for “The Oversized-Attribute Storage Technique”
and allows to broke up large fields value into multiple physical rows (see
the Po...
Il y a 5 ans
-
Get toast chunk_id from the user table tuples or from the toast index
thanks to pageinspect
-
Introduction TOAST stands for “The Oversized-Attribute Storage Technique”
and allows to broke up large fields value into multiple physical rows (see
the Po...
Il y a 5 ans
-
Philosophy – Treating Illness As A Performance Issue
-
Firstly, I’m on the mend. This is not a post about “oh woe is me, I am so
ill”. {Though it did turn out that I was more ill than I knew for several
months,...
Il y a 5 ans
-
PL/SQL & SQL Coding Guidelines Version 3.6
-
PL/SQL & SQL Coding Guidelines Version 3.6
Il y a 5 ans
-
Truncate (or drop!) partition without disturbing global non partitioned
indexes
-
The problem Typical problem with partition tables is partition pruning and
problems with global non partitioned index on them. From the theory, if you
tru...
Il y a 5 ans
-
Practical Application Performance Tuning: An nVision Case Study
-
I gave this presentation at the UKOUG Techfest 19 conference. It is
closely based on a previous presentation about PeopleSoft nVision
performance tuning,...
Il y a 5 ans
-
Human readable JSON, stored in BLOB
-
Currently Oracle (we're using Oracle 18c at the moment) is still
recommending to store your JSON document in a BLOB column. More efficient,
no character ...
Il y a 5 ans
-
Delphix XPP explained
-
This article was originally posted on the Delphix Support blog on 15-Nov
2015, but with the deprecation of the XPP feature with the new 6.0 release
and hig...
Il y a 5 ans
-
My Presentations at Germany Oracle User Group Conference (DOAG2019)
-
Next week I will be presenting the two following topics at Germany Oracle
User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot
for D...
Il y a 5 ans
-
My Presentations at Germany Oracle User Group Conference (DOAG2019)
-
Next week I will be presenting the two following topics at Germany Oracle
User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot
for D...
Il y a 5 ans
-
Exadata X8M - World's Fastest Database Machine
-
Exadata X8M has launched during OOW 2019, and termed as world's fastest
Database Machine. Let's walkthrough about new additions that has made X8M
as world...
Il y a 5 ans
-
SQLPATH/login.sql Not Run…. Again!
-
SQLPATH/login.sql will fail to run in 19c on Windows if the SQLPATH value
isn't to Oracle's liking. A simple rename can workaround the problem.
Il y a 5 ans
-
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 ...
Il y a 5 ans
-
Add Oracle Linux 8 Vagrant box
-
When using Oracle Linux (a lot) for local development you most likely want
to use Vagrant to quickly deploy new environments locally. Oracle
originally sup...
Il y a 5 ans
-
Pluggable Database Cloning using Snapshot Copy
-
You need to be logged in to see this part of the content. Please Login to
access.
Il y a 5 ans
-
MySQL history list effect on the latest record version reads
-
Mysql has a Multi Version Consistency Control(MVCC) to deal with Isolation
part of ACID. Mysql effectively keeps the old row versions as long as
needed for...
Il y a 5 ans
-
MySQL Parallel Index Range Scans: One is Sometimes Better Than Two
-
As presented at the Percona Live Conference in Austin in May, at Alibaba we
are working on adding support for parallel query execution to POLARDB for
MyS...
Il y a 5 ans
-
OGB Appreciation Day: free cloud and people
-
Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day! First
of all I am thankful for the people like …
Continue reading →
Il y a 5 ans
-
OGB Appreciation Day: free cloud and people
-
Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day! First
of all I am thankful for the people like …
Continue reading →
Il y a 5 ans
-
Rounding Timestamp Values with Fractional Seconds
-
Lately, I had to deal with a timestamp value with an overly long sequence
of decimal digits, coming as a string in ISO 8601 format :
1970-01-04T15:20:34.49...
Il y a 5 ans
-
Access Path Suggestor - Postgresql
-
Here is an improved access path suggestor from postgresql metadata. Based
from my Oracle version. In addition to visualized path alternative this
generates...
Il y a 5 ans
-
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 ...
Il y a 5 ans
-
OEM SSL Cipher Hardening Reset After Securing OMS
-
I have recently been installing Oracle Enterprise Manager at several sites,
and one of the key requirements has been to ensure that the installation
isn’t ...
Il y a 5 ans
-
Updates et Compression HCC (1)
-
Dans cet article je souhaiterais vous montrer ce qu'il se passe
concrètement quand un update est effectué sur des lignes compressées en HCC
(compression...
Il y a 5 ans
-
Completed Oracle 12c Database OCP Certification
-
Dear All,
Alhumdulilah Completed Oracle 12c OCP Certification after working hard in
Oracle 12c Databases.
Worked & Studied Rigorously on Oracle 12c Databa...
Il y a 5 ans
-
Sometimes the Simplest Things Are the Most Important
-
I didn’t ride in First Class a lot during my career, but I can remember one
trip, I was sitting in seat 1B. Aisle seat, very front row. Right behind
the la...
Il y a 5 ans
-
Version Conflicts among development maintained and customized templates
encountered; aborting AutoConfig run
-
*Issues : *
*Autoconfig Failing.*
applrac@dev-app01:~$
applrac@dev-app01:~$ adautocfg.sh
Enter the APPS user password:
The log file for this session is ...
Il y a 5 ans
-
MIN/MAX Optimization and Asynchronous Global Index Maintenance
-
In this short post I would like to point out a non-obvious issue that one
of my customers recently hit. On the one hand, it’s a typical case where
the quer...
Il y a 5 ans
-
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...
Il y a 5 ans
-
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...
Il y a 5 ans
-
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 ...
Il y a 5 ans
-
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...
Il y a 5 ans
-
Package and distribute a Scala jar to run on the command line
-
Add this to pom.xml – (update the mainClass to match your program): In
Eclipse right click project and run as Maven build with goal=package Sample
output f...
Il y a 5 ans
-
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...
Il y a 5 ans
-
Machine Learning Pipelines for High Energy Physics Using Apache Spark with
BigDL and Analytics Zoo
-
*Topic:* This post describes a data pipeline for a machine learning task of
interest in high energy physics: building a particle classifier to improve
even...
Il y a 5 ans
-
Identifying PostgreSQL Bloat and fixing it without downtime
-
Original Post can be viewed at Identifying PostgreSQL Bloat and fixing it
without downtime
MVCC (Multi-Version Concurrency Control) feature allows databa...
Il y a 5 ans
-
Oracle Ksplice introduces Known Exploit Detection functionality
-
The Oracle Ksplice team has added some really cool new functionality in
Oracle Ksplice. Instead of writing and copying the blog pretty much, just
go dire...
Il y a 5 ans
-
Playing with Oracle Database Security Assessment Tool (DBSAT)
-
The Database Security Assessment Tool (DBSAT) is an incredible free command
line tool provided by Oracle Corporation as a utility to help you verify
your d...
Il y a 5 ans
-
Hierarchical Query with search parameters (Pruning)
-
The following is a query from a friend, Reproducing it here: I have a menu
structure using a hierarchical query. i have search field to enter some
string a...
Il y a 5 ans
-
-
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...
Il y a 5 ans
-
Filtering in the APEX Interactive Grid
-
Remember Oracle Forms?
One of the nice features of Forms was the use of GLOBAL items. More or less
comparable to Application Items in APEX. These GLOBALS w...
Il y a 5 ans
-
OEM Target Discovery and One Potential Source of Duplicates
-
With OEM 12c came a feature that I've come to appreciate, the ability to
discover all targets on a given environment. Part of my appreciation is
the remo...
Il y a 5 ans
-
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 ...
Il y a 5 ans
-
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 ...
Il y a 6 ans
-
-
Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches
-
To mitigate SQL performance issues, I do make use of SQL Plan Baselines,
SQL Profiles and SQL Patches, on a daily basis. Our environments are
single-instan...
Il y a 6 ans
-
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....
Il y a 6 ans
-
OTW18 Sessions: Data Engineering and Latch Contentions
-
Thank you all those who came to my sessions at the OakTable World. Here are
the presentations materials
Think Data; not Database
Data Engineering for Data ...
Il y a 6 ans
-
Oracle Database EM 18 XE Available to Remote Clients
-
I found lot of posts about *Oracle Database 18 XE*. It's very interesting
for me. I didn't blog about how to install, because it's very easy for
using rpm...
Il y a 6 ans
-
Stop/Start all RAC databases at once
-
Introduction Stopping all RAC databases running on an ORACLE_HOME at once
and saving the state before shutting them down is really helpfull when you
are ...
Il y a 6 ans
-
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...
Il y a 6 ans
-
UKOUG London Development and Middleware event - free!
-
The Oracle development landscape is an extremely broad and complicated one
these days. It covers such a wide range of tools, technologies and
practices it ...
Il y a 6 ans
-
Strange sessions hang with waits on Latch: Undo Global Data
-
Just a quick note for those who may face the same issue 😉 Situation was
progressed like this: a lot of sessions waits for Latch: Undo Global Data
with loc...
Il y a 6 ans
-
Thoughts on the Oracle ACE Program
-
Four years ago during ODTUG KScope14, I was designated as an Oracle ACE in
the area of Database Development. Vikki Lira, who ran the ACE program at
the tim...
Il y a 6 ans
-
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...
Il y a 6 ans
-
The Oracle Active Session History (ASH) - a real treasure trove
-
When Oracle introduced the Active Session History (ASH) a new gate of
tuning and monitoring options was opened. Yes we had statspack, extended
tracing and...
Il y a 6 ans
-
N.R. Narayanamurthy, Ajith Narayanan, Bulgaria, Sofia, Istanbul, India -
What's the link?
-
This blogpost was again long pending one, but I was not sure on how to
write this non technical real life experience as a blogpost, as I used to
write o...
Il y a 6 ans
-
Failover with Amazon Aurora PostgreSQL
-
https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/
Advertisements
Il y a 6 ans
-
Duplicate database to a diferent server
-
Prepare OLD database cd $ORACLE_HOME/dbs; cp orapwDBNAME
orapwDBNAME.beforemigration
orapwd file=/oracle/DBNAME/12102/dbs/orapwDBNAME sysdg=yes sysbackup=y...
Il y a 6 ans
-
List_comprehension
-
if True A else B :
List Comprehension
Il y a 6 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder
-
While the quick start wizards in Visual Builder Cloud Service (VBCS) make
it very easy to create tables and other UI components and bind them to
business...
Il y a 6 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder
-
While the quick start wizards in Visual Builder Cloud Service (VBCS) make
it very easy to create tables and other UI components and bind them to
business...
Il y a 6 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder
-
While the quick start wizards in Visual Builder Cloud Service (VBCS) make
it very easy to create tables and other UI components and bind them to
business...
Il y a 6 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder
-
While the quick start wizards in Visual Builder Cloud Service (VBCS) make
it very easy to create tables and other UI components and bind them to
business...
Il y a 6 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder
-
While the quick start wizards in Visual Builder Cloud Service (VBCS) make
it very easy to create tables and other UI components and bind them to
business...
Il y a 6 ans
-
European Privacy Requirements: Considerations for Retailers
-
When retailers throughout Europe adopt a new set of privacy and security
regulations this week, it will be the first major revision of data
protection gu...
Il y a 6 ans
-
European Privacy Requirements: Considerations for Retailers
-
When retailers throughout Europe adopt a new set of privacy and security
regulations this week, it will be the first major revision of data
protection gu...
Il y a 6 ans
-
5 years
-
I’ve joined Pythian exactly 5 years ago. Back then I was a performance guy,
with no real DBA and operational support experience. I knew enough about
techno...
Il y a 6 ans
-
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...
Il y a 6 ans
-
HDFS: Useful Hadoop Admin Commands
-
HDFS is designed more for batch processing rather than interactive use by
users. The emphasis is on high throughput of data access rather than low
latency...
Il y a 6 ans
-
NEW FEATURES IN ORACLE12C R2 AND ORACLE18C R1
-
*NEW IN ORACLE12C AND ORACLE18C*
Oracle12c R2 Multitenant Container Database Architecture
Oracle12c R2 Database Architecture
*New Features in Oracl...
Il y a 6 ans
-
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...
Il y a 6 ans
-
#OUGN18 by OUGNorway is approaching
-
It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3
of my presentations are ready, all logistics are ready and the other stuff
are r...
Il y a 6 ans
-
#OUGN18 by OUGNorway is approaching
-
It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3
of my presentations are ready, all logistics are ready and the other stuff
are r...
Il y a 6 ans
-
Hotsos Symposium 2018
-
Just a quick note to say I’m doing a couple of talks at this year’s Hotsos
Symposium, which starts next Monday at 8:30AM. It’s not too late to
register. ...
Il y a 6 ans
-
Deep learning, concepts and frameworks: Find your way through the jungle
(talk)
-
Today at OOP in Munich, I had an in-depth talk on deep learning, including
applications, basic concepts as well as practical demos with Tensorflow,
Keras a...
Il y a 6 ans
-
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...
Il y a 6 ans
-
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...
Il y a 6 ans
-
Why Cloud? The reason changed in 2017…twice
-
In 2017, the predominant reason companies considered moving to the Cloud
changed *multiple times*. While the “how” tends to shift frequently, seeing
the “...
Il y a 7 ans
-
Service Contracts Renewal Portal
-
How to setup and use Service Contracts Renewal Portal Date: August 1,
2012Author: Parag Mone0 Comments Overview Renewing service contracts is an
important ...
Il y a 7 ans
-
Cloud Networking Basics for the Non CCNA certified – IP Address
-
As more and more enterprises are migrating their IT deployments to the
Public Cloud, several IT personnel who are not classically trained on
networking the...
Il y a 7 ans
-
Beware of intensive slow query logging when using -
log_queries_not_using_indexes
-
MySQL slow query log is great for identifying slow queries that are good
candidates for optimisation. Slow query logging is disabled by default, but
it is ...
Il y a 7 ans
-
Oracle and the Autonomous Database (a personal perspective from afar)
-
Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…
Il y a 7 ans
-
The power of scripting
-
So your system has a neat automated archive and purge function for your
rolling partitions, driven by the PART_RETENTION table which holds the
table name...
Il y a 7 ans
-
How to Clone Grid Infrastructure binaries for Oracle Server(Standalone)
-
*Yesterday I was applying patch on one of our development servers and
patch on Grid Home failed with space issue and binaries got corrupted.*
*I thought o...
Il y a 7 ans
-
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...
Il y a 7 ans
-
DataGuard FastSync : Define the Redo Transport Mode SYNC NOAFFRIM
-
*FASTSYNC *is a new DataGuard capability available with Oracle Database
12c. The FASTSYNC configures redo transport services for this configuration
member ...
Il y a 7 ans
-
ORDS 17.3 Beta - Introducing REST enabled SQL
-
Download Got get it on the normal ORDS download page
http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html
Versioning ...
Il y a 7 ans
-
InnoDB tablespace Encryption
-
InnoDB tablespace encryption uses a two tier encryption key architecture,
consisting of a master encryption key and tablespace keys. When
an InnoDBtable...
Il y a 7 ans
-
SQL Diag Repository
-
Every once in a while I look around the list of new (fixed) views in the
instance trying to find useful / interesting things to add to SQLd360 and
recently...
Il y a 7 ans
-
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...
Il y a 7 ans
-
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...
Il y a 7 ans
-
acroread on Linux 6
-
As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader
(acroread) allows users to view and print documents in Portable Document
Format (PDF...
Il y a 7 ans
-
12.2 ACFS compression, part I
-
One of the new 12.2 features is the ability to transparently compress ACFS
filesystems.
Compression is enabled using *acfsutil* utility:
[root@raca1 ~]#...
Il y a 7 ans
-
SiteSubtitle
-
has moved to -> http://KARLARAO.WIKI
Il y a 7 ans
-
Oracle Database 12c Release 2 - Long Identifiers
-
Prior to Oracle Database 12c Release 2 have a problem with long identifier
name, for example, in 11.2 version you cannot create long name (max 30
Bytes) t...
Il y a 7 ans
-
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...
Il y a 7 ans
-
Whoa! Release News for PHP OCI8, node-oracledb, Python cx_Oracle, Instant
Client and ODPI-C
-
I'm just catching up on some releases that happened prior/during my
vacation. Here are some things you may have missed tweets on:
-
PHP OCI8 2...
Il y a 7 ans
-
Comment acquérir les compétences nécessaires à la transformation digitale
lorsqu'on est partenaire Oracle
-
Notre vie est de plus en plus interconnectée avec nos appareils. Alors que
les machines sont de plus en plus intelligentes, l'Internet of Things est
appe...
Il y a 7 ans
-
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...
Il y a 7 ans
-
IOUG Collaborate 2017
-
I have a few presentations scheduled in IOUG Collaborate 2017, Las Vegas.
1. Session: 621: RAC Clusterware internals **Date/time: Mon, Apr 03, 2017
(01:30 ...
Il y a 7 ans
-
Oracle Database 12c R2 is in General Availability for On-premise Customers
-
With the announcement of GA for on-premises customers, Oracle Database 12c
R2 is now available everywhere-in the cloud, with Oracle Cloud at Customer,
an...
Il y a 7 ans
-
Object oriented logging
-
It is a very common requirement. You need to be able to log the start and
end of procedure and function calls. You also need to log error and
exception eve...
Il y a 7 ans
-
Oracle Database 12c Release 2 is out and with it Docker build files on
GitHub
-
Oracle just released Oracle Database 12c Release 2 for on-premises Linux
and Solaris.
With the Oracle 12c R2 release Oracle has also released the latest ...
Il y a 7 ans
-
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...
Il y a 7 ans
-
Announcing the 2016 PL/SQL Challenge Championship for Database Design
-
In 2016, 340 people answered 6,185 quizzes in the Database Design quiz on
the PL/SQL Challenge. I'm pleased to see so many people taking an interest
in h...
Il y a 7 ans
-
The Relational Data Model
-
Mid-eighties. I was studying Computer Science. Little did I know back then
that this thing called "The Relational Data Model" (RDM) would become huge
in th...
Il y a 7 ans
-
“library cache lock” waits from many concurrent DBMS_JOB.submit() operations
-
I have faced performance issue on one of production database in banking
environment. From AWR report I found that “library cache lock” as the top
wait ev...
Il y a 7 ans
-
Setting up Transport Layer Security/Secure Sockets Layer for Managed ODP.NET
-
*[I was chatting with ODP.NET product manager, Alex Keh, and he let me know
about some known issues that developers currently face when using managed
ODP...
Il y a 7 ans
-
Book on Oracle 12c New features
-
A Book on Oracle 12c New features for administrators Hi All, It’s our
pleasure to announce the availability of our first book – OCP 12c upgrade
1Z0-060 Exa...
Il y a 8 ans
-
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...
Il y a 8 ans
-
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...
Il y a 8 ans
-
Oracle back-port patches for Adaptive performance issues released for 12.1
(dynamic stats)
-
Previously I wrote about performance issues with 12.1 Adaptive features,
specifically the large number of dynamic statistics checks, usually
triggered by t...
Il y a 8 ans
-
Performance aspects of APEX reports
-
As this post appears, I'm presenting on this subject for the Dutch Oracle
User Group OGh. This blog post won't contain as much detail as the
presentation i...
Il y a 8 ans
-
Oracle CX Partner Enablement Summit – North America
-
Join us at the Oracle Headquarters in Redwood Shores, CA to continue to
develop your CX practices and solutions based on Oracle’s CX Platform
proposition...
Il y a 8 ans
-
#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...
Il y a 8 ans
-
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...
Il y a 8 ans
-
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...
Il y a 8 ans
-
Segment Statistics
-
rem******************************************************** rem Show
Segments with the highest Lock waits rem André Karlsson rem
https://www.protractus.com...
Il y a 8 ans
-
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...
Il y a 8 ans
-
Database Olympics - Training for the Medals?
-
I will admit, I have been inspired by watching the Olympics. The work,
training and even reinventing that the athletes do to be successful at the
competiti...
Il y a 8 ans
-
ORA-00600 [2663], [12], ....
-
After not having spotted ORA-00600 for a while a new one showed up.
ORA-00600: internal error code, arguments: [2663], [12], [3665664941],
[12], [38847178...
Il y a 8 ans
-
The User Experience (UX) Lab: Onsite Usability Testing at OpenWorld
-
Heading to Oracle OpenWorld? The Oracle Applications User Experience (OAUX)
team will be hosting the usability lab at Oracle’s largest conference of
the ...
Il y a 8 ans
-
Critical Patch Update for July 2016 Now Available
-
The Critical Patch Update (CPU) for July 2016 was released on July 19, 2016
and Oracle strongly recommends applying the patches as soon as possible. A
good...
Il y a 8 ans
-
R12.2 CUSTOM APPLICATION/TOP
-
STEP1: Download Patch 3636980 “Support Diagnostics (IZU) patch for AD
Splice” from My Oracle Support. STEP2: Manually copy the three .txt files
from the 36...
Il y a 8 ans
-
SQL Joins
-
Codeproject has this image which explains the simple basics of SQL joins,
taken from: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx
Il y a 8 ans
-
“ASH math” of time_waited explained with pictures and simulation
-
As explained by John Beresniewicz, Graham Wood and Uri Shaft in their
excellent overview ASH architecture and advanced usage, avg(
v$active_session_history...
Il y a 8 ans
-
zabbix dbsyncers and caching for log items - in version 3.0.1
-
I am using zabbix for about a year now and it still has not shown me all
power that is inside. One of the things that is very interesting to know
more ab...
Il y a 8 ans
-
RAC Installation Step by Step
-
Hi All, Please find the below link for RAC installation document for
reference. Click here for RAC Installation doc link Cheers, Sachin
Il y a 8 ans
-
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...
Il y a 8 ans
-
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 ...
Il y a 8 ans
-
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 ...
Il y a 8 ans
-
Formation Performance Oracle à Genève le 18 mai 2016
-
Une journée de formation Performance Oracle est organisée par le Swiss
Oracle User Group le 18 mai 2016 à Genève.
http://www.developpez.net/forums/blogs/19...
Il y a 8 ans
-
Help Celebrate One Million Answers at the PL/SQL Challenge!
-
*Sometime* in the next couple of months, someone will submit the
1,000,000th answer on the PL/SQL Challenge.
And Chris Saxon, member of the AskTom Answer...
Il y a 8 ans
-
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...
Il y a 8 ans
-
Weblogic and Oracle HTTP Server install with /tmp
-
Lately I have had to install Weblogic 12.1 and OHS 12.1 on a Linux server
in silent mode.
Somehow, there was very small space left on the default temporary...
Il y a 8 ans
-
Denodo Server - Setup & configure Cache Database to MySQL:
-
*Denodo Server - Setup & configure Cache Database: - Bottlenecks*
*Step1: *
Install the Denodo Server by clicking the executable and follow the steps
wit...
Il y a 8 ans
-
Client support for WITH using PL/SQL
-
My employer has been using 12c for about a year now, migrating away from
11gR2. It's fun working out the new functionality, including wider use of
PL/SQL.
...
Il y a 8 ans
-
Restoring and Recovering the Database on a New Host using RMAN
-
This blog will demonstrate detailed steps to restore a database on New Host
using RMAN. You can also use it to move a production database to new host
as...
Il y a 8 ans
-
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...
Il y a 8 ans
-
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...
Il y a 8 ans
-
Point In Time Recovery Using Binlog In MySQL-Part 1
-
Lets see how we can recover our database or tables using MySQL Binary logs.
To avail this feature make sure that BINARY LOGS are enabled in MySQL.Here
We ...
Il y a 8 ans
-
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...
Il y a 8 ans
-
ODI Interface'lerinde çalışma süresiyle ilgili performans iyileştirmeleri
-
Merhabalar,
Bir önceki yazımda ODI Uygulama Performans İyileştirme calısmasına ek
olarak ,du yazımdada ODI üzerinden yapılan geliştirmelerde yaşanılan
per...
Il y a 8 ans
-
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...
Il y a 9 ans
-
Giúp nam giới điều trị ung thư tinh hoàn bằng nấm lim xanh
-
Ung thư tinh hoàn là một căn bệnh chỉ xuất hiện ở nam giới liên
quan đến chức nắng sinh sản. Căn bệnh này có thể xuất hiện ở bất kỳ độ tuổi
nào...
Il y a 9 ans
-
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...
Il y a 9 ans
-
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 ...
Il y a 9 ans
-
How to Find the Optimal Configuration for Your Virtualized Environment
-
Thanks to the New York Oracle User Group for allowing me to present and to
all who attended for their valuable questions and comments. The
presentation sho...
Il y a 9 ans
-
-
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...
Il y a 9 ans
-
ACCESSIBLE BY clause versus Function Based Indexes
-
Oracle introduced the ACCESSIBLE BY clause in 12c to improve the security
of subrograms. Basically the scenario is following: Let’s create a tax
stored fun...
Il y a 9 ans
-
DOAG 2015: Best of Oracle Security 2015
-
Yesterday I gave my yearly presentation “Best of Oracle Security 2015” at
the DOAG 2015 conference in Nürnberg. In this presentation I
showed different Ora...
Il y a 9 ans
-
Things Be-a-Changin' - "OTN Garage" Will be Called "OTN Systems Hub" Very
Soon!
-
Oracle OpenWorld 2015 | OTN Systems Hub
Hi Y'all,
As I have mentioned a few months ago, the *OTN Garage* name will be
changing to *OTN Systems Hub*. Thi...
Il y a 9 ans
-
Database Link between Oracle Database and SQL Server Database
-
Here is link of this post Database Link between Oracle Database and SQL
Server Database This site moved to dbacatalog.blogspot.com please
visit dbacatalog....
Il y a 9 ans
-
Oracle APEX 5.0.2 now available
-
Oracle Application Express 5.0.2 is now released and available for
download. If you wish to download the full release of Oracle Application
Express 5.0.2, ...
Il y a 9 ans
-
Exadata Upgrade
-
Hi,
Recently we have upgraded our Exadata from 11.2.2.3.2 to 12.1.1.1.2
I am mentioning the steps in brief kindly return to MOS Doc ID 888828.1 for
full d...
Il y a 9 ans
-
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...
Il y a 9 ans
-
Automation for DBA - Vagrant part 2
-
Hello,
In the last post I presented steps to create Virtual Machine using Vagrant
with Virtual Box. It is a native combination but there are other
possib...
Il y a 9 ans
-
Exadata 12.1.2.2.0 Software is Released
-
Good new features announced, such as finding Flash Cache and Flash Log
statistics on AWR, automatic ASM data redundancy check even shutting down a
storage ...
Il y a 9 ans
-
Using the Spark Event Timeline
-
Source: Using the Spark Event Timeline
Il y a 9 ans
-
db file scattered read, db file sequential read & direct read wait events
explanation
-
As Oracle DBA's we come across these wait events in most environments. We
will discuss their definitions and see what we can do to reduce them.
*db file sc...
Il y a 9 ans
-
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...
Il y a 9 ans
-
Make Your Nominations: Oracle Database Developer Choice Awards
-
I Did. You Should. Here's the Nomination Form. Here's Why:
The Oracle Database Developer Choice Awards celebrate and recognize
technical expertise and ...
Il y a 9 ans
-
Oracle University Provides the Best Test Fests
-
Oracle University Certification Exams Are once again available at Test
Fests at various events. Last year at the TECH14 and APPS14 conferences,
the UK Orac...
Il y a 9 ans
-
Oracle University Provides the Best Test Fests
-
Oracle University Certification Exams Are once again available at Test
Fests at various events. Last year at the TECH14 and APPS14 conferences,
the UK Orac...
Il y a 9 ans
-
Patient-Centered Chronic Care Plan
-
In January 2015, the Centers for Medicare and Medicaid (CMS) announced a
new initiative: Chronic Care Management (CCM). CCM is intended to assist
clinici...
Il y a 9 ans
-
Windows 10 and E-Business Suite
-
Tomorrow (July 29, 2015) we will see the release of Windows 10 into the
wild. PC's all over the world that aren't under "enterprise control" have
been si...
Il y a 9 ans
-
Frequently asked questions about Nashorn and Node.js
-
During many of my talks about Nashorn, Node.js on the JVM and related
topics, I frequently get asked these kinds of questions and I'd like to try
to give s...
Il y a 9 ans
-
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’...
Il y a 9 ans
-
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started,
and Go-Live Checklist
-
This link helps you plan your move to Oracle E-Business Suite Release 12.2,
providing the following resources: An in-depth Oracle E-Business …
Continue rea...
Il y a 9 ans
-
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...
Il y a 9 ans
-
Monitoring Oracle GoldenGate Latency
-
Today I've implemented an approach to monitor OGG latency. Here I will
describe what I've done.
*1. Create a table gg_latency in source and target databa...
Il y a 9 ans
-
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...
Il y a 9 ans
-
How to Relocate the MySQL Binary Logs to New Location
-
The binary logs are created in the data directory by default in MySQL
Server.
To have the binary logs in the data directory is not always the optimal
l...
Il y a 9 ans
-
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/.
...
Il y a 9 ans
-
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
Il y a 9 ans
-
Top Challenges in the Life of an IT Capacity Manager
-
Let me first confess. I don’t have double-digit years of experience in IT
Capacity Management. But I would say, during last 9 years I have defined
the proc...
Il y a 9 ans
-
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...
Il y a 9 ans
-
Maintaining Tempfile in TEMP Tablespace of PDB$SEED in Oracle 12c (12.1.0.2)
-
During testing recovery procedures for one of the ongoing projects I
wanted to test the "complete disaster" recovery scenario. In this scenario
I had to r...
Il y a 9 ans
-
How To Approach Different Oracle Database Performance Problems
-
This page has been permanently moved. Please CLICK HERE to be redirected.
Thanks, Craig. How To Approach Different Oracle Database Performance
Problems J...
Il y a 9 ans
-
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 ...
Il y a 9 ans
-
Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup
-
If you missed my January 13th webinar entitled "Find it. Fix it. Real-World
SQL Tuning Cases" you can now access the recording and download the
presentatio...
Il y a 9 ans
-
Shifting IT to scale
-
While some IT groups are fine tuning their practices, many others are
still on the journey to achieve greater efficiency at scale. Not all can
make this s...
Il y a 10 ans
-
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...
Il y a 10 ans
-
Shrink a datafile, when ALTER TABLESPACE COALESCE is not working.
-
In a 11.2.0.3 database, we tried to reclaim space from USERS tablespace.
We faced a problem.
We use the following query to the the end of a particular USERS'...
Il y a 10 ans
-
-
What To Do If A Concurrent Request Is Inactive With No Manager Status?
APPLIES TO: Oracle Concurrent Processing - Version 11.5.10.0 to 12.2
[Release 11.5 ...
Il y a 10 ans
-
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 ...
Il y a 10 ans
-
GoldenGate Active-Active replication using CONFLICTRESOLUTION
-
*Source*
*Target*
*Database Version*
11.2.0.4
11.2.0.4
*OS Version*
OEL 6 – 64 Bit
OEL 6 – 64 Bit
*OGG HOME*
/u01/GG/training/source
/u01/GG/training
*Go...
Il y a 10 ans
-
Testing 123
-
This is is testing message. Pls ignore.
Il y a 10 ans
-
How to encrypt the data (tablespace or column's table) using a software
keystore previously known as Oracle Wallet
-
To create a standard Oracle wallet and then add a master key to it you have
to follow few basic steps:
*1) Configure the sqlnet.ora file to define a file sy...
Il y a 10 ans
-
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...
Il y a 10 ans
-
_direct_read_decision_statistcs_driven, _small_table_threshold and direct
path reads on partitioned tables in 11.2.0.3 (Part 2)
-
This is continuation of my last post regarding direct path reads on
partitioned tables in Oracle 11.2.0.3.
To recap, the behavior I observed is that direc...
Il y a 10 ans
-
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...
Il y a 10 ans
-
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...
Il y a 10 ans
-
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...
Il y a 10 ans
-
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...
Il y a 10 ans
-
Cluster Definition
-
In Oracle, *clustering* is a way of ordering the physical placement of
tables on a disk drive in such a way as to speed up I/O access times. This
is accom...
Il y a 10 ans
-
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...
Il y a 10 ans
-
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@...
Il y a 10 ans
-
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...
Il y a 11 ans
-
Yeni Blog
-
Kendime ait blog adresim http://zekeriyabesiroglu.com . Bundan sonraki
yazılarımı http://zekeriyabesiroglu.com den takip edebilirsiniz.
Teşekkürler.
Il y a 11 ans
-
-
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...
Il y a 11 ans
-
12C ADG Enhancements
-
- *Explain plan now works on Standby*
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
SQL> selec...
Il y a 11 ans
-
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: ...
Il y a 11 ans
-
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...
Il y a 11 ans
-
The ateamsoab2b blogs have been moved to www.ateam-oracle.com
-
The A-Team has a new web site: The A-Team Chronicles
All of our articles and posts from various locations, including this site,
have been consolidated th...
Il y a 11 ans
-
Aggregated Lists: Creating Aggregated List Strings - ListAgg() Function.
-
Oracle's ListAgg() Function -- Or Other Methods.
Given the following sample data shown below, we want to aggregate the
elements into a single, comma sep...
Il y a 11 ans
-
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 ...
Il y a 11 ans
-
Some Of Basic Questionnaire For Newly Release Oracle Database 12c
-
1) What is an Pluggable database really?
Ans-> This is new feature in oracle 12.1 release with respect to database.
With this release there is a parent-c...
Il y a 11 ans
-
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...
Il y a 11 ans
-
ReUse flag in PeopleSoft AE program – Bind variable issue and its impact on
Performance
-
It has been long since I blogged as I got busy. Personally I became a
Father and officially, I moved to PeopleSoft Performance and Benchmark(P&B)
team. N...
Il y a 11 ans
-
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...
Il y a 11 ans
-
Little Changed
-
Incredible and depressing to see people still getting Oracle internals as
wrong as this.
Il y a 11 ans
-
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...
Il y a 11 ans
-
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...
Il y a 11 ans
-
SQL 2008 Active-active cluster on windows 2008 R2 Share storage migration
-
This is my POC doc before we migrate our production sql 2008 cluster to new
storage. it has two parts: first part simply install the cluster on 2 ESX
VM im...
Il y a 11 ans
-
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 ...
Il y a 12 ans
-
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...
Il y a 12 ans
-
E-Business Suite R12 integration with Oracle Identity Management 11g
-
After successful implementations of Oracle SSO 10g with Oracle E-Business
Suite 11i and R12, I have now completed an installation and implementation
of th...
Il y a 12 ans
-
GoldenGate error OGG-01755 SQL error: OCI Error 26,723 = ORA-26723
-
I was trying to register extract OGG v 11.2 on one of my dev servers GGSCI
(tpadldb10.gratiscard.com) 1> dblogin userid srvegate password xxxxx
Successfu...
Il y a 12 ans
-
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 ...
Il y a 12 ans
-
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: ...
Il y a 12 ans
-
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...
Il y a 12 ans
-
An introduction to SQL Tuning : Basic Optimizer Operations
-
An introduction to SQL Tuning : Basic Optimizer Operations.
Setup SQL Tuning sample schema
1. Full Table scan
2. Index Fast Full scans
3. Index Full sc...
Il y a 12 ans
-
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...
Il y a 12 ans
-
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...
Il y a 12 ans
-
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 '%...
Il y a 12 ans
-
Blogging
-
I will now be blogging mostly over at the venerable blog of my employer,
Rittman Mead. You can see my first posting here: Web Services in BI
Publisher 11g....
Il y a 13 ans
-
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...
Il y a 13 ans
-
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...
Il y a 13 ans
-
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...
Il y a 13 ans
-
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...
Il y a 13 ans
-
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...
Il y a 14 ans
-
Materialized View
-
+++++++++++++++++++++++++++++++++++++
MVIEW refresh Status on MASTER Site :
+++++++++++++++++++++++++++++++++++++
set pages 1000
set linesize 180
col SNAPSHO...
Il y a 14 ans
-
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 ...
Il y a 14 ans
-
Composite Interval Partitioning isn't as advertised.
-
Oracle® Database VLDB and Partitioning Guide 11g Release 1 (11.1) Part
Number B32024-01 says:
Interval Partitioning
Interval partitioning is an extensi...
Il y a 14 ans
-
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...
Il y a 15 ans
-
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...
Il y a 15 ans
-
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 ...
Il y a 15 ans
-
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 ...
Il y a 16 ans
-
★ 5 Links from Around the Web (2007-04-10)
-
Links to interesting, educational, informational, or just plain fun
websites...
Il y a 17 ans
-
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...
Il y a 18 ans
-
Difference between SCN and checkpoint.
-
SCN and checkpoint:
System change number(SCN) is represented with SCN_WRAP and SCN_BASE.
Whenever SCN_BASE reaches 4294967290 (2 power 32), SCN_WRAP goes u...
Il y a 18 ans
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Move and improve your application on Oracle Autonomous Database and Oracle Cloud Infrastructure
- Generate SSH Keys
- Generate Auth Token
- Create Virtual Cloud Network
- Create Computes
- Create Autonomous Database
- Copy SSH Key and Wallet
- Install the Application and Migrate the Database
- Run the Application Workload
- Manage Storage Volumes and Images
Aucun commentaire:
Enregistrer un commentaire