06-24-2018
the V$LOCK database shows deadlocks. Most oracle "hangs" are caused by another, usually interactive process, that has a previous lock on a row. Your code performs DDL which does implicit locking (update, insert, etc.), so it is susceptible. Have your DBA clobber the offending process.
Example: We had lots of users who left for lunch in the middle of an update/insert Oracle form. Since we could not rewrite hundreds of forms to be better about transactions and locking, the DBA intervened and killed off the offending user process when a batch job got hung.
Consider DBA help.
Also oracle code example of a deadlock workaround:
Programming applications to handle deadlocks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Right now I have implemented autossh between ServerA & ServerB which are sun solaris based. I have made this shell script. I am facing one problem which I am going to discuss now.
The problem is when I sftp some files (suppose there is 10 files I have to transfer through sftp) from one server
to... (2 Replies)
Discussion started by: girish.batra
2 Replies
2. Shell Programming and Scripting
How can I trap a character press in the shell script.
For eg:- I have a script runinng a infinite loops , I will need to quit if q is pressed.
I have seen the traping the signal , but they give option only for traping the defined interrupt signals. But those does not help me here. (3 Replies)
Discussion started by: praveenbvarrier
3 Replies
3. Shell Programming and Scripting
Hi folks,
I have tried to add some trap detection in the below script....this script is used to monitor database activities...in a rather awkward way :rolleyes:....
The idea behind adding trap is that....this script creates lots of temporary files in the running folder to store the count... (1 Reply)
Discussion started by: frozensmilz
1 Replies
4. UNIX for Advanced & Expert Users
how to trap the ctrl c in unix shell script
my script is running in while loop it should not be terminate with ctrl c.
if i press ctrl c while running script it shloud ignore the same.
please healp..........
thanks in advance (2 Replies)
Discussion started by: arvindng
2 Replies
5. Shell Programming and Scripting
Hi All,
i have an issue regarding trap command.
i have specified trap function in the beginning of the script to catch some signals but in the later part of the script i want to remove the effect of this.
Can anybody help me out of this.
for e.g. pressing Ctrl+C for the first time should... (2 Replies)
Discussion started by: vikas_kesarwani
2 Replies
6. Shell Programming and Scripting
Hi ,
i have a scenario where...i have to put a check where if script is executing more than 15mins i have to kill that script and n retry again 2nd time.
i this case i can use background process to do it but i feel trap will be the efficent way to do so...
but i dont know much about it... (1 Reply)
Discussion started by: crackthehit007
1 Replies
7. Shell Programming and Scripting
Hello,
I am trying to identify names which are "illegal" in the sense that they do not comply with the spelling norms of a culture. I have written NGrams for initial and final combos which are illegal. These are lists stored in 2 files named Initial and Final. Here are few... (2 Replies)
Discussion started by: gimley
2 Replies
8. Shell Programming and Scripting
My employers would like me to selectively run one of several different (already-existing) Korn Shell menu-driven scripts out of the user's .profile file, depending on some yet-to-be-specified user critieria.
I've never done this kind of thing, but I have the existing scripts (among other... (5 Replies)
Discussion started by: Clovis_Sangrail
5 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
That is the last reply I received from my instructor, and I'm looking for some alternatives.
When using... (2 Replies)
Discussion started by: newuser45
2 Replies
10. Shell Programming and Scripting
sqlplus -s usrname/password@dbSID <<-SQL >> logfile
@create_table.sql
commit;
quit;
SQL
I am running this script to execute an sql file.
I want to display the oracle error if anything found during execution of the sql file and exit from script.
Please suggest How do it. (1 Reply)
Discussion started by: millan
1 Replies
LEARN ABOUT PHP
dba_handlers
DBA_HANDLERS(3) 1 DBA_HANDLERS(3)
dba_handlers - List all the handlers available
SYNOPSIS
array dba_handlers ([bool $full_info = false])
DESCRIPTION
dba_handlers(3) list all the handlers supported by this extension.
PARAMETERS
o $full_info
- Turns on/off full information display in the result.
RETURN VALUES
Returns an array of database handlers. If $full_info is set to TRUE, the array will be associative with the handlers names as keys, and
their version information as value. Otherwise, the result will be an indexed array of handlers names.
Note
When the internal cdb library is used you will see cdb and cdb_make.
EXAMPLES
Example #1
dba_handlers(3) Example
<?php
echo "Available DBA handlers:
";
foreach (dba_handlers(true) as $handler_name => $handler_version) {
// clean the versions
$handler_version = str_replace('$', '', $handler_version);
echo " - $handler_name: $handler_version
";
}
?>
The above example will output something similar to:
Available DBA handlers:
- cdb: 0.75, Revision: 1.3.2.3
- cdb_make: 0.75, Revision: 1.2.2.4
- db2: Sleepycat Software: Berkeley DB 2.7.7: (08/20/99)
- inifile: 1.0, Revision: 1.6.2.3
- flatfile: 1.0, Revision: 1.5.2.4
PHP Documentation Group DBA_HANDLERS(3)