ORACLE : DATABASE قاعدة بيانات Base de données: 12C:SQL Plan Directives

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

Martins Blog

Creating copies of your multi-TB databases doesn’t have to take forever - Back in the day when I worked as a production DBA I vividly remember all the coordination meetings that we held to ensure that the planned clone of our pro...
Il y a 7 heures
Technology Geek

Testing Terraform: Native Tests, Static Analysis, and Policy Gates - Infrastructure code that manages production deserves the testing pyramid application code gets, and the tooling finally supports it properly. Today: the la...
Il y a 17 heures
ThatJeffSmith

Ingest, chunk, vectorize, and load VecDB Tables with SQLcl Model command - How to setup a RAG pipeline in Oracle SQLcl, from ingesting your local documents to your vector database tables to pulling the data back out using our MC...
Il y a 1 jour
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 2 jours
Ask Tom MOST RECENT ARTICLES

Will Oracle AI Database be renamed again to Oracle SI Database? - (Not so serious) question is in the subject :-)
Il y a 2 jours
Annals of Oracle's Improbable Errors

Capture VS Code requests to Ollama using MITM reverse proxy - Have you ever wondered what exactly your VS Code AI extensions are whispering to your local models? By setting up a Man-in-the-Middle (MITM) proxy, you can...
Il y a 2 jours
Market Solutions to Our Energy Needs

Trillion-Dollar Ambition Meets the Laws of Physics: Why Compute Infrastructure Must Return to First Principles - Over the next decade, global capital expenditure on artificial intelligence infrastructure and modern computing campuses will cross the trillion-dolla...
Il y a 3 jours
sqlandplsql.com

Fakta Seputar SLOT88 yang Perlu Diketahui Sebelum Bermain - Fakta Seputar SLOT88 yang Perlu Diketahui Sebelum Bermain SLOT88 merupakan istilah yang dapat ditemukan dalam berbagai pembahasan mengenai permainan onli...
Il y a 3 jours
Learning is not a spectator sport

My AI World itinerary - I used AI to plan out my AI World. Here’s how I did it If you’re interested in a database-focused week at AI World, here’s the itinerary it generated. Sch...
Il y a 3 jours
Learning is not a spectator sport

My AI World itinerary - I used AI to plan out my AI World. Here’s how I did it If you’re interested in a database-focused week at AI World, here’s the itinerary it generated. Sch...
Il y a 3 jours
Dennis Yurichev

[Crypto] Communicating with TPM 2.0: the first step -
Il y a 1 semaine
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 1 semaine
Vlad Mihalcea's Blog

Thirteen years of blogging - Thirteen years later! Thirteen years ago today, I created this blog on WordPress.com because I wanted to share some best practices I discovered while dev...
Il y a 1 semaine
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 1 semaine
IT WorldIT World

Flink CDC for database replication to big data - Preamble Flink CDC is the parallel product of Flink for data movement, as the official documentation states: Flink CDC is a distributed data integration ...
Il y a 1 semaine
The ORACLE-BASE Blog

SQL Plan Management (SPM) Baseline Issue - I had an odd issue with a baseline recently in 19c (19.32). I thought I would share it in case someone else comes across a similar issue. The initial pro...
Il y a 1 semaine
Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

NMON en Oracle AI Database 26ai: investigando el nuevo observador de la red - Oracle AI Database 26ai incorpora numerosos cambios que resultan inmediatamente visibles para administradores y desarrolladores: nuevas capacidades re...
Il y a 1 semaine
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 2 semaines
Timur Akhmadeev's blog

Analyzing Log Writer slow writes - In the modern Oracle database releases, the Log Writer or its slaves produce well known messages like this: Warning: log write elapsed time 987ms, size 6KB...
Il y a 2 semaines
Ric Ramblings

End of an Era or something like that. - On Monday 14 September 2026 at 6AM Eastern US time I was one of many who were told that our services were no longer required at Oracle. I suppose I coul...
Il y a 2 semaines
Data Warehousing with Oracle

Aggregation Filters in Oracle 26ai - The FILTER clause in SQL allows an easy way of adding WHERE conditions to aggregation functions. There were other ways to implement this before, but this s...
Il y a 2 semaines
DBA Kevlar

Keeping Your AI Eye on the Right Ball - I haven’t blogged in a while, been a little busy, but today I found I was in a writing craze or maybe because Oracle announced layoffs, and Oracle is the c...
Il y a 3 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 4 semaines
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 4 semaines
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 4 semaines
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 5 semaines
Philipp Salvisberg's Blog

Implicit Outer Joins in Join-to-One: Feature or Flaw? - Background As you probably know, I’m maintaining a parser for grammars used in SQL files for Oracle AI Database and PostgreSQL. As a result, I check for ...
Il y a 5 semaines
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 1 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 1 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 1 mois
Apps DBA Workshop

OCI Key Vault for Oracle E-Business Suite on OCI - Architecture & Implementation Guide OCI Key Vault for Oracle E-Business Suite on OCI Centralize secrets, protect encryption keys, grant access through wor...
Il y a 1 mois
Simple Oracle Dba

Creating an Oracle 26ai database from a Single Script - Cool. - TL;DR: The One Script you will Ever Need to create an Oracle 26ai Database. And for you to configure, should you want to. After a remark from a colleague...
Il y a 1 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 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 2 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 2 mois
Lovely Oracle

Protect Your Oracle Database from SQL Injection and Unauthorized Access with SQL Firewall - SQL injection and credential misuse remain serious threats to database security. Oracle SQL Firewall offers a practical way to defend against these risks...
Il y a 2 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 3 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 5 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 5 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 5 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 5 mois
Oracle mechanics

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

Create a table out of nothing - sql table out of nothing
Il y a 6 mois
a Danish Sql and Pl/Sql Developer

Assertions for data integrity on a less-than-ideal data model - 25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mostly I worked wi...
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 7 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 7 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 7 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 7 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 8 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 8 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
Oracle

Purchasing model - A SQL Server running in an Azure virtual machine (IaaS) is equivalent to an on-premises SQL Server. You'll notice that several features described for SQ...
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 9 mois
HeliFromFinland | Heli's Oracle thoughts

Select AI Agents: Santa’s Workshop Runs on Oracle, Reindeer Health Copilot. And the wrap up. (6/6) - By Heli and Marko Helskyaho Last but definitely not least: Reindeer Health Copilot: Santa’s AI veterinarian on Duty 24/7. Reindeer … Continue reading →
Il y a 9 mois
HeliFromFinland

Select AI Agents: Santa’s Workshop Runs on Oracle, Reindeer Health Copilot. And the wrap up. (6/6) - By Heli and Marko Helskyaho Last but definitely not least: Reindeer Health Copilot: Santa’s AI veterinarian on Duty 24/7. Reindeer … Continue reading →
Il y a 9 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 11 mois
Grassroots Oracle

Ideas as a precursor to Oracle APEX #JoelKallmanDay - It seems if I post only once a year, it's for Joel Kallman Day... Last year I hinted of a small side story to a remediation project that was upgrade the...
Il y a 11 mois
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
Dimitri Gielis Blog (Oracle Application Express - APEX)

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 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 4 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 6 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 6 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 6 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 6 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 6 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 7 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 7 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 8 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 8 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 9 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 9 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 10 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 10 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
Enkitec.tv

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

Affichage des articles dont le libellé est 12C:SQL Plan Directives. Afficher tous les articles

mercredi 21 octobre 2015

SQL Plan Directives

Franck Pachot :
SQL Plan Directives