ORACLE : DATABASE قاعدة بيانات Base de données: PLW

Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

Technology Geek

AWS Direct Connect: Dedicated Hybrid Connectivity Between Your Data Center and AWS - Site-to-Site VPN runs over the public internet. Latency is unpredictable, throughput is limited, and for regulated workloads the shared path creates compli...
Il y a 1 heure
Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

Oracle Database 19c, Release Update, Auditoría Obligatoria para DML directos de SYS sobre AUD$ y FGA_LOG$ - Hola gente. El nuevo release de Oracle Database 19c, RU 19.33, trae algunos cambios interesantes, que precisa que tengamos en cuenta de ahora en ade...
Il y a 3 heures
DBA Kevlar

Peace, Purpose and the Next Book - When I finished Crushing the IT Gender Bias, I thought I’d sit down and write the next book soon after. I had the stories, but they just didn’t feel good, ...
Il y a 7 heures
ThatJeffSmith

Build a ChatGPT Plugin for PowerPoint Search with Oracle AI - See how to build an agentic AI workflow: a ChatGPT plugin that searches PowerPoint presentations by topic using Oracle Database and AI Vector Search. Th...
Il y a 13 heures
Oracle

Introduction to the change management methodology - Every deployment has three dimensions: People, Process, and Technology You already know the technology, and you probably know how it will improve people's ...
Il y a 16 heures
Ask Tom MOST RECENT ARTICLES

Oracle APEX running is encountered with error: localhost refused to connect - Hi, I did oracle apex installation (apex_24.2_en version) successfully but only at the first time I could open oracle apex and create workspace or etc. Act...
Il y a 1 jour
Learning is not a spectator sport

The AI World 2026 mega download! - Full disclosure: I cut/pasted this post from last year’s version and just changed the appropriate file names 🙂 We’ve all been there… You head over to the...
Il y a 1 jour
Learning is not a spectator sport

The AI World 2026 mega download! - Full disclosure: I cut/pasted this post from last year’s version and just changed the appropriate file names 🙂 We’ve all been there… You head over to the...
Il y a 1 jour
Market Solutions to Our Energy Needs

Why a Governed Open-Source Stack Will Reshape Enterprise Software - For the past year, legacy software vendors have eagerly pointed a finger at the "vibe coding" trend. When an untrained user prompts an LLM and watches i...
Il y a 1 jour
Timur Akhmadeev's blog

Elevated RAC waits due to LMS priority - If you happen to have a consolidated RAC environment number of databases is larger than approximately half a node’s core count a database is restarted some...
Il y a 4 jours
Martins Blog

Real productivity gains with AI: trace file analysis - I have been a database performance enthusiast for a long time, and I have spent a lot of time looking at Oracle database trace files. Depending on the leve...
Il y a 4 jours
IT WorldIT World

Automatic In-Memory Management (AIM) hands-on - Preamble Automatic In-Memory Management (AIM) is an extension to the In-Memory Enterprise Edition option that I tested back in 12cR1 (!!). As its name st...
Il y a 5 jours
Annals of Oracle's Improbable Errors

A Picture Is Worth A Thousand Words: Dashboards To The Rescue - Building an application in the age of AI assisted development is only half the battle. With an APEX application hosted on OCI, monitoring resource consum...
Il y a 1 semaine
Dennis Yurichev

Raw notes -
Il y a 1 semaine
sqlandplsql.com

LINK ORBIT4D Referensi Online dengan Informasi Akses yang Jelas dan Terstruktur - LINK ORBIT4D Referensi Online dengan Informasi Akses yang Jelas dan Terstruktur Perkembangan teknologi internet telah membawa perubahan besar dalam cara ...
Il y a 1 semaine
Dimitri Gielis Blog (Oracle Application Express - APEX)

This blog has moved to dgielis.com - Since 2006 this blog has been my home for Oracle APEX and Oracle Database posts: more than 800 of them. Today it moves to a new home: dgielis.com. Everyt...
Il y a 1 semaine
Ric Ramblings

The Company Party - Jack leaned back in his office chair feeling good. The week had gone very well, production went quite well this past week. Only a few minor hiccups in ...
Il y a 1 semaine
Vlad Mihalcea's Blog

A beginner’s guide to the Jenesis build tool - Introduction In this article, I’m going to show you how we can build the Hypersistence Utils project with Jenesis, a new Java build tool created by Rafae...
Il y a 1 semaine
The ORACLE-BASE Blog

Oracle VirtualBox 7.2.22 - Along with the new Oracle patches comes VirtualBox 7.2.22. The downloads and changelog are in the usual places. I’ve done installations on Windows 11 and...
Il y a 1 semaine
Lovely Oracle

A Practical Guide to Oracle Regex - If you've ever pulled thousands of rows into an application just to check whether a product code looks right, this post is for you. Oracle's built-in re...
Il y a 2 semaines
HeliFromFinland | Heli's Oracle thoughts

APEX is cool! - written by Matias Helskyaho and Heli Helskyaho Today is #JoelKallmanDay ! #moca Joel Kallman was a good friend to everybody. … Continue reading →
Il y a 2 semaines
HeliFromFinland

APEX is cool! - written by Matias Helskyaho and Heli Helskyaho Today is #JoelKallmanDay ! #moca Joel Kallman was a good friend to everybody. … Continue reading →
Il y a 2 semaines
Grassroots Oracle

Remembering on #JoelKallmanDay - Another year has gone by and it seems the time has arrived for my yearly post on Joel Kallman Day 🙄. Yes, I've still been working hard with Oracle techn...
Il y a 2 semaines
a Danish Sql and Pl/Sql Developer

Datapump over loopback link #JoelKallmanDay - Recently I helped a client setting up a way to clone schemas. While thinking and researching, I came across a little documentation snippet I found useful: ...
Il y a 3 semaines
Simple Oracle Dba

Got a Good Idea? Show it with SQL #JoelKallmanday - TL;DR: Always use a SQL-script too demonstrate what you to do. And make it Repeatable, and preferable Self-explaining. That way, anyone can quickly see f...
Il y a 3 semaines
Data Warehousing with Oracle

How to Find and Avoid Duplicates in Data Integration #JoelKallmanDay - Duplicate rows are the enemy of every data integration developer. They can cause job failures and – even worse – wrong results. Somtimes it is more complex...
Il y a 3 semaines
Philipp Salvisberg's Blog

Some Thoughts About Joel and AI #JoelKallmanDay - Where I Saw Joel for the First Time I remember Joel Kallman’s talk on the boat at APEX World 2019 in Rotterdam very well. I was sitting in the front row ...
Il y a 3 semaines
Pete Finnigan's Oracle security weblog

Oracle Forensics - Can we Understand what Happened? - In forensics the evidence can be grouped into two blocks. The first is changes made to the database and the second is read activity. Usually an attackers g...
Il y a 4 semaines
Apps DBA Workshop

From Legacy to Cloud Without Business Disruption: Mastering Oracle Database Migration with ZDM - Oracle Cloud · Business Continuity *The databases that matter most are the hardest to move — they never stop. This is how Oracle Zero Downtime Migrati...
Il y a 4 semaines
Bobby Durrett's DBA Blog

Selectloop – AI Queries an Oracle Database to Answer a Question - This is a follow up to my July post. I have had almost two months to work with my new Selectloop Python script and I want to tell people what I learned so ...
Il y a 4 semaines
AMIS Technology Blog

De andere milenniumproblemen - Nu OpenAI waarschijnlijk een oplossing heeft gevonden voor Navier-Stokes zal het misschien niet lang duren voor ook de andere milleniumproblemen aangepakt ...
Il y a 4 semaines
Confessions of an Oracle Magi

The State of APEX 2026 - For years, Oracle APEX was stuck with an unfair reputation: people saw it as a handy little tool for building internal bespoke applications, quick sprea...
Il y a 5 semaines
Oracle Study Notes by Denis

Building a Snowflake Cortex DBA Alert Analyst Agent - This document outlines the creation of an AI-assisted Database Operations Alert Analyst Agent designed to reduce operational "alert noise". It utilizes a s...
Il y a 1 mois
Biju's Oracle Notes

Oracle’s Base Database Service Changes for OCI Deployments - If you run Oracle databases on OCI, July 2026 was a significant inflection point that deserves more than a passing glance at your email inbox. Oracle retir...
Il y a 1 mois
Hemant's Oracle DBA Blog

Using the Python oracledb Driver to extract data to a Pandas DataFrame - My video demonstration on using python-oracledb to extract data from an Oracle Database and read it into a Pandas Dataframe The main documentation pag...
Il y a 1 mois
Geodata Master

Oracle 26ai Feature: Recording Historical SQL Queries At Session Level - A new, nice feature is introduced in Oracle 26ai that will enable developers and system admins to retrieve their historically executed SQL queries. The hi...
Il y a 2 mois
www.ORACLE-CKPT.com

Oracle Data Guard Broker PL/SQL API Limitations with DGPDB Switchover - Oracle Data Guard Broker provides DGMGRL as its primary command-line management interface, while the DBMS_DG... The post Oracle Data Guard Broker PL/SQL ...
Il y a 2 mois
www.markusdba.de | Markus Flechtner – Meine Erlebnisse rund um Oracle …

Alte Objekte im Data Dictionary - Objekte in der Datenbank, die mit „_OLD“ oder „_BACKUP“ enden, sind in den meisten Fällen Überbleibsel, Backups von irgendwelchen Applikationstabellen, die...
Il y a 2 mois
Cap Data Team SGBD Blog : Oracle, SQL Server, MySQL, Sybase...

Gqbet Casino in the UK – Account Verification - Gqbet Casino in the UK – Account Verification ▶️ PLAY Содержимое Step-by-Step Guide to Uploading ID Documents for Gqbet Account Verification Common Issue...
Il y a 2 mois
Julian Dontcheff's Database Blog

Football is not a database - To whom it may concern: And finally. Not every nation needs to be at the World Cup. Part of the magic was that getting there was almost as hard as winning ...
Il y a 3 mois
Julian Dontcheff's Database Blog

Football is not a database - To whom it may concern: And finally. Not every nation needs to be at the World Cup. Part of the magic was that getting there was almost as hard as winning ...
Il y a 3 mois
flashdba

Introducing the Hyperscaler GTM Playbook - A vendor-neutral practitioner guide on cloud alliances, co-sell and marketplace – 16 articles covering everything from partner programs to private offers, ...
Il y a 3 mois
Oracle Scratchpad

Savepoint Funny - Here’s an example that makes perfect sense if you know how Oracle handles data locking. It’s one that I thought I’d published years ago, but it’s not on th...
Il y a 4 mois
Laurent Schneider

Where to find ojdbc17_g.jar - I haven’t done much JDBC tracing yet, but recently for a Kerberos KCM + ANO case I wanted more traces. In the old doc, on google and myoraclesupport, you’l...
Il y a 5 mois
Talip Hakan Ozturk's ORACLE BLOG

Using RMAN Backup Validation To Distinguish Between Read and Write Bottlenecks - Hello Friends, Easy way to determine whether the output device or input disk I/O is the bottleneck in a given backup job is to compare the time required to...
Il y a 5 mois
Oracle High Availability

Physical Standby – the Ultimate Migration Tool - We attempted to find out if anyone else had used a physical standby to accomplish the following changes in our Oracle Architecture: AWS Instance Hardware C...
Il y a 5 mois
Oracle

Oracle Standby FIX using RMAN Incremental Backup from Primary DB - When you don’t have an option other than doing incremental backup from Primary DB (when ARCH logs are gone from all places) below is the high-level DB...
Il y a 5 mois
The Data Warrior | Changing the world, one data model at a time. How can I help you?

Better Data Models (redux) - Successful AI relies on high-quality, well-understood data and its context. Emphasizing the importance of good data management, the author advocates for re...
Il y a 5 mois
berxblog

Single Server DFO - Another improvement similar to last post is Single Server DFO. While in previous post the serial work was done by the query coordinator, that activity c...
Il y a 5 mois
External Table

Unlocking Apache Spark Performance: Three Open-Source Tools We Use at CERN - Apache Spark is incredibly powerful, but anyone who has worked with it long enough knows the feeling: *Why is this job suddenly slower today?* *Why are e...
Il y a 5 mois
Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

Migrate/Move Data to Autonomous AI Database - Assume following scenario’s: For 1 above, Autonomous AI Database provides Database Cloning option. It is just few clicks and the job is done. For 2, there ...
Il y a 5 mois
A! Help

Out of Place (OOP) Patching of Oracle Restart 26ai - Previous posts showed OOP for 19c and 21c Oracle restart. Things are even simpler with 26ai. The current patch level is crsctl query has releasepatch Orac...
Il y a 5 mois
Øystein on MySQL Optimizer

The hypergraph optimizer is now available in MySQL 9.7 Community Edition - I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-le...
Il y a 6 mois
Helios's Blog

Most Common Oracle Wait Events - Every DBA knows how to read the Top 5 Timed Events section of an AWR report. The common ones — db file sequential read, log file sync, buffer busy waits — ...
Il y a 6 mois
Enkitec.tv

Kèo chấp 0.5 là gì – Chiến thuật chốt kèo về bờ an toàn - Kèo chấp 0.5 là một trong những loại hình cá cược bóng đá phổ biến nhất mà bạn có thể tìm thấy tại Nowgoal 2in1. Việc đánh dấu bằng màu đỏ hoặc đi kèm dấu ...
Il y a 6 mois
Thinking Out Loud

Good Bye and Good Luck - June 27, 2007 was my first post and April 20, 2026 will be my last post. Be Healthy, Wealthy, and Wise !
Il y a 6 mois
DBA survival BLOG

Data Guard 26ai – #28: Fast-Start Failover Validation - FSFO validation in Oracle Data Guard 26ai: a single command to verify readiness, consistency, risk settings, and callout scripts across your configuratio...
Il y a 6 mois
Oracle mechanics

SPM при использовании VPD/RLS - На примере нетипично долгого выполнения стандартного OEBS 12.2 запроса: — формальный источник проблем — выбор HASH JOIN XLA_TRANSACTION_ENTITIES@SEL$3 с ин...
Il y a 7 mois
oracle-recipes

Create a table out of nothing - sql table out of nothing
Il y a 7 mois
Kerry Osborne's Oracle Blog

NoCOUG Conference – 2/27/2026 - Well for the first time in a very long time I am posting something on my blog. I’m doing a keynote for the Northern California Oracle Users Group (NoCOUG)....
Il y a 8 mois
Sujeet APPS DBA

ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' - This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user 'Mysql'@'%' to alter, or the ...
Il y a 8 mois
On The Peoplesoft Road

CPU patching with golden images - With the CPU patches, it's a all exercise that we all repeat 4 times a year on the systems. We are patching the different software part of the Peoplesoft....
Il y a 8 mois
Pavan DBA's Blog

Exploring the production process of navigation buoys in indonesia - Indonesia’s navigation buoy production stands as a vital pillar supporting maritime safety across its vast archipelago. The country’s manufacturers blend t...
Il y a 8 mois
DB Oriented » English

Aggregation Filters - Overview The FILTER clause is a nice addition to the SQL syntax in Oracle 26ai (23.26.1). It allows to restrict the rows considered by aggregate function...
Il y a 8 mois
Rafu on db

Oracle Data Guard Role Change History - Oracle documentation lists oracle-data-guard-in-oracle-database-views. Having diagnostics pack purchased and available one may find information of role cha...
Il y a 9 mois
Learners Reference - Learners Reference

NMLS Test Questions Made Simple - 1) Tax Lien is an involuntary lien that is a non-consensual claim on one’s property as a collateral towards repayment of a debt and the rights can be giv...
Il y a 9 mois
The Go-Faster Oracle Blog

Managing Ad Hoc PS/Queries in PeopleSoft - This post draws together all the recommendations for managing ad hoc user queries in PeopleSoft PS/Query. Some points relate to the database, some to the ...
Il y a 9 mois
Jeremy Cole

Reflections on a year of biking for 2025 - Last year I wrote up a summary of my biking for 2024, and I thought I’d continue that nascent tradition by writing a similar post for 2025, so here it is. ...
Il y a 10 mois
Oracle SQLOracle SQL

Parsing RTSM(Real-Time SQL Monitor) XML Reports - Learn how to parse Oracle Real-Time SQL Monitoring (RTSM) XML reports using table SQL macros introduced in Oracle 19.16. This article shows how the updated...
Il y a 10 mois
Notes on Oracle

Add a Little Joy to your Buttons #JoelKallmanDay - Recently we were sitting outside at a café having a coffee and a slice of apple pie, something we do often. This is nothing remarkable, but when we orde...
Il y a 1 an
MacLochlainns Weblog

GOLANG Pointer Functions - There are interesting behaviors when you start learning about
Il y a 1 an
Usn's IT Blog

Multiple Ways How to Get Rid of the Oracle Database Optimizer Statistics Advisor AUTO_STATS_ADVISOR_TASK - There are multiple ways to avoid the vast amounts of data in the SYSAUX tablespace created by the AUTO_STATS_ADVISOR_TASK. This advisor runs during a maint...
Il y a 1 an
Exadata

Step 3: Apply Patch on GI & RDBMS (Oracle Exadata) - Step 3: Apply Patch on GI & RDBMS (Oracle Exadata) *Target:* SDN_Env Cluster (Repeat for other clusters) *Mode:* Patch two nodes at a time (rolling patch...
Il y a 1 an
Home Of The Scary DBA

Slide Decks - Hello everyone! Just a quick note. I’ve removed all my slide decks from SlideShare. I found they were inserting ads into the slides and I didn’t sign up ...
Il y a 1 an
Sfaturi Oracle / Tips and tricks OracleDBA

the link between the rising oil level and the DPF blockage - Many Asian diesel cars, including Toyotas, Subarus, and Kias, share similar DPF-related challenges. One common problem is* a rising oil level.* This hap...
Il y a 1 an
Venzi's Tech-Blog

Blog has moved – saying Goodbye to E-Mail subscribers - Hi all, Some of you may have already noticed the new look and feel of my blog. This was enabled due to a blog migration away from WordPress.com to a privat...
Il y a 1 an
Martin Widlake's Yet Another Oracle Blog

Two Years Into Retirement - It’s two years and a day since I fully retired. On the 1st July 2023 I changed my LinkedIn profile to indicate my new, permanent, non-working status. I can...
Il y a 1 an
The PeopleSoft DBA Blog

Optimising Journal Line Queries: 5. Conclusion - This is the last of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). 1. Problem Statement ...
Il y a 1 an
Simon Krenger

Start a Pod in Kubernetes using curl - Recently I came across the issue that a customer needed to start a Pod without the kubectl or the oc command line tooling. Since the Kubernetes API is a re...
Il y a 1 an
An Oracle Programmer

SQL table macros 15: parameterized views revisited - In my previous post, I tried to use views and macros together as an equivalent to parameterized views. Unfortunately, my generic macro can’t handle bind va...
Il y a 1 an
Oracle SQL & PL/SQL

Sitemap - Sitemap - All posts on this blog 1. SQL Introduction 2. SQL Update 3. SQL Delete 4. SQL / PLSQL Interview Questions 5. PLSQL Cursors 6. PLSQL Triggers 7. S...
Il y a 1 an
The Observation Deck

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 ans
OraStory

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 2 ans
OraStory

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 2 ans
"Hey Alfredo..." - An Oracle Blog

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 2 ans
The Oracle Instructor

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 2 ans
AristaDBA's Oracle Blog....

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 2 ans
Blog | RDBMS Insight | natalka's oracular insights

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 2 ans
DBA Tips

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 2 ans
CarajanDB - Blog

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 2 ans
CarajanDB - Blog Johannes Ahrends

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 2 ans
dba topics

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 3 ans
veebrij.com

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 3 ans
Richard Foote's Oracle Blog

The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”) - NOTE -THIS BLOG IS NO LONGER BEING MAINTAINED!!! (Content may no longer be up to date or accurate with current versions of Oracle) Of all my many Ora...
Il y a 3 ans
Mohamed Houri’s Oracle Notes

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 3 ans
hourim.wordpress.com

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 3 ans
Anand's Blog | My experiences and views on Oracle Database

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 3 ans
Rittman Mead Consulting

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 3 ans
Data Virtualizer

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 4 ans
Oracle Diagnostician

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 4 ans
OracleFrontovik | Sharing my experiences and knowledge from the Oracle Development front line

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 4 ans
| Oracle blog by Anar Godjaev

“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 4 ans
Real DBA Magic

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 4 ans
Tales of an oracle dba

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 5 ans
Oracle Blogs | Oracle Infrastructure Blog

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 5 ans
Alejandro Vargas' Blog

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 5 ans
ThatJeffSmith

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 5 ans
Frits Hoogland Weblog

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 5 ans
Generally ... It Depends

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 5 ans
Generally ... It Depends

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 5 ans
Oracle Technology Network's Blog

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 5 ans
Security Inside Out

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 5 ans
Oracle Partner Hub: ISV Migration Center Team

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 5 ans
Proactive Support - Java Development using Oracle Tools

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 5 ans
Giri Mandalika's Repository

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 5 ans
Oracle Hardware

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 5 ans
DB Oriented » Languages » English

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 5 ans
Oraclewizard

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 5 ans
Oracle RAC, Virtualization and Exadata Expert

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 5 ans
A little bit of everything

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 5 ans
OracleTech dba ~ Karl

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 5 ans
Shahid's Oracle Blog

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 6 ans
allappsdba Blog....Powered by DOYENSYS

- "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 6 ans
Sloba's Blog

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 6 ans
Azmath's Oracle DBA Blog

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 6 ans
Databases at CERN blog

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 6 ans
Mokum Solutions - Oracle Consulting blogs

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 6 ans
Oracle Certification

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 6 ans
Oracle Hack

Unix - Automatically notifiy when disk space is running low - It's good to be forewarned when one of your volumes or diskspace is running low before it actually runs out (100% used). I have seen many databases hang wh...
Il y a 6 ans
Kevin Closson's Blog: Platforms, Databases and Storage

Following Various Legal Action Regarding “Oracle Cloud Revenue” - As a courtesy, I would like to provide a copy of the latest legal document filed in an action being brought against Oracle leadership resulting from allege...
Il y a 6 ans
Oracle related stuff

New Parallel Distribution Method For Direct Path Loads - Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT APPEND and CTAS ...
Il y a 6 ans
Lets Develop in Oracle

SQL Puzzle - Calendar of Current Year - With this post, I want to share a SQL Puzzle to *Generate the Complete Calendar of Current Year*. As you can see in the desired output - Month names shoul...
Il y a 6 ans
Steven Feuerstein on Oracle PL/SQL

Rankings for Logic Annual Championship for 2019 - You will find below the rankings for the Logic Annual Championship for 2019, held in February 2020 on the Oracle Dev Gym. The number next to the player's...
Il y a 6 ans
Andrew's Oracle DBA Blog

ORA-12954 - I went to Techfest 2019 in Brighton. While I was there I saw a presentation by somebody from Pythian. He said that Oracle Database Express Edition is now v...
Il y a 6 ans
Peasland Database Blog

Invalid ODCIPARTINFOLIST on Upgrade - I have been working on upgrading Oracle 12.1.0.2 databases to Oracle 19.3 when I ran into a problem that took me quite awhile to figure out. I did a search...
Il y a 6 ans
Oracle Thoughts | Jacek Gębal's adventures on Oracle SQL and PL/SQL

INSERT … LOG ERRORS and SQL%ROWCOUNT - Oracle SQL has a really neat feature to log the rows that failed to be processed during DML statement (INSERT / UPDATE / DELETE / MERGE ). This is really g...
Il y a 6 ans
Kamran Agayev's Oracle Blog

Exadata storage cell rolling restart caused datafile and redo log file header block corruptions - 24 hours passed – still at work. Struggling to start up the database which was corrupted during cell storage rolling restart procedure. And I’ve never seen...
Il y a 6 ans
Oracle DBA - A lifelong learning experience

Response to Make database simpler - I read an interesting and thought provoking blog this morning Make Oracle database simple again Much of is is common sense and is really best practise – n...
Il y a 6 ans
Oracle DBA Blog 2.0

Getting an excel list of all Azure Virtual machines - Now i don't think i'm unique in getting frustrated that from some of the Azure portal screens there is no download as csv option or a more effective fi...
Il y a 6 ans
bdt's oracle blog

Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect - Introduction TOAST stands for “The Oversized-Attribute Storage Technique” and allows to broke up large fields value into multiple physical rows (see the Po...
Il y a 6 ans
bdt's oracle blog

Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect - Introduction TOAST stands for “The Oversized-Attribute Storage Technique” and allows to broke up large fields value into multiple physical rows (see the Po...
Il y a 6 ans
ORACLE

PL/SQL & SQL Coding Guidelines Version 3.6 - PL/SQL & SQL Coding Guidelines Version 3.6
Il y a 6 ans
Damir Vadas, Oracle as I learned

Truncate (or drop!) partition without disturbing global non partitioned indexes - The problem Typical problem with partition tables is partition pruning and problems with global non partitioned index on them. From the theory, if you tru...
Il y a 6 ans
EvDBT

Delphix XPP explained - This article was originally posted on the Delphix Support blog on 15-Nov 2015, but with the deprecation of the XPP feature with the new 6.0 release and hig...
Il y a 6 ans
Oracle ACE Director Kai Yu's Oracle Blog

My Presentations at Germany Oracle User Group Conference (DOAG2019) - Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot for D...
Il y a 6 ans
Oracle ACE Director Kai Yu's Oracle Blog

My Presentations at Germany Oracle User Group Conference (DOAG2019) - Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot for D...
Il y a 6 ans
Jaffar's (Mr RAC) Oracle blog

Exadata X8M - World's Fastest Database Machine - Exadata X8M has launched during OOW 2019, and termed as world's fastest Database Machine. Let's walkthrough about new additions that has made X8M as world...
Il y a 6 ans
NZ DBA: Oracle Database Tuning & Tips

SQLPATH/login.sql Not Run…. Again! - SQLPATH/login.sql will fail to run in 19c on Windows if the SQLPATH value isn't to Oracle's liking. A simple rename can workaround the problem.
Il y a 7 ans
BestPerf

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 7 ans
Johan Louwers Personal Blog "my view on the IT world".

Add Oracle Linux 8 Vagrant box - When using Oracle Linux (a lot) for local development you most likely want to use Vagrant to quickly deploy new environments locally. Oracle originally sup...
Il y a 7 ans
Oracle DBA - Tips and Techniques

Pluggable Database Cloning using Snapshot Copy - You need to be logged in to see this part of the content. Please Login to access.
Il y a 7 ans
Laimis Oracle blog

MySQL history list effect on the latest record version reads - Mysql has a Multi Version Consistency Control(MVCC) to deal with Isolation part of ACID. Mysql effectively keeps the old row versions as long as needed for...
Il y a 7 ans
Odie's Oracle Blog

Rounding Timestamp Values with Fractional Seconds - Lately, I had to deal with a timestamp value with an overly long sequence of decimal digits, coming as a string in ISO 8601 format : 1970-01-04T15:20:34.49...
Il y a 7 ans
Guy Harrison's main page

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 7 ans
Oracle-Ninja.com

OEM SSL Cipher Hardening Reset After Securing OMS - I have recently been installing Oracle Enterprise Manager at several sites, and one of the key requirements has been to ensure that the installation isn’t ...
Il y a 7 ans
Le blog Oracle d'Ahmed AANGOUR

Updates et Compression HCC (1) - Dans cet article je souhaiterais vous montrer ce qu'il se passe concrètement quand un update est effectué sur des lignes compressées en HCC (compression...
Il y a 7 ans
******* Rafi ORACLE DBA & APPS DBA Blog*******

Completed Oracle 12c Database OCP Certification - Dear All, Alhumdulilah Completed Oracle 12c OCP Certification after working hard in Oracle 12c Databases. Worked & Studied Rigorously on Oracle 12c Databa...
Il y a 7 ans
Cary Millsap

Sometimes the Simplest Things Are the Most Important - I didn’t ride in First Class a lot during my career, but I can remember one trip, I was sitting in seat 1B. Aisle seat, very front row. Right behind the la...
Il y a 7 ans
Oracle DBA

Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run - *Issues : * *Autoconfig Failing.* applrac@dev-app01:~$ applrac@dev-app01:~$ adautocfg.sh Enter the APPS user password: The log file for this session is ...
Il y a 7 ans
Striving for Optimal PerformanceStriving for Optimal Performance

MIN/MAX Optimization and Asynchronous Global Index Maintenance - In this short post I would like to point out a non-obvious issue that one of my customers recently hit. On the one hand, it’s a typical case where the quer...
Il y a 7 ans
Oracle DBA tips

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 7 ans
Smart Database Replication

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 7 ans
www.arkzoyd.com/?lang=fr

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 7 ans
Steve Harville's Blog

Package and distribute a Scala jar to run on the command line - Add this to pom.xml – (update the mainClass to match your program): In Eclipse right click project and run as Maven build with goal=package Sample output f...
Il y a 7 ans
ORACLE IN ACTION

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 7 ans
AskDba.org Weblog

Identifying PostgreSQL Bloat and fixing it without downtime - Original Post can be viewed at Identifying PostgreSQL Bloat and fixing it without downtime MVCC (Multi-Version Concurrency Control) feature allows databa...
Il y a 7 ans
Wim Coekaerts Blog

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 7 ans
OracleNZ by Francisco Munoz Alvarez

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 7 ans
Ask Anantha

Hierarchical Query with search parameters (Pruning) - The following is a query from a friend, Reproducing it here: I have a menu structure using a hierarchical query. i have search field to enter some string a...
Il y a 7 ans
It Was Like That When I Got Here

Oracle 19c New Features - Oracle 19c New Features … Continue reading →
Il y a 7 ans
ORACLE数据库服务热线：400-690-3643 诗檀软件 » – ORACLE数据库技术文刊-汇聚全世界的甲骨文技术 – ParnassusData诗檀软件旗下网站

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 7 ans
Roels Blog

Filtering in the APEX Interactive Grid - Remember Oracle Forms? One of the nice features of Forms was the use of GLOBAL items. More or less comparable to Application Items in APEX. These GLOBALS w...
Il y a 7 ans
Dave Herring's DBA Blog

OEM Target Discovery and One Potential Source of Duplicates - With OEM 12c came a feature that I've come to appreciate, the ability to discover all targets on a given environment. Part of my appreciation is the remo...
Il y a 7 ans
Pierre blog

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 7 ans
OracleTuts

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 7 ans
Oracle PL/SQL Developer

bbb -
Il y a 7 ans
Oracle SQL Tuning Notepad

Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches - To mitigate SQL performance issues, I do make use of SQL Plan Baselines, SQL Profiles and SQL Patches, on a daily basis. Our environments are single-instan...
Il y a 7 ans
Osama Mustafa Oracle Blog

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 7 ans
The Arup Nanda Blog

OTW18 Sessions: Data Engineering and Latch Contentions - Thank you all those who came to my sessions at the OakTable World. Here are the presentations materials Think Data; not Database Data Engineering for Data ...
Il y a 8 ans
Surachart Opun's Blog

Oracle Database EM 18 XE Available to Remote Clients - I found lot of posts about *Oracle Database 18 XE*. It's very interesting for me. I didn't blog about how to install, because it's very easy for using rpm...
Il y a 8 ans
Oracle DBA Scripts and Articles (Montreal)

Stop/Start all RAC databases at once - Introduction Stopping all RAC databases running on an ORACLE_HOME at once and saving the state before shutting them down is really helpfull when you are ...
Il y a 8 ans
Ann Sjökvist – Oracle Standard Edition – Just love it! | old site: annsjokvist.wordpress.com – moved here

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 8 ans
Radio Free Tooting

UKOUG London Development and Middleware event - free! - The Oracle development landscape is an extremely broad and complicated one these days. It covers such a wide range of tools, technologies and practices it ...
Il y a 8 ans
Oleksandr Denysenko's Blog

Strange sessions hang with waits on Latch: Undo Global Data - Just a quick note for those who may face the same issue 😉 Situation was progressed like this: a lot of sessions waits for Latch: Undo Global Data with loc...
Il y a 8 ans
Kyle Hailey

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 8 ans
Karl Reitschuster's Oracle Space

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 8 ans
Oracle DBA Scripts

N.R. Narayanamurthy, Ajith Narayanan, Bulgaria, Sofia, Istanbul, India - What's the link? - This blogpost was again long pending one, but I was not sure on how to write this non technical real life experience as a blogpost, as I used to write o...
Il y a 8 ans
TwelveC

Failover with Amazon Aurora PostgreSQL - https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/ Advertisements
Il y a 8 ans
Oracle Corner

Duplicate database to a diferent server - Prepare OLD database cd $ORACLE_HOME/dbs; cp orapwDBNAME orapwDBNAME.beforemigration orapwd file=/oracle/DBNAME/12102/dbs/orapwDBNAME sysdg=yes sysbackup=y...
Il y a 8 ans
Oracle Solution Hub

List_comprehension - if True A else B : List Comprehension
Il y a 8 ans
Upgrade your Database - NOW!

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 8 ans
Ramkumar Menon's Blog

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 8 ans
The art of virtualization

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 8 ans
Oracle DB/EM Troubleshooting

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 8 ans
My Oracle Support

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 8 ans
Performance Diagnosis

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 8 ans
Ivica Arsov's blog | Database Management & Performance

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 8 ans
DATAWAREHOUSE CONCEPTS

HDFS: Useful Hadoop Admin Commands - HDFS is designed more for batch processing rather than interactive use by users. The emphasis is on high throughput of data access rather than low latency...
Il y a 8 ans
Oracle Expert Blog

NEW FEATURES IN ORACLE12C R2 AND ORACLE18C R1 - *NEW IN ORACLE12C AND ORACLE18C* Oracle12c R2 Multitenant Container Database Architecture Oracle12c R2 Database Architecture *New Features in Oracl...
Il y a 8 ans
Intermediate SQL

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 8 ans
Gurcan Orhan's Oracle Data Integrator Blog

#OUGN18 by OUGNorway is approaching - It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3 of my presentations are ready, all logistics are ready and the other stuff are r...
Il y a 8 ans
Gurcan Orhan's Oracle Data Integrator Blog

#OUGN18 by OUGNorway is approaching - It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3 of my presentations are ready, all logistics are ready and the other stuff are r...
Il y a 8 ans
recurrent null | Explorations in Oracle, mainly

Deep learning, concepts and frameworks: Find your way through the jungle (talk) - Today at OOP in Munich, I had an in-depth talk on deep learning, including applications, basic concepts as well as practical demos with Tensorflow, Keras a...
Il y a 8 ans
The Dutch Prutser's Blog

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 8 ans
Look Smarter Than You Are

Why Cloud? The reason changed in 2017…twice - In 2017, the predominant reason companies considered moving to the Cloud changed *multiple times*. While the “how” tends to shift frequently, seeing the “...
Il y a 8 ans
Nguyen Duc Hai's blog

Service Contracts Renewal Portal - How to setup and use Service Contracts Renewal Portal Date: August 1, 2012Author: Parag Mone0 Comments Overview Renewing service contracts is an important ...
Il y a 8 ans
dbaStreet

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 8 ans
Marko Sutic's Oracle Blog

Beware of intensive slow query logging when using - log_queries_not_using_indexes - MySQL slow query log is great for identifying slow queries that are good candidates for optimisation. Slow query logging is disabled by default, but it is ...
Il y a 9 ans
www.xmldb.nl

Oracle and the Autonomous Database (a personal perspective from afar) - Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…
Il y a 9 ans
Oracle WTF

The power of scripting - So your system has a neat automated archive and purge function for your rolling partitions, driven by the PART_RETENTION table which holds the table name...
Il y a 9 ans
Oracle Database

How to Clone Grid Infrastructure binaries for Oracle Server(Standalone) - *Yesterday I was applying patch on one of our development servers and patch on Grid Home failed with space issue and binaries got corrupted.* *I thought o...
Il y a 9 ans
The Pythian Blog

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 9 ans
Joords Oracle DBA blog

DataGuard FastSync : Define the Redo Transport Mode SYNC NOAFFRIM - *FASTSYNC *is a new DataGuard capability available with Oracle Database 12c. The FASTSYNC configures redo transport services for this configuration member ...
Il y a 9 ans
Kris' blog

ORDS 17.3 Beta - Introducing REST enabled SQL - Download Got get it on the normal ORDS download page http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html Versioning ...
Il y a 9 ans
ORACLE TIPS

InnoDB tablespace Encryption - InnoDB tablespace encryption uses a two tier encryption key architecture, consisting of a master encryption key and tablespace keys. When an InnoDBtable...
Il y a 9 ans
Mauro Pagano's Blog

SQL Diag Repository - Every once in a while I look around the list of new (fixed) views in the instance trying to find useful / interesting things to add to SQLd360 and recently...
Il y a 9 ans
Insights from an Oracle University Classroom

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 9 ans
Grid DBA

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 9 ans
Oracle Apps Technology

acroread on Linux 6 - As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader (acroread) allows users to view and print documents in Portable Document Format (PDF...
Il y a 9 ans
Alex Fatkulin's Blog

12.2 ACFS compression, part I - One of the new 12.2 features is the ability to transparently compress ACFS filesystems. Compression is enabled using *acfsutil* utility: [root@raca1 ~]#...
Il y a 9 ans
Karl Arao's TiddlyWiki

SiteSubtitle - has moved to -> http://KARLARAO.WIKI
Il y a 9 ans
Mahir M. Quluzade | Oracle Blog

Oracle Database 12c Release 2 - Long Identifiers - Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) t...
Il y a 9 ans
PHP and Oracle: Christopher Jones

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 9 ans
Oracle Partner Enablement France

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 9 ans
Virtually All The Time

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 9 ans
Oracle database internals by Riyaj

IOUG Collaborate 2017 - I have a few presentations scheduled in IOUG Collaborate 2017, Las Vegas. 1. Session: 621: RAC Clusterware internals **Date/time: Mon, Apr 03, 2017 (01:30 ...
Il y a 9 ans
Manageability Partner Community EMEA

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 9 ans
Tony's Oracle Tips

Object oriented logging - It is a very common requirement. You need to be able to log the start and end of procedure and function calls. You also need to log error and exception eve...
Il y a 9 ans
Developing using Oracle technologies

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 9 ans
Stu's Brain Dump

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 9 ans
All Things SQL

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 9 ans
The Helsinki Declaration (IT-version)

The Relational Data Model - Mid-eighties. I was studying Computer Science. Little did I know back then that this thing called "The Relational Data Model" (RDM) would become huge in th...
Il y a 9 ans
Expert Oracle

“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 9 ans
Christian Shay - Oracle and .NET

Setting up Transport Layer Security/Secure Sockets Layer for Managed ODP.NET - *[I was chatting with ODP.NET product manager, Alex Keh, and he let me know about some known issues that developers currently face when using managed ODP...
Il y a 9 ans
IN ORACLE MILIEU ...

Book on Oracle 12c New features - A Book on Oracle 12c New features for administrators Hi All, It’s our pleasure to announce the availability of our first book – OCP 12c upgrade 1Z0-060 Exa...
Il y a 9 ans
Scale Abilities » James Morle

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 9 ans
Oracle Database PL/SQL and EBR

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 9 ans
DBA n00b

Oracle back-port patches for Adaptive performance issues released for 12.1 (dynamic stats) - Previously I wrote about performance issues with 12.1 Adaptive features, specifically the large number of dynamic statistics checks, usually triggered by t...
Il y a 9 ans
About Oracle

Performance aspects of APEX reports - As this post appears, I'm presenting on this subject for the Dutch Oracle User Group OGh. This blog post won't contain as much detail as the presentation i...
Il y a 9 ans
Oracle PartnerNetwork News

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 9 ans
portrix systems

#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 10 ans
Martin Widlake's Yet Another Oracle Blog

Pint with Oracle User Group – First International POUG (Polish) Conference - Last week I enjoyed being at the first international conference put on by the resurrected/new Polish Oracle user group. I say enjoyed – I actually mean rea...
Il y a 10 ans
Technology tutorials by TechKatak

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 10 ans
blog | The Oracle DB inn

Segment Statistics - rem******************************************************** rem Show Segments with the highest Lock waits rem André Karlsson rem https://www.protractus.com...
Il y a 10 ans
SQLfail

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 10 ans
Michelle, DBA Unleashed

Database Olympics - Training for the Medals? - I will admit, I have been inspired by watching the Olympics. The work, training and even reinventing that the athletes do to be successful at the competiti...
Il y a 10 ans
Oracle by Madrid

ORA-00600 [2663], [12], .... - After not having spotted ORA-00600 for a while a new one showed up. ORA-00600: internal error code, arguments: [2663], [12], [3665664941], [12], [38847178...
Il y a 10 ans
Oracle OpenWorld Blog

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 10 ans
Peter`s DBA Blog

Critical Patch Update for July 2016 Now Available - The Critical Patch Update (CPU) for July 2016 was released on July 19, 2016 and Oracle strongly recommends applying the patches as soon as possible. A good...
Il y a 10 ans
OracleAPPSDBA & Oracle DBA Blog | OracleAppsDBA-11i/R12/R12.2

R12.2 CUSTOM APPLICATION/TOP - STEP1: Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support. STEP2: Manually copy the three .txt files from the 36...
Il y a 10 ans
ORACLE @ Work

SQL Joins - Codeproject has this image which explains the simple basics of SQL joins, taken from: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx
Il y a 10 ans
Alberto Dell'Era's Oracle blog

“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 10 ans
From errors we learn ...

zabbix dbsyncers and caching for log items - in version 3.0.1 - I am using zabbix for about a year now and it still has not shown me all power that is inside. One of the things that is very interesting to know more ab...
Il y a 10 ans
TechnologyLearning | Learning is not a spectator sport.. Let's play

RAC Installation Step by Step - Hi All, Please find the below link for RAC installation document for reference. Click here for RAC Installation doc link Cheers, Sachin
Il y a 10 ans
Oracle Database Insider Blog

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 10 ans
Doug's Oracle Blog

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 10 ans
Doug's Oracle Blog

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 10 ans
Oracle - Concepts et Exemples

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 10 ans
PL/SQL Challenge

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 10 ans
Latch, mutex and beyond

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 10 ans
Oracle BI Consultant

Denodo Server - Setup & configure Cache Database to MySQL: - *Denodo Server - Setup & configure Cache Database: - Bottlenecks* *Step1: * Install the Denodo Server by clicking the executable and follow the steps wit...
Il y a 10 ans
Sydney Oracle Lab

Client support for WITH using PL/SQL - My employer has been using 12c for about a year now, migrating away from 11gR2. It's fun working out the new functionality, including wider use of PL/SQL. ...
Il y a 10 ans
Unisoft Technologies Nagpur

Restoring and Recovering the Database on a New Host using RMAN - This blog will demonstrate detailed steps to restore a database on New Host using RMAN. You can also use it to move a production database to new host as...
Il y a 10 ans
Oracle and beyond...

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 10 ans
Just Another Day of Apps DBA's Life

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 10 ans
Oracle And MySQL Database | Zahid Quadri'S Blog

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 10 ans
Kyle Hailey

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 10 ans
Erdem ALTUNKAYNAK | Oracle Blog

ODI Interface'lerinde çalışma süresiyle ilgili performans iyileştirmeleri - Merhabalar, Bir önceki yazımda ODI Uygulama Performans İyileştirme calısmasına ek olarak ,du yazımdada ODI üzerinden yapılan geliştirmelerde yaşanılan per...
Il y a 10 ans
Oracle Internals from Basic to Advanced....

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 10 ans
THE RAJESH BLOG

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 10 ans
oracle-developer.net

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 10 ans
ORAganism

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 10 ans
Iordan Iotzov's DBA blog

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 10 ans
Roger Troller's Blog

- 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 10 ans
Lczinkoc's Blog

ACCESSIBLE BY clause versus Function Based Indexes - Oracle introduced the ACCESSIBLE BY clause in 12c to improve the security of subrograms. Basically the scenario is following: Let’s create a tax stored fun...
Il y a 10 ans
Alexander Kornbrust Oracle Security Blog

DOAG 2015: Best of Oracle Security 2015 - Yesterday I gave my yearly presentation “Best of Oracle Security 2015” at the DOAG 2015 conference in Nürnberg. In this presentation I showed different Ora...
Il y a 10 ans
OTN Garage

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 10 ans
O R A C L E | Simple Solution

Database Link between Oracle Database and SQL Server Database - Here is link of this post Database Link between Oracle Database and SQL Server Database This site moved to dbacatalog.blogspot.com please visit dbacatalog....
Il y a 11 ans
Inside Oracle APEX by Patrick Wolf

Oracle APEX 5.0.2 now available - Oracle Application Express 5.0.2 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.2, ...
Il y a 11 ans
Mete Karar's Weblog

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 11 ans
Oracle Performance and Backup Blog

Automation for DBA - Vagrant part 2 - Hello, In the last post I presented steps to create Virtual Machine using Vagrant with Virtual Box. It is a native combination but there are other possib...
Il y a 11 ans
Emre Baransel - Oracle Blog

Exadata 12.1.2.2.0 Software is Released - Good new features announced, such as finding Flash Cache and Flash Log statistics on AWR, automatic ASM data redundancy check even shutting down a storage ...
Il y a 11 ans
Inside Documentum

Using the Spark Event Timeline - Source: Using the Spark Event Timeline
Il y a 11 ans
AWR TOP 5 Timed Events Analysis

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 11 ans
OTN DBA/DEV Watercooler

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 11 ans
The Blog from the DBA Classroom

Oracle University Provides the Best Test Fests - Oracle University Certification Exams Are once again available at Test Fests at various events. Last year at the TECH14 and APPS14 conferences, the UK Orac...
Il y a 11 ans
The Blog from the DBA Classroom

Oracle University Provides the Best Test Fests - Oracle University Certification Exams Are once again available at Test Fests at various events. Last year at the TECH14 and APPS14 conferences, the UK Orac...
Il y a 11 ans
Dulcian, Inc.

Patient-Centered Chronic Care Plan - In January 2015, the Centers for Medicare and Medicaid (CMS) announced a new initiative: Chronic Care Management (CCM). CCM is intended to assist clinici...
Il y a 11 ans
The DBA Life

Windows 10 and E-Business Suite - Tomorrow (July 29, 2015) we will see the release of Windows 10 into the wild. PC's all over the world that aren't under "enterprise control" have been si...
Il y a 11 ans
Niko Köbler

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 11 ans
Sysadmin and DBA tips » Sysadmin and DBA tips

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 11 ans
Oadba's Blog

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 11 ans
Ronald's Oracle

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 11 ans
Robert G. Freeman on Oracle

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 11 ans
Sreedhar dba

How to Relocate the MySQL Binary Logs to New Location - The binary logs are created in the data directory by default in MySQL Server. To have the binary logs in the data directory is not always the optimal l...
Il y a 11 ans
Oracle Standard Edition blog - All about Oracle but in Standard Edition :)

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 11 ans
Francois Degrelle's blog

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 11 ans
Neeraj Bhatia's Blog

Top Challenges in the Life of an IT Capacity Manager - Let me first confess. I don’t have double-digit years of experience in IT Capacity Management. But I would say, during last 9 years I have defined the proc...
Il y a 11 ans
The Momen Blog

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 11 ans
Understanding Oracle

Maintaining Tempfile in TEMP Tablespace of PDB$SEED in Oracle 12c (12.1.0.2) - During testing recovery procedures for one of the ongoing projects I wanted to test the "complete disaster" recovery scenario. In this scenario I had to r...
Il y a 11 ans
A W i d e r V i e w

How To Approach Different Oracle Database Performance Problems - This page has been permanently moved. Please CLICK HERE to be redirected. Thanks, Craig. How To Approach Different Oracle Database Performance Problems J...
Il y a 11 ans
Pocket ORACLE: The Definitive Pocket Reference for Oracle!

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 11 ans
Karen Morton

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 11 ans
The Lazy Tech's Blog

Shifting IT to scale - While some IT groups are fine tuning their practices, many others are still on the journey to achieve greater efficiency at scale. Not all can make this s...
Il y a 11 ans
Triggers Considered Harmful, Considered Harmful

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 11 ans
ORACLE DBA

Shrink a datafile, when ALTER TABLESPACE COALESCE is not working. - In a 11.2.0.3 database, we tried to reclaim space from USERS tablespace. We faced a problem. We use the following query to the the end of a particular USERS'...
Il y a 11 ans
Oracle Newbie DBA / Apps DBA

- What To Do If A Concurrent Request Is Inactive With No Manager Status? APPLIES TO: Oracle Concurrent Processing - Version 11.5.10.0 to 12.2 [Release 11.5 ...
Il y a 11 ans
Oracle DBA and Apps DBA blog

No Write Permission on ACFS Mount Point - Last night, I managed to create the ACFS Mount Point after resolving the issue *"ACFS-9459: ASVM/ACFS is not supported on this os version"*. But, after ...
Il y a 12 ans
Oracle DBA's Blog

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 12 ans
Oracle Database: Lets explore it

Testing 123 - This is is testing message. Pls ignore.
Il y a 12 ans
blog.contractoracle.com

Oracle encrypted table data found unencrypted in SGA - When data needs to be kept private, or companies are worried about data leakage, then they often choose to store that data in encrypted columns in the tabl...
Il y a 12 ans
Database administrator workshop

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 12 ans
Oracle Musings

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 12 ans
My Oracle World

_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 12 ans
I'm just a simple DBA on a complex production system

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 12 ans
Oracle Database Administrator

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 12 ans
Get Proactive—The Insider's Track

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 12 ans
Brendan's blog

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 12 ans
Oracle DBA Exchange

Cluster Definition - In Oracle, *clustering* is a way of ordering the physical placement of tables on a disk drive in such a way as to speed up I/O access times. This is accom...
Il y a 12 ans
The Tom Kyte Blog

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 12 ans
Kannst nie wissen! | You can not ever know everything!

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 12 ans
Square DBA - Oracle DBA Talk

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 12 ans
ORACLE BLOG Zekeriya Besiroglu

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 12 ans
MON BLOG

@Bouarada : Some historical pictures -
Il y a 12 ans
My handy Oracle scripts

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 12 ans
el-caro

12C ADG Enhancements - - *Explain plan now works on Standby* SQL> select database_role from v$database; DATABASE_ROLE ---------------- PHYSICAL STANDBY SQL> selec...
Il y a 13 ans
DB Optimizer

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 13 ans
Coskan's Approach to Oracle

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 13 ans
A-Team - SOA

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 13 ans
Oracle SQL Stuff (by example)

Aggregated Lists: Creating Aggregated List Strings - ListAgg() Function. - Oracle's ListAgg() Function -- Or Other Methods. Given the following sample data shown below, we want to aggregate the elements into a single, comma sep...
Il y a 13 ans
Dominic Giles Blog

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 13 ans
Oracle database generic

Some Of Basic Questionnaire For Newly Release Oracle Database 12c - 1) What is an Pluggable database really? Ans-> This is new feature in oracle 12.1 release with respect to database. With this release there is a parent-c...
Il y a 13 ans
The great grandson of Husnu Sensoy

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 13 ans
Performance Tuning Hints

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 13 ans
blog.gerwinhendriksen.com

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 13 ans
The Oracle Sponge

Little Changed - Incredible and depressing to see people still getting Oracle internals as wrong as this.
Il y a 13 ans
For DBA

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 13 ans
Tyler Muth's Blog

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 13 ans
DBA Sensation

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 13 ans
Oracle Performance Tuning: Join Operations

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 13 ans
Inside Enterprise Information

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 13 ans
OraClever

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 13 ans
Miladin Modrakovic's Blog: Oraclue

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 13 ans
ORACLE CERTIFIED PROFESSIONALS

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 14 ans
OracleBlog

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 14 ans
APPS:ASM:EXADATA:DATAGUARD:RAC:OEM

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 14 ans
oracle on Collected

Free Book: Introducing Microsoft SQL Server 2012 - Michael McLaughlin‘s blog has a post about a free MS SQL Server book (Introducing Microsoft SQL Server 2012) available here. If you are into MS SQL Server...
Il y a 14 ans
SQL Tuning

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 14 ans
ORAXperts blogs

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 14 ans
Mandela

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 14 ans
Base de données Oracle : partage d'expérience...

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 14 ans
rmoff

Blogging - I will now be blogging mostly over at the venerable blog of my employer, Rittman Mead. You can see my first posting here: Web Services in BI Publisher 11g....
Il y a 14 ans
Long Live Oracle!

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 15 ans
OraJourn

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 15 ans
oracledba.ru

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 15 ans
Oracle Newbies Blog

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 15 ans
Dion Cho - Oracle Performance Storyteller

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 15 ans
Oracle DBA

Materialized View - +++++++++++++++++++++++++++++++++++++ MVIEW refresh Status on MASTER Site : +++++++++++++++++++++++++++++++++++++ set pages 1000 set linesize 180 col SNAPSHO...
Il y a 15 ans
Christian Bilien's Oracle performance and tuning blog

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 16 ans
Girlgeek's Oracle Blog

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 16 ans
Mark Williams :: Blog

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 16 ans
Yet another Database Blog

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 17 ans
Troubleshooting Apps DBA

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 17 ans
Linux + Administrator = Linuxator

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 17 ans
Eddie Awad's Blog

★ 5 Links from Around the Web (2007-04-10) - Links to interesting, educational, informational, or just plain fun websites...
Il y a 19 ans
Oracle Sponge -- Now Moved To Wordpress

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 20 ans
Oracle blog

Difference between SCN and checkpoint. - SCN and checkpoint: System change number(SCN) is represented with SCN_WRAP and SCN_BASE. Whenever SCN_BASE reaches 4294967290 (2 power 32), SCN_WRAP goes u...
Il y a 20 ans
A platform for Oracle professionals

-
Grid-IT BLOG

-
www.oracledba.co.uk

-
Oracle Optimizer

-
JJA News Page

-
DATABASE DEBUNKINGS

-
Database Security - Data Loss Prevention | McAfee Products

-
Planet Oracle

-
Morgan's Library Daniel Morgan's Oracle Blog DBA Developer SQL PL/SQL

-
Oracle Apps DBA Kaparelis

-
Blog | Tuning Knife Consulting | Exceptional Database Expertise

-
René Nyffenegger on Oracle

-
MY APPS DBA.COM

-
Dominic Giles Blog

-
Oracle's MySQL Blog

-
Siebel Essentials

-
The Data Warehouse Insider

-
My Journey as an Oracle DBA

-
Blog: The Real Stori - Stori: Find, Understand & Solve Oracle Performance Problems

-
Digora I Gestion des Données I

-
Sangam13 - The largest Oracle user group event in India

-
ArKZoYd

-
ArKZoYd

-
Oracle University

-
Oracle Security Blog | Integrigy

-
DavidLitchfield.com

-
Oracle Andy Technology

-
Steve O'Hearn's Blog

-
Oracle DBA support

-
Michael Wilson's Oracle DBA Blog

-
Inside Oracle - Julian Dyke

-
Oracle Database In-Memory

-
Oracloid Blog

-
The Oracle Software Security Assurance Blog

-
Oracle Enterprise Manager

-
Bridging Vision & Technology

-
EASYTEAM LE BLOG

-
Techienawa

-
OraWorld Blog | Oracle Articles Blog

-
Structured Data

-
Techienawa

-
Oracle DBA Adventures

-
Oracle Warehouse Builder (OWB)

-
OracleFlash.com: Oracle Articles, Tutorials, Step by Step Install Guides, Scripts.

-
Company Blog | Blue Medora

-
Cuddletech

-
Ora-600 | Zrozumieć wyrocznię

-
Paul Broughton's Blog

-
Go-Faster Consultancy Ltd. - Make your system go more quickly!

-
Bar Solutions WebLog

-
Oracle's Linux Blog

-
Summersky RAC Notebook

-
Simple Talk: SQL Server and .Net articles, forums and blogs

-
EvDBT.Com - Home Page

-
DbRunas - Noticias y Recursos sobre Bases de Datos

-

Tout afficher

Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

lundi 17 août 2015

PLW-07204: conversion away from column type may result in sub-optimal query plan