05-10-2007
Have you closed the DB connection immediately when you are done with the database or statement handles etc.? If you are running a resource-intensive script, you should make sure you deallocate things as quickly as you can to avoid holding something for too long. You should not rely on the automatic reference-count garbage collection in this case as it is possible that deallocation may not occur soon enough.
If you are having a variable with very large content, you should consider manually unset() the variables immediately when you are done with it. It may not be related to your case but just try.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Friends,
Is it possible to exit nicely(ie, to echo a message with the error occurred) from a shell script(quiet a big one :)) once it encounter an error in between the lines?
For example, in my script I am calling the command mkdir and sometimes (when the directory already exists) it... (4 Replies)
Discussion started by: Sreejith_VK
4 Replies
2. Shell Programming and Scripting
there are many script in my project.i am having a problem when i am trying to quit from child script.what is the command to wrap up all the parent script and calling script as well? exit 0 is not working.please help.... (1 Reply)
Discussion started by: arghya_owen
1 Replies
3. Shell Programming and Scripting
I have a script abc.sh. Its contents are as follows: (7 Replies)
Discussion started by: lassimanji
7 Replies
4. Shell Programming and Scripting
I have a script which has the following statement,
/opt/oracle/product/9i/bin/sqlplus << EOC >> $LOG_FILE 2>&1
username/password ---- Enters the SQL prompt
@/export/home/oracle/shells/grant_userview.sql ---Runs the SQL script
@/export/home/oracle/shells/grant_proc_userview.sql ---Runs the... (6 Replies)
Discussion started by: welldone
6 Replies
5. Shell Programming and Scripting
Hi,
I am trying to exit the script from a function.
I was in assumption that if we use exit ( inside or outside the function) it will exit from the script.
alternatively, return will exit from that particular function.
but in my case, exit is exiting from the function and not the script.... (8 Replies)
Discussion started by: shellwell
8 Replies
6. Shell Programming and Scripting
I have a script planned for the Helpdesk to allow them to (on a couple of RHEL 3 / RHEL 5 servers) reset passwords, stop / start printers, and clear print queues. The appropriate sudo permissions were given to their accounts, and the individual functions all work just fine. The ability to move... (0 Replies)
Discussion started by: tearsong
0 Replies
7. Shell Programming and Scripting
I have to write a script in ksh which again should call another script. Say A.ksh is calling B.ksh. Now in B.ksh if the condition we are checking for is true then we have to go back to the main script A.ksh or if the condition in B.ksh is false then we have to totally come out of the scripts.
I... (1 Reply)
Discussion started by: vpv0002
1 Replies
8. Shell Programming and Scripting
Hi Team,
Need your help for the below code snippet. I wrote a module to read the file names remote server using file name convention.
Issue : My script is coming out from while loop without reading complete file.
test1()
{
while read line
do
echo $line
file_nm_convention=`echo... (3 Replies)
Discussion started by: gvkumar25
3 Replies
9. SCO
Hi,
I am using SCO Unix. I write a script to execute a program by calling
exec program
The script will check the program is still there or not, if not, then it will exit the script by calling
exit
So if I press DEL to quit the program, the script will exit, but it will logout... (6 Replies)
Discussion started by: dannychan
6 Replies
10. Shell Programming and Scripting
function2()
{
cmd1
cmd2
cmd3
....
cmdn
}
function2()
{
cmd11
cmd12
cmd13
....
....
}
for i in {1,2} (7 Replies)
Discussion started by: yanglei_fage
7 Replies
LEARN ABOUT OSX
deallocate
deallocate(1) deallocate(1)
NAME
deallocate - device deallocation
SYNOPSIS
deallocate [-s] device
deallocate [-s] [-F] device
deallocate [-s] -I
The deallocate utility deallocates a device allocated to the evoking user. device can be a device defined in device_allocate(4) or one of
the device special files associated with the device. It resets the ownership and the permission on all device special files associated with
device, disabling the user's access to that device. This option can be used by an authorized user to remove access to the device by another
user. The required authorization is solaris.device.allocate.
When deallocation or forced deallocation is performed, the appropriate device cleaning program is executed, based on the contents of
device_allocate(4). These cleaning programs are normally stored in /etc/security/lib.
The following options are supported:
device Deallocate the device associated with the device special file specified by device.
-s Silent. Suppresses any diagnostic output.
-F device Forces deallocation of the device associated with the file specified by device. Only a user with the solaris.device.revoke
authorization is permitted to use this option.
-I Forces deallocation of all allocatable devices. Only a user with the solaris.device.revoke authorization is permitted to
use this option. This option should only be used at system initialization.
The following exit values are returned:
non--zero An error occurred.
/etc/security/device_allocate
/etc/security/device_maps
/etc/security/dev/*
/etc/security/lib/*
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
allocate(1), list_devices(1), bsmconv(1M), dminfo(1M), mkdevalloc(1M), mkdevmaps(1M), device_allocate(4), device_maps(4), attributes(5)
The functionality described in this man page is available only if the Basic Security Module (BSM) has been enabled. See bsmconv(1M) for
more information.
/etc/security/dev, mkdevalloc(1M), and mkdevmaps(1M) might not be supported in a future release of the Solaris Operating Environment.
28 Mar 2005 deallocate(1)