Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Shell Script executing Oracle PL/SQL code

I'm calling a Oracle PL/SQL code from shell script which takes time to finish, but after completion of PL/SQL code the shell script session is not terminated and also still shows as active when is type ps … -aef|grep 'SQL*PLUS'. Any suggestion why the shell script session is not terminated. Note : PL/SQL code has no issue and ran successfully. I have used cron job to run the shell script. The shell script is terminated when Data is less to process.

2 answers

In PL/SQL, I'd do it the other way round:

  1. Count number of connections that match your query
  2. If result > 400 send email
  3. Else generate the disconnection statements, probably with ALTER SYSTEM DISCONNECT SESSION...

I don't know your requirement of course, but could it be solved with resource profiles to limit user connections?


Encoding complier

0 votes

I'm afraid we are an Atlassian community, not an Oracle one. 

Some of us might be able to help, but I don't want you to be left hanging here - there's little chance this community will respond.  You may want to ask the question in an Oracle forum, rather than an Atlassian one.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Bitbucket

Git push size limits are coming to Bitbucket Cloud starting April 4th, 2022

Beginning on April 4th, we will be implementing push limits. This means that your push cannot be completed if it is over 3.5 GB. If you do attempt to complete a push that is over 3.5 GB, it will fail...

2,263 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you