:

RSSSQL Plus

SQLPlus Hangs

We were seeing an intermittent problem very recently whereby the listener would not accept connections for all DBs that it was listening for. A restart of the listener would resolve the issue, but within 5 minutes of the restart it would be stop accepting connections again. We had no idea what was causing the issue, […]

Continue Reading

Execute a script in SQLPlus

Execute a script in SQLPlus

To put it simply, you execute SQL from the command line using the @ command, for example: SQL> @script01.sql However, there are other areas which need to be considered so let’s take a look at them: Does your script call other scripts from within it, like a harness file? Have you copied the contents of […]

Continue Reading

SP2-0618 Cannot find the Session Identifier. Check PLUSTRACE role is enabled

SP2-0618: Cannot find the Session Identifier. Check  PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report This error was produced when logging in as a specific user  from a certain SQLPlus client version. To give you an example, when logging in  as USERA with a 9.2.0.1.0 client, the above error was produced. If I logged […]

Continue Reading

Spool on in SQL Plus

Spool on in SQL Plus

Why? When you run a query which could potentially generate a large number of results, or just if you want a record/file of the results, you can use the SPOOL command. Spooling results from a SQL query to a file is very simple, and you can even append to an existing file in Oracle 10g […]

Continue Reading