-
The CEIL function, dates and floating point numbers
Oh yes indeed, I have dug deep into the well of cheesy blog post titles for this one . But hey, I have two teenage children so I figure that I have reached the age where you’ll need to permit me my share of terrible Dad-joke style puns. Consider the two dates below (both of Read more
-
Docs hack to save you time!
The tech world is a big and varied place, so whilst there are some database customers running on 19c and have applied the latest RUs etc to get them to (at of time of writing) 19.8, there are plenty of customers running on 18c, plenty running on 12.2, plenty on 12.1 and so forth all Read more
-
DBMS_JOB and 19c – code changes needed
Sep 2021: Important update at tail of this post Here’s a “gotcha” brought to my attention by one of our AskTOM readers. I’ve mentioned in the past that DBMS_JOB, having been deprecated in favour of DBMS_SCHEDULER, got a new lease of life in 19c because under the covers we translated calls to create a job Read more
-
Frequency histogram – where did that estimate come from?
Frequency histograms in any version of Oracle are pretty cool things, so whenever you have a distribution of data that potentially skewed and the number of distinct values fall under the limit of how many histogram buckets you can have, then a frequency histogram is pretty much a no-brainer. In particular, if you don’t have Read more
-
How to control resource usage on Autonomous
When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on whether you are using a transaction processing (ATP) or a data warehouse instance (ADW) of the database, but for example, for an ATP database you get the following: Note: This is a screen of the Read more
-
How to make queries to DBA_FREE_SPACE faster
The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk” message, I was motivated to see if I could clear down some of the space utilization on the myriad of databases on my machine. On the majority them I encountered no issue doing that, but Read more
-
How to do a GRANT on an entire schema
TL;DR: There is no schema grant command in Oracle, but this routine lets you get close. Update 2024: You’ll be pleased to know that this shortcoming is now addressed in Oracle Database 23ai! See my post for more details. Why no schema level grant? A very common request on the various forums that exist for Read more
-
How to upgrade to Oracle 19.8 on Windows
As always, you should follow the instructions in the README.html that comes with the Release Update, but because I know many people like to see what the experience of others is like, here’s my run of the patch application. As always don’t forget to run your CMD prompt as Administrator, otherwise OPatch will typically have Read more
-
Developer Live wrap up
The Developer Live event for database has concluded. Thank you to the (almost) 2000 people that attended my talk across the USA, Europe and APAC timezones! I very much appreciate you giving up your time to attend the session. Whilst we were doing some Q&A I tried to add as many useful links into the Read more
-
Faster DISTINCT operations in 19c
If I gave you a telephone book and asked you to tell me how many distinct street names are present in the book, then the most likely thing you would do is …Wave your mobile phone at me and ask what a “telephone book” is . But assuming you’re old enough to remember telephone books, Read more
-
How to stop your site from being Clickjacked!
In the language of the millennials I should start this post with “TIL”, but for the rest of us out there that are “not so down with the cool kids” the expression is “Today I learned”. Anyway…today I learned about a security risk called ClickJacking. You can read the full history and details of it Read more
-
How to change Scheduler maintenance windows
There are a few possible reasons why you might be one of those people why you might be using your database late in the evening. These include you support a 24 by 7 system and so you often need to be online late at night, you are a hopeless geek and love tinkering with the Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 