New answers tagged

4 votes
Accepted

How to terminate user's sessions in Oracle DB exactly 8 hours after user connected?

CREATE PROFILE To specify resource limits for a user, you must: Enable resource limits dynamically with the ALTER SYSTEM statement or with the initialization parameter RESOURCE_LIMIT. This parameter ...
user avatar
  • 38.1k
-1 votes

How do I execute a PL/SQL package from my database SQL> prompt?

It is a function so you have to use SELECT C_FIX_STUCK_COS.FIX_STUCK_COS() FROM DUAL
user avatar

Top 50 recent answers are included