Entries Tagged 'Database' ↓

Please Note this post is for archival purposes. I don’t know if Oracle after 8.x needs this. Hopefully it will still be of use to someone.

---

So your programmer decided to create a query that had a little syntax error. Say, a typo and it became an endless loop. Now your temporary tablespace is hosed because it is bigger than 2 gigs.Note that this is really only a solution for temp files because they don’t have any data that needs saving.Here is how to fix it:

By Jon Griffin

Please Note this post is for archival purposes. I don’t know if Oracle after 8.x needs this. Hopefully it will still be of use to someone.

• Your temporary tablespace is hosed - Salvaging your programmers big syntax error.
• analyze - Using analyze to speed up Oracle.

Some useful queries

The below query shows all tables that have more than one index with the same leading column. These indexes can cause queries to use an inappropriate indexes; in other words, Oracle will use the index that was created most recently if two indexes are of equal ranking. This can cause different indexes to be used from one environment to the next (e.g., from DEV to TEST to PROD).

By Jon Griffin

Please Note this post is for archival purposes. I don’t know if Oracle after 8.x needs this. Hopefully it will still be of use to someone.

Oracle works much better if analyze is run on a periodic basis.

• Scripts for analyze cron job (.gz file)

Some people have requested the that I put the scripts here so they don’t have to download the tarball.