02-25-2009
Now it makes a little more sense to me...
The issues I see can happen on your HP will be
Users ( oracle ) cant connect anymore, and in worst case you loose also the connection...
Only a reboot can solve at this point (very rare...).
I will go and look if I can find you a ( live) sample...
8 More Discussions You Might Find Interesting
1. Windows & DOS: Issues & Discussions
Hi Guys,
i am new to the fourms..
i have one doubt related to unix..
i was developed one application in asp.net under windows platfrom.
i want to run this application in sun one web server under unix environment..
Its possible or not ..
please calrify my doubt.
Thanks and Regards... (4 Replies)
Discussion started by: ksathiya76
4 Replies
2. AIX
Dear all ,
I have a serious question and i need an answer before i go throught a new project.
I have an oracle DB is on remote UNIX box.How can I connect through ASP.net on a windows server machine to the oracle db and do all the jobs i need (insert ,update delete) ? is their is a way ??
please... (2 Replies)
Discussion started by: hoshakhs
2 Replies
3. Windows & DOS: Issues & Discussions
hi,
this is probably a terrible question: can I program using .NET on Unix Servers ?
thanks
Patrick (2 Replies)
Discussion started by: aneuryzma
2 Replies
4. Shell Programming and Scripting
I had issues with processes locking up. This script checks for processes and kills them if they are older than a certain time.
Its uses some functions you'll need to define or remove, like slog() which I use for logging, and is_running() which checks if this script is already running so you can... (0 Replies)
Discussion started by: sukerman
0 Replies
5. Windows & DOS: Issues & Discussions
I have a .NET application that remotely starts, stops, and gets status of Windows services and scheduled tasks. I would like to add the capability of starting, stopping, and getting status of remote AIX applications also. Based on some preliminary research, one option may be to use 3rd party .NET... (0 Replies)
Discussion started by: auser1
0 Replies
6. UNIX for Dummies Questions & Answers
I have an application I wrote that is designed to run on a windows system but now starting to think I would rather be using Unix. Would the application have to be 100% rewritten to work on unix, or is there something I could install that would allow me to run my .NET application inside unix? (2 Replies)
Discussion started by: redbrad0
2 Replies
7. Programming
Hello friends,
I started my career with VB.6.0 in 2007, In 2008 moved in VB.NET window application programming and then for web application programming with C#,ASP.NET with different databse like Oracle,MySQL and SQL Server.Currently I have 4.7 years experience in .NET application and worked... (8 Replies)
Discussion started by: Amit Verma
8 Replies
8. Web Development
Hi All,
Frankly I'm new to Linux Environment. While we are trying to Host an ASP.NET 5 Web Application on Centos OS7 Web hosting Server. There were couple of steps which we are supposed to go through, please see this link -
We are stuck at Create a Container & then Running the Container,... (1 Reply)
Discussion started by: John Fredric
1 Replies
LEARN ABOUT PHP
oci_set_client_info
OCI_SET_CLIENT_INFO(3) OCI_SET_CLIENT_INFO(3)
oci_set_client_info - Sets the client information
SYNOPSIS
bool oci_set_client_info (resource $connection, string $client_info)
DESCRIPTION
Sets the client information for Oracle tracing.
The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
statement is executed.
The client information can subsequently be queried from database administration views such as V$SESSION.
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 $client_info
- User chosen string up to 64 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the client information
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the client information
oci_set_client_info($c, 'My Application Version 2');
// 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 client
// information:
sqlplus system/welcome
SQL> select client_info 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_action(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_CLIENT_INFO(3)