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 3 heures
-
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 4 heures
-
Create a Free Local AI Dungeon Game with Ollama
-
This video shows how to create a dungeon and dragon game with help of
local models with Ollama easily.
Code:
conda create -n ai python=3.10 -y && con...
Il y a 1 jour
-
Duwamish Trail Cleanup – Saturday, December 7, 2024
-
Who? You! Anyone can help if you can spend a bit of time and muscle power.
Whether you like to bike, walk, or just happen to drive by the trail and
see oth...
Il y a 1 jour
-
Your local development environment: Oracle Database 23ai Free on WSL2
-
Recently I posted a few tweets about my experience developing on windows.
That’s something new to me, typically I’d use either Linux or MacOS. Some
of you ...
Il y a 1 jour
-
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 2 jours
-
Optimizer Environment 2
-
Many years ago I wrote a short note to introduce the view
v$sql_optimizer_env (and the session and system equivalents) which report
the current values of o...
Il y a 3 jours
-
APEX Office Hours Building Low-Code SaaS App Extensions with Oracle APEX
Recording
-
When the recording will be available for APEX office hours 7th November
2024 Building Low-Code SaaS App Extensions with Oracle APEX?
Il y a 3 jours
-
Audit ALTER USER Inconsistent Issue in Unified Audit Trail
-
If you use still or used standard auditing in the Oracle database then you
should have come across an issue. If you have multiple teams enabling audit
one ...
Il y a 3 jours
-
Avoid using Set for bidirectional JPA OneToMany collections
-
Introduction In this article, we are going to see why there is no benefit
in using the Set collection type when mapping a bidirectional JPA OneToMany
ass...
Il y a 5 jours
-
Oracle Doesn’t Look Good – 23ai TBA
-
I have to say that Oracle Corporation is not looking like a company that
knows what its doing. At least when it comes to getting Oracle 23ai shipped
out th...
Il y a 5 jours
-
PeopleSoft PS/Query: Finding Users' Cartesian Joins
-
Many PeopleSoft users like its ad hoc query tool because they can write
their own queries directly on the system, without having to learn to write
struct...
Il y a 6 jours
-
My First Decade in the International Oracle Community
-
Exactly ten years ago, in November 2014, I gave my first presentation at a
conference outside my country and not in my native language. At that point,
I ...
Il y a 6 jours
-
New Oracle User Group ora2know – not DOAG
-
What is ora2know? One week ago, on November 18, 2024 we founded ora2know,
the new German Oracle User Group. The focus of the new group is the Oracle
Databa...
Il y a 6 jours
-
Validate an image file using ImageMagick
-
If you ever want to check whether an image file is valid or has been
corrupted, you can use ImageMagick to do so. ImageMagick is available for
Mac OS X via...
Il y a 6 jours
-
Using Oracle's Autonomous Health Framework to get an "Insight" into a RAC
Cluster
-
I've posted a video demonstration on using Oracle's Autonomous Health
Framework ("AHF") get an "Insight" into a RAC Cluster.
AHF (Oracle Support Doc ID...
Il y a 1 semaine
-
We did {insert item} and it failed!
-
During my DevOps and automation journey I saw lots of posts and videos
proclaiming that DevOps is rubbish because it failed. Recently my YouTube
recommen...
Il y a 1 semaine
-
Oracle 23ai - Converged Database, playing with images and text
-
TL;DR: Investigating the use of VECTORs in Oracle 23ai, I stumble across
all kind of (python) models. Some of those, pre trained, models think they
can ...
Il y a 1 semaine
-
Information schema hands-on
-
Preamble Information Schema is a database accessible on all MariaDB/MySQL
instances that provide access to instance metadata: Information about the
Maria...
Il y a 1 semaine
-
All together in no man's land
-
by Eamonn McCormick & Jason Libersky
So many of us feel like we are in no man's land. The world we knew seems to
be crumbling around us, leaving us unce...
Il y a 1 semaine
-
Oracle Architecture – Bridging the Old to the New
-
I’m passionate about making technology easier to understand, a mission I’ve
pursued on my blog since 2008. However, I’ve faced
Tags: oracle
Del.icio.us
F...
Il y a 1 semaine
-
Oracle LiveSQL, free SQL/DB (23ai!), no sign-up required
-
It's that much easier to get started learning SQL and Oracle Database with
our new and improved Oracle LiveSQL platform! Now running 23ai!
The post Oracl...
Il y a 1 semaine
-
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 semaine
-
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 semaine
-
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 2 semaines
-
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 2 semaines
-
SQL CONNECT BY Example
-
SQL CONNECT BY Example There is a table 'emp' with the data as shown below:
Table has data for 4 employees. A has no manager. B and C's manager is A.
D's m...
Il y a 2 semaines
-
APEX tip of the day: translate tooltip when TITLE = "some text" is added to
the link attributes of a IR report column
-
The "link attributes" of an interactive report allows a developer to
specify additional attributes for a column displayed as a link in a
interactive repo...
Il y a 2 semaines
-
Using the PL/SQL Profiler in the Oracle Autonomous Database
-
The PL/SQL (Hierarchical) Profiler has been part of the Oracle database for
quite some time but there is very little, close to none, information on how
to ...
Il y a 2 semaines
-
Using the PL/SQL Profiler in the Oracle Autonomous Database
-
The PL/SQL (Hierarchical) Profiler has been part of the Oracle database for
quite some time but there is very little, close to none, information on how
to ...
Il y a 2 semaines
-
Oracle Hot Topics- 13-NOV-2024
-
Bugs
Bug Product Area Bug ID Last Updated
ORA-00600:[KRFBDORESETLOGS-2] ON FLASHBACK TO RESETLOG'S TIMESTAMP
Oracle Database - Enterprise Edition BUG ID...
Il y a 2 semaines
-
UPDATE SET ROW – Convenience Might Be Costly
-
A cool feature in PL/SQL is the ability to perform common DML operations
without needing to reference the individual columns of a table. The ability
to do ...
Il y a 2 semaines
-
UPDATE SET ROW – Convenience Might Be Costly
-
A cool feature in PL/SQL is the ability to perform common DML operations
without needing to reference the individual columns of a table. The ability
to do ...
Il y a 2 semaines
-
-
pre-post check script
-
#######################################################
#!/bin/ksh
# set the DB env and run
# Script to check PRE & Post checks Manually
#
# CB - -...
Il y a 3 semaines
-
SAFE Exam Practice Test
-
1) What is the act of persuading home owners to sell their homes at bargain
prices mentioning that certain ethic groups will migrate to the particular
neig...
Il y a 4 semaines
-
Connecting To Pluggable Database as SYSDBA
-
In Oracle container database architecture when you connect by default using
bequeath protocol as SYSDBA you will connect against CDB$ROOT. Is there a
way t...
Il y a 4 semaines
-
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 4 semaines
-
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 4 semaines
-
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 4 semaines
-
-
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 1 mois
-
Display JSON in APEX using APEX_MARKDOWN and JSON_TRANSFORM #JoelKallmanDay
-
Markdown is a plain text format for writing structured documents, and in
APEX there is a built-in package that can transform Markdown notation into
HTML....
Il y a 1 mois
-
PL/SQL vs. JavaScript in the Oracle Database 23ai #JoelKallmanDay
-
JavaScript is the first language supported by the Multilingual Engine (MLE)
in Oracle Database 23ai. Having additional languages in the Oracle Database
a...
Il y a 1 mois
-
Learning by letting others workout in the Gym - #JoelKallmanDay
-
This year I'm on the road for Joel Kallman Day, speaking at POUG 2024, AOUG
(EMEA tour 2024), HrOUG 2024 and DOUG Day 2024. But when it's Joel Kallman
Da...
Il y a 1 mois
-
Upgrading Forms compared to APEX #JoelKallmanDay
-
My current project has involved rebuilding the entire aging stack for an
environment that's currently 95% Forms, with any new work developed in
Oracle AP...
Il y a 1 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 1 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 1 mois
-
Mastering Realtime Data: How I Topped the Leaderboard at PyData
-
Two weeks ago I went to PyData Amsterdam which kicked off with a tutorial
day. These tutorials included a workshop on creating multi-modal LLM
agents, ad...
Il y a 2 mois
-
identify the character set of a Data Pump file
-
many times have a need to get information how export (dmp) file was created
(what nls setup). The following PL/SQL code enables you to identify the
charact...
Il y a 2 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 2 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 2 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 2 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 2 mois
-
Speaking At Oracle CloudWorld
-
For the first time in a few years I’ll be speaking at Oracle’s annual
conference! I’m doing a joint session w/ a couple of the good guys from
Oracle (Nages...
Il y a 2 mois
-
Public Speaking Advice
-
There was a post on the best public speaking advice with a video, have a
look: https://twitter.com/AnnieAndrewsMD/status/1828046910986313933 I
thought it’s...
Il y a 3 mois
-
Особенности ASH против статистики V$SQLSTATS при использовании SQL Profile
для фиксации планов выполнения
-
После не очень удачной попытки фиксации очевидно более лучшего плана с
помощью SQL Profile: , наблюдал странность отображения выполнения запроса
(из генери...
Il y a 3 mois
-
Excluding / ignoring sensors in node_exporter
-
I like to use the Prometheus node_exporter to get metrics about my
hardware. However some hardware (such as my X300M-STX mainboard) exposes
sensors with so...
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 4 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 4 mois
-
PostgreSQL 17 : des sauvegardes incrémentales avec pg_basebackup
-
Bonjour Les 11 et 12 juin derniers, nous étions aux journées PGDAY à
Lille pour découvrir les nouveautés autour de PostgreSQL. Cette conférence
regroup...
Il y a 4 mois
-
New for 2024 - The Kscope100 (Positions 1-10)
-
So who is really responsible for the success of Kscope24? Is it your
Kscope Executive Officer? Not a chance. Your ODTUG President? Not single
handedly, ...
Il y a 4 mois
-
csv Data to Rows - SQL
-
If you have a data with Comma, or any other character delimited use the
following query to convert it to individual rows.-- Created on 03/07/2024
by ANANT...
Il y a 4 mois
-
SELECT AI ! Generative AI on Autonomous Database
-
Imagine, we communicate with our Database in Business Language and Database
responding with a result that matches the Business criteria. Natural
Language P...
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 5 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 5 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 5 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 5 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 6 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 6 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 6 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 6 mois
-
Running Llama3 model inference on Intel CPU and Intel GPU (1)
-
Introduction On April 18, 2024, Meta released Llama 3, the latest and most
capable Open source large language model (LLM) model, which is a major
leap ov...
Il y a 7 mois
-
Running Llama3 model inference on Intel CPU and Intel GPU (1)
-
Introduction On April 18, 2024, Meta released Llama 3, the latest and most
capable Open source large language model (LLM) model, which is a major
leap ov...
Il y a 7 mois
-
Building an Apache Spark Performance Lab: Tools and Techniques for Spark
Optimization
-
Apache Spark is renowned for its speed and efficiency in handling
large-scale data processing. However, optimizing Spark to achieve maximum
performance r...
Il y a 7 mois
-
SQL table macros 14: parameterized views
-
Developers like to reuse code. In SQL, views are reusable queries with lots
of advantages, but one drawback: no parameters to limit the queries to only
tho...
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 7 mois
-
-
How to Detect and Repair Corruption in Your Oracle Database
-
The *DBMS_DICTIONARY_CHECK* is a read-only and lightweight PL/SQL package
procedure that helps you identify Oracle Database dictionary
inconsistencies th...
Il y a 8 mois
-
Moh_Create Standby DB
-
------------------------------------------------------------------------------------------------------------------------------------------
-- Prepare the ...
Il y a 9 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 10 mois
-
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 11 mois
-
APEX application to display tablespace usage of databases registered in an
Oracle Enterprise Manager installation
-
This is an APEX application (created with APEX 23.2) to present tablespace
usage data, retrieved from your OEM 13c. It uses *spaceUsed*, *bytesFree *an...
Il y a 11 mois
-
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 11 mois
-
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 11 mois
-
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...
Il y a 1 an
-
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...
Il y a 1 an
-
Oracle 19c RU Release Update 19.19 nice little enhancement:
DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated
-
I've recently found out by coincidence a nice little enhancement that
apparently was introduced with the 19.19 Release Update - a backport of the
fix tha...
Il y a 1 an
-
Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay
-
It’s Joel Kallman Day again. And we still miss him dearly. A place Joel
loved was Israel, and especially Jerusalem. …
Continue reading →
Il y a 1 an
-
Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay
-
It’s Joel Kallman Day again. And we still miss him dearly. A place Joel
loved was Israel, and especially Jerusalem. …
Continue reading →
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
-
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...
Il y a 1 an
-
How Slow Programs Are Like Christmas: a Sales Pitch
-
My company, Method R Corporation, makes systems faster. And we make people
who make systems faster, faster. We train people to become performance
optimiz...
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
-
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...
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
-
Pluggable databases ignores SAVE STATE / is always opened in READ WRITE
-
I noticed a new “feature” on my managed DBAAS Oracle OCI environments, that
whatever I…
Il y a 1 an
-
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, ...
Il y a 1 an
-
Protected: First Personal Notes
-
There is no excerpt because this is a protected post.
Il y a 1 an
-
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...
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 1 an
-
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 1 an
-
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...
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
-
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...
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
-
Microsoft Azure Virtual Training Day:DevOps with GitHub
-
I am starting to take some Microsoft training and this was the first one I
tried. I thought it would be a good way to get familiar with how Git is
integrat...
Il y a 2 ans
-
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;
...
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
-
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 ...
Il y a 2 ans
-
Analytical SQL - Running Total - Order by without Partition By
-
Welcome to the third post on the series Analytical SQL. In the first two
posts we studied
1. Analytical Function without Window Clause
2. Analytica...
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
-
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 ...
Il y a 2 ans
-
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...
Il y a 2 ans
-
Creating a SQL Patch with Many Hints Requires a Hack
-
In the past, when I created a SQL patch, I always specified a small number
of hints. Last week, for the first time, I created one with more than 100
of the...
Il y a 2 ans
-
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...
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 2 ans
-
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 yea...
Il y a 3 ans
-
PostgreSQL HA - Patroni, ETCD, HAProxy, Keepalived - Test failure scenarios
-
I will test few failover/maintenance scenarios and show results in this
blog post.
Just to mention, this is *not* proper production test. Before consideri...
Il y a 3 ans
-
100k views Thanks everyone Happy learning
-
100k views !! Thanks everyone! Happy learning!!
Il y a 3 ans
-
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,...
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
-
OAC 6.3 Features | Difference between OAC6.2 and OAC6.3 | Features of
OAC6.3 | Oracle Analytics Cloud
-
The OAC 6.3 version is getting released. When comparing to OAC 6.2, below
mentioned are the new features or enhancements in OAC 6.3
1 General1.1 ...
Il y a 3 ans
-
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...
Il y a 3 ans
-
Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of
Statistics
-
This blog post is inspired by Jesper's recent blog post on how the
automatic update of InnoDB persistent statistics may never trigger if
servers are rest...
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
-
Azure host-caching with Oracle database workloads on Azure VMs
-
There are almost 2,000 Azure customers running Oracle database workloads on
Azure VMs, and that number is growing rapidly all the time. Running Oracle
on ...
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
-
-
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 ...
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
-
-
*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...
Il y a 3 ans
-
Investigation on why database doesn’t start after successfully dropping a
diskgroup
-
Few months ago, while performing storage migration I faced an interesting
issue which could lead to potential downtime if I didn’t notice a hidden
warning ...
Il y a 3 ans
-
New Ranking Tags Feature of Oracle Dev Gym
-
You can take quizzes, workouts and classes at the Oracle Dev Gym solely
with the objective of learning and improving your ...
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 3 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 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...
Il y a 4 ans
-
The use and misuse of %TYPE and %ROWTYPE attributes in PL/SQL APIs
-
PL/SQL provides two attributes which allow us to declare a data structure
with its datatype derived from a database table or a previously declared
variable...
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
-
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...
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
-
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...
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
-
A Lifeline for EBS Customers Still on RDBMS 11gR2 and 12cR1
-
Yesterday, the Oracle E-Business Suite Applications Technology Group made a
couple of very significant announcements for E-Business Suite customers.
-...
Il y a 4 ans
-
Oracle Cloud Marketplace GoldenGate Classic Environment
-
To launch Goldengate via GGSCI we need to enter “ggsci” followed by the
“version” -bash-4.2$ which ggsci /usr/local/bin/ggsci -bash-4.2$ ggsci
Usage: /us...
Il y a 4 ans
-
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 ...
Il y a 4 ans
-
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...
Il y a 4 ans
-
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...
Il y a 4 ans
-
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...
Il y a 4 ans
-
Retrieve PostgreSQL variable-length storage information thanks to
pageinspect
-
Introduction In PostgreSQL a variable-length datatype value can be stored
in-line or out-of-line (as a TOAST). It can also be compressed or not (see
the do...
Il y a 4 ans
-
Retrieve PostgreSQL variable-length storage information thanks to
pageinspect
-
Introduction In PostgreSQL a variable-length datatype value can be stored
in-line or out-of-line (as a TOAST). It can also be compressed or not (see
the do...
Il y a 4 ans
-
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. ...
Il y a 4 ans
-
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...
Il y a 5 ans
-
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...
Il y a 5 ans
-
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...
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
-
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
-
Phần mềm quản lý doanh nghiệp là loại phần mềm code khó nhất!
-
Full:
https://codeburst.io/enterprise-software-is-the-hardest-software-to-write-c76d59725f3
Short: https://www.techinasia.com/talk/enterprise-software-hard...
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
-
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
-
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
-
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...
Il y a 5 ans
-
Exadata X8 is here!
-
The Exadata X8 machines are here!
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
-
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 ...
Il y a 5 ans
-
Oracle 12.2 ASM PWFile Recreated in New Disk Group. ASM and GI Doesn’t
Start Anymore
-
Just a small pre story: new Storage Cells were delivered ACS configured new
ASM Disk Groups data and configuration info were moved to new ASM Disk
Groups o...
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 5 ans
-
-
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...
Il y a 5 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 5 ans
-
DOAG conference: Best of Oracle Security – older presentations (2013-2017)
-
Here is a list of older „Best-of“-presentations: Best of Oracle Security
2017 Best of Oracle Security 2016 Best of Oracle Security 2015 Best of
Oracle Secu...
Il y a 6 ans
-
Cloud Security - Prevent DDOS attacks through Memcached
-
Recently, I provisioned a new server and went home for 2 days did not
login, once I was back, I could see around 2.5 lakh failed login attempts
from variou...
Il y a 6 ans
-
#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...
Il y a 6 ans
-
#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...
Il y a 6 ans
-
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...
Il y a 6 ans
-
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...
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
-
Linux CPU stress testing sample script
-
for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 33 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52...
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
-
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...
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
-
Introducing SQLdb360: merging eDB360 and SQLd360, while raising the bar for
community engagement
-
Today, we are very happy to release SQLdb360, a new tool that merges
together eDB360 and SQLd360, under a single package Tools eDB360 and
SQLd360 can still...
Il y a 6 ans
-
Hide the sensitive columns – using $$PLSQL_UNIT_OWNER inquiry
-
Let’s suppose that a table owner (such as HR) wants to create a procedure
that displays all columns for a specific criteria. Later, it wants to share
this ...
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
-
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
-
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...
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
-
Filter predicates with NVL on mandatory columns using the index
-
Last Friday at work, I overheard a conversation between two DBA's about a
performance problem of a job which usually ran in 10 minutes, now taking
more tha...
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
-
-
Nested VM : Oracle VM 3.4.4 on VMWare VSphere Hypervisor 6.5
-
More than 4 years ago, I wrote an article about the same subject, find out
here.
Other time, other software version, slight configuration setting changes.
...
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
-
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...
Il y a 7 ans
-
ORA-28017: The password file is in the legacy format.
-
*Today I was trying to change password for one of my 12c database and got
below error :-*
SQL> alter user dbsnmp identified by "*************"
*
ERROR at ...
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
-
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...
Il y a 7 ans
-
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...
Il y a 7 ans
-
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...
Il y a 7 ans
-
Step by step guide to set up Multi source replication in MariaDB
-
Expectations:
1. You should be knowing how to set up replication in MySQL
2. You have basic knowledge of MySQL components such as binary logs, relay
logs, ...
Il y a 7 ans
-
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]:...
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
-
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...
Il y a 7 ans
-
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...
Il y a 7 ans
-
My NoPlsql versus SmartDB deep-dive presentation materials
-
For those who are interested here are my two slidedecks used in yesterday's
deep-dive session at ODTUG, here they are in ppsx format which includes all
the...
Il y a 7 ans
-
SiteSubtitle
-
has moved to -> http://KARLARAO.WIKI
Il y a 7 ans
-
This site moved to dbacatalog.blogspot.com
-
This site moved to dbacatalog.blogspot.com please
visit dbacatalog.blogspot.com
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
-
12.2 New Feature: Automatically Synchronize Password Files in Oracle Data
Guard
-
A new feature automatically synchronizes password files across Oracle Data
Guard configurations. When the passwords of SYS, SYSDG, and so on, are
changed, ...
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
-
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
-
Sponsored: 64% off Code Black Drone with HD Camera [del.icio.us]
-
Our #1 Best-Selling Drone--Meet the Dark Night of the Sky!
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
-
Funny "ORA-01017: invalid username/password; logon denied" during DataGuard
switchover operation from DG broker
-
Recently one of my customers encountered a problem when they tried to
perform a switchover from DataGuard broker command line interface.
$ dgmgrl /
DGMGRL...
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
-
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...
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
-
cleartext userid and passwords in config fles - how to get rid of them
-
Since ages Oracle has wallets that can be used to store userid and password
configurations for connections in safe way. There are a few rules you need
to...
Il y a 7 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 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
-
Unclean shutdown detected. for mongod process in Arbiter server
-
Following messages were received in “/var/log/mongo/mongod.log” of primary
server and other servers of replicatset
Sat Jul 30 02:48:08.631 [rsHealthPoll] ...
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
-
Database encryption in transit, why is this still a question?
-
As data flows between systems, applications and databases, valuable
information is pass along either internal, external or a combination of
both types of...
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
-
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...
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
-
Redshift~<- Denodo!<-- Tableau!<- TDE -Large Data volume Extracts:
-
*Redshift~<- -large="" data="" denodo="" extracts:="" tableau="" tde=""
u="" volume="">*
1: Creation of Large Extract in Tableau from Data sources with hi...
Il y a 8 ans
-
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...
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
-
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...
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
-
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...
Il y a 8 ans
-
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...
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
-
MariaDB - a surprise dependent subquery execution plan
-
Welcome myself into the MySQL world. While working with MariaDB 10.0.21,
there are two queries as shown below, one uses alias and the other does
not, seems...
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
-
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...
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
-
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...
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 8 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 8 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 8 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 8 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 8 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 8 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
-
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...
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
-
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
-
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
-
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
-
What to consider to set innodb_sort_buffer_size variable ?
-
what to consider when choosing the value to use for the
innodb_sort_buffer_size configuration option.
The innodb_sort_buffer_size option specifies how muc...
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
-
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
-
What Is That Light-Green Oracle Database CPU Wait Time?
-
This page has been permenately moved. Please CLICK HERE to be redirected.
Thanks, Craig.
What Really Is That Light-Green Oracle Database CPU Wait Time?
...
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
-
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 9 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 c...
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
-
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 10 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 10 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 10 ans
-
12C ADG Enhancements
-
- *Explain plan now works on Standby*
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY
SQL> select ...
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
-
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
-
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 11 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 11 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
-
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 13 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
-
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...
Il y a 18 ans
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
HISTORY OF ASH VIEWS
VIEW_NAME
DBA_HIST_ACTIVE_SESS_HISTORY : DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history of recent system activity. This view contains snapshots of V$ACTIVE_SESSION_HISTORY. See "V$ACTIVE_SESSION_HISTORY" for further interpretation details for many of these columns (except SNAP_ID,DBID, and INSTANCE_NUMBER).
DBA_HIST_BASELINE : DBA_HIST_BASELINE displays information on baselines taken in the system. For each baseline, this view displays the complete time range and whether the baseline is the default baseline.
DBA_HIST_BG_EVENT_SUMMARY :
DBA_HIST_BG_EVENT_SUMMARY displays the historical summary background event activity. This view contains snapshots from V$SESSION_EVENT.
DBA_HIST_BUFFERED_QUEUES
DBA_HIST_BUFFERED_SUBSCRIBERS
DBA_HIST_BUFFER_POOL_STAT
DBA_HIST_COMP_IOSTAT
DBA_HIST_CR_BLOCK_SERVER
DBA_HIST_CURRENT_BLOCK_SERVER
DBA_HIST_DATABASE_INSTANCE
DBA_HIST_DATAFILE
DBA_HIST_DB_CACHE_ADVICE :DBA_HIST_DB_CACHE_ADVICE displays historical predictions of the number of physical reads for the cache size corresponding to each row. This view contains snapshots of V$DB_CACHE_ADVICE.
DBA_HIST_DLM_MISC
DBA_HIST_ENQUEUE_STAT
DBA_HIST_EVENT_NAME
DBA_HIST_FILEMETRIC_HISTORY
DBA_HIST_FILESTATXS
DBA_HIST_INSTANCE_RECOVERY
DBA_HIST_INST_CACHE_TRANSFER
DBA_HIST_JAVA_POOL_ADVICE
DBA_HIST_LATCH
DBA_HIST_LATCH_CHILDREN
DBA_HIST_LATCH_MISSES_SUMMARY
DBA_HIST_LATCH_NAME
DBA_HIST_LATCH_PARENT
DBA_HIST_LIBRARYCACHE
DBA_HIST_LOG
DBA_HIST_METRIC_NAME
DBA_HIST_MTTR_TARGET_ADVICE
DBA_HIST_OPTIMIZER_ENV
DBA_HIST_OSSTAT
DBA_HIST_OSSTAT_NAME
DBA_HIST_PARAMETER
DBA_HIST_PARAMETER_NAME
DBA_HIST_PGASTAT
DBA_HIST_PGA_TARGET_ADVICE
DBA_HIST_PROCESS_MEM_SUMMARY
DBA_HIST_RESOURCE_LIMIT
DBA_HIST_ROWCACHE_SUMMARY
DBA_HIST_RULE_SET
DBA_HIST_SEG_STAT
DBA_HIST_SEG_STAT_OBJ
DBA_HIST_SERVICE_NAME
DBA_HIST_SERVICE_STAT
DBA_HIST_SERVICE_WAIT_CLASS
DBA_HIST_SESSMETRIC_HISTORY
DBA_HIST_SESS_TIME_STATS
DBA_HIST_SGA
DBA_HIST_SGASTAT
DBA_HIST_SGA_TARGET_ADVICE
DBA_HIST_SHARED_POOL_ADVICE
DBA_HIST_SNAPSHOT
DBA_HIST_SNAP_ERROR
DBA_HIST_SQLBIND
DBA_HIST_SQLSTAT
DBA_HIST_SQLTEXT
DBA_HIST_SQL_BIND_METADATA
DBA_HIST_SQL_PLAN
DBA_HIST_SQL_SUMMARY
DBA_HIST_SQL_WORKAREA_HSTGRM
DBA_HIST_STAT_NAME
DBA_HIST_STREAMS_APPLY_SUM
DBA_HIST_STREAMS_CAPTURE
DBA_HIST_STREAMS_POOL_ADVICE
DBA_HIST_SYSMETRIC_HISTORY
DBA_HIST_SYSMETRIC_SUMMARY
DBA_HIST_SYSSTAT
DBA_HIST_SYSTEM_EVENT
DBA_HIST_SYS_TIME_MODEL
DBA_HIST_TABLESPACE_STAT
DBA_HIST_TBSPC_SPACE_USAGE
DBA_HIST_TEMPFILE
DBA_HIST_TEMPSTATXS
DBA_HIST_THREAD
DBA_HIST_UNDOSTAT
DBA_HIST_WAITCLASSMET_HISTORY
DBA_HIST_WAITSTAT
DBA_HIST_WR_CONTROL
Aucun commentaire:
Enregistrer un commentaire