ORACLE : DATABASE قاعدة بيانات Base de données: Architecture d'une base des données Oracle

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

Technology Geek

Advanced OCI Cost Management Resource Optimization and Predictive Budget Control - Cloud cost management has evolved from simple monitoring to sophisticated FinOps practices that combine financial accountability with operational efficienc...
Il y a 11 heures
The ORACLE-BASE Blog

30 years? OK, but what do you actually do? - I was recently contacted by a former colleague. We both started our first job in tech at the same company on the same day. His message started like this....
Il y a 15 heures
sqlandplsql.com

Keamanan dan Kepercayaan dalam Bermain di Situs Slot Scatter Hitam - Keamanan dan Kepercayaan dalam Bermain di Situs Slot Scatter Hitam Dalam memilih situs slot pusatgame online, aspek keamanan dan kepercayaan menjadi fakt...
Il y a 22 heures
DBA survival BLOG

SHOW CONFIGURATION VERBOSE changes in 23.9 - Traditionally, the DGMGRL command SHOW CONFIGURATION VERBOSE not only retrieved detailed configuration information but also triggered a health check. Th...
Il y a 1 jour
Simple Oracle Dba

Oracle23ai and python - Measuring (Network-)Time. - TL;DR: I wanted a utility-function in python to report the "time spent", notably looking for "Network-Time". It evolved during coding into a time-reporti...
Il y a 1 jour
oracle-recipes

Create a table out of nothing - sql table out of nothing
Il y a 1 jour
Sujeet APPS DBA

Query to get the package specification - In *Oracle E-Business Suite R12.2.10*, if you want to *download (export)* a package’s source code (specification and body), you can do it using a SQL que...
Il y a 1 jour
Pete Finnigan's Oracle security weblog

What is a Schema in Oracle? - In Oracle a user is the same as a schema - well not 100% true - so lets explain a bit. Firstly at a logical high level in Oracle a user is an account used ...
Il y a 1 jour
Learning is not a spectator sport

Quick tip for OpenAI on APEX - Posting this here simply because I constantly forget it 🤣, and end up wasting hours of my life on a trivial thing! When configuring your APEX workspace to...
Il y a 1 jour
Learning is not a spectator sport

Quick tip for OpenAI on APEX - Posting this here simply because I constantly forget it 🤣, and end up wasting hours of my life on a trivial thing! When configuring your APEX workspace to...
Il y a 1 jour
Market Solutions to Our Energy Needs

Accelerating Grid Transformation - Key Questions & Answers - Accelerating Grid Transformation Overview This briefing document summarizes key themes and ideas from the "241023 Energy Catalyst - Accelerating Grid Tra...
Il y a 2 jours
AMIS Technology Blog

Quarkus – Kubernetes extension (reinvestigated, part 5), using Vagrant and shell scripts to further automate setting up my Quarkus demo environment, and implementing a Service of service type LoadBalancer - In my previous article, I shared with you the steps I took, to further automate setting up my demo environment, and implementing a Service of service typ...
Il y a 2 jours
Ask Tom MOST RECENT ARTICLES

printing data vertically like PRINT_TABLE via sqlplus - In some 10gr2 and 11gr2 Customer's databases I need, inside sqlplus , print some data vertically, much like your PRINT_TABLE function, but my user is "read...
Il y a 2 jours
Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

Oracle Hot Topics, Ago 13, 2025 - Bugs Bug Product Area Bug ID Last Updated ORA-600 [KGLDELETEALLPINSONOBJ1] GENERATED BY MMON FOR DROP MATERIALIZED VIEW "SYSTEM"."MV$$_ Oracle Datab...
Il y a 2 jours
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 4 jours
Bobby Durrett's DBA Blog

Migrating WordPress to Amazon Linux 2023 - I recently migrated my WordPress blog from Amazon Linux 2 to Amazon Linux 2023 to take advantage of newer software versions. The process was mostly smooth,...
Il y a 4 jours
IT WorldIT World

MongoDB Time Series collection hands-on - Preamble We are studying different solutions to efficiently store Timeseries data for different use cases like: Effective retrieval of IOTs/Sensors infor...
Il y a 5 jours
DBA Kevlar

Career Lessons from Mentoring - Why I Move On, and Why You Might Need To I mentor between three and five individuals at any given
Il y a 1 semaine
ThatJeffSmith

Coding React Apps with Oracle Database MCP & Claude Sonnet 4 - How I built a REACT web app for my Oracle Database with the assistance from my AI Agent and our MCP Server in only a few minutes. The post Coding React A...
Il y a 1 semaine
Geodata Master

Dropping AWR Snapshot is failing with ORA-13516: AWR Operation failed: AWR Schema is unavailable due maintenance - A very interesting case I have faced in an Oracle database environment patched with 19.27 RU, I tried dropping an AWR snapshot and it failed as shown below...
Il y a 1 semaine
Martins Blog

Why does my call to json_table return null for a column despite it not being empty? - I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to store rather large JSON documents, individual field lengths exceeding ...
Il y a 1 semaine
Hemant's Oracle DBA Blog

An introduction to Oracle Cloud Infrastructure - A *1hour video* Description: This session will cover the fundamentals of Oracle Cloud Infrastructure (OCI) including cloud concepts, OCI structures, a...
Il y a 1 semaine
Data Warehousing with Oracle

Oracle 23.9 supports GROUP BY ALL - Aggregating data is now easier than ever before with the newest version of Oracle database 23ai. Oracle version 23.9 supports the GROUP BY ALL syntax. Some...
Il y a 1 semaine
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 semaine
Oracle Scratchpad

Bind Peeking - Here’s a simple detail about bind peeking (during optimisation) that makes a big difference to “fetch first/next” queries. The optimizer knows about your b...
Il y a 2 semaines
Lovely Oracle

Install Wan2.2 Locally with Free ComfyUI Workflow: Text-to-Video and Image-to-Video - This video locally installs Wan2.2, which is the premier video foundation model. *Models :* Comfy-Org/Wan_2.2_ComfyUI_Repackaged at main *Workflow...
Il y a 2 semaines
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 2 semaines
The PeopleSoft DBA Blog

Determining Optimal Index Key Compression Length - In 2008, Richard Foote wrote this still excellent 4-part guide to index key compression. - Index Compression Part I (Low) - Index Compression ...
Il y a 3 semaines
Ric Ramblings

Recording of Reading Plans - Hey folks! Here is a link to the reading plans talk I did with Chris Saxon of Ask Tom Office hours last week. https://www.youtube.com/watch?v=Waqdsae...
Il y a 3 semaines
Laurent Schneider

sqlite3 - I just tried sqlite. It is ultra-light and support SQL commands. Just try this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" fo...
Il y a 3 semaines
Annals of Oracle's Improbable Errors

stringify() or to_string() ? - While I was experimenting with genAI LLMs applied to generating PL/SQL code, I noticed that Claude-Sonnet created a function containing a *stringify()* met...
Il y a 3 semaines
Biju's Oracle Notes

ExaDB-XS vs ExaDB-D – When to choose ExaDB-XS - Let’s compare Exadata Database Service on Exascale Infrastructure (ExaDB-XS) and Exadata Database Service on Dedicated Infrastructure (ExaDB-D) and review ...
Il y a 3 semaines
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 4 semaines
Philipp Salvisberg's Blog

Outer Joining With ANSI SQL-89 and SQL-92 - Introduction I recently implemented a quick fix for the rule G-3130 to transform queries to ANSI SQL-92 syntax. One of the challenges was to handle Oracl...
Il y a 4 semaines
DB Oriented » English

Mixed Feelings About MERGE - I have a love-hate relationship with the MERGE SQL statement. Well, maybe it’s a bit harsh. Let’s make it a like-dislike relationship. Why I Like It Beca...
Il y a 4 semaines
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 mois
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 mois
The Go-Faster Oracle Blog

Deadlock within DML statements - Oracle maintain a very detailed note Troubleshooting "ORA-00060 Deadlock Detected" Errors (Doc ID 62365.1). - This document includes an example tha...
Il y a 1 mois
Pavan DBA's Blog

Navigating success: the manufacture of navigation buoys in indonesia - Indonesia’s manufacturing sector plays a vital role in the maritime industry, particularly in the production of navigation buoys. These essential tools ens...
Il y a 1 mois
www.markusdba.de | Markus Flechtner – Meine Erlebnisse rund um Oracle …

Unterschiedliche Benutzer, unterschiedliche Versionen, unterschiedliche Ergebnisse - Bei der Aktualisierung meines Beitrages zum SYSAUX-Tablespace habe ich ein SQL-Skript ergänzt, mit dem man in einer Container-Datenbank die Belegung des SY...
Il y a 1 mois
Oracle Study Notes by Denis

SnowSQL config password needs to be enclosed in double quotes - Today I tested how to use snowsql to connect to SnowFlake. I put the connection credential in the config file. But I encountered the following error mess...
Il y a 1 mois
Helios's Blog

Oracle CDB vs Non-CDB: A Future-Ready Database Architecture - As you know With the release of Oracle Database 12c, Oracle introduced a major shift in database architecture: the Multitenant Architecture, also known as ...
Il y a 2 mois
Thinking Out Loud

Cash Is Not King - Typical Asians hide money mattresses. I have finally started a portfolio for my spouse. Better to buy bottom then top. Before investing please understand a...
Il y a 2 mois
Cap Data Team SGBD Blog : Oracle, SQL Server, MySQL, Sybase...

PostgreSQL Basics : lire un plan d’exécution comme un·e pro (ou presque) - Introduction : Quand une requête PostgreSQL est considérée comme lente ou que ses performances se dégradent soudainement, il y a un réflexe à toujours av...
Il y a 3 mois
www.ORACLE-CKPT.com

Oracle SQL Plan Instability: Why SQL Profiles Are Not Enough and SQL Plan Baselines Are the Reliable Solution - In performance-critical environments, having consistent SQL execution plans is essential. A common challenge arises when... The post Oracle SQL Plan Inst...
Il y a 3 mois
Vlad Mihalcea's Blog

MySQL Query Optimization with Releem - Introduction In this article, I’m going to show you how to optimize the queries executed by a Spring application running on MySQL using Releem. For a sho...
Il y a 3 mois
Talip Hakan Ozturk's ORACLE BLOG

How To Recreate MGMT Database in 12c/19c Grid Infrastructure? - Hello, From 12c onwards, MGMTDB which is known as Grid Infrastructure Management Repository Database (GIMR) which stores diagnostic and performance related...
Il y a 3 mois
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 3 mois
Oracle SQLOracle SQL

Oracle Telegram Bot - For the Oracle performance tuning and troubleshooting Telegram channel https://t.me/ora_perf, I developed a simple helpful Telegram bot. It simplifies comm...
Il y a 3 mois
MacLochlainns Weblog

Comparative Techniques - This post is designed to illustrate PL/SQL code with techniques employed before Oracle Database 12c with manual sequence references rather than auto genera...
Il y a 4 mois
External Table

ATLAS DCS Analysis with Apache Spark and Jupyter Notebooks - The *ATLAS Detector Control System (DCS)* at *CERN *is essential for ensuring optimal detector performance. Each year, the system generates tens of billi...
Il y a 4 mois
Julian Dontcheff's Database Blog

MongoDB API: operations and data types supported by Oracle Database - “With the right set of mind, with the right people, with the right support, things happen.” Grigor Dimitrov There is an extensive list of the MongoDB APIs,...
Il y a 5 mois
Julian Dontcheff's Database Blog

MongoDB API: operations and data types supported by Oracle Database - “With the right set of mind, with the right people, with the right support, things happen.” Grigor Dimitrov There is an extensive list of the MongoDB APIs,...
Il y a 5 mois
A! Help

23ai JDBC Driver Does Not Consider RETRY_COUNT and RETRY_DELAY - RETRY_COUNT and RETRY_DELAY are key to setting up JDBC client failover setup. Adjusting these parameters allow connection pool to wait for the duration pla...
Il y a 5 mois
berxblog

Sessionless Transactions - the moving target - Sessionless Transactions are quite new to Oracle. Some might argue this is not true: XA transactions are available since Oracle 7. The new Sessionless Tra...
Il y a 5 mois
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 5 mois
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 6 mois
Learners Reference - Learners Reference

HABITS help us align our values with daily - HABITS are daily and our daily life is decided by our HABITS. Good (or) bad our life is decided by HABITS Our values define our life and it is possible to ...
Il y a 6 mois
Oracle mechanics

Oracle 19c: Online Statistics Gathering и скорость выполнения операций Drop / Truncate Partition - Начиная с 19 версии Partitioned Table Statistics Changed After Truncate Partition or Drop Partition Operation (Doc ID 2970098.1) On Oracle 19C, a partition...
Il y a 6 mois
Jeremy Cole

Reflections on a year of biking for 2024 - Since shortly after moving to Seattle in July 2022, I have not driven a car. I’ve gotten around by bike and public transit. During 2023, I stayed mostly in...
Il y a 7 mois
Usn's IT Blog

Install Oracle 23ai ASM on Linux from Exadata Sources - Why Oracle 23ai from Exadata? With Oracle Database 23ai being postponed to a later date (“tba”) in November 2024, and many people not being part of the Ora...
Il y a 7 mois
Apps DBA Workshop

OLVM Backup and Restore - Oracle Linux Virtualization Manager (OLVM) is a powerful virtualization platform based on oVirt. Ensuring consistent backups of the OLVM environment is cri...
Il y a 9 mois
Dennis Yurichev

Please update your RSS URL -
Il y a 9 mois
Oracle

pre-post check script - ####################################################### #!/bin/ksh # set the DB env and run # Script to check PRE & Post checks Manually # # CB - -...
Il y a 9 mois
Oracle

Microsoft Fabric - Data Factory (microsoft.com) *Create a Data Flow* Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft Learn Getting Started wi...
Il y a 9 mois
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 11 mois
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 1 an
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 1 an
"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 1 an
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 1 an
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 1 an
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 1 an
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 1 an
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 1 an
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 1 an
The Data Warrior | Changing the world, one data model at a time. How can I help you?

Introducing the All New Data Vault Alliance Professional Membership - This is very exciting news to everyone interested is upping their #DataVault 2.0 game with access to exclusive member benefits including regular coaching a...
Il y a 1 an
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 1 an
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 2 ans
Richard Foote's Oracle Blog

The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”) - Of all my many Oracle blog posts, this particular post will remain with me the longest, for not only is it the last blog post I’ve done in a while, but i...
Il y a 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 2 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 3 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 3 ans
flashdba

The Biggest Gap In The Clouds? High Performance RDBMS - Over the course of the last few blog posts, we’ve looked at how an increasing number of database workloads are migrating to the cloud, how there is more th...
Il y a 3 ans
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 3 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 3 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 4 ans
Oracle's Linux Blog

A study of the Linux kernel PCI subsystem with QEMU - *Oracle Linux kernel engineer Dongli Zhang provides a cheat sheet on how to utilize QEMU to study the Linux kernel PCI subsystem.* The Linux PCI sub...
Il y a 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 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 4 ans
The Data Warehouse Insider

Autonomous Database Newsletter - March 8, 2021 - March 8, 2021 Newsletter For Autonomous Database on Shared Exadata Infrastructure Welcome to our latest customer newsletter for Autonomous Databa...
Il y a 4 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 4 ans
Oracle University

Celebrating 25 Years of Java - Twenty-five years after its initial premier, Java is still the most widely used development language in the world. It continues to be a favorite technolo...
Il y a 4 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 4 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 4 ans
Oracle Optimizer

Optimizer Real-time Statistics Parameter in RU 19.10 Onwards - The Oracle Database 21c database initialisation parameter *optimizer_real_time_statistics* has been backported to Oracle Database 19c RU 10. The real-ti...
Il y a 4 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 4 ans
Oracle Database In-Memory

Oracle Database 21c Automatic In-Memory Enhancements - In Oracle Database 21c the Database In-Memory feature Automatic In-Memory (AIM) has been significantly enhanced. I wrote a blog post about AIM when it fi...
Il y a 4 ans
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 4 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 4 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 4 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 4 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 5 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 5 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 5 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 5 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 5 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 5 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 5 ans
a Danish Sql and Pl/Sql Developer

The "Practical Oracle SQL" book is available... - You all know I've been writing on this book called "Practical Oracle SQL", right? [image: Practical Oracle SQL front cover] Well, now it's available for ...
Il y a 5 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 5 ans
Oracle High Availability

ORA 29648 Error Java Mismatch - Error Msg = ORA-29548: Java system class reported: joxcsys: release mismatch, 12.2.0.1.190716 1.8 in database (classes.bin) vs 12.2.0.1.200114 1.8 in execu...
Il y a 5 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 5 ans
Grassroots Oracle

APEX Component Settings for Switch - While I point out a 'hidden' setting for Switch items in APEX, I want to comment on two related item types found in Oracle APEX => radio buttons and checkb...
Il y a 5 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 5 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 5 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 5 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 5 ans
Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

DBMS_CLOUD : Loading a TEXT file without any DELIMITER - Recently I was working on an issue related to loading data from a flat file on to Autonomous Data Warehouse using dbms_cloud api. While lot has been writte...
Il y a 5 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 5 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 5 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 5 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 5 ans
ORACLE

PL/SQL & SQL Coding Guidelines Version 3.6 - PL/SQL & SQL Coding Guidelines Version 3.6
Il y a 5 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 5 ans
Notes on Oracle

Human readable JSON, stored in BLOB - Currently Oracle (we're using Oracle 18c at the moment) is still recommending to store your JSON document in a BLOB column. More efficient, no character ...
Il y a 5 ans
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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 ans
Øystein on MySQL Optimizer

MySQL Parallel Index Range Scans: One is Sometimes Better Than Two - As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to POLARDB for MyS...
Il y a 5 ans
HeliFromFinland | Heli's Oracle thoughts

OGB Appreciation Day: free cloud and people - Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day! First of all I am thankful for the people like … Continue reading →
Il y a 5 ans
HeliFromFinland

OGB Appreciation Day: free cloud and people - Thank you, Tim Hall (oracle-base.com), for the OGB Appreciation Day! First of all I am thankful for the people like … Continue reading →
Il y a 5 ans
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 5 ans
Rafu on db

Access Path Suggestor - Postgresql - Here is an improved access path suggestor from postgresql metadata. Based from my Oracle version. In addition to visualized path alternative this generates...
Il y a 5 ans
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 5 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 5 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 5 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 6 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 6 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 6 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 6 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 6 ans
The Oracle Software Security Assurance Blog

Security Alert CVE-2019-2729 Released - Oracle has just released Security Alert CVE-2019-2729. This vulnerability affects a number of versions of Oracle WebLogic Server and has a CVSS Base Sco...
Il y a 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 ans
It Was Like That When I Got Here

Oracle 19c New Features -
Il y a 6 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 6 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 6 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 6 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 6 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 6 ans
Oracle PL/SQL Developer

bbb -
Il y a 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 ans
Confessions of an Oracle Magi

Thoughts on the Oracle ACE Program - Four years ago during ODTUG KScope14, I was designated as an Oracle ACE in the area of Database Development. Vikki Lira, who ran the ACE program at the tim...
Il y a 6 ans
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 6 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 7 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 7 ans
TwelveC

Failover with Amazon Aurora PostgreSQL - https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/ Advertisements
Il y a 7 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 7 ans
Oracle Solution Hub

List_comprehension - if True A else B : List Comprehension
Il y a 7 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 7 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 7 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 7 ans
Oracle Warehouse Builder (OWB)

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 7 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 7 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 7 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 7 ans
Timur Akhmadeev's blog

5 years - I’ve joined Pythian exactly 5 years ago. Back then I was a performance guy, with no real DBA and operational support experience. I knew enough about techno...
Il y a 7 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 7 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 7 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 7 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 7 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 7 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 7 ans
Kerry Osborne's Oracle Blog

Hotsos Symposium 2018 - Just a quick note to say I’m doing a couple of talks at this year’s Hotsos Symposium, which starts next Monday at 8:30AM. It’s not too late to register. ...
Il y a 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 7 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 8 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 8 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 8 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 8 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 8 ans
Karl Arao's TiddlyWiki

SiteSubtitle - has moved to -> http://KARLARAO.WIKI
Il y a 8 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 8 ans
Oracle's MySQL Blog

MySQL Cluster 7.6: The First Milestone - The first Development Milestone Release (DMR) of MySQL Cluster 7.6--7.6.2--is now available! You can see the full changelog for 7.6.2 here. But before we...
Il y a 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 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 8 ans
Oracle Enterprise Manager

Reasons to upgrade to Enterprise Manager 13.2 - Before, during and after the Open World, I have received numerous queries on the release of Enterprise Manager 13.2. This is an important release for *En...
Il y a 8 ans
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 8 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 8 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 8 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 8 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 ans
On The Peoplesoft Road

Weblogic and Oracle HTTP Server install with /tmp - Lately I have had to install Weblogic 12.1 and OHS 12.1 on a Linux server in silent mode. Somehow, there was very small space left on the default temporary...
Il y a 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 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 9 ans
Inside Documentum

Using the Spark Event Timeline - Source: Using the Spark Event Timeline
Il y a 9 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 9 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 9 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 9 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 ans
Oracle Database: Lets explore it

Testing 123 - This is is testing message. Pls ignore.
Il y a 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 ans
MON BLOG

@Bouarada : Some historical pictures -
Il y a 11 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 11 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 11 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 ans
The Oracle Sponge

Little Changed - Incredible and depressing to see people still getting Oracle internals as wrong as this.
Il y a 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 12 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 13 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 13 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 13 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 13 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 13 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 13 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 13 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 13 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 13 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 14 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 14 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 14 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 14 ans
Oracle DBA

Materialized View - +++++++++++++++++++++++++++++++++++++ MVIEW refresh Status on MASTER Site : +++++++++++++++++++++++++++++++++++++ set pages 1000 set linesize 180 col SNAPSHO...
Il y a 14 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 14 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 15 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 15 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 16 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 16 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 16 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 18 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 19 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 19 ans
A platform for Oracle professionals

-
Grid-IT BLOG

-
www.oracledba.co.uk

-
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

-
Siebel Essentials

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

-
Oracloid Blog

-
Bridging Vision & Technology

-
EASYTEAM LE BLOG

-
Techienawa

-
OraWorld Blog | Oracle Articles Blog

-
Structured Data

-
Techienawa

-
Oracle DBA Adventures

-
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

-
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

-