Il y a 17 heures
ORACLE, Performances, PL/SQL, SQL, TUNING, Upgrade
Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)
-
What is going on? A question for Marcus Aurelius - The Question: Marcus, I’m just an ordinary guy, a Joe Blow trying to make sense of a world that feels completely out of control. I look at the news and t...
-
JOIN TO ONE and Star Schemas - Oracle’s new JOIN TO ONE syntax offers several benefits for queries in star schemas. Let’s take a look at some typical use cases involving facts and dimens...Il y a 1 jour
-
Observations concerning PostgreSQL transactional DDL and concurrency - Recently, while browsing my feed on LinkedIn I came across a post dealing with PostgreSQL transactional DDL. Although I couldn’t find an exact documentatio...Il y a 3 jours
-
Not the post I was expecting - I’m currently here in India for the Sangam conference, and I’m always a fan of coming to India, because there is always an adventure. Coincidentally at bre...Il y a 3 jours
-
Not the post I was expecting - I’m currently here in India for the Sangam conference, and I’m always a fan of coming to India, because there is always an adventure. Coincidentally at bre...Il y a 3 jours
-
Difference REF vs HARD dependency type - Hi, I'm trying to understand the dependencies among objects in Oracle database and I have a few questions. 1) What is the meaning of the DEPENDENCY_TYPE fi...Il y a 3 jours
-
Slot4D Tampil Lebih Profesional dengan Teknologi Terbaru dan Pengalaman Pengguna Maksimal - Slot4D Tampil Lebih Profesional dengan Teknologi Terbaru dan Pengalaman Pengguna Maksimal Inovasi Teknologi Modern untuk Menciptakan Platform Digital Pro...Il y a 4 jours
-
Download latest RU gold image (full installation) with AutoUpgrade - Preamble If you are on a new Linux system and want to install a fresh Oracle Home with latest Release Update (RU), I am sure that, like me, you have been...Il y a 4 jours
-
Cuando te contratan para perder. - Hace unos días empecé a ver Ted Lasso. Curiosamente, después de una copa de vino, la serie me llevó a pensar en algo que he visto repetirse durante más ...
Il y a 5 jours -
Introducing the Hyperscaler GTM Playbook - A vendor-neutral practitioner guide on cloud alliances, co-sell and marketplace – 16 articles covering everything from partner programs to private offers, ...
Il y a 5 jours -
Your Old SQL Reports Deserve a Second Life — as Agent Tools - You can take advantage of your existing SQL based business reports to make your Agents 'smarter' and deliver more predictable answers, and for fewer toke...Il y a 5 jours
-
Scaling Applications with Amazon ElastiCache for Redis: Caching Patterns That Actually Work in Production - There is a moment every engineering team hits at some point. The application is growing. Traffic is up. Users are happy. Then the database starts groaning ...Il y a 5 jours
-
Cluster Objects in the Oracle Database - Sometimes in forensic analysis of an Oracle database it is necessary to understand how data is stored on disk. Actually we must understand that if we were ...Il y a 6 jours
-
How to choose your next AI Lakehouse database? - Many companies are moving away from separate data warehouses, data lakes, and AI platforms toward a unified architecture. This is the trend and it is happe...Il y a 1 semaine
-
How to choose your next AI Lakehouse database? - Many companies are moving away from separate data warehouses, data lakes, and AI platforms toward a unified architecture. This is the trend and it is happe...Il y a 1 semaine
-
Introducing Oracle Enterprise AI Lakehouse: Unifying AI, Data, and Analytics Across Clouds - Getting Hands-On with Oracle's Enterprise AI Lakehouse 📅 July 11, 2026 🏷️ Autonomous AI Lakehouse, OCI ⏱ 15 min read Quick DiSCLAIMER Quick disclaime...Il y a 1 semaine
-
Ten Years Later, I’m Back at AIOUG Yatra: See You in Bengaluru and Hyderabad - Ten years ago, I was part of the AIOUG OTN Yatra tour. This July, I’m back — Sangam AI Yatra 2026, Bengaluru on the 18th and Hyderabad on the 19th. It’s be...Il y a 1 semaine
-
Protect Your Oracle Database from SQL Injection and Unauthorized Access with SQL Firewall - SQL injection and credential misuse remain serious threats to database security. Oracle SQL Firewall offers a practical way to defend against these risks...Il y a 1 semaine
-
Using an LLM in a SELECT Loop - Introduction This post describes a way to use a Large Language Model (LLM) to investigate Oracle database problems. In this approach, the LLM repeatedly ge...Il y a 1 semaine
-
Creating an Oracle 26ai database - Parameters and parameter-files. - TL;DR: The minimum amount of parameters for the init.ora when creating an Oracle 26ai database from scripts. Simple is better: I'll provide just the bare...
Il y a 1 semaine -
Oracle VirtualBox 7.2.12 - Oracle released VirtualBox 7.2.12 a couple of days ago. This comes hot on the heels of version 7.2.10, which I wrote about here. The downloads and change...Il y a 2 semaines
-
-
Detecting Security Vulnerabilities With the APEXlang Parser - Introduction A parser for the APEXlang grammar enables the development of tools beyond the scope of the APEXlang compiler included in SQLcl, SQL Develope...Il y a 2 semaines
-
Bosses Who Made a Difference, Part II - The Boss Who Said “Show Me” In a previous post, I talked about how much having the right boss has meant to me throughout my career, and nowhere did that tr...Il y a 3 semaines
-
Savepoint Funny - Here’s an example that makes perfect sense if you know how Oracle handles data locking. It’s one that I thought I’d published years ago, but it’s not on th...Il y a 3 semaines
-
Oracle Applications on Azure: Drivers, Connection Pools and SSL/TLS Troubleshooting - When application teams report intermittent Oracle connectivity issues on Azure, the database is often the... The post Oracle Applications on Azure: Drive...Il y a 3 semaines
-
Resource Role in Oracle Database 26ai - RESOURCE role is a popular and famous built-in database role, historically its used to be granted to developers to enable them create objects in their work...Il y a 4 semaines
-
Oracle Database 19c auf Windows: RU-Patch-Nummern - Nachdem ich letztens mal wieder einen Windows-Datenbank-Server patchen musste (kommt selten vor), gibt es die Liste mit den Patch-Nummern für Oracle 19c je...Il y a 1 mois
-
Where to find ojdbc17_g.jar - I haven’t done much JDBC tracing yet, but recently for a Kerberos KCM + ANO case I wanted more traces. In the old doc, on google and myoraclesupport, you’l...Il y a 1 mois
-
Logical IOs: why you should care - The recording. - Here is the recording of the LIO talk I had with Chris Saxon last week. Enjoy!! https://asktom.oracle.com/ords/r/tech/catalog/session-landing-page?p2_...Il y a 1 mois
-
Using RMAN Backup Validation To Distinguish Between Read and Write Bottlenecks - Hello Friends, Easy way to determine whether the output device or input disk I/O is the bottleneck in a given backup job is to compare the time required to...Il y a 1 mois
-
WAIT Clause for DMLs in 26.2 - Oracle 26ai 26.2 now introduces the WAIT (and NOWAIT) Clause for INSERT / UPDATE / DELETE / MERGE DMLs. We have had a WAIT Clause for SELECT FOR UPDATE...Il y a 1 mois
-
Physical Standby – the Ultimate Migration Tool - We attempted to find out if anyone else had used a physical standby to accomplish the following changes in our Oracle Architecture: AWS Instance Hardware C...Il y a 1 mois
-
Oracle Standby FIX using RMAN Incremental Backup from Primary DB - When you don’t have an option other than doing incremental backup from Primary DB (when ARCH logs are gone from all places) below is the high-level DB...Il y a 1 mois
-
Better Data Models (redux) - Successful AI relies on high-quality, well-understood data and its context. Emphasizing the importance of good data management, the author advocates for re...
Il y a 1 mois -
Single Server DFO - Another improvement similar to last post is Single Server DFO. While in previous post the serial work was done by the query coordinator, that activity c...
Il y a 1 mois -
Unlocking Apache Spark Performance: Three Open-Source Tools We Use at CERN - Apache Spark is incredibly powerful, but anyone who has worked with it long enough knows the feeling: *Why is this job suddenly slower today?* *Why are e...Il y a 1 mois
-
Migrate/Move Data to Autonomous AI Database - Assume following scenario’s: For 1 above, Autonomous AI Database provides Database Cloning option. It is just few clicks and the job is done. For 2, there ...Il y a 2 mois
-
Data Pump Export to OCI Storage from Autonomous Database - *This is the second of three blogs about using Data Pump on an Autonomous Oracle database. * 1. *General considerations and setup.* 2. *Export* ...Il y a 2 mois
-
Out of Place (OOP) Patching of Oracle Restart 26ai - Previous posts showed OOP for 19c and 21c Oracle restart. Things are even simpler with 26ai. The current patch level is crsctl query has releasepatch Orac...Il y a 2 mois
-
The hypergraph optimizer is now available in MySQL 9.7 Community Edition - I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-le...Il y a 2 mois
-
Most Common Oracle Wait Events - Every DBA knows how to read the Top 5 Timed Events section of an AWR report. The common ones — db file sequential read, log file sync, buffer busy waits — ...Il y a 2 mois
-
Good Bye and Good Luck - June 27, 2007 was my first post and April 20, 2026 will be my last post. Be Healthy, Wealthy, and Wise !Il y a 2 mois
-
Data Guard 26ai – #28: Fast-Start Failover Validation - FSFO validation in Oracle Data Guard 26ai: a single command to verify readiness, consistency, risk settings, and callout scripts across your configuratio...Il y a 3 mois
-
SPM при использовании VPD/RLS - На примере нетипично долгого выполнения стандартного OEBS 12.2 запроса: — формальный источник проблем — выбор HASH JOIN XLA_TRANSACTION_ENTITIES@SEL$3 с ин...Il y a 3 mois
-
Quarkus – trying out the “Argo CD Extension for Quarkus” (part 5) - In a series of previous articles, I covered a lot about the “Argo CD Extension for Quarkus”. In my previous article, I described how I continued with the...Il y a 3 mois
-
-
Assertions for data integrity on a less-than-ideal data model - 25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mostly I worked wi...
Il y a 4 mois -
NoCOUG Conference – 2/27/2026 - Well for the first time in a very long time I am posting something on my blog. I’m doing a keynote for the Northern California Oracle Users Group (NoCOUG)....Il y a 4 mois
-
How to emulate LEFT JOIN FETCH using Record-based projections - Introduction In this article, I’m going to show you how to emulate a LEFT JOIN FETCH between two root entities without fetching the intermediate child en...Il y a 4 mois
-
ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' - This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user 'Mysql'@'%' to alter, or the ...Il y a 4 mois
-
CPU patching with golden images - With the CPU patches, it's a all exercise that we all repeat 4 times a year on the systems. We are patching the different software part of the Peoplesoft....Il y a 5 mois
-
Exploring the production process of navigation buoys in indonesia - Indonesia’s navigation buoy production stands as a vital pillar supporting maritime safety across its vast archipelago. The country’s manufacturers blend t...Il y a 5 mois
-
Aggregation Filters - Overview The FILTER clause is a nice addition to the SQL syntax in Oracle 26ai (23.26.1). It allows to restrict the rows considered by aggregate function...Il y a 5 mois
-
Oracle Data Guard Role Change History - Oracle documentation lists oracle-data-guard-in-oracle-database-views. Having diagnostics pack purchased and available one may find information of role cha...Il y a 5 mois
-
NMLS Test Questions Made Simple - 1) Tax Lien is an involuntary lien that is a non-consensual claim on one’s property as a collateral towards repayment of a debt and the rights can be giv...Il y a 5 mois
-
Managing Ad Hoc PS/Queries in PeopleSoft - This post draws together all the recommendations for managing ad hoc user queries in PeopleSoft PS/Query. Some points relate to the database, some to the ...Il y a 6 mois
-
Purchasing model - A SQL Server running in an Azure virtual machine (IaaS) is equivalent to an on-premises SQL Server. You'll notice that several features described for SQ...Il y a 6 mois
-
Reflections on a year of biking for 2025 - Last year I wrote up a summary of my biking for 2024, and I thought I’d continue that nascent tradition by writing a similar post for 2025, so here it is. ...Il y a 6 mois
-
Select AI Agents: Santa’s Workshop Runs on Oracle, Reindeer Health Copilot. And the wrap up. (6/6) - By Heli and Marko Helskyaho Last but definitely not least: Reindeer Health Copilot: Santa’s AI veterinarian on Duty 24/7. Reindeer … Continue reading →Il y a 6 mois
-
Select AI Agents: Santa’s Workshop Runs on Oracle, Reindeer Health Copilot. And the wrap up. (6/6) - By Heli and Marko Helskyaho Last but definitely not least: Reindeer Health Copilot: Santa’s AI veterinarian on Duty 24/7. Reindeer … Continue reading →Il y a 6 mois
-
Parsing RTSM(Real-Time SQL Monitor) XML Reports - Learn how to parse Oracle Real-Time SQL Monitoring (RTSM) XML reports using table SQL macros introduced in Oracle 19.16. This article shows how the updated...Il y a 7 mois
-
SQLDeveloper 23.1.1 fails on startup - Getting a long trace of errors like the following on launching SQLDeveloper? ... oracle.ide.indexing - org.netbeans.InvalidException: Netigso: C:\...Il y a 7 mois
-
PostgreSQL 18 : des IO asynchrones performantes ! - Le 25 septembre dernier, PostgreSQL sortait sa toute dernière version, PostgreSQL 18. Cette version apporte de nombreux correctifs mais aussi des nouve...Il y a 8 mois
-
Add a Little Joy to your Buttons #JoelKallmanDay - Recently we were sitting outside at a café having a coffee and a slice of apple pie, something we do often. This is nothing remarkable, but when we orde...Il y a 9 mois
-
Ideas as a precursor to Oracle APEX #JoelKallmanDay - It seems if I post only once a year, it's for Joel Kallman Day... Last year I hinted of a small side story to a remediation project that was upgrade the...
Il y a 9 mois -
GOLANG Pointer Functions - There are interesting behaviors when you start learning aboutIl y a 9 mois
-
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 10 mois
-
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 11 mois
-
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 11 mois
-
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 11 mois
-
Blog has moved – saying Goodbye to E-Mail subscribers - Hi all, Some of you may have already noticed the new look and feel of my blog. This was enabled due to a blog migration away from WordPress.com to a privat...Il y a 1 an
-
Two Years Into Retirement - It’s two years and a day since I fully retired. On the 1st July 2023 I changed my LinkedIn profile to indicate my new, permanent, non-working status. I can...Il y a 1 an
-
Two Years Into Retirement - It’s two years and a day since I fully retired. On the 1st July 2023 I changed my LinkedIn profile to indicate my new, permanent, non-working status. I can...Il y a 1 an
-
SnowSQL config password needs to be enclosed in double quotes - Today I tested how to use snowsql to connect to SnowFlake. I put the connection credential in the config file. But I encountered the following error mess...Il y a 1 an
-
Start a Pod in Kubernetes using curl - Recently I came across the issue that a customer needed to start a Pod without the kubectl or the oc command line tooling. Since the Kubernetes API is a re...Il y a 1 an
-
SQL table macros 15: parameterized views revisited - In my previous post, I tried to use views and macros together as an equivalent to parameterized views. Unfortunately, my generic macro can’t handle bind va...Il y a 1 an
-
Sitemap - Sitemap - All posts on this blog 1. SQL Introduction 2. SQL Update 3. SQL Delete 4. SQL / PLSQL Interview Questions 5. PLSQL Cursors 6. PLSQL Triggers 7. S...Il y a 1 an
-
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
-
Caveat on index compression advanced low - The first time I played with the ADVANCED LOW option of index compression I got burned. I’m still in the process of getting burned. I don’t have much info ...Il y a 2 ans
-
Client-side database connection timeout insanity - Attributed to Einstein but considered a dubious association, the quote is something like “Insanity is doing the same thing over and over and expecting diff...Il y a 2 ans
-
Modifying ORDS Jetty Parameters - Recently we were working on an issue that was occurring to developers in Oracle Application Express’s (APEX) Page Designer. When we would attempt to vali...Il y a 2 ans
-
Pickleball & Longevity - Studien zufolge trägt die Trendsportart Pickleball in nahezu idealer Weise zur Langlebigkeit bei! Wer möchte nicht sein Leben bei guter Gesundheit um 10 Ja...Il y a 2 ans
-
Difference Between OCI Load Balancer & Network Load Balancer by A-Team…. - So this is more of me putting this article for my own memory. Oracle’s A-Team(www.ateam-oracle.com) has put together probably the best article on the diffe...Il y a 2 ans
-
AGI vs AI - One of my newsletter readers was asking me about the difference between “AGI” and “AI”. In one issue of my newsletter last year, I put it this way: Artific...Il y a 2 ans
-
I Cannot Participate in the Genocide | I Quit Blogging on Oracle Products - Since Oracle declared its "*stand with Israel*", it puts me in a moral dilemma, in one hand my main intention of blogging was to share the knowledge with...Il y a 2 ans
-
The converged Christmastree - With this year’s converged Christmas tree, we achieved a particularly special variety. It not only contains the Multifir Christmas tree (...) Der Beitrag...Il y a 2 ans
-
The converged Christmastree - With this year’s converged Christmas tree, we achieved a particularly special variety. It not only contains the Multifir Christmas tree (...) Der Beitrag...Il y a 2 ans
-
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 2 ans
-
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
-
The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”) - NOTE -THIS BLOG IS NO LONGER BEING MAINTAINED!!! (Content may no longer be up to date or accurate with current versions of Oracle) Of all my many Ora...
Il y a 2 ans -
SPM baseline and historical execution plans - I have often wondered why when we consult a past execution plan that is protected by an SPM baseline, there is no Note at the bottom of that execution plan...Il y a 3 ans
-
SPM baseline and historical execution plans - I have often wondered why when we consult a past execution plan that is protected by an SPM baseline, there is no Note at the bottom of that execution plan...Il y a 3 ans
-
GoodBye 2022, Hello 2023 - 2022 has been a peaceful and kind year both professionally and personally for me. I began the year as an AWS Data Lab Solution Architect, helping external ...Il y a 3 ans
-
Sql2Odi - best practices for auto-generating your ETL content - I blogged a while ago about our Sql2Odi tool that converts SELECT (and WITH as well) statements into Oracle ODI Mappings. (Blog posts 1, 2 and 3.) Now th...Il y a 3 ans
-
World Cup 2022 Challenge online! - For the last 16 years, with every big football tournament (World Cup and Euro Cup), we've launched an Oracle APEX app where you can predict the scores of...Il y a 3 ans
-
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 3 ans
-
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 3 ans
-
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 3 ans
-
“Oracle Database Security with practice solution” books - Finally I would like to say I made it. First time in Azerbaijan , I published “Oracle Database Security with practice solution” books. I strongly recommend...Il y a 4 ans
-
Running High Scale Low Latency Database with Zero Data In Memory? - I was talking to one of my oldest database colleagues (and a very dear friend of mine). We were chatting about how key/value stores and databases are evo...Il y a 4 ans
-
Puppy remembrance virtual goodbye session - Our dear friend Pieter left us unexpectedly in July, a lot of people couldn't say goodbye yet. Therefore we organise a virtual goodbye ceremony We wi...
Il y a 4 ans -
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
-
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
-
Video: Updated Tour of Database Actions & JSON - Video tour and demonstration of our latest JSON interface in Database Actions (formally SQL Developer Web) for the Oracle Database. The post Video: Updat...Il y a 5 ans
-
pgbouncer and slow server pool increase - This post is about an issue I ran into when trying to use pgbouncer in front of Yugabyte YSQL, the postgres layer yugabyte reuses for handling relational d...Il y a 5 ans
-
Certification Tests – A Necessary Evil - Originally posted on Mike Gangler's Musings: In today’s database market, getting certified is becoming more of a requirement than previous years.?? The cur...
Il y a 5 ans -
Certification Tests – A Necessary Evil - Originally posted on Mike Gangler's Musings: In today’s database market, getting certified is becoming more of a requirement than previous years.?? The cur...
Il y a 5 ans
-
Sending Push Notifications from Oracle Notification Service with Oracle Functions and Pushover - The Oracle Notification Service is an extraordinary service. I’ve blogged about it in the past (see the Complete Guide to the Oracle Notification Service...Il y a 5 ans
-
Oracle Identity and Access Management 12c Upgrade Factory - Organizations want to reduce complexity and achieve more control across an increasingly complicated technology landscape. The dynamics and logistics are ...Il y a 5 ans
-
Introducing Oracle Cloud Infrastructure Vulnerability Scanning Service - Oracle Cloud Infrastructure puts the security of critical workloads at the center of our cloud infrastructure. This modern public cloud is built with the...Il y a 5 ans
-
Fusion Middleware Support Monthly Blog Index - March 2021 - Welcome to the Monthly Index for March 2021 The following provides quick links to recent Fusion Middleware Proactive Support Blog postings from over the ...Il y a 5 ans
-
ANNOUNCING: Systems Engineering Forum - Modernizing Enterprise Infrastructure with Oracle ... - Oracle Systems Engineering is hosting a webinar on Oracle Solaris and SPARC systems in the North America time zone on April 13th, 2021. Join us live at 9...Il y a 5 ans
-
ANNOUNCING: Systems Engineering Forum - Modernizing Enterprise Infrastructure with Oracle ... - Oracle Systems Engineering will be hosting a webinar on Oracle Solaris and SPARC systems in the North America time zone on April 13th, 2021. Join us live...Il y a 5 ans
-
ANY_VALUE and FIRST/LAST (KEEP) - The FIRST and LAST (a.k.a. “KEEP”) aggregate functions are very useful when you want to order a row set by one column and return the value of another col...Il y a 5 ans
-
Upcoming talks UTOUG, INSYNC, and Uzbekistan INHA University. - March and April are booking up fast. Getting real busy and loving life. Utah Oracle Users Group (UTOUG) March 17 – 18 Keynote: “Curves ahead: Emerging tech...Il y a 5 ans
-
Oracle ODA 19.10 Will Support KVM for Hard Partitioning of Oracle Databases - Major announcement made by the ODA team last week that this release will be the last release to support 11.2.0.4. After this release, customers will hav...Il y a 5 ans
-
Am I running from inside a (DBMS_SCHEDULER) Job? - I’ve talked about improving your code instrumentation in the past, in particular how to use conditional compilation for your extra logger calls. See Debugg...Il y a 5 ans
-
Security - "WIn16 :Z:\ Module 02 Footprinting and Reconnaissance\Website Mirroring Tools\HTTrack Web Site Copier and double-click httrack_x64-3.49.2.exe to launch the...Il y a 5 ans
-
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 5 ans
-
-
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
-
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 -
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
-
3 Benefits of Migrating to Oracle Linux Virtualization Manager (OLVM) - 3 Benefits of Migrating to Oracle Linux Virtualization Manager (OLVM) As Oracle VM inches ever closer to its 2021 end of support date, Oracle VM users have...Il y a 6 ans
-
Advance Your Career with New 2020 Credentials - We’re excited to announce the release of many new 2020 certification exams. Being certified on the latest release ensures you stay current on Oracle te...Il y a 6 ans
-
Unix - Automatically notifiy when disk space is running low - It's good to be forewarned when one of your volumes or diskspace is running low before it actually runs out (100% used). I have seen many databases hang wh...Il y a 6 ans
-
Following Various Legal Action Regarding “Oracle Cloud Revenue” - As a courtesy, I would like to provide a copy of the latest legal document filed in an action being brought against Oracle leadership resulting from allege...Il y a 6 ans
-
New Parallel Distribution Method For Direct Path Loads - Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT APPEND and CTAS ...Il y a 6 ans
-
SQL Puzzle - Calendar of Current Year - With this post, I want to share a SQL Puzzle to *Generate the Complete Calendar of Current Year*. As you can see in the desired output - Month names shoul...Il y a 6 ans
-
Rankings for Logic Annual Championship for 2019 - You will find below the rankings for the Logic Annual Championship for 2019, held in February 2020 on the Oracle Dev Gym. The number next to the player's...
Il y a 6 ans -
ORA-12954 - I went to Techfest 2019 in Brighton. While I was there I saw a presentation by somebody from Pythian. He said that Oracle Database Express Edition is now v...Il y a 6 ans
-
Invalid ODCIPARTINFOLIST on Upgrade - I have been working on upgrading Oracle 12.1.0.2 databases to Oracle 19.3 when I ran into a problem that took me quite awhile to figure out. I did a search...Il y a 6 ans
-
INSERT … LOG ERRORS and SQL%ROWCOUNT - Oracle SQL has a really neat feature to log the rows that failed to be processed during DML statement (INSERT / UPDATE / DELETE / MERGE ). This is really g...Il y a 6 ans
-
Exadata storage cell rolling restart caused datafile and redo log file header block corruptions - 24 hours passed – still at work. Struggling to start up the database which was corrupted during cell storage rolling restart procedure. And I’ve never seen...Il y a 6 ans
-
Response to Make database simpler - I read an interesting and thought provoking blog this morning Make Oracle database simple again Much of is is common sense and is really best practise – n...Il y a 6 ans
-
Getting an excel list of all Azure Virtual machines - Now i don't think i'm unique in getting frustrated that from some of the Azure portal screens there is no download as csv option or a more effective fi...
Il y a 6 ans -
Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect - Introduction TOAST stands for “The Oversized-Attribute Storage Technique” and allows to broke up large fields value into multiple physical rows (see the Po...Il y a 6 ans
-
Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect - Introduction TOAST stands for “The Oversized-Attribute Storage Technique” and allows to broke up large fields value into multiple physical rows (see the Po...Il y a 6 ans
-
PL/SQL & SQL Coding Guidelines Version 3.6 - PL/SQL & SQL Coding Guidelines Version 3.6Il y a 6 ans
-
Truncate (or drop!) partition without disturbing global non partitioned indexes - The problem Typical problem with partition tables is partition pruning and problems with global non partitioned index on them. From the theory, if you tru...Il y a 6 ans
-
Delphix XPP explained - This article was originally posted on the Delphix Support blog on 15-Nov 2015, but with the deprecation of the XPP feature with the new 6.0 release and hig...Il y a 6 ans
-
My Presentations at Germany Oracle User Group Conference (DOAG2019) - Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot for D...Il y a 6 ans
-
My Presentations at Germany Oracle User Group Conference (DOAG2019) - Next week I will be presenting the two following topics at Germany Oracle User Group Conference (DOAG2019): Cloning Oracle EBS Database With Snapshot for D...Il y a 6 ans
-
Exadata X8M - World's Fastest Database Machine - Exadata X8M has launched during OOW 2019, and termed as world's fastest Database Machine. Let's walkthrough about new additions that has made X8M as world...Il y a 6 ans
-
SQLPATH/login.sql Not Run…. Again! - SQLPATH/login.sql will fail to run in 19c on Windows if the SQLPATH value isn't to Oracle's liking. A simple rename can workaround the problem.Il y a 6 ans
-
Logical Domains and Micro Partitions - Consolidation of different workloads often involves the use of virtualization technologies and/or partitioning of a physical server platform. Scenarios ...Il y a 6 ans
-
Add Oracle Linux 8 Vagrant box - When using Oracle Linux (a lot) for local development you most likely want to use Vagrant to quickly deploy new environments locally. Oracle originally sup...
Il y a 6 ans -
Pluggable Database Cloning using Snapshot Copy - You need to be logged in to see this part of the content. Please Login to access.Il y a 6 ans
-
MySQL history list effect on the latest record version reads - Mysql has a Multi Version Consistency Control(MVCC) to deal with Isolation part of ACID. Mysql effectively keeps the old row versions as long as needed for...Il y a 6 ans
-
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 6 ans
-
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 6 ans
-
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 6 ans
-
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
-
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 -
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
-
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
-
MIN/MAX Optimization and Asynchronous Global Index Maintenance - In this short post I would like to point out a non-obvious issue that one of my customers recently hit. On the one hand, it’s a typical case where the quer...Il y a 7 ans
-
TIP 120 - How much memory my Linux process is using - _uacct = "UA-2338271-1"; urchinTracker(); Just came across some notes regarding Linux memory and I thought to share the below tip on how to find out memory...Il y a 7 ans
-
Dbvisit Standby Version 9 has landed! - Dbvisit Standby, Disaster Recovery, Oracle [image: Dbvisit blog preview image] Dbvisit Standby Version 9 has landed! Wow what an exciting time at Dbvisit ...Il y a 7 ans
-
Petit lexique du BigData - Avec l’importance grandissante des technologies BigData, les entreprises se sont retrouvées confrontées à une multitude de nouvelles notions, qu’elles on...Il y a 7 ans
-
Package and distribute a Scala jar to run on the command line - Add this to pom.xml – (update the mainClass to match your program): In Eclipse right click project and run as Maven build with goal=package Sample output f...Il y a 7 ans
-
CDB Fleet in Oracle Database 18c - RSS content Oracle database 18c introduces a new CDB Fleet feature which allows many CDBs to be managed as one. A CDB fleet is a collection of CDBs and...Il y a 7 ans
-
Identifying PostgreSQL Bloat and fixing it without downtime - Original Post can be viewed at Identifying PostgreSQL Bloat and fixing it without downtime MVCC (Multi-Version Concurrency Control) feature allows databa...Il y a 7 ans
-
Oracle Ksplice introduces Known Exploit Detection functionality - The Oracle Ksplice team has added some really cool new functionality in Oracle Ksplice. Instead of writing and copying the blog pretty much, just go dire...Il y a 7 ans
-
Playing with Oracle Database Security Assessment Tool (DBSAT) - The Database Security Assessment Tool (DBSAT) is an incredible free command line tool provided by Oracle Corporation as a utility to help you verify your d...Il y a 7 ans
-
Hierarchical Query with search parameters (Pruning) - The following is a query from a friend, Reproducing it here: I have a menu structure using a hierarchical query. i have search field to enter some string a...Il y a 7 ans
-
-
Oracle Certification Highlights – March - Oracle Certification highlights provides insight on new exams, exam preparation, exams that are retiring, program announcements, and all the great things t...Il y a 7 ans
-
Filtering in the APEX Interactive Grid - Remember Oracle Forms? One of the nice features of Forms was the use of GLOBAL items. More or less comparable to Application Items in APEX. These GLOBALS w...Il y a 7 ans
-
OEM Target Discovery and One Potential Source of Duplicates - With OEM 12c came a feature that I've come to appreciate, the ability to discover all targets on a given environment. Part of my appreciation is the remo...Il y a 7 ans
-
Statspack Documentation - There is a lot of information on Statspack on the web but I have not found the official Statspack documentation except for Oracle 9i. As of Oracle 10g the ...Il y a 7 ans
-
Why JAVA Is A Top Career Option for Beginners - There are multiple platforms and streams for developing a product or application. When we talk of technologies and programming languages, Java is the most ...Il y a 7 ans
-
-
Scripts to deal with SQL Plan Baselines, SQL Profiles and SQL Patches - To mitigate SQL performance issues, I do make use of SQL Plan Baselines, SQL Profiles and SQL Patches, on a daily basis. Our environments are single-instan...Il y a 7 ans
-
The Ultimate guide to DevOps Tools Part #4 : Docker - In this series that related to DevOps Tools that helps you as DBA to automate your work and make it easier for you , this will be the last part for Docker....
Il y a 7 ans -
OTW18 Sessions: Data Engineering and Latch Contentions - Thank you all those who came to my sessions at the OakTable World. Here are the presentations materials Think Data; not Database Data Engineering for Data ...Il y a 7 ans
-
Oracle Database EM 18 XE Available to Remote Clients - I found lot of posts about *Oracle Database 18 XE*. It's very interesting for me. I didn't blog about how to install, because it's very easy for using rpm...
Il y a 7 ans -
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 7 ans
-
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 7 ans
-
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
-
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
-
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 -
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
-
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
-
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 -
Failover with Amazon Aurora PostgreSQL - https://aws.amazon.com/blogs/database/failover-with-amazon-aurora-postgresql/ AdvertisementsIl y a 8 ans
-
Duplicate database to a diferent server - Prepare OLD database cd $ORACLE_HOME/dbs; cp orapwDBNAME orapwDBNAME.beforemigration orapwd file=/oracle/DBNAME/12102/dbs/orapwDBNAME sysdg=yes sysbackup=y...Il y a 8 ans
-
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder - While the quick start wizards in Visual Builder Cloud Service (VBCS) make it very easy to create tables and other UI components and bind them to business...Il y a 8 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder - While the quick start wizards in Visual Builder Cloud Service (VBCS) make it very easy to create tables and other UI components and bind them to business...Il y a 8 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder - While the quick start wizards in Visual Builder Cloud Service (VBCS) make it very easy to create tables and other UI components and bind them to business...Il y a 8 ans
-
Reflecting Changes in Business Objects in UI Tables with Visual Builder - While the quick start wizards in Visual Builder Cloud Service (VBCS) make it very easy to create tables and other UI components and bind them to business...Il y a 8 ans
-
European Privacy Requirements: Considerations for Retailers - When retailers throughout Europe adopt a new set of privacy and security regulations this week, it will be the first major revision of data protection gu...Il y a 8 ans
-
European Privacy Requirements: Considerations for Retailers - When retailers throughout Europe adopt a new set of privacy and security regulations this week, it will be the first major revision of data protection gu...Il y a 8 ans
-
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 8 ans
-
Date and Time Format in ASMCMD for File Listing - This is a short blog post to give you an idea how you can define your own custom date and time format for “ls -l” command in ASMCMD. If you use ASMCMD qu...Il y a 8 ans
-
HDFS: Useful Hadoop Admin Commands - HDFS is designed more for batch processing rather than interactive use by users. The emphasis is on high throughput of data access rather than low latency...Il y a 8 ans
-
NEW FEATURES IN ORACLE12C R2 AND ORACLE18C R1 - *NEW IN ORACLE12C AND ORACLE18C* Oracle12c R2 Multitenant Container Database Architecture Oracle12c R2 Database Architecture *New Features in Oracl...
Il y a 8 ans -
Good bye and thanks for the memories! - Hello fellow reader, 8 years ago I set up a goal to share my knowledge with fellow database engineers via this blog. This resulted in 36 (hopefully, decent...Il y a 8 ans
-
#OUGN18 by OUGNorway is approaching - It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3 of my presentations are ready, all logistics are ready and the other stuff are r...
Il y a 8 ans -
#OUGN18 by OUGNorway is approaching - It is “now” time to post about upcoming OUGN 2018 Vårseminar. Since all 3 of my presentations are ready, all logistics are ready and the other stuff are r...
Il y a 8 ans
-
Deep learning, concepts and frameworks: Find your way through the jungle (talk) - Today at OOP in Munich, I had an in-depth talk on deep learning, including applications, basic concepts as well as practical demos with Tensorflow, Keras a...Il y a 8 ans
-
Oracle Solaris 11.4 Public Beta Released - Yesterday the Oracle Solaris 11.4 Beta was released to the public. You can download it from OTN to have your go with it. Please read the documentation to l...Il y a 8 ans
-
Why Cloud? The reason changed in 2017…twice - In 2017, the predominant reason companies considered moving to the Cloud changed *multiple times*. While the “how” tends to shift frequently, seeing the “...Il y a 8 ans
-
Service Contracts Renewal Portal - How to setup and use Service Contracts Renewal Portal Date: August 1, 2012Author: Parag Mone0 Comments Overview Renewing service contracts is an important ...Il y a 8 ans
-
Cloud Networking Basics for the Non CCNA certified – IP Address - As more and more enterprises are migrating their IT deployments to the Public Cloud, several IT personnel who are not classically trained on networking the...Il y a 8 ans
-
Beware of intensive slow query logging when using - log_queries_not_using_indexes - MySQL slow query log is great for identifying slow queries that are good candidates for optimisation. Slow query logging is disabled by default, but it is ...Il y a 8 ans
-
Oracle and the Autonomous Database (a personal perspective from afar) - Yeah, if you hadn’t seen that one coming, hmmm, what can I say… Lot’s of…Il y a 8 ans
-
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 8 ans
-
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 8 ans
-
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 8 ans
-
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 -
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 -
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
-
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
-
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
-
Using DML with ADRCI - The Oracle Database has some useful debugging and diagnostics features. One such utility called the Automatic Diagnostics Repository Command Interpreter or...
Il y a 9 ans -
acroread on Linux 6 - As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader (acroread) allows users to view and print documents in Portable Document Format (PDF...Il y a 9 ans
-
12.2 ACFS compression, part I - One of the new 12.2 features is the ability to transparently compress ACFS filesystems. Compression is enabled using *acfsutil* utility: [root@raca1 ~]#...Il y a 9 ans
-
-
Oracle Database 12c Release 2 - Long Identifiers - Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) t...
Il y a 9 ans -
Whoa! Release News for PHP OCI8, node-oracledb, Python cx_Oracle, Instant Client and ODPI-C - I'm just catching up on some releases that happened prior/during my vacation. Here are some things you may have missed tweets on: - PHP OCI8 2...Il y a 9 ans
-
Comment acquérir les compétences nécessaires à la transformation digitale lorsqu'on est partenaire Oracle - Notre vie est de plus en plus interconnectée avec nos appareils. Alors que les machines sont de plus en plus intelligentes, l'Internet of Things est appe...Il y a 9 ans
-
Oracle VM Features: Distributed Resource Scheduler - One of the handy management features of Oracle VM is the Distributed Resource Scheduler (DRS). DRS lets administrators load balance CPU and network resou...Il y a 9 ans
-
IOUG Collaborate 2017 - I have a few presentations scheduled in IOUG Collaborate 2017, Las Vegas. 1. Session: 621: RAC Clusterware internals **Date/time: Mon, Apr 03, 2017 (01:30 ...Il y a 9 ans
-
Oracle Database 12c R2 is in General Availability for On-premise Customers - With the announcement of GA for on-premises customers, Oracle Database 12c R2 is now available everywhere-in the cloud, with Oracle Cloud at Customer, an...Il y a 9 ans
-
Object oriented logging - It is a very common requirement. You need to be able to log the start and end of procedure and function calls. You also need to log error and exception eve...Il y a 9 ans
-
Oracle Database 12c Release 2 is out and with it Docker build files on GitHub - Oracle just released Oracle Database 12c Release 2 for on-premises Linux and Solaris. With the Oracle 12c R2 release Oracle has also released the latest ...Il y a 9 ans
-
User-based filters in query zones - whilst developing query zones is relatively well documented, the ability to filter output based on the currently logged on user is less well defined, and...Il y a 9 ans
-
Announcing the 2016 PL/SQL Challenge Championship for Database Design - In 2016, 340 people answered 6,185 quizzes in the Database Design quiz on the PL/SQL Challenge. I'm pleased to see so many people taking an interest in h...Il y a 9 ans
-
The Relational Data Model - Mid-eighties. I was studying Computer Science. Little did I know back then that this thing called "The Relational Data Model" (RDM) would become huge in th...Il y a 9 ans
-
“library cache lock” waits from many concurrent DBMS_JOB.submit() operations - I have faced performance issue on one of production database in banking environment. From AWR report I found that “library cache lock” as the top wait ev...Il y a 9 ans
-
Setting up Transport Layer Security/Secure Sockets Layer for Managed ODP.NET - *[I was chatting with ODP.NET product manager, Alex Keh, and he let me know about some known issues that developers currently face when using managed ODP...Il y a 9 ans
-
Book on Oracle 12c New features - A Book on Oracle 12c New features for administrators Hi All, It’s our pleasure to announce the availability of our first book – OCP 12c upgrade 1Z0-060 Exa...Il y a 9 ans
-
Do you suffer from Storage Stockholm Syndrome? - The last year at DSSD (now a part of Dell EMC) has been an extremely interesting one for me, and I’ve learned a great deal, which is always good. Some of t...Il y a 9 ans
-
On issuing commit from database PL/SQL - There was something of a storm on Twitter on 12-Oct-2016. Twitter is a nice medium for, say, showing a photo to your followers or referring them to an in...Il y a 9 ans
-
Oracle back-port patches for Adaptive performance issues released for 12.1 (dynamic stats) - Previously I wrote about performance issues with 12.1 Adaptive features, specifically the large number of dynamic statistics checks, usually triggered by t...Il y a 9 ans
-
Performance aspects of APEX reports - As this post appears, I'm presenting on this subject for the Dutch Oracle User Group OGh. This blog post won't contain as much detail as the presentation i...Il y a 9 ans
-
Oracle CX Partner Enablement Summit – North America - Join us at the Oracle Headquarters in Redwood Shores, CA to continue to develop your CX practices and solutions based on Oracle’s CX Platform proposition...Il y a 9 ans
-
#doag2016 and we are presenting!! - Portrix Systems will be at #doag2016… and we will be presenting too!! Each day of the conference, members of the Portrix Systems staff will be active! On T...Il y a 9 ans
-
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 9 ans
-
Segment Statistics - rem******************************************************** rem Show Segments with the highest Lock waits rem André Karlsson rem https://www.protractus.com...Il y a 9 ans
-
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
-
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 -
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
-
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
-
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 -
R12.2 CUSTOM APPLICATION/TOP - STEP1: Download Patch 3636980 “Support Diagnostics (IZU) patch for AD Splice” from My Oracle Support. STEP2: Manually copy the three .txt files from the 36...Il y a 10 ans
-
SQL Joins - Codeproject has this image which explains the simple basics of SQL joins, taken from: http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx
Il y a 10 ans -
“ASH math” of time_waited explained with pictures and simulation - As explained by John Beresniewicz, Graham Wood and Uri Shaft in their excellent overview ASH architecture and advanced usage, avg( v$active_session_history...Il y a 10 ans
-
zabbix dbsyncers and caching for log items - in version 3.0.1 - I am using zabbix for about a year now and it still has not shown me all power that is inside. One of the things that is very interesting to know more ab...Il y a 10 ans
-
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, SachinIl y a 10 ans
-
Get the Familiar Database You Trust, In the Cloud - With Oracle Database Cloud, you can have up to 3x mirroring of storage for data redundancy, 100% system backup and restore, plus data centers in multiple...Il y a 10 ans
-
Moving Sideways - The past two years have seen a lot of change in my life :- - I moved to Singapore thinking it would be for a year or two at least and is now looking ...Il y a 10 ans
-
Moving Sideways - The past two years have seen a lot of change in my life :- - I moved to Singapore thinking it would be for a year or two at least and is now looking ...Il y a 10 ans
-
Formation Performance Oracle à Genève le 18 mai 2016 - Une journée de formation Performance Oracle est organisée par le Swiss Oracle User Group le 18 mai 2016 à Genève. http://www.developpez.net/forums/blogs/19...Il y a 10 ans
-
Help Celebrate One Million Answers at the PL/SQL Challenge! - *Sometime* in the next couple of months, someone will submit the 1,000,000th answer on the PL/SQL Challenge. And Chris Saxon, member of the AskTom Answer...Il y a 10 ans
-
Tech15 - Last December I presented at Tech15, the largest Oracle conference in the Europe. Many thanks to the organizing team of this great conference. Here is my p...Il y a 10 ans
-
Denodo Server - Setup & configure Cache Database to MySQL: - *Denodo Server - Setup & configure Cache Database: - Bottlenecks* *Step1: * Install the Denodo Server by clicking the executable and follow the steps wit...Il y a 10 ans
-
Client support for WITH using PL/SQL - My employer has been using 12c for about a year now, migrating away from 11gR2. It's fun working out the new functionality, including wider use of PL/SQL. ...Il y a 10 ans
-
Restoring and Recovering the Database on a New Host using RMAN - This blog will demonstrate detailed steps to restore a database on New Host using RMAN. You can also use it to move a production database to new host as...
Il y a 10 ans -
OCI Client-Side Deployment in 12C - The 12c version has introduced a new features called “OCI Client-Side Deployment Parameters” this feature gives you the possibility to override some OCI pa...Il y a 10 ans
-
Moving my blog! - Hi All! I just wanted to let you know I’ve moved my blog to https://me-dba.com I’m going to hide all content from this site as it will be available from th...Il y a 10 ans
-
Point In Time Recovery Using Binlog In MySQL-Part 1 - Lets see how we can recover our database or tables using MySQL Binary logs. To avail this feature make sure that BINARY LOGS are enabled in MySQL.Here We ...Il y a 10 ans
-
Docker Containers and Delphix Architecture - I use wordpress for my personal blog. Works fine on it’s own. It is just me making a few posts here and there. Occasionally there are problems like an upgr...Il y a 10 ans
-
ODI Interface'lerinde çalışma süresiyle ilgili performans iyileştirmeleri - Merhabalar, Bir önceki yazımda ODI Uygulama Performans İyileştirme calısmasına ek olarak ,du yazımdada ODI üzerinden yapılan geliştirmelerde yaşanılan per...Il y a 10 ans
-
Oracle Clusterware - Startup (Internals) - It's an long standing post for me to share how the CRS start-up works. Hope every one known with pictorial representation of CRS start-up provided in orac...Il y a 10 ans
-
Giúp nam giới điều trị ung thư tinh hoàn bằng nấm lim xanh - Ung thư tinh hoàn là một căn bệnh chỉ xuất hiện ở nam giới liên quan đến chức nắng sinh sản. Căn bệnh này có thể xuất hiện ở bất kỳ độ tuổi nào...Il y a 10 ans
-
Mystats utility - A variation on Jonathan Lewis's SNAP_MY_STATS package to report the resource consumption of a unit of work between two snapshots. Designed to work under co...Il y a 10 ans
-
Grants to retrieve SQL_MONITOR - A quick post as I have been struggling to get the full list of object level grants to be able to retrieve the output of DBMS_SQLTUNE.REPORT_SQL_MONITOR. 1 ...Il y a 10 ans
-
How to Find the Optimal Configuration for Your Virtualized Environment - Thanks to the New York Oracle User Group for allowing me to present and to all who attended for their valuable questions and comments. The presentation sho...Il y a 10 ans
-
-
ACCESSIBLE BY clause versus Function Based Indexes - Oracle introduced the ACCESSIBLE BY clause in 12c to improve the security of subrograms. Basically the scenario is following: Let’s create a tax stored fun...Il y a 10 ans
-
DOAG 2015: Best of Oracle Security 2015 - Yesterday I gave my yearly presentation “Best of Oracle Security 2015” at the DOAG 2015 conference in Nürnberg. In this presentation I showed different Ora...Il y a 10 ans
-
Things Be-a-Changin' - "OTN Garage" Will be Called "OTN Systems Hub" Very Soon! - Oracle OpenWorld 2015 | OTN Systems Hub Hi Y'all, As I have mentioned a few months ago, the *OTN Garage* name will be changing to *OTN Systems Hub*. Thi...Il y a 10 ans
-
Database Link between Oracle Database and SQL Server Database - Here is link of this post Database Link between Oracle Database and SQL Server Database This site moved to dbacatalog.blogspot.com please visit dbacatalog....Il y a 10 ans
-
Oracle APEX 5.0.2 now available - Oracle Application Express 5.0.2 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.2, ...Il y a 10 ans
-
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 10 ans
-
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 10 ans
-
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 10 ans
-
-
Analyzing 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 -
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
-
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
-
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
-
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
-
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
-
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 -
Frequently asked questions about Nashorn and Node.js - During many of my talks about Nashorn, Node.js on the JVM and related topics, I frequently get asked these kinds of questions and I'd like to try to give s...Il y a 11 ans
-
Xeoma Review - I decided to write a CCTV review after our bank mail started to disappear from our mailbox. I have learned quickly that simply purchasing cheap camera won’...Il y a 11 ans
-
Oracle E-Business Suite Release 12.2: Technical Planning, Getting Started, and Go-Live Checklist - This link helps you plan your move to Oracle E-Business Suite Release 12.2, providing the following resources: An in-depth Oracle E-Business … Continue rea...Il y a 11 ans
-
Printing a large XMLTYPE value using DBMS_OUTPUT - As a sort of primitive debugging-method I wanted to show the contents of an XMLTYPE variable using DBMS_OUTPUT.PUT_LINE. When you want to extract the conte...Il y a 11 ans
-
Sorry about late approval of comments.... - Just wanted to apologize about the late approval of a couple of comments. I thought I'd approved them but when I got on to do a blog entry I found that t...Il y a 11 ans
-
How to Relocate the MySQL Binary Logs to New Location - The binary logs are created in the data directory by default in MySQL Server. To have the binary logs in the data directory is not always the optimal l...Il y a 11 ans
-
Another blog on Oracle Standard Edition - Recently I found a blog dedicated on Oracle Standard Edition too. It’s from Ann Sjökvist and it’s available at this URL: http://www.sejustloveit.com/. ...Il y a 11 ans
-
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/ FrancoisIl y a 11 ans
-
Top Challenges in the Life of an IT Capacity Manager - Let me first confess. I don’t have double-digit years of experience in IT Capacity Management. But I would say, during last 9 years I have defined the proc...Il y a 11 ans
-
Oracle Database In-Memory Advisor Released - Oracle Database In-Memory option was released with Oracle Database 12c (12.1.0.2) and the In-Memory Advisor (IMA) has been much awaited since then. The Or...Il y a 11 ans
-
Maintaining Tempfile in TEMP Tablespace of PDB$SEED in Oracle 12c (12.1.0.2) - During testing recovery procedures for one of the ongoing projects I wanted to test the "complete disaster" recovery scenario. In this scenario I had to r...Il y a 11 ans
-
How To Approach Different Oracle Database Performance Problems - This page has been permanently moved. Please CLICK HERE to be redirected. Thanks, Craig. How To Approach Different Oracle Database Performance Problems J...
Il y a 11 ans -
12c New features - 1.1 Advanced Index Compression Advanced Index Compression works well on all supported indexes, including those indexes that are not good candidates for the...Il y a 11 ans
-
Find it. Fix it. Real-World SQL Tuning Cases - Jan. 13 Webinar Followup - If you missed my January 13th webinar entitled "Find it. Fix it. Real-World SQL Tuning Cases" you can now access the recording and download the presentatio...Il y a 11 ans
-
Shifting IT to scale - While some IT groups are fine tuning their practices, many others are still on the journey to achieve greater efficiency at scale. Not all can make this s...Il y a 11 ans
-
Continuing the story - One of my 2015 new year's resolutions, was to finish the story I started on this blog. The story being a talk that I had delivered a couple of times 3-4 y...
Il y a 11 ans -
Shrink a datafile, when ALTER TABLESPACE COALESCE is not working. - In a 11.2.0.3 database, we tried to reclaim space from USERS tablespace. We faced a problem. We use the following query to the the end of a particular USERS'...Il y a 11 ans
-
-
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 11 ans
-
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 encrypted table data found unencrypted in SGA - When data needs to be kept private, or companies are worried about data leakage, then they often choose to store that data in encrypted columns in the tabl...Il y a 12 ans
-
How to encrypt the data (tablespace or column's table) using a software keystore previously known as Oracle Wallet - To create a standard Oracle wallet and then add a master key to it you have to follow few basic steps: *1) Configure the sqlnet.ora file to define a file sy...
Il y a 12 ans -
brew install sqlplus - Gee, that didn’t work. For those of you wondering about the title of this post, I’m referring to the brew package manager for Mac OS — a nice utility for i...Il y a 12 ans
-
_direct_read_decision_statistcs_driven, _small_table_threshold and direct path reads on partitioned tables in 11.2.0.3 (Part 2) - This is continuation of my last post regarding direct path reads on partitioned tables in Oracle 11.2.0.3. To recap, the behavior I observed is that direc...Il y a 12 ans
-
On Error Messages - Here’s a pet peeve of mine: Customers who don’t read the error messages. The usual symptom is a belief that there is just on error: “Doesn’t work”, and tha...Il y a 12 ans
-
Step by Step Creating Asm instance and database - Click Add Button Click Next Button Click Next Button Click ide and next Button Size 3gb Click Next Button Click Finish Button Add another one disk 3g...Il y a 12 ans
-
Visit and Bookmark the My Oracle Support Blog - Untitled Document [image: MOS Icon] The My Oracle Support Blog continues the "Get Proactive" discussion and covers all topics related to My Oracle Suppor...Il y a 12 ans
-
A New Challenge - About two years ago Joyent began offering Linux instances, running under KVM, stored on ZFS, and secured by Zones (“double hull virtualization”). Since the...Il y a 12 ans
-
Cluster Definition - In Oracle, *clustering* is a way of ordering the physical placement of tables on a disk drive in such a way as to speed up I/O access times. This is accom...Il y a 12 ans
-
Upcoming Events... - I took some time off from the road at the beginning of 2014 - getting ready to get back on the road again, lots of trips scheduled from February till the e...Il y a 12 ans
-
How to find out all default values in init.ora? - This small test case shows it. [oracle@node1 ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0.3/dbhome_1 [oracle@node1 ~]$ cd $ORACLE_HOME/dbs [oracle@...Il y a 12 ans
-
Auditing a user in Oracle - Do you need to audit a user in your Oracle database? AUDIT ALL BY JOEUSER BY ACCESS; AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY JOEU...Il y a 12 ans
-
Yeni Blog - Kendime ait blog adresim http://zekeriyabesiroglu.com . Bundan sonraki yazılarımı http://zekeriyabesiroglu.com den takip edebilirsiniz. Teşekkürler.Il y a 12 ans
-
-
User defined locking with DBMS_LOCK - User defined locks with DBMS_LOCKS often brings up unexpected results, especially when it occurs within a mix of transactions in an application layer. Ther...Il y a 12 ans
-
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
-
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
-
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
-
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
-
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
-
Something for the future - A nice little feature in Oracle Database 12c is to query patching information via SQL. You can do this from SQLPlus or any other SQL interface jdbc/odbc ...Il y a 13 ans
-
Some Of Basic Questionnaire For Newly Release Oracle Database 12c - 1) What is an Pluggable database really? Ans-> This is new feature in oracle 12.1 release with respect to database. With this release there is a parent-c...Il y a 13 ans
-
How to Move USER_SDO_GEOM_METADATA like a Grandpa - Sometimes moving a small amount of data in Oracle database requires more work than the actual task you need to complete. DBAs always have their tools (PL/S...Il y a 13 ans
-
ReUse flag in PeopleSoft AE program – Bind variable issue and its impact on Performance - It has been long since I blogged as I got busy. Personally I became a Father and officially, I moved to PeopleSoft Performance and Benchmark(P&B) team. N...
Il y a 13 ans -
Hotsos 2013 A personal Touch 3/4 – Third Day - After having a good sleep I attended the first session in the morning from George Djerdj Srdanov with a presentation called “How to Get the Most Out of You...Il y a 13 ans
-
Little Changed - Incredible and depressing to see people still getting Oracle internals as wrong as this.Il y a 13 ans
-
Profile Baselines Patches - Whats the difference … I should have written this one earlier but better late than never. So, lots of DBA’s might me thinking, why oracle has 3 ways to acc...Il y a 13 ans
-
Add Code w/ Syntax Highlighting to PowerPoint - …or any media that supports rich text or HTML. I often include code-snippets or queries in technical presentations. I find them much more visually appealin...Il y a 13 ans
-
SQL 2008 Active-active cluster on windows 2008 R2 Share storage migration - This is my POC doc before we migrate our production sql 2008 cluster to new storage. it has two parts: first part simply install the cluster on 2 ESX VM im...Il y a 13 ans
-
Hash Semi Right Join : Oracle Tuning Tip#27 - *TOPIC:* Hash Semi Right Join *DEFINITION:* As described semi-join in previous forum (Tip#25), a semi-join between two tables returns rows from the outer ...
Il y a 13 ans -
Identify memory leak in Java app - One important advantage of java is programer don't care memory management and GC handle it well. Maybe this is one reason why java is more popular. As J...Il y a 13 ans
-
E-Business Suite R12 integration with Oracle Identity Management 11g - After successful implementations of Oracle SSO 10g with Oracle E-Business Suite 11i and R12, I have now completed an installation and implementation of th...
Il y a 13 ans -
GoldenGate error OGG-01755 SQL error: OCI Error 26,723 = ORA-26723 - I was trying to register extract OGG v 11.2 on one of my dev servers GGSCI (tpadldb10.gratiscard.com) 1> dblogin userid srvegate password xxxxx Successfu...Il y a 13 ans
-
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 13 ans -
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
-
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
-
Free Book: Introducing Microsoft SQL Server 2012 - Michael McLaughlin‘s blog has a post about a free MS SQL Server book (Introducing Microsoft SQL Server 2012) available here. If you are into MS SQL Server...Il y a 14 ans
-
An introduction to SQL Tuning : Basic Optimizer Operations - An introduction to SQL Tuning : Basic Optimizer Operations. Setup SQL Tuning sample schema 1. Full Table scan 2. Index Fast Full scans 3. Index Full sc...Il y a 14 ans
-
Oracle database on IBM Power systems with LPAR - Quite often I have been involved into discussions on Oracle database tuning or best practices for IBM AIX machines especially logically partitioned (LPAR...Il y a 14 ans
-
Waiting for “PX Deq Credit: send blkd”? - Occasionally I hear someone talking about how to reduce the waiting time of the event “PX Deq Credit: send blkd”. And it’s not uncommon to also realize tha...Il y a 14 ans
-
AUDIT : principes - *Paramètres d'initialisation concernant l'audit :* SQL> col name for a25 SQL> col value for a45 SQL> select name, value from v$parameter where name like '%...Il y a 14 ans
-
-
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 14 ans
-
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 -
OraSRP 4.1.0 - First time I've read about LOBREAD lines in 10046 traces in Vladimir Begun's blog-post dated Jun 2, 2010. I've tried to reproduce such trace in my environm...Il y a 15 ans
-
The Last Post... - ...at least here, on this blog as I’ve moved over to blog.lisadobson.com now.I’ve copied all the posts from here across to the new blog, but I will also be...Il y a 15 ans
-
Interesting case of the restriction of global hints - One of my colleagues sent following test case, of which he couldn’t control the join order with hints. 1. Create objects – table t1, t2 and t3 2. Now Let’s...Il y a 15 ans
-
Materialized View - +++++++++++++++++++++++++++++++++++++ MVIEW refresh Status on MASTER Site : +++++++++++++++++++++++++++++++++++++ set pages 1000 set linesize 180 col SNAPSHO...Il y a 15 ans
-
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 15 ans
-
Composite Interval Partitioning isn't as advertised. - Oracle® Database VLDB and Partitioning Guide 11g Release 1 (11.1) Part Number B32024-01 says: Interval Partitioning Interval partitioning is an extensi...Il y a 16 ans
-
Quick Tip: Counting Cursors - Counting the number of open cursors in a database instance can be a confusing activity. Perhaps an application has received an "ORA-01000: maximum open c...Il y a 16 ans
-
Blog relocation - I've decided to move on from TypePad, and I'm now blogging at www.guyharrison.net/blog (RSS http://guyharrison.squarespace.com/blog/rss.xml ) See you there...Il y a 17 ans
-
APP-FND-01564: ORACLE error 31202 in changepassword - We had this issue in our production this morning. Our dedicated sysadmin team were not able to change any user password from frontend. They were receiving ...Il y a 17 ans
-
Having more than 4GB of RAM on x86 Linux - When you do some googling on having more than 4GB of RAM on a 32bit x86 Linux system you usually get a lot of responses like: it's not possible, you won't ...Il y a 17 ans
-
★ 5 Links from Around the Web (2007-04-10) - Links to interesting, educational, informational, or just plain fun websites...Il y a 19 ans
-
Moving to WordPress - Blogger irritates me. Let's see if Wordpress makes me happy. http://oraclesponge.wordpress.com/ I've used the supplied import functionality to move over po...Il y a 20 ans
-
Difference between SCN and checkpoint. - SCN and checkpoint: System change number(SCN) is represented with SCN_WRAP and SCN_BASE. Whenever SCN_BASE reaches 4294967290 (2 power 32), SCN_WRAP goes u...Il y a 20 ans
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
jeudi 27 juin 2013
mercredi 26 juin 2013
Oracle Database 12c Review :: Finally, a true cloud database
JUNE 26, 2013
Oracle Database 12c review: Finally, a true cloud database
Pluggable databases bring a new level of efficiency and ease to database consolidation, while a wealth of other new features address performance, availability, and more
Interesting article. Read it
jeudi 20 juin 2013
Inscription à :
Articles (Atom)