OraFAQ Forum: Server Administration » IDLE_TIME & CONNECT

Home » RDBMS Server » Server Administration » IDLE_TIME & CONNECT_TIME in seconds

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IDLE_TIME & CONNECT_TIME in seconds [message #315664]

Tue, 22 April 2008 06:14

ORA-MAN
Messages: 24
Registered: January 2008
Location: ===

Junior Member

Hi all,

I am trying to create a profile and set idle_time & connect_time in seconds 20sec (20/86400) but I got error:

1 CREATE PROFILE test_profile LIMIT
2 IDLE_TIME 20/86400
3* connect_time 20/86400
IDLE_TIME 20/86400
*
ERROR at line 2:
ORA-02376: invalid or redundant resource

Is allowed to spcify seconds?

thanks

Report message to a moderator

Re: IDLE_TIME & CONNECT_TIME in seconds [message #315670 is a reply to message #315664]

Tue, 22 April 2008 06:26

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Idle time and connect time are in minutes and must be integers.

Next time, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Regards
Michel

[Updated on: Tue, 22 April 2008 06:26]

Report message to a moderator

Re: IDLE_TIME & CONNECT_TIME in seconds [message #315678 is a reply to message #315664]

Tue, 22 April 2008 06:42

ORA-MAN
Messages: 24
Registered: January 2008
Location: ===

Junior Member

thanks a lot.

alright its OK.

Report message to a moderator

Previous Topic:	recover deleted records
Next Topic:	ora-01008 not all variables bound

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 16:52:02 CDT 2024