Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)
-
How to Implement Tool Use with Command R Plus Model Locally
-
This video is a simple hands-on tutorial to show how to implement Tool Use
with your own data locally by using Cohere Comand R+ model.
Code:
# p...
Il y a 3 heures
-
Create a table out of nothing
-
sql table out of nothing
Il y a 4 heures
-
why view's trigger disappear?
-
Got information from your archives, BUT solution is not provided or there's
no solution??? Archive : "Why the trigger disappears... May 28, 2003
Reviewer: ...
Il y a 4 heures
-
Creating a GraphQL endpoint … within the database
-
GraphQL is protocol agnostic. Most GraphQL is served via HTTP, but there is
nothing wrong with a different format. Why not put a GraphQL endpoint into
the ...
Il y a 5 heures
-
Migrating OAuth2 Clients and maintaining their SECRETs
-
How to move your OAuth2 clients from one Oracle Database to another,
maintaining their associated Client Secrets - with our PL/SQL API.
The post Migratin...
Il y a 20 heures
-
Enabling Cursor Sharing in PeopleSoft Processes
-
One of the challenges that PeopleSoft gives to an Oracle database is that
many processes dynamically generate many SQL statements. They usually have
dif...
Il y a 23 heures
-
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 1 jour
-
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 1 jour
-
#Pickleball Kompaktkurs vom 27. April 2024
-
Gestern fand der 4-stündige Kompaktkurs mit 8 Teilnehmern statt. Hier sind
ein paar Impressionen: Da haben sich wieder einige mit dem Pickleball-Virus
infi...
Il y a 2 jours
-
El parámetro MAX_STRING_SIZE, como aumentar el tamaño a 32K de
almacenamiento en 19c y 23c de las variables VARCHAR2, NVARCHAR2 y RAW
-
En una base de datos Oracle el parámetro MAX_STRING_SIZE controla el tamaño
máximo de los tipo VARCHAR2, NVARCHAR2 y RAW en SQL.
En la versión 19c que act...
Il y a 3 jours
-
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 3 jours
-
Rownum quiz
-
Here’s a silly little puzzle that baffled me for a few moments until I
spotted my typing error. It starts with a small table I’d created to hold a
few rows...
Il y a 4 jours
-
The best way to use the JPA OneToOne optional attribute
-
Introduction In this article, we are going to see what is the best way we
can use OneToOne optional attribute so that we can avoid N+1 query issues.
One-...
Il y a 6 jours
-
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 6 jours
-
The Essence of TOGAF and the Architect's Role in Modern Enterprise
Architecture
-
In the realm of enterprise architecture, TOGAF has emerged as the de facto
standard, complemented by ArchiMate for documentation. Yet, a surprising
numbe...
Il y a 6 jours
-
Multitenant: Einhängen einer Non-CDB mit anderer Blockgröße
-
Die am häufigsten genutzte Blockgröße bei Oracle sind 8 KB. Andere
Standard-Blockgrößen sind selten. Und eine Mischung aus verschiedenen
Blockgrößen ebenfa...
Il y a 6 jours
-
Understanding OCI Security Lists….
-
Security List Security lists are alike set of common firewall rules
associated with a subnet. Because SL are associated with a subnet, they
are going to...
Il y a 6 jours
-
OEM Modifying-em-metric-threshold sizeOfOSAuditFiles
-
In order to modify “*sizeOfOSAuditFiles*” metric for all the targets in OEM
when you have several of them use below script to do all in one shot
*Chec...
Il y a 1 semaine
-
-
-
In-Memory OLTP for rapid data ingestion
-
Preamble In-Memory OLTP is a feature of SQL Server (Standard and
Enterprise) and Azure SQL than aim to optimize performance of transaction
processing or ...
Il y a 1 semaine
-
When Auditing Attacks
-
I had a particularly annoying problem with Oracle auditing a few days ago.
I thought I would write about it here in case anybody knows a solution, or
if ...
Il y a 1 semaine
-
The ORA-00060 error…
-
The ORA-00060 error. As a DBA we can see that error message during daily
database works. As you know that error referred to as a “deadlock detected”
error....
Il y a 1 semaine
-
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 1 semaine
-
software defined vehicles
-
https://youtu.be/hJe5xQr4LEY
This is a podcast by Motor Trend about the future of car. The host is
talking about software defined vehicles [*SDV*] and i...
Il y a 2 semaines
-
EXISTS vs EQUALITY - sand in the gears
-
The best thing about doing SQL Optimization is there is always something
that needs attention.
The worse thing about doing SQL Optimization is there is...
Il y a 2 semaines
-
OGG: ORA-01403 No Data Found – 2
-
Oracle GoldenGate is a powerful tool for real-time data replication, but
errors such as ORA-01043...
The post OGG: ORA-01403 No Data Found – 2 appeared f...
Il y a 2 semaines
-
Configuring Shared Global Area (SGA) in a Multitenant Database
-
I have been working on a PeopleSoft Financials application that we have
converted from a stand-alone database to be the only pluggable database
(PDB) in ...
Il y a 2 semaines
-
Let’s meet at TROUG Ankara ORACLE Day!
-
Date :25 April 2024 Address: ORACLE Ankara Office | 312 Vista Eskişehir
Yolu 2176.Cadde No:9/7 Söğütözü Çankaya 06530 Ankara Agenda: 13:00 – 13:30
The Suc...
Il y a 2 semaines
-
Video on Client Side Failover in RAC
-
I've posted a new video demonstrating Client Side Failover defined by the
tnsnames.ora file
Il y a 2 semaines
-
SHRD0014: GLLEZL - process exiting with failure
-
*SYMPTOMS*
Journal Import completes with the following error:
*Error*
------
ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES
ORA-01653 ...
Il y a 2 semaines
-
Oracle Database 23c–some intriguing new features–dbms_pipe, Prometheus,
pre-authenticated request URL, reset database session, Vector Search
-
This article is really just a quick draft to remind myself of some really
interesting new Oracle Database features that I want to further
investigate. Ve...
Il y a 2 semaines
-
Will I lose my existing AUDIT settings in 23c?
-
A few days back I posted a video how Unified Auditing is now the only
support auditing option in 23c, and gave you some easy steps on how to
migrate your e...
Il y a 3 semaines
-
Will I lose my existing AUDIT settings in 23c?
-
A few days back I posted a video how Unified Auditing is now the only
support auditing option in 23c, and gave you some easy steps on how to
migrate your e...
Il y a 3 semaines
-
-
Generic Prompts and Lacking Diversity- Fix it, ChatGPT
-
I’ve been intensely preparing the LinkedIn Learning Oracle 23c courses, set
to film later this month. Despite my responsibilities as
Tags: AI, AI in IT
D...
Il y a 3 semaines
-
pg_recursively_delete : Simplifier les suppressions récursives
-
Si vous avez été amené au fil de votre carrière à manipuler de gros volumes
de données contenus dans plusieurs tables possédant des références croisées
e...
Il y a 3 semaines
-
Learning SQL Exercise
-
I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development
class with MySQL 8. It’s a great book overall but Chapter 12 lacks a
complete exer...
Il y a 4 semaines
-
Setting the CARDINALITY (undocumented) hint on two tables
-
I was trying to solve a performance problem in a query containing a left
join on two global temporary tables. Clearly if you run an Explain Plan on
such ta...
Il y a 4 semaines
-
IslandSQL Episode 7: DML Statements in PostgreSQL 16 and What I Miss in
Oracle Database 23c
-
Introduction In the last episode, we covered DML statements in
SQL*Plus/SQLcl scripts for the Oracle Database 23c. The IslandSQL grammar
can now also han...
Il y a 5 semaines
-
dbms_dictionary_check package back-ported to 19c [19.22]
-
DBMS_DICTIONARY_CHECK package has been back-ported from 23c to oracle 19c
when applying January 2024 RU [19.22]. The package is a read-only PL/SQL
package ...
Il y a 5 semaines
-
10GbE in the DeskMini X300
-
As my little home server I have an Asrock DeskMini X300 with an AMD Ryzen 7
5700G (16 cores) and 64GB of memory. A nice low powered home server to play
aro...
Il y a 5 semaines
-
Locate an Error in Wrapped PL/SQL
-
I had a conversation a few weeks ago with someone who asked me how to find
a missing table when you have a wrapped PL/SQL file and cannot see the
source co...
Il y a 1 mois
-
How to Use Databases Inside GitHub Actions
-
GitHub Actions is a platform that automates the build, test and deployment
pipeline of your GitHub projects. Since its introduction, GitHub Actions
has bee...
Il y a 1 mois
-
Disaster Recovery for the Oracle Autonomous JSON Database
-
“You can’t prepare for everything – but you can prepare for anything.” –
Paul Youngjohns Backup-Based Disaster Recovery is a low-cost DR option for
databas...
Il y a 1 mois
-
Disaster Recovery for the Oracle Autonomous JSON Database
-
“You can’t prepare for everything – but you can prepare for anything.” –
Paul Youngjohns Backup-Based Disaster Recovery is a low-cost DR option for
databas...
Il y a 1 mois
-
When is an Oracle ACE not an Oracle ACE?
-
As of this week (11th March 2024) I am no longer a proper Oracle ACE – and
this is exactly as it should be. I am now an ACE Alum (I would prefer
Alumnus bu...
Il y a 1 mois
-
When is an Oracle ACE not an Oracle ACE?
-
As of this week (11th March 2024) I am no longer a proper Oracle ACE – and
this is exactly as it should be. I am now an ACE Alum (I would prefer
Alumnus bu...
Il y a 1 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 1 mois
-
Moh_Create Standby DB
-
------------------------------------------------------------------------------------------------------------------------------------------
-- Prepare the ...
Il y a 2 mois
-
Archivelog Space Needed Python Script
-
I wrote a script called archivelogspace.py to help size our Oracle archive
log filesystems to support replication tools such as Fivetran, DMS, or
GoldenGat...
Il y a 2 mois
-
One year on the Giant Explore E+ 2 with a Rohloff Speedhub 500/14
-
I thought since it’s been exactly a year since I upgraded my Giant Explore
E+ to a Rohloff Speedhub 500/14 internal gear hub, that it’s a good time
for an ...
Il y a 2 mois
-
Oracle 19: Сравнение Query Block Registry
-
Для ускорения/оптимизации выполнения запроса коллега Сергей Перегудин
проанализировал и предложил поправить/зафиксировать план важного, но
замедлившегося з...
Il y a 2 mois
-
reading a LOB in another session
-
Reading a LOB in Oracle is often quite easy: it's just a column in the
query and all the libraries available today are doing the work necessary to
make...
Il y a 2 mois
-
NMLS Exam Prep Practice Questions
-
1) Do all licensed loan originators need surety bond for each state in
which they are actively licensed? a) Yes, they need surety bond for each
state b) No...
Il y a 3 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 3 mois
-
AWS CLOUD STORAGE OVERVIEW
-
There are three types of cloud storage: object, file, and block. Each
storage option has a unique combination of performance, durability, cost,
and interfa...
Il y a 3 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 3 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 4 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 4 mois
-
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
-
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a
pretty simple question: What do you think about PostgreSQL events? Prior to
th...
Il y a 4 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 4 mois
-
My Personal Conference Review 2023
-
In the last two weeks I was very busy: three conferences in ten days are
exhausting – but it was a lot of fun. The last conference for this year is
over no...
Il y a 5 mois
-
What punch cards teach us about AI risk
-
I (finally) read Edwin Black’s IBM and the Holocaust, and I can’t recommend
it strongly enough. This book had been on my queue for years, and I put it
off ...
Il y a 5 mois
-
Database 19c Certified for Oracle Linux 9 – Preinstall Package Available
-
Oracle Database 19c is certified for Oracle Linux 9 now (minimum
requirement RU19.19). The Oracle Database preinstall package in its initial
version is als...
Il y a 6 mois
-
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 6 mois
-
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 6 mois
-
Valdosta State Endorses Low Code Solutions
-
Valdosta State continues to use Oracle APEX for stand-alone applications as
well as enterprise-level applications with thousands of daily users.
Arthur Ri...
Il y a 6 mois
-
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 6 mois
-
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 6 mois
-
Database Authentication using Azure AD Token #JoelKallmanDay
-
Oracle Database supports modern ways of authentication using some of the
cloud directories – OCI and Azure. I’ve tested Azure AD and set up
authentication-...
Il y a 6 mois
-
The Care and Feed of Oracle User Groups - #JoelKallmanDay
-
On todays #JoelKallmanDay, my topic of choice is The Care and Feed of
Oracle User Groups.
What is an Oracle User Group?
According to Wikipedia, it is:
...
Il y a 6 mois
-
Pressing Pause on APEX #JoelKallmanDay
-
To honour this year's #JoelKallmanDay, I'd like to use this as an
opportunity to speak about mental health, rather than get technical like I
have done in...
Il y a 6 mois
-
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 7 mois
-
Bitcoin Halving
-
Bitcoin halving is a significant event on the Bitcoin network every four
years. During this event, the block reward that miners receive for
verifying tr...
Il y a 7 mois
-
HTAP: Well, How Did We Get Here?
-
I’m speaking at an HTAP Conference put on by PingCap, (the folks
responsible for TiDB). As usual, I’m the only one with a cap. 🙂 By now
the event is s...
Il y a 7 mois
-
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 7 mois
-
oem cpu jul 23
-
this blog is no longer maintained. go there : OEM patch |
LaurentSchneider.Com (wordpress.com)
Il y a 7 mois
-
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 7 mois
-
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 7 mois
-
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 8 mois
-
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 8 mois
-
Adding PDBs is Easy also in v23c.
-
TL;DR: Success! I've got several PDBs plugged in a CDB, all created "just
from scripts", no "template-recovery". From here on it is all is
Dead-Simple. O...
Il y a 8 mois
-
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 9 mois
-
Out of Place (OOP) Patching of Oracle Restart 21c
-
Previous post showed OOP for 19c Oracle restart. Things are much simpler in
21c and can expect the same for 23c once released. The -switchGridHome
option i...
Il y a 9 mois
-
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 9 mois
-
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 9 mois
-
Oracle Database Online Migration to ASM
-
We were recently migrating one of our non-production databases to Oracle
ASM. Previously, we used the Linux files system EXT4. We wanted the
flexibility ...
Il y a 11 mois
-
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 11 mois
-
Oracle AVDF Installation and Setup Document
-
This blogpost will provide you detailed information about Oracle Audit
Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a
comprehensive Data...
Il y a 11 mois
-
Roll Forward Standby with 1 Command
-
I have a testbed that I use for research purposes. This testbed consists of
a 2-node RAC primary database (RESP) and a 2-node RAC physical standby
database...
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
-
Autonomous Database – Scaling UP/DOWN OCPU’s using Pl/SQL API’s
-
Autonomous Database provides an option of Scaling UP and DOWN of CPU &
Storage. Scaling UP/DOWN of CPU resources is a common practice that most of
the cust...
Il y a 1 an
-
APEX Interactive Grid: Cell Selection as Default
-
When you want to copy a specific value from an Interactive Grid, you would
need to change Row Selection to Cell Selection in the Actions menu.
When you do...
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
-
ALTER TABLE NOCOMPRESS
-
What a difference three words can make. No, not those ones, these ones
MODIFY DEFAULT ATTRIBUTES.
https://docs.oracle.com/en/database/oracle/oracle-databas...
Il y a 1 an
-
ALTER TABLE NOCOMPRESS
-
What a difference three words can make. No, not those ones, these ones
MODIFY DEFAULT ATTRIBUTES.
https://docs.oracle.com/en/database/oracle/oracle-databas...
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 1 an
-
Rebuild index candidates
-
Recent reminder on Oracle on line course "Understanding Explain Plans &
Index Utilization" by Dan Hotka and problems that I faced in real
professional life...
Il y a 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
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 1 an
-
“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 1 an
-
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 year...
Il y a 2 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 2 ans
-
100k views Thanks everyone Happy learning
-
100k views !! Thanks everyone! Happy learning!!
Il y a 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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
-
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 3 ans
-
Your session has expired - For Custom Apps after Oracle Apex Upgrade from 5
to 20
-
I was getting the above error "Your session has expired" immediately after
upgrade of Oracle Apex from Version 5 to 20 in my premises. Searched a lot
and d...
Il y a 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 ans
-
-
Failover with Amazon Aurora PostgreSQL
-
https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/
Advertisements
Il y a 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 ans
-
SQL Server Indexes best practices
-
SQL Server Indexes best practices Below are some of the SQL Server Indexes
best practices or points to keep in mind while creating SQL Server Indexes.
1. A...
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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 ans
-
SiteSubtitle
-
has moved to -> http://KARLARAO.WIKI
Il y a 6 ans
-
This site moved to dbacatalog.blogspot.com
-
This site moved to dbacatalog.blogspot.com please
visit dbacatalog.blogspot.com
Il y a 6 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 6 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 6 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 6 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 6 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
-
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 7 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 7 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 7 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 7 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 7 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 7 ans
-
Segment Statistics
-
rem******************************************************** rem Show
Segments with the highest Lock waits rem André Karlsson rem
https://www.protractus.com...
Il y a 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 8 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 8 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 8 ans
-
Using the Spark Event Timeline
-
Source: Using the Spark Event Timeline
Il y a 8 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 8 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 8 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 8 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 8 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 8 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 8 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 9 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 9 ans
-
Testing 123
-
This is is testing message. Pls ignore.
Il y a 9 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 9 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 9 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 10 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 10 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 10 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 10 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 10 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 11 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 11 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 11 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 11 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 11 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 12 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 12 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 13 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 13 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 13 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 14 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 14 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 14 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 15 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 17 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
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-