Sponsored Content
Operating Systems AIX Anyone has experience with mirroring vg for Oracle Database and Application Post 302785435 by DGPickett on Monday 25th of March 2013 03:49:40 PM
Old 03-25-2013
If you can segregate high churn and query from low churn and query (work in progress versus quiescent history), RAID alone is fine for history, but mirror is better for both high churn and high query.

For instance, RAID with 5 drives 1-5 is striped so drive 5 block zero is parity for superblock 0, and drive 5 block 1 starts superblock1. Every write writes all 5 drives and every read can only be had from one device, but sequential reading is striped 5 ways. Writing is striped 4 ways since parity takes the 5th drive.

In practice, SAN mirrors are often raid at a lower level, so there can be a hidden cost, since you cannot reclaim the raid %.
 

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

UNIX Database / Application Installation

Greetings, forgive me if this is listed in another thread somewhere, I am short on time. I am being interviewed for the position of UNIX Database and Job code installer for a consulting firm. I have never installed or worked on a native UNIX system. I have been running Linux (RH,SuSE,Slackware)... (3 Replies)
Discussion started by: OllieTech
3 Replies

2. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

3. AIX

Filesystem using Oracle and mirroring VG ?

Hello, I have a filesystem which has Oracle EBS 11.5.9 running and database 9i # df -g Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/fslv00 270.00 69.68 75% 746263 5% /oratec which is in oraclevg # lsvg oraclevg VOLUME GROUP: ... (5 Replies)
Discussion started by: filosophizer
5 Replies

4. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
Session::Oracle(3)					User Contributed Perl Documentation					Session::Oracle(3)

NAME
Apache::Session::Oracle - An implementation of Apache::Session SYNOPSIS
use Apache::Session::Oracle; #if you want Apache::Session to open new DB handles: tie %hash, 'Apache::Session::Oracle', $id, { DataSource => 'dbi:Oracle:sessions', UserName => $db_user, Password => $db_pass, Commit => 1 }; #or, if your handles are already opened: tie %hash, 'Apache::Session::Oracle', $id, { Handle => $dbh, Commit => 1 }; DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the documentation for Apache::Session::Store::Oracle for more details. USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order to make you think about this problem. This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default maximum is 8 KB. AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session perl v5.12.1 2007-09-28 Session::Oracle(3)
All times are GMT -4. The time now is 05:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy