ORACLE : DATABASE قاعدة بيانات Base de données: Comment vérifier et activer Parallel DML (nouveauté 11.2.0.4 et 12c)

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

Pete Finnigan's Oracle security weblog

How Can a Data Breach of an Oracle Database be Managed and Analysed? - No one wants to be hacked or their data stolen or leaked or their database be breached but it can happen. If you become the latest victim of a data hack an...
Il y a 17 heures
oracle-recipes

Create a table out of nothing - sql table out of nothing
Il y a 20 heures
Oracle

pre-post check script - ####################################################### #!/bin/ksh # set the DB env and run # Script to check PRE & Post checks Manually # # CB - -...
Il y a 2 jours
Julian Dontcheff's Database Blog

Indexing and partitioning of JSON Collection Tables in Oracle Database 23ai - In the Oracle Database, a JSON Collection Table is a special table that provides JSON documents in a single JSON-type object column named DATA. JSON Collec...
Il y a 2 jours
Julian Dontcheff's Database Blog

Indexing and partitioning of JSON Collection Tables in Oracle Database 23ai - In the Oracle Database, a JSON Collection Table is a special table that provides JSON documents in a single JSON-type object column named DATA. JSON Collec...
Il y a 2 jours
Oracle SQL & PL/SQL

SQL Case Expression - SQL Case Expression 1. What is the purpose of the CASE expression in Oracle SQL? A) To perform arithmetic operations B) To manipulate strings C) To make de...
Il y a 3 jours
The ORACLE-BASE Blog

Oracle Database 23ai Release Delays - Once again we get the news that on-prem release of Oracle Database 23ai has been delayed. Over the weekend the news dropped that the Release Schedule of ...
Il y a 4 jours
Geodata Master

Connecting To Pluggable Database as SYSDBA - In Oracle container database architecture when you connect by default using bequeath protocol as SYSDBA you will connect against CDB$ROOT. Is there a way t...
Il y a 4 jours
Market Solutions to Our Energy Needs

Navigating the Maze: Communication Standards for Microgrids and ADMS - The world of communications standards for the electric power industry can be a complex landscape to traverse with many options available; understanding w...
Il y a 5 jours
Ask Tom MOST RECENT ARTICLES

Create Pluggable Database - How do i create pluggable database in oracle linux Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 23ai Free Release 23...
Il y a 5 jours
Oracledbacr, por simple pasión ...-Copyleft Miembro Comunidad Tecnológica de Oracle Latinoamérica

Taller 06 de Noviembre: Transformación en la nube: moderniza tus aplicaciones en Oracle Cloud - [image: Oracle Logo] Transformación en la nube: moderniza tus aplicaciones en Oracle Cloud [image: Participa el 6 de noviembre en el Taller de Modernizac...
Il y a 5 jours
Technology Geek

Automating Oracle Cloud Networking with OCI Service Gateway and Terraform - Oracle Cloud Infrastructure (OCI) offers a wide range of services that enable users to create secure, scalable cloud environments. One crucial aspect of a ...
Il y a 5 jours
Vlad Mihalcea's Blog

High-Performance Java Persistence Newsletter, Issue 68 - Introduction Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow ...
Il y a 5 jours
Dennis Yurichev

[Crypto][Newbies] An easy cryptographical challenge -
Il y a 6 jours
Bobby Durrett's DBA Blog

Using PyTorch to Predict Host CPU from Date/Time - In my previous post I mentioned that I took a machine learning class based on Python and a library called PyTorch. Since the class ended, I have been worki...
Il y a 1 semaine
IT WorldIT World

Performance schema hands-on – part 2 - Preamble After a first part let’s move forward and activate more options of Performance Schema and go deeper of the analysis of performance. When activat...
Il y a 1 semaine
Ric Ramblings

Something fun to do, a word search!! - From days gone by. I had this in some of the courses I wrote while at Hotsos as a filler for some blank pages. Enjoy!
Il y a 1 semaine
Martins Blog

Troubleshooting the Oracle Cloud Infrastructure API - Sometimes, it can be interesting to learn how the Oracle Cloud Infrastructure (OCI) API works, particularly if your favourite Internet search engine fails ...
Il y a 1 semaine
Oracle Scratchpad

4096 Columns - If you thought 1,000 columns was over the top for a table in Oracle, then you’ll love 23ai which allows you to stretch that to 4,096 columns if you’ve set ...
Il y a 1 semaine
Venzi's Tech-Blog

How to create an OCI Container Registry and upload container images - With a lot of the Oracle Database Free and 23ai efforts behind me – for the time being, the time has come for me to put some focus back on the cloud-native...
Il y a 1 semaine
Learning is not a spectator sport

Highlights from the EMEA tour - Just a quick snapshot of the EMEA tour, which I hope inspires you to get involved next year as either a speaker, user group volunteer or even as simply as ...
Il y a 1 semaine
Learning is not a spectator sport

Highlights from the EMEA tour - Just a quick snapshot of the EMEA tour, which I hope inspires you to get involved next year as either a speaker, user group volunteer or even as simply as ...
Il y a 1 semaine
Talip Hakan Ozturk's ORACLE BLOG

Let’s meet at Sakarya University Oracle Career Seminar! -
Il y a 1 semaine
DBA Kevlar

PASS Summit 2024 - Now that I’ve been at Redgate as the newest Advocate, along with my engineering duties, let’s talk about the annual Tags: Community, Summit Del.icio.us F...
Il y a 1 semaine
ThatJeffSmith

Oracle SQL Developer & Data Modeler 24.3 are now available - Oracle SQL Developer 24.3 is now available for download, now offering Java 17 and an updated script engine/SQLcl (24.3). The post Oracle SQL Developer & ...
Il y a 2 semaines
MacLochlainns Weblog

SQL Statement Management - It’s very difficult explaining to students new to relational databases how SQL works. There are many parts that seem intuitive and then there are others th...
Il y a 2 semaines
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 3 semaines
Notes on Oracle

Display JSON in APEX using APEX_MARKDOWN and JSON_TRANSFORM #JoelKallmanDay - Markdown is a plain text format for writing structured documents, and in APEX there is a built-in package that can transform Markdown notation into HTML....
Il y a 3 semaines
Simple Oracle Dba

Serverless, Docker, Podman, k8s #JoelKallmanDay - TL;DR: Soon you will run Production databases from a "serverless" platform. For several years now, I run most of my tests and demos from docker or po...
Il y a 3 semaines
Annals of Oracle's Improbable Errors

Two ways of configuring APEX faceted reports with cascading LOVs (video) #JoelKallmanDay - There are at least two ways of configuring facets in a faceted report in a hierarchical fashion, using different attributes for the child facet, one is s...
Il y a 3 semaines
Philipp Salvisberg's Blog

PL/SQL vs. JavaScript in the Oracle Database 23ai #JoelKallmanDay - JavaScript is the first language supported by the Multilingual Engine (MLE) in Oracle Database 23ai. Having additional languages in the Oracle Database a...
Il y a 3 semaines
Lovely Oracle

Train F5-TTS Voice Model on Custom Dataset for Free Locally - Step by Step Tutorial - This video is a step-by-step tutorial to fine-tune or do full training of a voice model F5-TTS and E2-TTS on your own custom voice dataset locally. ...
Il y a 3 semaines
a Danish Sql and Pl/Sql Developer

Learning by letting others workout in the Gym - #JoelKallmanDay - This year I'm on the road for Joel Kallman Day, speaking at POUG 2024, AOUG (EMEA tour 2024), HrOUG 2024 and DOUG Day 2024. But when it's Joel Kallman Da...
Il y a 3 semaines
Grassroots Oracle

Upgrading Forms compared to APEX #JoelKallmanDay - My current project has involved rebuilding the entire aging stack for an environment that's currently 95% Forms, with any new work developed in Oracle AP...
Il y a 3 semaines
Home Of The Scary DBA

RDS Connectivity - I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time, connectivity, while not th...
Il y a 4 semaines
Sfaturi Oracle / Tips and tricks OracleDBA

lipsa de testosteron - https://youtu.be/HFcnx4k9XNg
Il y a 4 semaines
The PeopleSoft DBA Blog

Cursor Sharing in Scheduled Processes: 4. How to Identify Candidate Processes for Cursor Sharing - This is the last in a series of 4 posts about the selective use of cursor sharing in scheduled processes in PeopleSoft. 1. Introduction 2. What happe...
Il y a 4 semaines
Laurent Schneider

negative regexp - if you want to grep anything except foo, use grep -v or negative lookahead echo -e 'foo\nbar\nboz'|grep -P '^(?!.*foo).*$' bar boz it is just so beautiful ...
Il y a 5 semaines
AMIS Technology Blog

Mastering Realtime Data: How I Topped the Leaderboard at PyData - Two weeks ago I went to PyData Amsterdam which kicked off with a tutorial day. These tutorials included a workshop on creating multi-modal LLM agents, ad...
Il y a 5 semaines
Hemant's Oracle DBA Blog

Video on DataGuard Snapshot Standby - I have posted a new video on creating a "Snapshot Standby" database in DataGuard. Typically such a Standby can be used for "destructive testing" like D....
Il y a 5 semaines
Martin Widlake's Yet Another Oracle Blog

Sometimes Tech Is Not In Our Best Interest - Tech, we are led to believe, will improve our lives. Sometimes it undoubtedly does. But more and more often it seems to me that tech is making our lives co...
Il y a 1 mois
Martin Widlake's Yet Another Oracle Blog

Sometimes Tech Is Not In Our Best Interest - Tech, we are led to believe, will improve our lives. Sometimes it undoubtedly does. But more and more often it seems to me that tech is making our lives co...
Il y a 1 mois
Damir Vadas, Oracle as I learned

identify the character set of a Data Pump file - many times have a need to get information how export (dmp) file was created (what nls setup). The following PL/SQL code enables you to identify the charact...
Il y a 1 mois
berxblog

Custom parameters in Method-R Workbench - Method-R Workbench is a leading tool to analyze many aspects of Oracles SQL-Trace files. It can use parameters in its commands and let users fill their ...
Il y a 1 mois
The Go-Faster Oracle Blog

Purging Standard and Unified Audit Data - Introduction It is not uncommon for businesses to have policies to retain audit data for several years, but then it ought to follow that that data should b...
Il y a 1 mois
DB Oriented » English

Optimization of NOT NULL Constraint Creation - Several years ago I wrote a series of 8 posts about constraint creation optimization. I think it’s time to add some more posts to the series. I showed th...
Il y a 1 mois
A! Help

Restore Standby Database from Standby Backups - This post shows the steps for full restoring (controlfile + data files) for a standby database using standby database backups. The same could be achieved u...
Il y a 1 mois
Sujeet APPS DBA

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database - When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G; alter table...
Il y a 2 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 2 mois
Kerry Osborne's Oracle Blog

Speaking At Oracle CloudWorld - For the first time in a few years I’ll be speaking at Oracle’s annual conference! I’m doing a joint session w/ a couple of the good guys from Oracle (Nages...
Il y a 2 mois
Timur Akhmadeev's blog

Public Speaking Advice - There was a post on the best public speaking advice with a video, have a look: https://twitter.com/AnnieAndrewsMD/status/1828046910986313933 I thought it’s...
Il y a 2 mois
Oracle mechanics

Особенности ASH против статистики V$SQLSTATS при использовании SQL Profile для фиксации планов выполнения - После не очень удачной попытки фиксации очевидно более лучшего плана с помощью SQL Profile: , наблюдал странность отображения выполнения запроса (из генери...
Il y a 2 mois
Simon Krenger

Excluding / ignoring sensors in node_exporter - I like to use the Prometheus node_exporter to get metrics about my hardware. However some hardware (such as my X300M-STX mainboard) exposes sensors with so...
Il y a 3 mois
www.markusdba.de | Markus Flechtner – Meine Erlebnisse rund um Oracle …

„Silent Install“ der Oracle Grid Infrastructure - Ich sehe es immer wieder bei Kunden, dass die Oracle Software, insbesondere die Grid Infrastructure, über die GUI installiert. X-mal klicken und dann läuft...
Il y a 3 mois
Data Warehousing with Oracle

Staging Tables in Oracle 23ai - Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a ne...
Il y a 3 mois
Confessions of an Oracle Magi

New for 2024 - The Kscope100 (Positions 1-10) - So who is really responsible for the success of Kscope24? Is it your Kscope Executive Officer? Not a chance. Your ODTUG President? Not single handedly, ...
Il y a 3 mois
Ask Anantha

csv Data to Rows - SQL - If you have a data with Comma, or any other character delimited use the following query to convert it to individual rows.-- Created on 03/07/2024 by ANANT...
Il y a 4 mois
Real Life Database / SQL Experiences : An Oracle Blog from Vivek Sharma

SELECT AI ! Generative AI on Autonomous Database - Imagine, we communicate with our Database in Business Language and Database responding with a result that matches the Business criteria. Natural Language P...
Il y a 4 mois
OraStory

Caveat on index compression advanced low - The first time I played with the ADVANCED LOW option of index compression I got burned. I’m still in the process of getting burned. I don’t have much info ...
Il y a 4 mois
www.ORACLE-CKPT.com

Blog Post Title - What goes into a blog post? Helpful, industry-specific content that: 1) gives readers a useful takeaway, and 2) shows you’re an industry expert. Use your c...
Il y a 4 mois
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 4 mois
Usn's IT Blog

Oracle Linux 8/RHEL8: Lock User After Failed Login Attempts with Faillock - Many security audits and checklists like the ones supplied by CIS or DISA STIG require locking user accounts after a number of unsuccessful login attempts....
Il y a 4 mois
Apps DBA Workshop

Oracle EBS R12.1.3 autoconfig failed with Error - txkCfgUtlfileDir.sh - In one of our csutomer Environment during the Oracle E-Business suite siwtchover activity we encounted the following error during exeuction of autoconfig. ...
Il y a 4 mois
Thinking Out Loud

Thank You And Good Bye Again - Fill your mind with thoughts of peace, courage, and hope. – Dale Carnegie’s Golden Book.
Il y a 5 mois
"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 5 mois
Helios's Blog

How to add new disk at Oracle Linux? - You may need to add disk to your server. Adding a disk to Oracle Linux involves several steps, including identifying the disk, partitioning it if necessary...
Il y a 5 mois
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 5 mois
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 5 mois
Learners Reference - Learners Reference

MLO Practice Test 2024 - 1) What is FHA rehabilitation program that allows for the acquisition of a property along with financing needed renovation? a) 203(a) b) 203(g) c) 203(k) d...
Il y a 5 mois
Oracle ACE Director Kai Yu's Oracle Blog

Running Llama3 model inference on Intel CPU and Intel GPU (1) - Introduction On April 18, 2024, Meta released Llama 3, the latest and most capable Open source large language model (LLM) model, which is a major leap ov...
Il y a 6 mois
Oracle ACE Director Kai Yu's Oracle Blog

Running Llama3 model inference on Intel CPU and Intel GPU (1) - Introduction On April 18, 2024, Meta released Llama 3, the latest and most capable Open source large language model (LLM) model, which is a major leap ov...
Il y a 6 mois
External Table

Building an Apache Spark Performance Lab: Tools and Techniques for Spark Optimization - Apache Spark is renowned for its speed and efficiency in handling large-scale data processing. However, optimizing Spark to achieve maximum performance r...
Il y a 6 mois
An Oracle Programmer

SQL table macros 14: parameterized views - Developers like to reuse code. In SQL, views are reusable queries with lots of advantages, but one drawback: no parameters to limit the queries to only tho...
Il y a 6 mois
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 6 mois
Oracle High Availability

Issues Encountered Migrating to PDB Land -
Il y a 7 mois
Joords Oracle DBA blog

How to Detect and Repair Corruption in Your Oracle Database - The *DBMS_DICTIONARY_CHECK* is a read-only and lightweight PL/SQL package procedure that helps you identify Oracle Database dictionary inconsistencies th...
Il y a 7 mois
Exadata

Moh_Create Standby DB - ------------------------------------------------------------------------------------------------------------------------------------------ -- Prepare the ...
Il y a 8 mois
Jeremy Cole

One year on the Giant Explore E+ 2 with a Rohloff Speedhub 500/14 - I thought since it’s been exactly a year since I upgraded my Giant Explore E+ to a Rohloff Speedhub 500/14 internal gear hub, that it’s a good time for an ...
Il y a 8 mois
DBA survival BLOG

New views in Oracle Data Guard 23c - Oracle Data Guard 23c comes with many nice improvements for observability, which greatly increase the usability of Data Guard in environments with a high...
Il y a 10 mois
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 10 mois
ORACLE DBA

APEX application to display tablespace usage of databases registered in an Oracle Enterprise Manager installation - This is an APEX application (created with APEX 23.2) to present tablespace usage data, retrieved from your OEM 13c. It uses *spaceUsed*, *bytesFree *an...
Il y a 10 mois
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 11 mois
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 11 mois
Kevin Closson's Blog: Platforms, Databases and Storage

PGIO Update - PGIO is the SLOB method for PostreSQL. An old friend of mine, Bart Sjerps, has implemented a modified PGIO in Python and posted it on Github: https://githu...
Il y a 11 mois
Sydney Oracle Lab

Whatever happened to SydOracle - So I haven't posted in *mumble* years. What happened ? Firstly there was this thing called Twitter. There seemed to be less blogging and more twee...
Il y a 1 an
Oracle related stuff

Oracle 19c RU Release Update 19.19 nice little enhancement: DBA_HIST_SQL_PLAN ACCESS_PREDICATES and FILTER_PREDICATES columns populated - I've recently found out by coincidence a nice little enhancement that apparently was introduced with the 19.19 Release Update - a backport of the fix tha...
Il y a 1 an
HeliFromFinland

Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay - It’s Joel Kallman Day again. And we still miss him dearly. A place Joel loved was Israel, and especially Jerusalem. … Continue reading →
Il y a 1 an
HeliFromFinland | Heli's Oracle thoughts

Joel Kallman, Jerusalem, and the Oracle Community in Israel #JoelKallmanDay - It’s Joel Kallman Day again. And we still miss him dearly. A place Joel loved was Israel, and especially Jerusalem. … Continue reading →
Il y a 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
Biju's Oracle Notes

Oracle Database Service options for Azure Customers - We saw Larry Ellison visit Redmond for the first time to make an important partnership announcement with Satya Nadella. Yesterday’s announcement shows we h...
Il y a 1 an
Rafu on db

Sqlstat History - Oracle Diagnosics pack purchased? AWR reports reveal many aspects of database usage and behavior. In addition to Enterprise Manager Cloud control pages the...
Il y a 1 an
Cary Millsap

How Slow Programs Are Like Christmas: a Sales Pitch - My company, Method R Corporation, makes systems faster. And we make people who make systems faster, faster. We train people to become performance optimiz...
Il y a 1 an
Oracle SQL Tuning Notepad

SQL Stats Analytics (from SQL*Plus!) - If you have access to some other graphical tool that displays time series on multiple dimensions for one or a set of SQL statements from an Oracle database...
Il y a 1 an
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 1 an
www.xmldb.nl

Pluggable databases ignores SAVE STATE / is always opened in READ WRITE - I noticed a new “feature” on my managed DBAAS Oracle OCI environments, that whatever I…
Il y a 1 an
Roels Blog

APEX (Multi) Application Settings - Most applications need some sort of "configuration" table. A simple key-value store where you can put values that might change on a different environment, ...
Il y a 1 an
Peasland Database Blog

Roll Forward Standby with 1 Command - I have a testbed that I use for research purposes. This testbed consists of a 2-node RAC primary database (RESP) and a 2-node RAC physical standby database...
Il y a 1 an
Neeraj Bhatia's Blog

Protected: First Personal Notes - There is no excerpt because this is a protected post.
Il y a 1 an
The Lazy Tech's Blog

Designing a secured Landing Zone in AWS - When adopting cloud computing, securing your cloud infrastructure should be a top priority. Starting with a landing zone provides the foundational infras...
Il y a 1 an
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 1 an
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 1 an
OracleAPPSDBA & Oracle DBA Blog | OracleAppsDBA-11i/R12/R12.2

Test -
Il y a 1 an
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 1 an
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 1 an
******* Rafi ORACLE DBA & APPS DBA Blog*******

PMP Success Journey of Melanie Project Manager - Melanie Lorenzo, PMP® achieved PMP with all above target in all Domain. She attended 1-1 training with me few months back. I'm confident, she will excel in...
Il y a 1 an
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 1 an
Oracle SQLOracle SQL

CBO and Partial indexing - Oracle 12c introduced Partial indexing, which works well for simple partitioned tables with literals. However, it has several significant issues: For insta...
Il y a 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
sqlandplsql.com

Difference between ROWNUM and ROWID in Oracle - First let us examine what is ROWID and ROWNUM Both ROWID and ROWNUM are Oracle’s pseudo-columns ROWID The ROWID pseudo-column returns the address of the ro...
Il y a 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
Steve Harville's Blog

Microsoft Azure Virtual Training Day:DevOps with GitHub - I am starting to take some Microsoft training and this was the first one I tried. I thought it would be a good way to get familiar with how Git is integrat...
Il y a 2 ans
ORACLE

ORACLE PIVOT FUNCTION & ORA-00918 - First we create a view *v_emp* create or replace view scott.v_emp as select a.empno,a.sal,b.dname from scott.emp a, scott.dept b where a.deptno=b.deptno; ...
Il y a 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 2 ans
Odie's Oracle Blog

Building and Using an APEX Item Property Matrix - I’ve recently been involved in some APEX development. One of the application form had a bunch of input items whose visibility and mandatory aspects depend ...
Il y a 2 ans
Lets Develop in Oracle

Analytical SQL - Running Total - Order by without Partition By - Welcome to the third post on the series Analytical SQL. In the first two posts we studied 1. Analytical Function without Window Clause 2. Analytica...
Il y a 2 ans
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 2 ans
Oracle DBA Blog 2.0

How much storage am i using? - We were recently asked how much Azure storage we are actually using - initially I thought this was going to be a simple thing to find out - but actually ...
Il y a 2 ans
Oracle-Ninja.com

OJVM and DBA_REGISTRY_SQLPATCH - I woke up this morning and did what I do most days - doomscroll through twitter. One of the benefits of being in the US is that there are usually some inte...
Il y a 2 ans
Striving for Optimal PerformanceStriving for Optimal Performance

Creating a SQL Patch with Many Hints Requires a Hack - In the past, when I created a SQL patch, I always specified a small number of hints. Last week, for the first time, I created one with more than 100 of the...
Il y a 2 ans
Oracle DBA - A lifelong learning experience

I have retired - I have now retired from work as of June 2021 and will no longer be updating this site. I had been doing a different role in the 18 months prior to retireme...
Il y a 2 ans
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 2 ans
Oracle SQL Stuff (by example)

Fun - Query Generated Calendar - Here's a query that will generate a full year calendar given any year. Enter the 4-digit year in the first line and execute the code. WITH yea...
Il y a 2 ans
Marko Sutic's Oracle Blog

PostgreSQL HA - Patroni, ETCD, HAProxy, Keepalived - Test failure scenarios - I will test few failover/maintenance scenarios and show results in this blog post. Just to mention, this is *not* proper production test. Before consideri...
Il y a 2 ans
TechnologyLearning | Learning is not a spectator sport.. Let's play

100k views Thanks everyone Happy learning - 100k views !! Thanks everyone! Happy learning!!
Il y a 2 ans
Andrew's Oracle DBA Blog

Oracle to Postgres Migration Issue with Commit - If you have some PL/SQL, Oracle allows you to include *commit* statements between a *begin* and *end*. Assuming this is appropriate for your application,...
Il y a 2 ans
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
DATAWAREHOUSE CONCEPTS

OAC 6.3 Features | Difference between OAC6.2 and OAC6.3 | Features of OAC6.3 | Oracle Analytics Cloud - The OAC 6.3 version is getting released. When comparing to OAC 6.2, below mentioned are the new features or enhancements in OAC 6.3 1 General1.1 ...
Il y a 3 ans
Dulcian, Inc.

Dulcian Presentation Archive - Dulcian personnel are active participants in Oracle conferences and user group meetings. Use these links to view slides presentations given at various Or...
Il y a 3 ans
Øystein on MySQL Optimizer

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics - This blog post is inspired by Jesper's recent blog post on how the automatic update of InnoDB persistent statistics may never trigger if servers are rest...
Il y a 3 ans
Oracle Blogs | Oracle Infrastructure Blog

How can Oracle help with Zero-Trust Security Model? - *An overview of Zero Trust Security Architecture* Zero trust is an IT security approach to keeping sensitive data safe while complying with new privacy r...
Il y a 3 ans
Alejandro Vargas' Blog

Moving Databases from ASM to ZFS on Exadata - Exadata is the best database machine available to run every Oracle database workload. But many times, within Exadata proliferate a large number of test a...
Il y a 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 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 3 ans
Oracle Corner

- Cloning a database where source Oracle Home has a higher DST patch than a destination Oracle home Example: Source database has a DST patch version 23, and ...
Il y a 3 ans
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 3 ans
Look Smarter Than You Are

- *Scenario Planning: Pivoting from Pandemic to Proactive* On a scale of 1-10, how far off was your 2020 budget? Feel free to go as high as 14. We star...
Il y a 3 ans
Kamran Agayev's Oracle Blog

Investigation on why database doesn’t start after successfully dropping a diskgroup - Few months ago, while performing storage migration I faced an interesting issue which could lead to potential downtime if I didn’t notice a hidden warning ...
Il y a 3 ans
Steven Feuerstein on Oracle PL/SQL

New Ranking Tags Feature of Oracle Dev Gym - You can take quizzes, workouts and classes at the Oracle Dev Gym solely with the objective of learning and improving your ...
Il y a 3 ans
Oracle Database 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 3 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
AskDba.org Weblog

How to perform groupby using Python Itertools - Original Post can be viewed at How to perform groupby using Python Itertools Itertools is a powerful module and is part of python standard library. It pr...
Il y a 4 ans
Radio Free Tooting

The use and misuse of %TYPE and %ROWTYPE attributes in PL/SQL APIs - PL/SQL provides two attributes which allow us to declare a data structure with its datatype derived from a database table or a previously declared variable...
Il y a 4 ans
Shahid's Oracle Blog

How to solve ORA-19505: failed to identify file in RMAN? - Reason: Archive log is deleted from os level and catalog is not synchronised. Posted by Pavan DBA on January 18, 2011 DBA’s will feel bad when they got a...
Il y a 4 ans
allappsdba Blog....Powered by DOYENSYS

- "ORA-02020: too many database links in use " Cause: The current session has exceeded the INIT.ORA open_links maximum. To find: --------- SQL> show ...
Il y a 4 ans
Sloba's Blog

ORA-65140: invalid common profile name - How to solve if you get an error “ORA-65140” while creating a profile on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 . Let us see how we can ...
Il y a 4 ans
Oracle DBA

Segment Tunning. - Segment Tuning: ################ what is Fragmentations in a table. when there is huge delete operations done on a table, The blocks which occupied t...
Il y a 4 ans
Azmath's Oracle DBA Blog

Read [PDF] Suits A Woman on Wall Street - *Download PDF Suits A Woman on Wall Street* *Download* PDF EPub Doc EBooks Rtf Mobipocket Kindle FREE UNLIMITED BOOKS, ALL IN ONE PLACE. FREE TO TRY FREE...
Il y a 4 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 4 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 4 ans
Jaffar's (Mr RAC) Oracle blog

Oracle Cloud & Third party tools - There have been several buzz words and offerings since the invention of Cloud concepts. We have been hearing of Private Cloud, Public Cloud, Hybrid cloud a...
Il y a 4 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 4 ans
Pavan DBA's Blog

New Performance Tuning batch from 25th May [demo on 23rd May] - *Oracle Performance Tuning batch from 25th May [demo on 23rd May]* Duration: 20 classes Frequency: 5 days a week Timings: 7 – 8 AM IST Demo date & time: 23...
Il y a 4 ans
The DBA Life

A Lifeline for EBS Customers Still on RDBMS 11gR2 and 12cR1 - Yesterday, the Oracle E-Business Suite Applications Technology Group made a couple of very significant announcements for E-Business Suite customers. -...
Il y a 4 ans
Oracle DBA - Tips and Techniques

Oracle Cloud Marketplace GoldenGate Classic Environment - To launch Goldengate via GGSCI we need to enter “ggsci” followed by the “version” -bash-4.2$ which ggsci /usr/local/bin/ggsci -bash-4.2$ ggsci Usage: /us...
Il y a 4 ans
Oracle Thoughts | Jacek Gębal's adventures on Oracle SQL and PL/SQL

BUG in INSERT … SELECT with nested objects - I came across a very nasty bug in Oracle SQL engine while working on some new code. It took me a while to figure out what the problem is as the SQL code I ...
Il y a 4 ans
Oracle Hack

Updated Monitor Server Disk Space - Monitoring of potential issues includes knowing when any volumes reach a certain capacity. It can take time to add space or free it up so being notified be...
Il y a 4 ans
Laimis Oracle blog

MySQL trading latency for throughput(not) - MySQL again. The goal: use binlog_group_commit_sync_delay setting to reduce IOPSes. The idea is to set binlog_group_commit_sync_delay to a large value like...
Il y a 4 ans
Surachart Opun's Blog

How to create signed url on google cloud storage? - A signed URL is a URL that provides limited permission and time to make a request. It's good to be used by someone who does not have a Google Account. I ca...
Il y a 4 ans
bdt's oracle blog

Retrieve PostgreSQL variable-length storage information thanks to pageinspect - Introduction In PostgreSQL a variable-length datatype value can be stored in-line or out-of-line (as a TOAST). It can also be compressed or not (see the do...
Il y a 4 ans
bdt's oracle blog

Retrieve PostgreSQL variable-length storage information thanks to pageinspect - Introduction In PostgreSQL a variable-length datatype value can be stored in-line or out-of-line (as a TOAST). It can also be compressed or not (see the do...
Il y a 4 ans
Oracle Expert Blog

Succinct Study of Oracle SQL BI API as Evolution - SQL API Evolution from Oracle9i through Oracle19g This is a visual summary of my presentation at Oracle USA for the NYOUG 2019 Winter General Meeting. ...
Il y a 4 ans
NZ DBA: Oracle Database Tuning & Tips

Snapshot Too Old Too Soon - What could cause a SQL statement to fail with ORA-01555 after 1 second? The answer appears to be related to a limitation of Active Data Guard that makes me...
Il y a 4 ans
Johan Louwers Personal Blog "my view on the IT world".

Cloud Native Event Message Transformation - When designing a cloud native architecture on an enterprise scale it is most likely that you cannot start with a green-field situation. In all reality it i...
Il y a 5 ans
Le blog Oracle d'Ahmed AANGOUR

Row Prefetching et PL/SQL - J'avais écrit il y'a plusieurs années déjà un article qui présentait le row prefetching avec en illustration un problème de performance d'une requête SQL o...
Il y a 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
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
Nguyen Duc Hai's blog

Phần mềm quản lý doanh nghiệp là loại phần mềm code khó nhất! - Full: https://codeburst.io/enterprise-software-is-the-hardest-software-to-write-c76d59725f3 Short: https://www.techinasia.com/talk/enterprise-software-hard...
Il y a 5 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 5 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 5 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 5 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 5 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 5 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 5 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 5 ans
recurrent null | Explorations in Oracle, mainly

Update - I’m an applied researcher at RStudio, where I contribute to the r-tensorflow family of packages (e.g., tfprobability). I write about doing deep learning fr...
Il y a 5 ans
It Was Like That When I Got Here

Exadata X8 is here! - The Exadata X8 machines are here!
Il y a 5 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 5 ans
Dave Herring's DBA Blog

OS-Level Stalls, NAS and LD_LIBRARY_PATH - Although there are many posts about the evils of using LD_LIBRARY_PATH, at times it's required when working with Oracle, specifically with Oracle Golden ...
Il y a 5 ans
Oleksandr Denysenko's Blog

Oracle 12.2 ASM PWFile Recreated in New Disk Group. ASM and GI Doesn’t Start Anymore - Just a small pre story: new Storage Cells were delivered ACS configured new ASM Disk Groups data and configuration info were moved to new ASM Disk Groups o...
Il y a 5 ans
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 5 ans
Oracle PL/SQL Developer

bbb -
Il y a 5 ans
The Arup Nanda Blog

Sangam 18: Presentations, Scripts and More - Many, many thanks to those who came to my three sessions at Sangam 18, the largest meeting of Oracle technologists in South Asia. As I promised, you can do...
Il y a 5 ans
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 5 ans
Alexander Kornbrust Oracle Security Blog

DOAG conference: Best of Oracle Security – older presentations (2013-2017) - Here is a list of older „Best-of“-presentations: Best of Oracle Security 2017 Best of Oracle Security 2016 Best of Oracle Security 2015 Best of Oracle Secu...
Il y a 5 ans
Oracle DBA Scripts

Cloud Security - Prevent DDOS attacks through Memcached - Recently, I provisioned a new server and went home for 2 days did not login, once I was back, I could see around 2.5 lakh failed login attempts from variou...
Il y a 5 ans
Gurcan Orhan's Oracle Data Integrator Blog

#OOW18 is almost there - Oracle Open World 2018 and Oracle Code One 2018 is just around the corner. This will be my 8th time in Oracle Open World and again I will be heavily busy w...
Il y a 6 ans
Gurcan Orhan's Oracle Data Integrator Blog

#OOW18 is almost there - Oracle Open World 2018 and Oracle Code One 2018 is just around the corner. This will be my 8th time in Oracle Open World and again I will be heavily busy w...
Il y a 6 ans
DBA n00b

How people ask DBAs for tuning … - How people ask for database tuning, in the form of a more well-known analogy … Hey I hear you’re a mechanic. Cool. Can you fix my vehicle? No, I don’t know...
Il y a 6 ans
Oracle DBA Scripts and Articles (Montreal)

Renaming a RAC cluster - Introduction Renaming an Oracle RAC cluster is not an easy thing, unfortunately for me I had to do this today because the name chosen for the newly insta...
Il y a 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
ORACLE @ Work

Linux CPU stress testing sample script - for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 33 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52...
Il y a 6 ans
Kyle Hailey

MySQL 5.6 vs 5.7 - Whitelist preview of Performance Insights has just started on RDS MySQL and it gave me a chance to visually compare load profiles of MySQL 5.6 and 5.7. I f...
Il y a 6 ans
Karl Reitschuster's Oracle Space

The Oracle Active Session History (ASH) - a real treasure trove - When Oracle introduced the Active Session History (ASH) a new gate of tuning and monitoring options was opened. Yes we had statspack, extended tracing and...
Il y a 6 ans
Mahir M. Quluzade | Oracle Blog

Oracle Database 18c - Install On-Premises for Linux - Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux ( *LINUX.X64_180000_db_home.zip)* O...
Il y a 6 ans
Oracle Solution Hub

sysdba in python -
Il y a 6 ans
TwelveC

Failover with Amazon Aurora PostgreSQL - https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/ Advertisements
Il y a 6 ans
Mauro Pagano's Blog

Introducing SQLdb360: merging eDB360 and SQLd360, while raising the bar for community engagement - Today, we are very happy to release SQLdb360, a new tool that merges together eDB360 and SQLd360, under a single package Tools eDB360 and SQLd360 can still...
Il y a 6 ans
Lczinkoc's Blog

Hide the sensitive columns – using $$PLSQL_UNIT_OWNER inquiry - Let’s suppose that a table owner (such as HR) wants to create a procedure that displays all columns for a specific criteria. Later, it wants to share this ...
Il y a 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 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 6 ans
rmoff

Blogging v2 - So the last post here was in 2011…seven years later I should probably post again, just to point random Google visitors to : My new blog : https://rmoff.net...
Il y a 6 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 6 ans
About Oracle

Filter predicates with NVL on mandatory columns using the index - Last Friday at work, I overheard a conversation between two DBA's about a performance problem of a job which usually ran in 10 minutes, now taking more tha...
Il y a 6 ans
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 6 ans
blog.contractoracle.com

ContractOracle.com is for sale - If you would like to purchase this domain, email Robert.Geier@ContractOracle.com This domain is perfect if you are a contractor working with Oracle softwa...
Il y a 6 ans
Unisoft Technologies Nagpur

Dropping Oracle Database 11g Manually with Drop Database Statement -
Il y a 6 ans
On The Peoplesoft Road

Nested VM : Oracle VM 3.4.4 on VMWare VSphere Hypervisor 6.5 - More than 4 years ago, I wrote an article about the same subject, find out here. Other time, other software version, slight configuration setting changes. ...
Il y a 6 ans
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 6 ans
Oracle WTF

Mmm, π - Young *rz.He* over on Stack Overflow has a question about why SQL*Plus doesn't parse every line of a PL/SQL block in case it's a comment in order to avoi...
Il y a 7 ans
Oracle Database

ORA-28017: The password file is in the legacy format. - *Today I was trying to change password for one of my 12c database and got below error :-* SQL> alter user dbsnmp identified by "*************" * ERROR at ...
Il y a 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
Christian Shay - Oracle and .NET

Windows and .NET sessions at Openworld - Interested in Oracle Database on Windows performance and security, Active Directory, or .NET development topics? At Oracle Openworld SF next week there's a...
Il y a 7 ans
Oracle database internals by Riyaj

Oracle Open World 2017 presentation - Hi, I will be presenting about ASM internals in Oracle Open World 2017 conference on Sunday October 1st. Following are the details: Session ID: SUN5682 Ses...
Il y a 7 ans
Kris' blog

Demo App for REST enabled SQL - Getting Started The new Oracle REST Data Services SQL over REST. How to enable that is on my last blog post here: http://krisrice.blogspot.com/2017/09/or...
Il y a 7 ans
ORACLE TIPS

Step by step guide to set up Multi source replication in MariaDB - Expectations: 1. You should be knowing how to set up replication in MySQL 2. You have basic knowledge of MySQL components such as binary logs, relay logs, ...
Il y a 7 ans
Oracle Apps Technology

Unable to locally verify the issuer's authority - Chuka pinged me when he got this error in Qualys logs after installation of qualys agent on a server 2017-07-24 15:23:08.363 [qualys-cloud-agent][232147]:...
Il y a 7 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 7 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 7 ans
Alex Fatkulin's Blog

Exadata 12c PX Adaptive Offloading - Here is yet another case when you may not see as much offloading on your Exadata as you expect. I was recently investigating a simple *select count(*)* qu...
Il y a 7 ans
Tony's Oracle Tips

CSV parsing and tokenizing strings - Most of you will be familiar with the “Comma Separated Values” data format. It is used in spreadsheets and other places to store ordered lists of character...
Il y a 7 ans
The Helsinki Declaration (IT-version)

My NoPlsql versus SmartDB deep-dive presentation materials - For those who are interested here are my two slidedecks used in yesterday's deep-dive session at ODTUG, here they are in ppsx format which includes all the...
Il y a 7 ans
Karl Arao's TiddlyWiki

SiteSubtitle - has moved to -> http://KARLARAO.WIKI
Il y a 7 ans
O R A C L E | Simple Solution

This site moved to dbacatalog.blogspot.com - This site moved to dbacatalog.blogspot.com please visit dbacatalog.blogspot.com
Il y a 7 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 7 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 7 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 7 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 7 ans
Peter`s DBA Blog

12.2 New Feature: Automatically Synchronize Password Files in Oracle Data Guard - A new feature automatically synchronizes password files across Oracle Data Guard configurations. When the passwords of SYS, SYSDG, and so on, are changed, ...
Il y a 7 ans
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 7 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 7 ans
Oracle Newbie DBA / Apps DBA

Sponsored: 64% off Code Black Drone with HD Camera [del.icio.us] - Our #1 Best-Selling Drone--Meet the Dark Night of the Sky!
Il y a 7 ans
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 7 ans
Understanding Oracle

Funny "ORA-01017: invalid username/password; logon denied" during DataGuard switchover operation from DG broker - Recently one of my customers encountered a problem when they tried to perform a switchover from DataGuard broker command line interface. $ dgmgrl / DGMGRL...
Il y a 7 ans
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 7 ans
IN ORACLE MILIEU ...

AWS Solutions Architect – Associate Certification - Hi All, I am glad to announce that I have completed AWS Solutions Architect – Associate Level certification This is a completely new world with lots of opp...
Il y a 7 ans
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 7 ans
From errors we learn ...

cleartext userid and passwords in config fles - how to get rid of them - Since ages Oracle has wallets that can be used to store userid and password configurations for connections in safe way. There are a few rules you need to...
Il y a 7 ans
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 7 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 7 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 7 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 database generic

Unclean shutdown detected. for mongod process in Arbiter server - Following messages were received in “/var/log/mongo/mongod.log” of primary server and other servers of replicatset Sat Jul 30 02:48:08.631 [rsHealthPoll] ...
Il y a 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
Michelle, DBA Unleashed

Database encryption in transit, why is this still a question? - As data flows between systems, applications and databases, valuable information is pass along either internal, external or a combination of both types of...
Il y a 8 ans
SQLfail

SQLfail? SQLwin! - update sqlfail set last_posting_date = date'2016-08-18'; It’s been a while since I’ve published here. You see, I’ve been kind of busy. Back in January 2015...
Il y a 8 ans
Oracle by Madrid

Temporary tablespace takes ages to drop - A simple command like 'DROP TABLESPACE TEMP;' in a regular database can become excessively slow. The reason behind this is quite simple, even if the users...
Il y a 8 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 8 ans
Oracle BI Consultant

Redshift~<- Denodo!<-- Tableau!<- TDE -Large Data volume Extracts: - *Redshift~<- -large="" data="" denodo="" extracts:="" tableau="" tde="" u="" volume="">* 1: Creation of Large Extract in Tableau from Data sources with hi...
Il y a 8 ans
Oracle DBA Exchange

30 Useful Linux Commands for System Administrators - In this article we are going to review some of the useful and frequently used Linux or Unix commands for Linux System Administrators that are used in their...
Il y a 8 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 8 ans
Inside Oracle APEX by Patrick Wolf

Test Drive Oracle APEX 5.1 Early Adopter 1! - It’s here! Oracle Application Express 5.1 Early Adopter 1 is available at https://apexea.oracle.com/ and we are really looking forward to get your feedback...
Il y a 8 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 8 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 8 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 8 ans
The Blog from the DBA Classroom

Become a Master of Oracle 12c - Oracle Database 12c: Administrator Certified Master Technology moves on, and to keep pace with it, so should you. If you are an Oracle Certified profession...
Il y a 8 ans
The Blog from the DBA Classroom

Become a Master of Oracle 12c - Oracle Database 12c: Administrator Certified Master Technology moves on, and to keep pace with it, so should you. If you are an Oracle Certified profession...
Il y a 8 ans
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 8 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 8 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 8 ans
Oracle Study Notes by Denis

MariaDB - a surprise dependent subquery execution plan - Welcome myself into the MySQL world. While working with MariaDB 10.0.21, there are two queries as shown below, one uses alias and the other does not, seems...
Il y a 8 ans
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 8 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 8 ans
Erdem ALTUNKAYNAK | Oracle Blog

Oracle Data Integrator 12c new Features Overview - Merhaba, Bu yazımda Cloud teknoloji ile hayatımıza giren Oracle 12c ile kullanıcılara sunulan *Oracle Data Integrator 12c *nin getirdiği yeni özelliklerin...
Il y a 8 ans
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 8 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 8 ans
Emre Baransel - Oracle Blog

Mount Clone Database in TSPITR - "alter database mount clone database" is a statement that forces all datafiles to be put OFFLINE when mounting the target instance. You'll see it's being u...
Il y a 8 ans
Oracle 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 8 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 8 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 8 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 8 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 8 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 8 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 8 ans
Oracle Performance and Backup Blog

Automation for DBA - Ansible part 1 - Hello, In this post I would like to move forward with software provisioning and configuration. In my last post I covered a ways to build a "core VM" and n...
Il y a 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
Inside Documentum

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

db file scattered read, db file sequential read & direct read wait events explanation - As Oracle DBA's we come across these wait events in most environments. We will discuss their definitions and see what we can do to reduce them. *db file sc...
Il y a 9 ans
Enkitec.tv

Fill the Glass Episode 4 with Jorge Rimblas! - Measuring software performance in the real world Featured Speaker: Jorge Rimblas September 11, 2015 | 10:00am–11:00am CST Jorge is your Been There Done Tha...
Il y a 9 ans
OTN DBA/DEV Watercooler

Make Your Nominations: Oracle Database Developer Choice Awards - I Did. You Should. Here's the Nomination Form. Here's Why: The Oracle Database Developer Choice Awards celebrate and recognize technical expertise and ...
Il y a 9 ans
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 9 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 9 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 9 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 9 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 9 ans
Sreedhar dba

What to consider to set innodb_sort_buffer_size variable ? - what to consider when choosing the value to use for the innodb_sort_buffer_size configuration option. The innodb_sort_buffer_size option specifies how muc...
Il y a 9 ans
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 9 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 9 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 9 ans
A W i d e r V i e w

What Is That Light-Green Oracle Database CPU Wait Time? - This page has been permenately moved. Please CLICK HERE to be redirected. Thanks, Craig. What Really Is That Light-Green Oracle Database CPU Wait Time? ...
Il y a 9 ans
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 9 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 9 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 9 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 c...
Il y a 10 ans
Oracle DBA's Blog

GoldenGate Active-Active replication using CONFLICTRESOLUTION - *Source* *Target* *Database Version* 11.2.0.4 11.2.0.4 *OS Version* OEL 6 – 64 Bit OEL 6 – 64 Bit *OGG HOME* /u01/GG/training/source /u01/GG/training *Go...
Il y a 10 ans
Oracle Database: Lets explore it

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

@Bouarada : Some historical pictures -
Il y a 10 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 10 ans
el-caro

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

latency heatmaps in D3 and Highcharts - See Brendan Gregg’s blog on how important and cool heatmaps can be for showing latency information and how average latency hides what is really going on: ...
Il y a 11 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 11 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 11 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 11 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 11 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 11 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 11 ans
The Oracle Sponge

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

Materialized View - +++++++++++++++++++++++++++++++++++++ MVIEW refresh Status on MASTER Site : +++++++++++++++++++++++++++++++++++++ set pages 1000 set linesize 180 col SNAPSHO...
Il y a 13 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 14 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 14 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 15 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 15 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 15 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 17 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 18 ans
Oracle blog

Weirdness of v$datafile on a standby db. - Here are some oddities of v$datafile on a standby Oracle gets content of v$datafile from controlfile, but on a standby database "STATUS" column wouldn't ge...
Il y a 18 ans
Structured Data

-
Oracle Security Blog | Integrigy

-
www.oracledba.co.uk

-
JJA News Page

-
Planet Oracle

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

-
OracleTuts

-
OraWorld Blog | Oracle Articles Blog

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

-
DATABASE DEBUNKINGS

-
Techienawa

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

-
Michael Wilson's Oracle DBA Blog

-
Database Security - Data Loss Prevention | McAfee Products

-
Cap Data Team SGBD Blog : Oracle, SQL Server, MySQL, Sybase...

-
Oracle DBA support

-
Ora-600 | Zrozumieć wyrocznię

-
veebrij.com

-
Oracle DBA Adventures

-
Dominic Giles Blog

-
Bar Solutions WebLog

-
Techienawa

-
ArKZoYd

-
Digora I Gestion des Données I

-
Siebel Essentials

-
oracle on Collected

-
René Nyffenegger on Oracle

-
Steve O'Hearn's Blog

-
Sangam13 - The largest Oracle user group event in India

-
Oracle Andy Technology

-
MY APPS DBA.COM

-
ArKZoYd

-
Blog | Tuning Knife Consulting | Exceptional Database Expertise

-
DavidLitchfield.com

-
Inside Oracle - Julian Dyke

-
Summersky RAC Notebook

-
EvDBT

-
Bridging Vision & Technology

-
Cuddletech

-
Grid-IT BLOG

-
DbRunas - Noticias y Recursos sobre Bases de Datos

-
Oracloid Blog

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

-
Company Blog | Blue Medora

-
Oracle Apps DBA Kaparelis

-
Paul Broughton's Blog

-
My Journey as an Oracle DBA

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

-
EASYTEAM LE BLOG

-
A platform for Oracle professionals

-
EvDBT.Com - Home Page

-