Home » RDBMS Server » Server Administration » IDLE_TIME & CONNECT_TIME in seconds
IDLE_TIME & CONNECT_TIME in seconds [message #315664] Tue, 22 April 2008 06:14 Go to next message
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


Re: IDLE_TIME & CONNECT_TIME in seconds [message #315670 is a reply to message #315664] Tue, 22 April 2008 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 Go to previous message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
thanks a lot.

alright its OK.
Previous Topic: recover deleted records
Next Topic: ora-01008 not all variables bound
Goto Forum:
  


Current Time: Sat Dec 03 11:51:51 CST 2016

Total time taken to generate the page: 0.22170 seconds