In this post I’ll continue talking about writing bash scripts for database stuff. I’ll devote this entire part to sqlplus, as there is a lot to say here.
In this post I’ll continue talking about writing bash scripts for database stuff. I’ll devote this entire part to sqlplus, as there is a lot to say here.
Many Oracle databases are running on Linux/UNIX systems, and many DBAs need to write all kind of scripts. Over the years I’ve written probably tens of thousands of script lines
Being in North America (the English speaking side), made me understand that many people are not aware (and don’t actually care) about character sets too much. Everything supports English, and
Oracle database is a very complex software, and as we all know, has bugs. Oracle tries to address these bugs, and fixes a lot of them all the time. Except
Many of my clients use storage backup (snapshots, etc.) to backup their databases. The right and supported way to do that is like any hot backup: place the database in
In the last post about tablespaces (tablespaces free space) I talked about used and free space in permanent and temporary tablespaces. I also included a script to see all the
Over the years I got many questions about free space in tablespaces and other issues related to allocating and de-allocating of space, fragmentation and more. So I decided to write
This is very common on the web, but I will still want to have it here as well.Sometimes hidden parameters are interesting, and we would like to see them and
As of Nov 2015, Oracle decided to change the naming method for PSU (Patch Set Update).
My previous post about bypassing the listener was a big success. It actually broke my daily record (the previous one was the Oracle Challenge). Anyway, because of this success, I’ve