07-31-2005
Sorry, we are running an Oracle Database in a UNIX Server. Thanks for the help.
10 More Discussions You Might Find Interesting
1. AIX
Hi,
Would any one be so kind to explain me :
are ulimits defined for each user seperately ? When ?
Specialy what is the impact of :
max locked memory
and
virtual memory
on performance of applications for a user.
Many thanks.
PS :
this is what I can see in MAN :
ulimit ]
... (5 Replies)
Discussion started by: big123456
5 Replies
2. Solaris
Hi,
Im working on Solaris 9 on SPARC-32 bit running on an Ultra-80, and I have to find out the following:-
1. Total Physical Memory in the system(total RAM).
2. Available Physical Memory(i.e. RAM Usage)
3. Total (Logical) Memory in the system
4. Available (Logical) Memory.
I know... (4 Replies)
Discussion started by: 0ktalmagik
4 Replies
3. Solaris
Is it possible to restrict physical memory in solaris zone with zone.max-locked-memory just like we can do with rcapd ? I do not want to used rcapd (1 Reply)
Discussion started by: fugitive
1 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
I am new to Linux kernel/user space programming having been an assembly programmer in my previous life. I am now using 2.6.x kernel on an embedded CPU that has a few dedicated hardware blocks (including more CPU running just C-code, i.e., no operating system).
There is a single DRAM... (1 Reply)
Discussion started by: agaurav
1 Replies
5. Solaris
Hi,
I am on an Solaris machine "SunOS 5.10 Generic_139556-08 i86pc i386 i86pc"..how do i check if I am on an physical or an virtaul server.
Thanks. (6 Replies)
Discussion started by: jjoy
6 Replies
6. Solaris
Hello,
Firstly, apologies if the theme of this post is discussed elsewhere.
At the moment we have a dual-domain M5000 running. Each domain is running with equal amounts of CPU and memory.
What we'd like to do is move the 2 hosts in question (1 per domain) to a Solaris 10 zone of it's zone.... (2 Replies)
Discussion started by: nm146332
2 Replies
7. UNIX for Advanced & Expert Users
Hi All,
How can I know whether the server I am connecting to is a virtual or physical one? The server might be having any Unix OS (Linux/Solaris/HP-UX etc.).
Is there any system files / commands which can show these concrete information?
Thanks in advance for the replies.
sanzee (1 Reply)
Discussion started by: sanzee007
1 Replies
8. Red Hat
Hi,
i am trying to find out hpw many virtual and physical processors does any linux machine has:
output of /proc/cpuinfo is as below :
# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU... (8 Replies)
Discussion started by: omkar.jadhav
8 Replies
9. AIX
HI,
I need a command to find,
1) Avaiable Physical CPU
2) Avaiable virtual CPU
TIA (1 Reply)
Discussion started by: sumanthupar
1 Replies
10. Solaris
uname -a reports type Generic so I know its virtual. Assume its an ldom somewhere.
How do I find out what physical host server is? (4 Replies)
Discussion started by: psychocandy
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)