Oracle Category

All UxOra articles related to Oracle database 11g/12c and SQL/PLSQL will be published under this category.

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

When DBMS_STATS.GATHER_TABLE_STATS collects statistics on a partitioned table, generally it does so at the partition and table (global) level (the default behavior can be modified by changing the GRANULARITY parameter). This is done in two steps:

  • First, partition level stats are gathered by scanning the partition(s) that have stale or empty stats,
  • Then a full table scan is executed to gather the global statistics.

As more partitions are added to a given table, the longer the execution time for GATHER_TABLE_STATS, due to the full table scan requited for global stats.

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

The process of turning redo log files into archived redo log files is called archiving. It is only possible if the database is running in ARCHIVELOG mode. Here are some advantages to be in ARCHIVELOG mode:

  • Recover a database
  • Update a standby database
  • Perform a hot backup

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

In developpement, it can happen that you may want to shrink oracle datafiles after a huge delete (ie. drop user, drop big table, ...).

Here is a simple way to shrink datafiles using RESIZE option, but it may not be the most efficient.

User Rating: 1 / 5

Star ActiveStar InactiveStar InactiveStar InactiveStar Inactive

The temporary tablespace can reach a huge size, sometimes because of a big batch operation.

You may want to reduce it to save some disk space. If so, this article will present you some ways to do it.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Sometimes it may happen that you will not be able to drop an Oracle user. It happens when there are still opened sessions on it.

This article will show you how to kill all theses sessions in order to drop this user.