#NowPlaying
#MusicSky
▶️ Atlantic Starr - Always (1987)
#AtlanticStarr #Always #80s #R&B #soul #pop #DavidLewis #JonathanLewis #WayneLewis
Latest posts tagged with #JonathanLewis on Bluesky
#NowPlaying
#MusicSky
▶️ Atlantic Starr - Always (1987)
#AtlanticStarr #Always #80s #R&B #soul #pop #DavidLewis #JonathanLewis #WayneLewis
Four news stories from four organizations all asked why we are unprepared for this year's floods.
#flooding #sarasota #dredging #jonathanlewis
scansarasota.blogspot.com/2025/06/unpr...
#OrclDB #JonathanLewis #MustRead4DBA
Shrinking indexes
https://bit.ly/3cPOU03
#OrclDB #JonathanLewis
Upgrade Surprise
https://bit.ly/3NTPR4Y
#OrclDB #JonathanLewis Materialized Views catalogue
This is a list of articles (Jonathan) written about materialized views. Each entry has a date stamp and a short note of the contents.
https://buff.ly/3HifM25
#JonathanLewis Catalog #OrclDB
Compression Catalogue
https://buff.ly/32TLILX
#JonathanLewis Catalog #OrclDB
Column Group Catalogue
https://buff.ly/2DCsFrV
#JonathanLewis Catalog #OrclDB
Indexing Catalogue
https://buff.ly/3s9QPjz
#JonathanLewis Catalog #OrclDB
255 column catalogue
https://buff.ly/3rn4KDH
#JonathanLewis Catalog #OrclDB
Execution Plans Catalogue
https://buff.ly/3Gm54qv
#OrclDB #JonathanLewis Statistics_Level
The script is just a simple report of v$statistics_level, which reports the various real-time statistics collections and advisors that could be enabled, the view that holds associated results (where relevant)...
#OrclDB #JonathanLewis DB Optimizer
"I’ve rediscovered this list of articles by Stefan Koehler on my laptop; it has a bias towards SAP users, and it’s several years old ... but there still seem to be plenty of people using 12c (and SAP)"
https://buff.ly/3Gyb291
#OrclDB #JonathanLewis
Partitioning existing data
https://buff.ly/3fxlYbA
#OrclDB #JonathanLewis Oracle Sequences: RAC
Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.
https://buff.ly/2RVWrQ4
#OrclDB Edition-based Redefinition
#JonathanLewis
A list of links to the presentations that Bryn Llewellyn gave to the Swedish Oracle Users Group in a full-day seminar on EBR. There are 8 videos ranging from about 40 to 60 minutes each, and the last link is for the full playlist.
#OrclDB #JonathanLewis
In-row LOBs
https://buff.ly/36Fe1wG
#OrclDB #JonathanLewis What’s the best way to delete millions of rows from a table?
https://buff.ly/3j22ADu
#JonathanLewis #OrclDB
Drop Column Bug
https://buff.ly/37hgdbv
#JonathanLewis #OrclDB #Performance
Wait for Java
https://buff.ly/2S4QBtK
#OrclDB #JonathanLewis
Table Space -- a report that shows the total space allocation for a table – including its indexes and LOB columns. (Very cool script, read the comments too).
https://buff.ly/2rsW6XZ
#OrclDB #JonathanLewis Nologging
https://buff.ly/2NZtFKn
#OrclDB #JonathanLewis SQL Patch
https://buff.ly/2ZpU7TE
#OrclDB #JonathanLewis LOB Reads
https://buff.ly/2yst8rs
#OrclDB #JonathanLewis DB Links
https://buff.ly/2LBBhl9
#OrclDB #JonathanLewis ANSI Bug
https://buff.ly/2ID0dXF
#OrclDB Trouble-shooting #jonathanlewis
https://buff.ly/2Zs2jiu
#orcldb Scalar Subquery Costing
#jonathanlewis
https://buff.ly/2EXnrFr
#orcldb Re-partitioning – 18
#jonathanlewis #db18c
https://buff.ly/30MmQjj
#orcldb Re-partitioning #jonathanlewis
https://buff.ly/30EmevT
#orcldb In-table predicates #jonathanlewis
https://buff.ly/2KHjbzo