Re: Unix TZ

Time zone is set during database creation - so it's gotta be stored somewhere inside the data dictionary. question would be: if it's not set explicity during database creation, and oracle uses the os value, if that os value gets altered between instance startup and shutdown, wether or not oracle will use the new value, or stick to the one that was set when creating the database.

check database_properties for the current value

Stefan

On 10/25/06, Ethan Post <post.ethan_at_gmail.com> wrote:
>
> What is the simplest way to determine what the unix TZ is set to for a
> particular instance from within the instance? What I am going to have is a
> instance running with TZ set to pacific time on a server with other
> instances running central time. I want to prevent the instance from opening
> if TZ is not set correctly. Trying to avoid calling out to the OS if I can,
> any internal tables which would store this?
>

--
http://www.freelists.org/webpage/oracle-l