DBA
-
Tuning a packaged solution using OCI-drivers
Read more: Tuning a packaged solution using OCI-driversWe’ve all been there. You have an application bought from some vendor that has less than adequate knowledge about the Oracle Database. The solution underperforms even though the SQL itself looks OK. You dig into it and it turns out the solution retrieves a lot of data but each fetch gets too few rows from…
-
EZ Connect Plus
Read more: EZ Connect PlusSometimes new things that are really useful show up in new versions and you can miss it if you’r not paying close attention. EZ Connect Plus is one such feature for me. You may think it is not new and that it has been there for a long time. You’d be correct EZ Connect is…
-
Enable Enterprise Manager Express
Read more: Enable Enterprise Manager ExpressThere are many blogs about the product and so on. I want to recommend that you enable and give your developers access to it. Setting them up and getting them to scale the mountain of complexity that is the normal Enterprise Manager is probably not what you want to do. However, EM Express is a…
-
Add hint to SQL you cannot modify
Read more: Add hint to SQL you cannot modifyThe last post showed how to lock the plan for a SQL that switched plan every now and then. Another common issue one can encounter is that of a SQL that uses a suboptimal plan and for which you’d want it to use a different plan. The way to instruct the optimiser to use a…
-
Lock the plan for a SQL
Read more: Lock the plan for a SQLA SQL that sometimes just uses a plan you prefer it to not use is fairly common. There are always reasons for unstable plans, but more important than knowing the reason is often to make it stick to a certain plan. This has historically been done with a lots of ways from changing the SQL,…
-
Grabbing an AWR without access to the database server
Read more: Grabbing an AWR without access to the database serverGetting an AWR can sometimes be difficult. If you are on an autonomous database you cannot log in to the database server and run your trusty old script for it. Other times you may not have the access and cannot get the DBA to find time to help you with it every time you want…
-
Dumb Oracle refuses to use my great index
Read more: Dumb Oracle refuses to use my great indexLet me tell you a story about a developer, let’s call her Sue, that had proved that Oracle was having mood swings and just didn’t use a perfectly good index even though it was the perfect index to use. This of course made Sue very upset and she spared nobody from her bitter words about…
-
Update on creating wallet
Read more: Update on creating walletI held a live stream for SWEOUG that presented what my last two blogs covered. It was my first ever and while it was a bit uncomfortable to set up to not see your audience it worked well. In fact it was really enjoyable and I look forward to doing more. In the stream Ilmar Kerm made…
-
Wallet setup for https
Read more: Wallet setup for httpsIn the last blog post I wrote about how to access an HTTP-resource and the ACL needed for it. That works great for HTTP, but as the world is turning to HTTPS it is not enough in most cases. In this post I will look at how to set up the trust store in a…
-
Waiting for direct write temp – but what file?
Read more: Waiting for direct write temp – but what file?This is essentially a not for myself for the next time I forget. It seems to be like once every other year I figure this out. It is not too easy to google for so it usually takes a bit too long. So you have identified the event “direct path read temp” or “Direct path…
Subscribe
Sign up with your email address to receive our weekly news
Latest news
- 23ai 4000+ columns
- 23ai Lock-free reservations
- Troubleshooting conversion errors
- 23ai Syntactic sugar – IF [NOT] EXIST
- 23ai Select without FROM
Categories
- Alert Log (4)
- APEX (25)
- AQ (1)
- Article (1)
- Back To Basics (2)
- Blogging (10)
- Books (1)
- Bug (4)
- Business (1)
- Challenge (2)
- Commit (2)
- Database (16)
- DBA (24)
- Docker (4)
- EXA (1)
- Humor (1)
- I/O (2)
- ITL (1)
- JoelKallmanDay (1)
- Licensing (3)
- Machine Learning (1)
- MultiTenant (2)
- New Stuff (2)
- OOW (12)
- Oracle (36)
- Oracle Cloud (7)
- Oracle DB 23ai (3)
- Oracle Developer Tools (3)
- ORDS (10)
- OTN (1)
- Partitioning (6)
- Performance (19)
- Perl (1)
- PL/SQL (7)
- Presenting (2)
- Property Graph (1)
- Python (2)
- RSS (2)
- Security (3)
- SQL (34)
- SQL Developer (3)
- SQLcl (5)
- ThanksODC (1)
- Uncategorized (6)
- Undo (1)
- Versioning (1)
- Virtualization (2)
- Visual Code (4)
- Wallet (3)
- XML (4)