How To Choose Best Stripe Size For A RAID10 Array - 10gR2

Oct 7, 2010

I have been studying possible ways to calculate the best size for the stripe size on my new storage. From what I have seen it appears that there is no straight answer but I believe there must be good way of estimating it. I am deploying a new storage that uses 16 x 600GB 15k RPM 6Gbps SAS drives, it is supposed to be very fast but I think if I get the stripe size on the RAID10 array right I should be able to get even more out of it. I am running oracle 10.2.0.4.0 (10gR2) on 64bit Linux with 32GB of RAM, the SGA is set to 20GB.

What I read said that the "stripe size must be at least as large as the I/O size." The I/O size is calculated from DB_BLOCK_SIZE * DB_ FILE_ MULTIBLOCK_ READ_COUNT, which is my case is "db_block_size = 16k * db_file_multiblock_read_count = 16 = 256k." The current RAID10 array that I am using which will be decommissioned soon has a stripe size of 128k, and if I understood it all correctly it is undersized for my Oracle instance.

With an I/O size of 256k the smallest stripe that I should choose is 256k but how do I know what is the best combination of db_file_ multiblock_ read_ count and db_block_size?

We are planning to create new table space with a block size of 32k as this has been recommended by a number of DBAs but with "db_block_size = 32k * db_file_multiblock_read_count = 16 = 512k".

Is this a viable size? Do you think this will actually improve performance on my system? Note that this database gets about 1500 insertions per second and peaks around 3000 insertions per second, it is a mixture of OLTP and data warehousing.

After doing a lot of research I came across an article by "Don Burleson" which says that starting in Oracle 10gR2 the "Oracle recommends not setting the db_file_multiblock_read_count parameter, allowing Oracle to empirically determine the optimal setting." References: URLs.....

View 5 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Choose First And Second Row Value

Jun 21, 2011

if i have table contains the following

r_nu record_s value time
1 11111 1 33904
2 30119 4 33904
3 70119 3 33904
4 11111 2 33904
5 20219 1 33920
6 11111 3 33920
7 50119 4 33935

if i want sql statement to select the first value of record_s and the second (both same value) and ignoring the rest

maybe to subtract its value from its second value

got it ?

so will choose
record_s 11111 and value 1
record_s 11111 and value 2
to do : value of second one - value of first one
2-1

View 3 Replies View Related

Forms :: How To Choose Tab In Focus

Oct 7, 2011

I have created a form in Oracle Forms 6i that utilizes a tabbed interface. Each section of the form has different modules to create a quote on the end page. As far as the logic goes, I have it complete. However, I would like to choose the tab that is in focus, and I can't find a place to change this in the property panel. What am I missing? I don't want it to focus on the last tab which is the totals page, when it should focus on the first page where you enter the data.

View 5 Replies View Related

Forms :: Choose Fields From Left

Feb 16, 2013

Is there any possibility of creating a selection interface similar to our report or forms wizard where user can select single fields or multiple fields together and when he clicks on the arrow those fields data to be inserted into another table.Please refer attachment.

--this is the main table
create table batch_item (batch_no varchar2(12),item_batch varchar2(12),total_batch_qty number);

insert into batch_item ('0001','a',300);
insert into batch_item ('0002','b',200);
insert into batch_item ('0003','a',102);

--after inserting the data i should be able to move this data to corresponding batches by manually selection and pushing them to a batch.create table ct_item (item varchar2(12),item_nm varchar2(20),item_qty number);

insert into om_item values ('a','alpha',2);
insert into om_item values ('b','beta',3);
insert into om_item values ('c','gama',4);

--left side is om_item and right will have batch items where batch qty will be accumulated upon choose arrows.

View 3 Replies View Related

SQL & PL/SQL :: Choose Explicit Cursor To Loop Through At Runtime?

Nov 1, 2011

Oracle Version: 11.2.0.2.0. I have two explicit cursors and I would like to choose at run time which one to run. Here is a simplified code snippet of what I am doing today:

DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';

[code]....

I want to avoid maintaining the same long list of transformations. I also want to avoid, if possible, an explicit FETCH INTO, because there are hundreds of fields in both tables. I'm looking for something like this (and I know this doesnt work):

DECLARE
CURSOR Cursor_A IS
SELECT * FROM EMP_A;
CURSOR Cursor_B IS
SELECT * FROM EMP_B;
RUNA CHAR(1) := 'Y';
CursorToRun IS REF CURSOR;

[code]....

View 4 Replies View Related

Choose Right Raid Level For Oracle Database

Aug 10, 2010

Tell me the right raid level for oracle database and why? The best companies that makes raid servers?

[URL].........

View 3 Replies View Related

Memory Management - Choose Parameters For Server With A Fixed RAM?

Apr 18, 2011

the erelationship between sga_max_size,sga_targt,shared_pool_size,pga_aggregate_target and the server memory.

In short how shud i choose the above parameters for a server with a fixed RAM.

View 1 Replies View Related

Performance Tuning :: How Oracle Optimizer Choose Joins (hash / Merge And Nested Loop Join)

Oct 18, 2012

I want to know how the Oracle optimizer choose joins and apply them while executing the query. So that I will insure about optimizer join before writing any query.

View 2 Replies View Related

Server Utilities :: Estimate Size Of FlatFile Based On Table Size?

May 8, 2013

We are planning to export the table data to a file pipedelimited. How do i estimate the size of the FlatFile based on the table size? or avg rowlength

View 3 Replies View Related

Server Administration :: How To Reduce Size Of TEMP DBF File Size

Apr 13, 2011

I am using oracle 8.1.5 database and my temp01.dbf file size is increased upto 19.8 GB now i want reduce its size .

View 13 Replies View Related

Forms :: Choose Lov In First Record That Won't Be Display In Second Record Lov

Sep 10, 2012

I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov...

View 4 Replies View Related

Windows :: How To Install 10gr2 In Win 7

May 1, 2010

Is it possible to install 10gr2 in windows 7?

View 12 Replies View Related

Oracle DB 10gR2 Installation

Jul 8, 2011

I try to install th a oracle 10gR2 database to a SuSe Linux 11.4.

I try to install to tha local machine, not to a remote host. But when I start the installation every time I get the next error message:

CODECan't connect to X11 window server using '' as the value of the DISPLAY variable.

Unable to start an interactive install session because of the following error:Can't connect to X11 window server using '' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.

Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:

- For csh: % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY

Use the following command to see what shell is being used:

echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY

- Make sure that client users are authorized to connect to the X Server. To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:

% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 basedprogram that comes with the native operating system such as 'xclock':
% <full path to xclock... see below>

If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance. Typical path for 'xclock': ''

I think that I don't need the x server when I install the product to the local machine. But every time I get this message.

View 6 Replies View Related

Database Upgrade From 9.2.0.8 To 10gR2

Oct 26, 2012

Why is knowing the backup policy important before starting any upgrade.

View 17 Replies View Related

Installation :: 10gr2 On 32 Bit RHEL 5 OS

Aug 1, 2012

I am trying to install 10gr2 on a 32 bit RHEL 5 OS. One of the packages that's need to be installed is elfutils-libelf-devel-0 according to metalink.

Now, when I try to install it i get the following error:

error: Failed dependencies:
elfutils-libelf-devel-static-i386 = 0.137-3.el5 is needed by elfutils-libelf-devel-0.137-3.el5.i386

Now i tried to install the said dependency and i got this error:

error: Failed dependencies:
elfutils-libelf-devel-i386 = 0.137-3.el5 is needed by elfutils-libelf-devel-static-0.137-3.el5.i386

I saw a somehow similar solution in

[URL].........

I have to install both the packages in the same rpm command according to the link and i got the following:

[root@MCISMACAMDB Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
1:elfutils-libelf-devel-s########################################### [ 50%]
2:elfutils-libelf-devel ########################################### [100%]

The ..static package didn't seem to have installed completely. I tried checking if elfutils-libelf-devel-i386 = 0.137-3.el5 was really installed:

[root@MCISMACAMDB Server]# rpm -q elfutils-libelf-devel-0.137-3.el5.i386.rpm
package elfutils-libelf-devel-0.137-3.el5.i386.rpm is not installed

So i tried installing it again then the system prompted that it is already installed:

[root@MCISMACAMDB Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ########################################### [100%]
package elfutils-libelf-devel-0.137-3.el5.i386 is already installed

Did i make the right steps? Can i go on now? I don't know if what I did was correct and ok and that I should already consider that package as installed.

View 3 Replies View Related

Duplicating DB In 10gR2 With RMAN Without Target DB

Dec 2, 2011

I would like to have some inputs on RMAN backup that we are planning to perform for the database that has to be now discarded; and which may have have to be restored in distant future.

Current Env--
DB Ver: 10gR2
OS: Solaris
Backup mode: RMAN WITHOUT CATALOG(i.e. using controlfile for storing rman info)

From what I know(I might be wrong), that for duplicating the 10gR2 DB to another machine we have to have the target(original) database running and connected. In my case we need to take the rman backup and then use the target db for fresh installation and hence the db will be deleted.

View 2 Replies View Related

Download Full Oracle 10gR2 Documentation?

Nov 3, 2010

want to download full oracle 10gR2 documentation. I also navigated on [URL] but this link allowing me to download pdf one by one but I want to download all pdf's in single shot.

View 2 Replies View Related

Oracle 10gR2 Installation Failed On SLES10

Jul 15, 2008

While installing Oracle10gR2 on zlinux machine where the OS is SLES10 SP1 I got this error

In installActions2008-07-15_04-37-15PM.log

INFO: /usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libdl.so when searching for -ldl
/usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libm.so when searching for -lm

[Code]....

View 1 Replies View Related

PL/SQL :: Creating PSP Reports In Oracle Database 10gr2?

Feb 6, 2013

I want to create the .psp(pl/sql ser pages) reports in the oracle database 10gr2.but i am unable to do it why because it needs http server(knew by going through some of the oracle docs but not able to understand) where i find this first of all details configuration needed for the .psp files.

View 8 Replies View Related

Server Utilities :: To Import All Data From 8i To 10gR2

Apr 14, 2010

At my current organization there are two instances are running one is at 8i and another one is 10g. I want to migrate all the data from 8i to 10g. I have already taken the export from 8i with the below command:-

exp file=<<PATH>> full=y logfile=<<PATH>> compress=y

Now I want to import it to 10g DB. Can I do the import with that below command?

imp file=<<PATH>> full=y logfile=<<PATH>> ignore=y compile=y

View 3 Replies View Related

Oracle 10gR2 - OEM Database Control Configured For DBs

Jul 24, 2013

 I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?

View 7 Replies View Related

Upgrade :: 10gR2 Single Instance To 11gR2 RAC?

Aug 3, 2012

upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.

View 3 Replies View Related

Oracle Database Migration From 9iR2 / 10gR2 To 11gR2

Apr 22, 2013

Which is the best method for migration of database from Oracle 9iR2,10gR2 to 11gR2.

Current Environment
Server1
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 9.2.0.8 (32 bit)
Average Db Size: 600Gb
RAc Configuration: No
Server2
Operating System: Sun OS 5.10
Oracle Database: Oracle Database Enterprise Edition 10.2.0.3 (64 bit)
Average Db Size: 600Gb
RAC Configuration: No

Proposed Environment
Server1 and Server2
Operating System: Sun Solaris 10
Oracle Database: Oracle Database Enterprise Edition 11.2.0.3 (64 bit)
RAC Configuration: No
Hardware is New : Yes

View 2 Replies View Related

RAC & Failsafe :: Upgrade Database With ASM Storage From 10gR2 To 11gR2?

Mar 7, 2011

I have a database running on 10205 version. It is a RAC database with ASM storage.

I want to migrate this database to other server and upgrade this database to 11202 version .

View 1 Replies View Related

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Server Administration :: Migration Of Oracle 10gR2 To 11gR2?

Jun 23, 2010

I am migrating an oracle 10g to 11gR2. i am a bit confused. The developers in my work place have a tablespace for storing table and a different tablespace for storing indexes.

For the migration i am using exp and imp. My question is how i am going to migrate the indexes from 10g to 11gR2?

OS; solaris sparc 10

Oracle 10g: 10.2.0.1.0

oracle 11g: 11.2.0.1.0

View 1 Replies View Related

Forms :: Retrieving Dynamic Values In Builder 10gr2

Jun 30, 2011

How can i use this below example in forms builder 10gr2

var oput_cur refcursor
var tabname varchar2(30)
exec :tab_name := 'dual';
begin
open :oput_cur for 'select * from ' || :tabname;
end;
/
print oput_cur

how can i get the values from oput_cur into forms grids(containing text items).

View 11 Replies View Related

Installation :: Oracle 10gR2 For Windows 7 64bit Processor?

Jul 10, 2012

I need to download Oracle 10g R2 for windows7 64bit processor. send the link

View 4 Replies View Related

Migrate From Oracle 10gR2 In Windows To 11gR2 In Linux

Jun 22, 2012

Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:

1.     need to expdp all schemas/users from oracle 10gR2 in Windows,
2.     then impdp each schema/user into oracle 10gR2 in Linux first,
3.     then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4.     Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?

Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?

View 5 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved