02-12-2012
You'll probably get more joy from your post on OTN if you mention your Country of origin. There are strict laws about exporting software. Oracle are often very helpful when you have a maintenance contract
Strongly advise that you seek advice from Oracle first and only buy from a second-user broker if Oracle state that the end result will be street legal.
It would be illegal for unix.com to supply you with copyright software or to ask our members to do the same.
7 More Discussions You Might Find Interesting
1. IP Networking
I am trying to network two solaris workstations(ultra sparc 5) at home. what shoud I use to build the one of workstations as a http and ftp server and to network with the other workstation?
(please explain to me in detail.. what kind of software or equipment do I need..)
Thanks
John (1 Reply)
Discussion started by: jung1975
1 Replies
2. Filesystems, Disks and Memory
i would like about the emulation in workstations. thanks. (2 Replies)
Discussion started by: rmilano
2 Replies
3. UNIX for Advanced & Expert Users
What's the idea of Unsyncron SUN WS's ? one of our client had a problem & my supervisor told me that this causes of unsynchron WS's i mean maybe the setting of one is not compatible with other .....
Any Suggestion would be helpful
Rgrds,
nikk (1 Reply)
Discussion started by: nikk
1 Replies
4. Filesystems, Disks and Memory
Am planning on adding a secodary SCSI hardrive to the existing 20gb drive., that I have. The old drive has Linux on it. Once, the new drive is added, I am planning on having windows on it.
Firstly, could this be done ? Has anyone build a system with a similar configuration ? What is requried,... (1 Reply)
Discussion started by: matvrix
1 Replies
5. Solaris
I am looking to buy W2100z workstation. I want to run solaris 10 on it.
I realize it's a few years old, from 2004.
Is it a good machine to get or should I look for a newer workstation? (1 Reply)
Discussion started by: etc
1 Replies
6. Hardware
Hi I have the above machine, which is exhibiting the classic cpu fan pulsing issue. It seems I need to apply a BIOS update to the machine, from a CD that was formerly a free download from Sun, but now Oracle has taken over you need a support contract to get it. This machine is now very out of... (4 Replies)
Discussion started by: ZaphodB
4 Replies
7. HP-UX
Hi there,
I got a pretty old HP 382 workstation, and the hdd is pretty LOUD ... ;)
So I thought I clone it to an much quiter one.
I tried this:
- removed the loud hdd
- connected it to an system running knoppix 7.0.4 (hdd is recognized with UFS filesystem; Clonezilla couldn't handle the... (9 Replies)
Discussion started by: pelegrine
9 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)