03-24-2013
TPS for what? Oracle database? Sybase database? Or what? Your question is vague.
10 More Discussions You Might Find Interesting
1. Solaris
This may be an off the wall question but is there anyway in Solaris to snag the serial number of a Sun box? I'm not sure if you can do this but it would save me a long drive to the data center to get the serial number to renew support... (8 Replies)
Discussion started by: kingdbag
8 Replies
2. Shell Programming and Scripting
does any one have any ideas how i would go about calculating the number of days left in the month from a bash script ?. I want to do some operations on a csv file according to the result (8 Replies)
Discussion started by: dunryc
8 Replies
3. Shell Programming and Scripting
Hi all
I have a variable called "variable" and is of the form
variable ="AAA BBB CCC DDD" {basically it has values separated by spaces}
What is the simplest way to check if "variable" has more that one value in its list?
Thanks. (9 Replies)
Discussion started by: felixmat1
9 Replies
4. Solaris
Hi All,
I have an issue with calculating the network number that needs to be put in /etc/netmasks file in my Sol-9 server.
The IP of my server in 10.164.114.135
Default Gateway - 10.164.114.130
Netmask - 255.255.255.240
If I set "10.164.114.130 255.255.255.240" in netmask file, after... (2 Replies)
Discussion started by: Hari_Ganesh
2 Replies
5. Solaris
Our solaris are configured to send out email and i would like to know the number of emails sent out from the solaris server.
Anyone know can this be done?
Thanks (1 Reply)
Discussion started by: sirius20d
1 Replies
6. Programming
Hi,
plz see the below code.
here my aim is to calculate the number of lines in unprocessedData.out
if this file contains 40 lines then lastly $linenum should print 40.(except blank lines)
i have tried below code but it giving me the output only one. can anyone help me how to do ?
... (9 Replies)
Discussion started by: pspriyanka
9 Replies
7. Web Development
Is this code good for this purpose?
<?php
$date1 = mktime(0,0,0,01,01,1991);
$date2 = mktime(0,0,0,03,22,2012);
$diff = $date2 - $date1;
$days = $diff / (60*60*24);
echo ($days . "<br />");
?> (3 Replies)
Discussion started by: kovacsakos
3 Replies
8. Shell Programming and Scripting
Hi anyone can help?
How to calculate total number of weeks from a specify date, for example, 01 Jan 2012.
Thx! (2 Replies)
Discussion started by: rayray2013
2 Replies
9. Shell Programming and Scripting
Hello everyone,
I have some problem in calculation number using awk.
input file format :
S1 1 : 0.003 0.031
S2 1 : 0.020 0.095
S3 4 : 0.088 0.012
S4 2 : 0.010 0.090
S5 2 : 0.244 0.066
S6 3 : 0.249 0.751
S7 3 : 0.010 0.990
S8 3 : 0.230... (4 Replies)
Discussion started by: awil
4 Replies
10. Solaris
Hi,
I want to get total number of cores on my all non-global zones on Solaris 10. I got two methods and both are giving different results. Below link is a script, which tells me that total cores are 8
Mandalika's scratchpad: Oracle Solaris: Show Me the CPU, vCPU, Core Counts and the... (4 Replies)
Discussion started by: ron323232
4 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)