In the absence of time to write new interesting articles, I update the Script in with a small simple and very useful script. what it does is: getting the totlat DB size, including datafiles, temp … [Read more...] about Total Database Size
Here is a script that tries to analyze all the indexes (except sys and system or more accurate SYS%). This works very well in most situations, where can however be som issues with the ddl lock … [Read more...] about Analyze all Indexes in the DB
First this link is very well written source of information on PCTFree and chained/migrated rows http://blog.tanelpoder.com/2009/11/04/detect-chained-and-migrated-rows-in-oracle/ This one of my … [Read more...] about PCTfree Advice
I'm wrapping up a few scripts for an upcoming performance investigation at a customers. And find the SQL queries is(can be at least) a Key part of finding DB performance issues. These are all … [Read more...] about Find TOP SQL Statements
This script is NOT done by me it is done by Daniel Westermann but it is an amazing piece of code. I have some scripts like these myself, but they all looks like crap compared to this one. … [Read more...] about Create a complete Oracle 12c Database from script.
Going through my old Jtree notes from the beginning of time and found some nice scripts I used to run to do some basic DBA work. I guess most of the benefits with these scripts has bin depleted since … [Read more...] about DB Management Basic Scripts