Oracle – Running sqlplus From UNIX bash Scripts

Today we’re going to see how to connect and run queries on a database from a UNIX bash script.

Shrink Oracle Tables Online

Oracle 10g Supply a new alter table option that enables online table reorganization, this option is shrink

Paging Oracle Query Result

Programmers often retrieve big result set using queries and need to split them up in order to display the result correctly. This tip shows you how to split oracle query result sets into pages.

Oracle Temporary Tablespace Free Space

The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Once a session needs to perform a large sort operation

Oracle Temporary Tablespace Usage

The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Users use the same temporary segments in the temporary tablespace to perform the sort operation, joins, etc. How can we tell which users use the temporary tablespace and how much space they use?

Connect as an Oracle User Without Knowing the Password

In some cases we have to connect to the database as a specific user, but don’t know the password.

There are two ways to handle this problem:

Oracle Datafile High Watermark

Datafiles in Oracle can be resized to a smaller size only if there are no used blocks at the end of the file. If there is a used block at the end of the file we will not be able to reduce it size even if the rest of the file is empty

Oracle Database Hidden Parameters

Always wanted to see all Oracle parameters? Including the hidden ones?

Oracle – Monitoring Long Operations

There are several specific operations that are considered as long operations.
When performing one of these operations, we can follow the progress of the operation

Oracle RMAN backup script

Need an RMAN backup script?