This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.
This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.
This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.
Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory.
mkdir tpt cd tpt wget -r -nH --cut-dirs=2 --no-parent --reject="index.html*" http://blog.tanelpoder.com/files/scripts/ cd .. [svn/git] add tpt [svn/git] commit tpt -m "added Tanel Poder's script library to our script repository"
Please remember that as Tanel says on his own website, “always proofread the scripts and test their effect out in a test environment before running in production.”
Tanel does offer a zip file with all of his scripts. The zip seems up-to-date now; I started doing this alternative technique awhile ago when the zip file didn’t seem to get updated as quickly as the raw scripts directory.
mkdir tpt cd tpt wget -r -nH --cut-dirs=2 --no-parent --reject="index.html*" http://blog.tanelpoder.com/files/scripts/ cd .. [svn/git] add tpt [svn/git] commit tpt -m "added Tanel Poder's script library to our script repository"
Please remember that as Tanel says on his own website, “always proofread the scripts and test their effect out in a test environment before running in production.”
Just filing this away on my own blog because it seems that I always have hard finding it via google. Here’s some code to convert raw/hex values into timestamps. (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low values in column statistics.)
As a query, without creating any objects in the database:
Just filing this away on my own blog because it seems that I always have hard finding it via google. Here’s some code to convert raw/hex values into timestamps. (I’ve come across this need in two situations: [1] bind variables recorded in trace files or sql monitor and [2] hi/low values in column statistics.)
As a query, without creating any objects in the database:
This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system. (Specifically, a RAC/thread aware script.)
There are a few scripts published:
This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system. (Specifically, a RAC/thread aware script.)
There are a few scripts published:
This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.
Recent comments
1 year 3 weeks ago
1 year 15 weeks ago
1 year 19 weeks ago
1 year 20 weeks ago
1 year 25 weeks ago
1 year 46 weeks ago
2 years 14 weeks ago
2 years 44 weeks ago
3 years 28 weeks ago
3 years 29 weeks ago