8 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.
For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
2. Shell Programming and Scripting
hello guys,
I need your help in mastering UNIX shell Scripting. I am looking out for some good books or pdf's . Please provide ur help. :p (4 Replies)
Discussion started by: himanshu sood
4 Replies
3. Shell Programming and Scripting
We have an interactive program that when I execute some of its commands through telnet, it complains, "Command must be executed from master console". Can executing this program from a shell through telnet get around this problem? Can cron get around this? Thanks. (1 Reply)
Discussion started by: jerryg01
1 Replies
4. Programming
We have an interactive program from a 3rd party. We don't have the code. When I execute some of its commands through telnet, it complains, "Command must be executed from master console". Can executing this program from a shell through telnet get around this problem? Can cron get around this? Thanks. (1 Reply)
Discussion started by: jerryg01
1 Replies
5. AIX
Hi,
I want to know how to create nim master in AIX 5.3.
Regards,
Manoj (0 Replies)
Discussion started by: manoj.solaris
0 Replies
6. AIX
Hi,
I want to know what are steps required to create nim master in aix?
Regards,
Manoj (1 Reply)
Discussion started by: manoj.solaris
1 Replies
7. AIX
All,
I'm testing NIM on a 7026-m80 machine.
But everytime i want to setup the master, i get this error message...
Anyone who knows how to solve this issue? google doesn't seem to know much about it
# nim_master_setup
############################## NIM master setup... (1 Reply)
Discussion started by: kvanelshocht
1 Replies
8. UNIX for Dummies Questions & Answers
I was a sys admin on a HP3000. I was able to virtually move the console where ever I needed it for commands that had to be done at the master console. So I could be at home and perform some functions that you would usually have to do from the console. Now I am sys admin newbee on an AIX pseries.... (2 Replies)
Discussion started by: Beetlejuice
2 Replies
OCI_SET_ACTION(3) OCI_SET_ACTION(3)
oci_set_action - Sets the action name
SYNOPSIS
bool oci_set_action (resource $connection, string $action_name)
DESCRIPTION
Sets the action name for Oracle tracing.
The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
is executed.
The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitor-
ing 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 $action_name
- User chosen string up to 32 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the action
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the action
oci_set_action($c, 'Friend Lookup');
// 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 actions
// being performed:
sqlplus system/welcome
SQL> select action from v$session;
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.
SEE ALSO
oci_set_module_name(3), oci_set_client_info(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_ACTION(3)