Recent searches
Search options
#OracleDB
So today, I did not find the solution to an exotic #OracleDB problem (how can I set the Oracle Parameter allowed_pvf_owners?) in My Oracle Support or on the usual sites. I found it in a Japanese blog:
https://qiita.com/plusultra/items/d0b8e92ce7bdae82e430 And people say learning #Japanese does not help you in IT. (Oh, and the solution is that you are not allowed to set the parameter allowed_pvf_owners, but you can set it as parameter _allowed_pvf_owners).
@thjanssen123 This post is full of pure gold if you're using #Hibernate. When optimizing your queries for a #OracleDB keep in mind Oracle supports function-based indexes. Use the DBMS_STATS package to regularly create histograms for the indexes/the indexed table columns.
When designing your data model remember Oracle does not index the null value. Also do not distort index histograms with default values (as a fix to the null problem). If handling larger datasets index range scans are key.
While working on #Operaton, our #Camunda 7 fork, a community member asked a question on the performance of the job executor in a scaleable environment. His test setup and experiments showed, that it did not scale well, confirming existing preconceptions.
The discussion led to a work-in-progress feature for the Operaton engine, using `FOR UPATE ... SKIP LOCKED` on #postgres, #mariab, #mysql and #oracledb.
https://javahippie.net/java/bpmn/operaton/2024/12/15/for-update-skip-locked.html
Hiring Now!
with 7-13 years of experience in the following technologies:
Microservices Oracle DB | SQL Angular Java | Spring Boot | Hibernate
Locations: Chennai & Pune
Notice Period: Immediate Joiner / Serving November
we want to hear from you! 
Apply Now: inderpreetk@overturerede.com
Contact: 9910078724
> "Hell hath frozen over," Patrick Moorhead ... told Yahoo Finance about the partnership. "These two companies have been essentially at war with each other since AWS was formed 15 years ago, and AWS's thesis before this was they were going to take out Oracle ... and they would use their database. ... What's clear today ... was that Oracle database is very much alive and well."
#Roundcube 1.5.9 (#LTS) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport) https://roundcube.net/
#Roundcube 1.6.9 (stable) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL) https://roundcube.net/
#Roundcube 1.5.8 (LTS) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability) https://roundcube.net/
#Roundcube 1.6.8 (stable) has been released (#Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability) https://roundcube.net/
@sabi also there's a more sinister reason for low-core-count CPUs, with garbage like #OracleDB and #WindowsServer being #licensed per core, socket & system and costs going up exponentially.
And no, they won't accept I.e. just disabling CCXes and Threads per UEFI or just putting them into a resource-restricted VM because they CPUID the CPU and require licening the entire Host System even if they only utilize a fraction of it's resources.
And no, disabling CPUID won't work, then they'll just not activate their license at all if not outrifht snitch on the Sysadmin / Company...
Ask me how I know...
@jasongorman I've seen a project where #OracleDB was replaced with #postgresql . The project was long and painful due to "optimized platform usage".
I've created a #poc where I replaced postgre driver with #neo4j but this was even harder due to no many-to-one support in the persistence layer.
Haven't seen a project where frontend change was required (unless it was from #jsp to some separate FE app)
Updated #Introduction #Introductions, hashtags ahead …
#TwitterExile
#SoftwareEngineer - #OpenVMS, #Linux, #HP-UX, #OracleDB, #SQL, #VirtualBox
#RealAle (#Tring especially), #RedWine and #Whisky (#SingleMalt)
#Curry, #IndianFood, #FullEnglish, #ChocolateOrange
#SciFi #ScienceFiction - #StarTrek, #Orville, #StarWars, #Expanse etc.
#CouchPotato but love socialising down the #Pub
Fedora #Hat wearer
#AgnosticAtheist
#UKLabour voter (or #LibDem or
#Greens to get Tories out) #Socialism #FBPE
Wer sich Oracle nicht länger leisten kann oder möchte, findet mit dem EnterpriseDB PostgreSQL Advanced Server (EPAS) eine kompatible Alternative.
Migrations-Leitfaden: Von Oracle zur günstigen Alternative EnterpriseDB wechseln