01-12-2002
Perderabo is correct - increase shmmax.
And you can control the size of your SGA by changing certain settings in the init<SID>.ora file. A big one is db_block_buffers. If this is set to 10000, and you have 16K block size, this will contribute about 160MB toward the total size of the SGA. Another big one (as regards SGA size) is shared_pool_size.
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 DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)
NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)