Re: Hidden Oracle NT Environment variables

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Thu, 28 Jan 1999 13:37:42 -0800
Message-ID: <36B0D8A6.3AEF16BC@us.oracle.com>

Don

Standard Oracle variables, regardless of platform. One (%s) is the log sequence number (archive log list will show you what this is currently), the other (%t) is the thread number (useless if not running OPS). From memory, %s gives you just the number, while %S gives you the sequence number left padded to 6 or 8 numbers with zeroes. If not, it's the other way round!

HTH Pete

Don Hall wrote:

> In the v$parameter view, the name of the redo log file is defined as
> log_archive_format %%ORACLE_SID%%%S.%T .
> Oracle_sid is obvious, and can be found in the registry, but what are
> %S% and %T% supposed to represent, and where are they defined? They
> appear to be a unique sequence number and the redo thread. Anyways, my
> curiosity is getting the best of me.

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Jan 28 1999 - 15:37:42 CST