Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sessions automatically cancelled after inactivity?
Yes, but not in init.ora.
You have to create a new profile or change de default profile on "idle time" parameter (minutes).
To create a new profile:
CREATE PROFILE <profile name> LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT CONNECT_TIME UNLIMITED IDLE_TIME <nš of minutes> SESSIONS_PER_USER DEFAULT LOGICAL_READS_PER_SESSION DEFAULT LOGICAL_READS_PER_CALL DEFAULT PRIVATE_SGA DEFAULT COMPOSITE_LIMIT DEFAULT; To assign the new profile to users:
ALTER USER <user name> PROFILE <profile name>;
oracow_at_my-deja.com wrote in message <7vuv25$qvu$1_at_nnrp1.deja.com>...
>Hello,
>
>Is there an option within Oracle to have sessions automatically
>cancelled after a certain amount of inactivity/idle time? (i.e. an
>init.ora parameter?).
>
>Thanks,
>
>Dave
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 05 1999 - 12:04:51 CST