01-10-2002
Emergency Block Size Very Important!!!
I have a problem with Oracle Database due to block size it said : "Oracle's SGA to big to fit contiguosly into one segment" Reconfigure the UNIX kernel to have bigger segments.
How can I reconfigure Kernel in order to get bigger "segments". Does it works on pure UNIX system with no Solstice install?
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Hi,
Somehow i have forgotten a comand that displays me the block size of the unix filesystem. Can someone letme know this command
regards
penguin (5 Replies)
Discussion started by: linuxpenguin
5 Replies
2. Filesystems, Disks and Memory
AIX 4.3.3
How can I find the os block size?
How can I change the OS Block Size?
When and where does the os block size get set?
I am running oracle 8.1.7 and am under the impression I need to set my os block size = oracle block size which is 8k.
Any insight on this would be... (1 Reply)
Discussion started by: kburrows
1 Replies
3. Solaris
how do you determine block size for a file system? In solaris 5.8 (3 Replies)
Discussion started by: csaunders
3 Replies
4. UNIX for Dummies Questions & Answers
Hello Unix guru's
I want to check my OS Block size for the Solaris 8
Following is one of the line from df -g command.
Can anybody help to interpret the same.
/u03 (/dev/vx/dsk/oradg/vol03): 8192 block size 8192 frag size
205463552 total blocks 50433792... (1 Reply)
Discussion started by: Dilippatel
1 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
drwxr-xr-x 2 root root 4096 May 31 14:47 test
Please let me know here 4096 indicating what?
Thanks & Regards,
Bache (1 Reply)
Discussion started by: bache_gowda
1 Replies
6. AIX
Hi, I try to change the block size from 512 to 0, but it send this message:
0514-068 Cause not know
Can someone help me whith this? (3 Replies)
Discussion started by: Ruben78
3 Replies
7. HP-UX
I cannot tar an ORACLE backup file with the size of > 8GB. So I am using "dd" to copy file to tape. What is the optimum block size for this process? (2 Replies)
Discussion started by: vslewis
2 Replies
8. UNIX for Advanced & Expert Users
Hello,
in one default UFS filesystem we have 8K block size (bsize) and 1K fragmentsize (fsize). At this scenary I thought all "FileSytem IO" will be 8K (or greater) but never smaller than the fragment size (1K). If a UFS fragment/blocksize is allwasy several ADJACENTS sectors on disk (in a ... (4 Replies)
Discussion started by: rarino2
4 Replies
9. Red Hat
Hi Guys,
I am running Linux 2.6.18-164.el x86_64 how do i check the block size?
Thanks in advance... (1 Reply)
Discussion started by: Phuti
1 Replies
10. HP-UX
Accordingly a lot of manuals - if you have block size 8KB and trying to write a 1KB file to the block, as result you waste 7KB of the block space. But recently I noticed about Fragments of File Block. In same case if you have File Block 8KB and Fragment size 1KB - you can save your block space,... (6 Replies)
Discussion started by: jess_t03
6 Replies
LEARN ABOUT PHP
oci_set_action
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)