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)

Market Solutions to Our Energy Needs

Our evolutionary trap...Energy, economics and the growth imperative... meets planetary limits.. - Let's explore the powerful connections between energy, economics, and evolution, drawing on the foundational concepts outlined by researcher Carey King. Th...
Il y a 1 heure
oracle-recipes

Create a table out of nothing - sql table out of nothing
Il y a 2 heures
Martins Blog

New DEBUG flag simplifies troubleshooting ORDS container image issues - I previously wrote about troubleshooting the ORDS (Oracle REST Data Services) container’s entrypoint, e.g. the script that’s run whenever an ORDS container...
Il y a 12 heures
Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

SPOUGAcademy; Como integrar la GenAI en la base de datos para ejecutar consultas con lenguaje natural - Ejecutando consultas sin escribir una sentencia completa de lenguaje de programación. La combinación de modelos de lenguaje grande (LLM) de IA generati...
Il y a 13 heures
Pete Finnigan's Oracle security weblog

Happy 21st Anniversary to my Oracle Security Blog - The 21st anniversary of this blog is coming up on the 20th September 2025. I started this blog on the 20th of September 2004 and it has been doing well eve...
Il y a 15 heures
sqlandplsql.com

Live Draw SDY: Mengungkap Semua Informasi Terkait Togel Sydney - Live Draw SDY: Mengungkap Semua Informasi Terkait Togel Sydney Togel Sydney atau yang lebih dikenal dengan sebutan togel SDY, merupakan salah satu permai...
Il y a 19 heures
External Table

Troubleshoot I/O & Wait Latency with OraLatencyMap and PyLatencyMap - *TL;DR:* When your database “feels slow,” metrics are key for investigations, however relying on averages may mislead you. That's when wait *latency hist...
Il y a 2 jours
Ask Tom MOST RECENT ARTICLES

Materialized View USING TRUSTED CONSTRAINTS and staleness=UNKNOWN - It appears USING TRUSTED CONSTRAINTS causes a materialized view to have staleness=UNKNOWN when it would otherwise be FRESH. Is it possible to have a materi...
Il y a 2 jours
Oracle mechanics

ORA-04031 с аргументами KGLH0^ при активном использовании Pipes - С коллегой Валерием Смирновым столкнулись/разбирали проблему многочисленных, вплоть до невозможности залогиниться, ошибок ORA-04031, в основном, вида: Посл...
Il y a 3 jours
Learning is not a spectator sport

Low code is dead - I was watching a live stream recently about using AI tools to generate applications, and obviously “vibe coding” is getting a lot of attention nowadays. My...
Il y a 4 jours
Learning is not a spectator sport

Low code is dead - I was watching a live stream recently about using AI tools to generate applications, and obviously “vibe coding” is getting a lot of attention nowadays. My...
Il y a 4 jours
Learners Reference - Learners Reference

Free NMLS Exam Prep Titbits - CHARM Booklet Delivery Details – CHARM booklet helps a borrower decide whether ARM is the right choice for them and helps them take control of the homebuyi...
Il y a 6 jours
Oracle

Oracle Zero Downtime Migration (ZDM) - Oracle Zero Downtime Migration (ZDM) is the Oracle Maximum Availability Architecture (MAA)-recommended solution to migrate Oracle Databases to the Oracl...
Il y a 6 jours
Lovely Oracle

Run Microsoft VibeVoice TTS Locally on CPU - In this tutorial, I install the Microsoft VibeVoice model locally and test. app.py: """ VibeVoice with Fahd Mirza """ import argparse import os im...
Il y a 6 jours
ThatJeffSmith

Asking AI to generate test data, more is better - Some advice around using LLMs to generate test data for your apps & reports, and how that can be easier with Oracle Database via our MCP Server. The post...
Il y a 6 jours
Annals of Oracle's Improbable Errors

Item ID (P9999_USERNAME) is not an item defined on the current page. - If you are hitting this weird problem when trying to login to your APEX app running on Oracle ADB 23ai: Item ID (P9999_USERNAME) is not an item defined o...
Il y a 6 jours
Geodata Master

Overcoming Blocking & Locking in Oracle 19c with max_idle_blocker_time parameter - To illustrate and simulate locking and blocking let me first prepare a dummy table and two database accounts for simulation: create table SH1.purchase_orde...
Il y a 1 semaine
The Go-Faster Oracle Blog

Partition Pruning/Elimination on Reference Partitioned Tables - I discussed locally partitioning the unique index on a reference partitioned table in a previous blog. Having implemented it, I wanted to confirm what h...
Il y a 1 semaine
The ORACLE-BASE Blog

A little story of Oracle APEX (Low Code) for the win - As the undisputed worlds worst APEX developer, I just wanted to share a little story that illustrates why I love APEX when trying to deliver value as qui...
Il y a 1 semaine
Technology Geek

Advanced OCI AI Services and Machine Learning Integration: Building Intelligent Cloud Applications - Oracle Cloud Infrastructure (OCI) offers a comprehensive suite of artificial intelligence and machine learning services that go far beyond traditional clou...
Il y a 1 semaine
IT WorldIT World

QuestDB for time series data hands-on - Preamble QuestDB is the next one in my journey of storing and handling Time Series data. This candidate is coming from Time Series DBMS ranking of DB-Eng...
Il y a 1 semaine
Ric Ramblings

In this era of speed, we need to slow down. - It’s certainly not new, this idea of doing things faster. Working in IT as I do it has been a theme all along. Be it the speed of the CPUs or storage r...
Il y a 1 semaine
AMIS Technology Blog

Terminaltrucs: minder typen dankzij je commandogeschiedenis - Bijna elke developer komt zo nu en dan in aanraking met de terminal. Hoewel dit niet vervelend hoeft te zijn is het vaak een obstakel dat je moet overwin...
Il y a 1 semaine
www.markusdba.de | Markus Flechtner – Meine Erlebnisse rund um Oracle …

Der Konferenz-Herbst naht … - Vier Monate vor Weihnachten – und noch nicht alle Geschenke gekauft? Etwa drei Monate vor dem Konferenz-Herbst und es ist noch kein Vortrag fertig? Im Nove...
Il y a 2 semaines
Julian Dontcheff's Database Blog

Size limit and init.ora parameters for JSON in Oracle Database 23ai - In Oracle Database 23ai, JSON’s built-in data type has maximum size of 32 megabytes. But did you know that you can now (Oracle Database 23.7 and above) lim...
Il y a 2 semaines
Julian Dontcheff's Database Blog

Size limit and init.ora parameters for JSON in Oracle Database 23ai - In Oracle Database 23ai, JSON’s built-in data type has maximum size of 32 megabytes. But did you know that you can now (Oracle Database 23.7 and above) lim...
Il y a 2 semaines
Data Warehousing with Oracle

Book Review: “Data Engine Thinking” by Roelant Vos and Dirk Lerner - If you are planing to develop a new data warehouse or replace an existing one, the book “Data Engine Thinking” is a good choice to read. Also if you are in...
Il y a 2 semaines
Sujeet APPS DBA

java.sql.SQLSyntaxErrorException: Access was denied to the user in MySQL 8.4. - java.sql.SQLSyntaxErrorException: Access denied for user 'SIT'@'%' to database 'SIT' means the MySQL user SIT does not have sufficient privileges on the...
Il y a 2 semaines
Usn's IT Blog

Multiple Ways How to Get Rid of the Oracle Database Optimizer Statistics Advisor AUTO_STATS_ADVISOR_TASK - There are multiple ways to avoid the vast amounts of data in the SYSAUX tablespace created by the AUTO_STATS_ADVISOR_TASK. This advisor runs during a maint...
Il y a 2 semaines
Hemant's Oracle DBA Blog

Cross-Instance Deadlock in RAC - I've created a *video demonstration of a Cross-Instance Deadlock in a 2-node RAC* environment and how to read the trace file. Note : Only the SQL that h...
Il y a 2 semaines
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 3 semaines
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 3 semaines
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 semaines
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 semaines
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 4 semaines
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 5 semaines
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 5 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 1 mois
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 1 mois
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 1 mois
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 1 mois
Venzi's Tech-Blog

Blog has moved – saying Goodbye to E-Mail subscribers - Hi all, Some of you may have already noticed the new look and feel of my blog. This was enabled due to a blog migration away from WordPress.com to a privat...
Il y a 1 mois
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 1 mois
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 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 2 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 2 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 2 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 2 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 3 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 3 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 4 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 4 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 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 6 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 6 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 7 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 8 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 10 mois
Dennis Yurichev

Please update your RSS URL -
Il y a 10 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 10 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 1 an
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 4 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 5 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 5 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 6 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 7 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 7 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 7 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 7 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 8 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 8 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 8 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 9 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 9 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 10 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 10 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 10 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 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
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 11 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 12 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

-