Home » RDBMS Server » Server Administration » a few questions
a few questions [message #60871] Thu, 11 March 2004 08:06 Go to next message
falcon91
Messages: 2
Registered: March 2004
Junior Member
i have a few questions, and it is probably best to ask in one message than separate ones; so here goes.

NOTE: some of this is for a sanity check

1. Timeout parameters

there are client and server side parameters relevant to connections.
server side  --[>] listener.ora, connect_timeout_<listener name>
**NOTE: default 10 seconds


server side  --[>] sqlnet.ora, sqlnet.expire_time
**NOTE: default 0 minutes (forever?)

2. Log
Logs are not generated by default

my question is even if you set:
log_directory_client
log_file_client
it means nothing unless the application is coded to generate log events?

main question, is this accurate?
Re: a few questions [message #60875 is a reply to message #60871] Thu, 11 March 2004 11:20 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
sqlnet.expire_time 's default value is None ,which means Dead connection detection is disabled.

You are talking about client side Net8(sqlnet) log ?

By default they are generated in the directory from where the program started(current working directory) , with a name of sqlnet.log.
Re: a few questions [message #60897 is a reply to message #60875] Fri, 12 March 2004 04:46 Go to previous message
falcon91
Messages: 2
Registered: March 2004
Junior Member
yes, i mean client side Net8 log.

If these parameters are set and the defaults overridden, will logs be generated? or is the generation of logs also dependant on the application?

I made a couple attempts of setting the params and running my app AND also sqlplus. I didn't generate any logs.

I wanted some confirmation on what log generation requires.
Previous Topic: how to get the script created tablespace
Next Topic: Creating Users ?
Goto Forum:
  


Current Time: Tue Jan 07 22:53:54 CST 2025