07-14-2006
You need to know something -
Most databases like Oracle create cooperating processes - one is the Pro*C executable, another is a child process totally devoted to communicating with the Oracle kernel and the other server processes located on your box.
If this is Oracle learn about tkprof instead. It's Oracle that is doing all of the work, almost always not the C process.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi
can someone help me to write a script to monitor the growth of the directory running at 5 hours interval and then pipe it to a file :(?
i only know the manual command "du -sk"
and the worst i dun know anything about script. (3 Replies)
Discussion started by: legato
3 Replies
2. Solaris
Hi,
I want to write a script that will monitor cpu,mem usage and disk usage for entire day and data will be redirected to file, (4 Replies)
Discussion started by: manoj.solaris
4 Replies
3. Shell Programming and Scripting
Dear All,
I am new to Shell Programming, but I need a script which will monitor the different IP's in the live logs.
Condition:-
The script will monitor the logs continously and should print only those IP's which exists more than 3 times per day.
Please do help me.
Thanks and... (1 Reply)
Discussion started by: akhtar.bhat
1 Replies
4. Shell Programming and Scripting
Could anyone please help?
I have written a small program that's actually working fine for me and extracting all the details I required. What code does is, it goes to all archivelog directories and see if archivelog backup was failed or successful
<<CODE>>
... (2 Replies)
Discussion started by: anjum.suri
2 Replies
5. Shell Programming and Scripting
Hi Gurus,
Currently I am learning UNIX through online forums and unix blogs. I have the below requirement.
I need to write a script to monitor server processes. For example, there are 3 processes currently running on the server.(java, pmrepagent, pmserver). If any of the process goes down,... (2 Replies)
Discussion started by: svajhala
2 Replies
6. Shell Programming and Scripting
Hi,
I want to write script that monitors particular ports in a server.
I completed the script but.... If the server is restarted i need manually start the script..
Is there any way i can make the script start by it self after the server reboot........
Thanks,
Firestar (4 Replies)
Discussion started by: firestar
4 Replies
7. Red Hat
Hi,
I ned to monitor the memory for the red-hat machine,when its reaches a threshold value like 2GB then a mail should be sent as soon as it finds the the value is met
can you suggest me which is the best way to do this? (2 Replies)
Discussion started by: sriniv666
2 Replies
8. UNIX for Advanced & Expert Users
Hi
I do a very simple monitoring of our OpenLDAP (runs in cronjob and generate alerts if unsuccessfull)
$ ldapsearch -h hostname.domain -D "cn=monitor_user,ou=People,dc=organisation" -w "password" -b "dc=organisation" -x "(&(cn=monitor_user)(ou=People))" dn | grep -v version
dn:... (4 Replies)
Discussion started by: slashdotweenie
4 Replies
9. Shell Programming and Scripting
Hello All,
I have written a script which will grep for error codes in a file and if the count for the same is about 500 it will send and smpp alert.
Here is my code.
#!/bin/bash
#########################################################################################################... (3 Replies)
Discussion started by: Siddheshk
3 Replies
10. Shell Programming and Scripting
I currently have a shellscript to check the size of a filesystem and email me if the size is over a certain percentage (80%). I have this script on crontab and executes the shell every 10 mins.
I have the above in place on 8 servers. It so happens that a file system on one of the servers is... (1 Reply)
Discussion started by: goddevil
1 Replies
LEARN ABOUT PHP
oci_set_module_name
OCI_SET_MODULE_NAME(3) OCI_SET_MODULE_NAME(3)
oci_set_module_name - Sets the module name
SYNOPSIS
bool oci_set_module_name (resource $connection, string $module_name)
DESCRIPTION
Sets the module name for Oracle tracing.
The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitoring such
as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $module_name
- User chosen string up to 48 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
EXAMPLES
Example #1
Setting the module name
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the module
oci_set_module_name($c, 'Home Page');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the
// modules in use:
sqlplus system/welcome
SQL> select module from v$session;
SEE ALSO
oci_set_action(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_MODULE_NAME(3)