jloracle.bsky.social
Nearly-retired Oracle performance specialist. 50 years using computers, 40 years self-employed, 35 years as a freelance Oracle specialist.
125 posts
210 followers
45 following
Regular Contributor
Active Commenter
comment in response to
post
Within limits!
jonathanlewis.wordpress.com/2016/02/26/p...
comment in response to
post
Many people consider Darjeeling to be the best.
comment in response to
post
Thinking about the problems is good for you. Thinking about the tea is, of course, much better than thinking about the meetings you have to go to.
comment in response to
post
Abstract posted for #poug2025, and uploaded to my "Public Appearances" page.
Predictions, Plans and Problems.
jonathanlewis.wordpress.com/public-appea...
comment in response to
post
whe -> "why" not "when" if you're trying to decide which it should be without reading the blog.
comment in response to
post
The joy of writing blog notes - from time to time someone attaches a comment that will add real value for your readers (and yourself, of course). In this case Mikhail Velikikh:
mvelikikh.github.io/blog/
comment in response to
post
And there are entertaining differences between space management after CTAS compared to simple inserts into an empty table:
Some (lazy) SQL, and results from calls to the dbms_space package after inserting one row:
comment in response to
post
There are so many funny things that can go on around the edges with TRUNCATE - especially when the tablespace is defined with the autoallocate option for extents and you do things with large objects.
How to reduce a truncate from 6 minutes to 2 seconds:
jonathanlewis.wordpress.com/2014/09/08/a...
comment in response to
post
Can't help feeling that this is a bit of a cue to pointing to another Golden (very-)Oldie about SQL*Net compression - and a (3 years late) follow-up about roundtrips and what they're really counting:
jonathanlewis.wordpress.com/2010/05/07/s...
comment in response to
post
Does that mean it will be in a superposition of being released and not released at the same time?
comment in response to
post
3/2
Checking the Feedback area of the Developer Forum, it's possible this is a side effect of a filter that requires a post to go through moderation. The obvious guess is that it's about posting URLs, except I posted the same URL 17 minutes later and it passed immediately
(The 1st post now visible)
comment in response to
post
2/2
Today I followed up immediately with a second post, which appeared immediately even though the first post is still not available (to me).
comment in response to
post
I've had a brilliant idea for solving the USA's problem of illegal Mexican immigrants. Draw a line from (roughly) Los Angeles to Houston and give everything south of the line to the United Mexican States. I'm sure King Charles and Xi Jinping would be prepared to handle the negotiations.
comment in response to
post
Greater than the "Lesser spotted woodpecker" which comes in a matching pattern but smaller package.
www.rspb.org.uk/birds-and-wi...
comment in response to
post
Thanks for the comment. I've deleted the remains of your comment and echoed (and linked) your tweet into the note.
comment in response to
post
... the beers may have been the same, but the glasses were different shapes.
comment in response to
post
This looks interesting. Could eliminate a lot of work done by "stateless" systems. Looks like there's plenty to read at docs.oracle.com/en/database/...
And it works with RAC! I remember terrible struggles getting applications to take advantage of XA properly.
comment in response to
post
The last time I heard about infinities appearing it was some client code used OCI calls that promised to supply valid values using the Oracle internal format (and got it wrong)
OTOH, Martin Berger @martinberx.bsky.social recently found a CBO trace reporting an IEEE 754 64-bit infinity as 1e308
comment in response to
post
Everyone should read about Hilbert's Hotel. (e.g. en.wikipedia.org/wiki/Hilbert... )
comment in response to
post
Finished after just 90 more minutes up (and down, and up, and ...) a ladder. Even had time to do some (restorative) pruning on a climbing rose; nearly got away unscathed, just one minor scalp wound.
("Restorative pruning" = code phrase for "cutting out some really big bits".)
comment in response to
post
There —> their
comment in response to
post
There used to be several dozen Blockbuster stores in the UK, with their HQ in the Uxbridge (towards the North-West of London)
comment in response to
post
I never owned a walkman so 1 point.
I think I probably have to admit listening to a boom box - although it was more of a whimper box than a boom box.