SQL & PL/SQL :: How To Find OS Block Size

Oct 25, 2002

I find posted and written in many places that the DB block size should be a multiple of the OS block size. I can't find any information, however, on how to find what the OS block size is for an OS. How to find the OS block size for Windows and UNIX systems (Solaris, Linux, and HP-UX)?

View 4 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Know The Block Size Of A Table

Jul 12, 2011

AS of we know that we can get the number of blocks occupied by data in a table by querying the user_tables Data Dictionary.

My questions are,

1.)how to know if i want the each block size ?(i.e each block size either it is 4kb or 8kb or 16kb..)?

2.) Is the block size is same for all blocks in a table and in Database or it varies?

3.)The block size is DB dependent or Table dependent or Machine dependent(32-bit, 64-bit and OS)?

View 5 Replies View Related

Database Block And Cache Size

Oct 5, 2010

In Oracle 9i

I know that db_block_size defines the standard/default block size for my datafiles.

I know db_cache_size defines the size of the my default database buffer of the size of my standard/default block size.

db_block_size = 8192 (8k)
db_cache_size = 200Mo of 8k block

Is there any needs for the other buffer cache

db_16k_cache_size
db_4k_cache_size
db_32k_cache_size

and so on?

If I have NO datafiles other than of the default block size, would I need to define a size for those other buffer pool? Is there any process that would benifit of these pools?

View 3 Replies View Related

Patch And Non-Standard Block Size

Apr 14, 2013

1) When might one choose non-standard block sizes?
2) Why do we need to apply patch? Just to fix bugs?

View 3 Replies View Related

Server Administration :: Non Standard Block Size

Aug 15, 2011

I am using oracle 10g with sga_max_size =4GB and db block size 16k. Now i am creating a tablespace with block size 32 kb , whats value i select for the parameter db_32k_cache_size.

Is there any standard way to calculate the value of this parameter.

View 4 Replies View Related

Server Administration :: Control File And Database Block Size?

Oct 24, 2011

SQL> select block_size from v$controlfile;

BLOCK_SIZE
----------
16384

SQL> show parameter db_block_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192

the 2 can have difference block size?

View 3 Replies View Related

Server Utilities :: Importing From 9i To 11g - Getting ORA-29339 Error Because Of Block Size?

Oct 5, 2010

We are working on migrating from 9.2.0.4 to 11.2 and we've set up a test machine so that we could test the install and the import (as well as test additional 11g features that we want to begin using).

So we created the database and created all of the tablespaces beforehand.

Our import command is

$ORACLE_HOME/bin/imp system/manager FULL=Y BUFFER=140000 FILE=/dbexport/Lhtech.exp VOLSIZE=2000M GRANTS=Y INDEXES=Y COMMIT=Y IGNORE=Y

However, when we run the import, we get the errors like so:

Import: Release 11.2.0.1.0 - Production on Tue Oct 5 15:01:19 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path

[code]....

First of all, the block size in our "newly" created tablespaces is 8192...and these are obviously trying to recreate the tablespaces with a block size of 2048.

1) Why is it not ignoring these create tablespace commands when those tablespaces already exist?

2) how in the world do we get around the block size issue? We've tried nearly everything we could find, but we've still not had any luck.

View 8 Replies View Related

Performance Tuning :: Tablespace With Different Block Size Inside Same Database?

Nov 25, 2011

All the analysis till now on our system proves that our system is clearly I/O bound and db sequential read is the biggest culprit.

We have even identified the index which is being affected by sequential read. I am thinking of creating a new tablespace with 32K blocksize (currently all table spaces are 8k) and migrate this index to the new space. That way, Oracle will have to do less number of reads to get the required data.

But is there anything wrong in having just one tablespace with a differnt block size? Or is there anything that I have to be watchful about while doing it?

View 14 Replies View Related

Server Administration :: ORA-04030 - Split From Tablespace With Different Block Size Inside Same Database

Nov 26, 2011

i written this code i m facing ORA-04030: out of process memory when trying to allocate 16408 bytes error

/* Formatted on 2011/11/26 11:52 (Formatter Plus v4.8. */
DECLARE
row_id varchar2(50);
v_batch_id temp.batch_id%TYPE;
v_slab_id temp.slab_id%TYPE;
flag NUMBER (2);
num varchar2(50) := &row_id;

[code].....

View 1 Replies View Related

SQL & PL/SQL :: How To Find Size Of View Or Table In Database

Jul 10, 2010

How can we find the size of a view or synonym or table in a database. What is the code.

View 4 Replies View Related

Server Administration :: How To Find The Size Of Individual Folder In ASM 10g

Mar 16, 2012

Would like to know, how to find the size of individual folder in ASM 10g !

Also I am not able to find the PATH/name of the raw devices in ASM 10g !

View 3 Replies View Related

Find Tablespace Size (used And Free) For Partitioned Table?

Aug 9, 2013

I need to find the tablespace size (used and free) for a partitioned table

View 3 Replies View Related

How To Check / Find Size Of Current ROLLBACK Segment

Apr 8, 2013

How to check/find the size of current ROLLBACK segment in oracle 10g ?

View 20 Replies View Related

XML DB :: Find Size Of Table With XML Type Column Store As Binary XML

Dec 21, 2012

I have a table with structure as:

CREATE TABLE XML_TABLE_1
(
ID NUMBER NOT NULL,
SOURCE VARCHAR2(255 CHAR) NOT NULL,
XML_TEXT SYS.XMLTYPE,
CREATION_DATE TIMESTAMP(6) NOT NULL
[code].....

- So HOW do I find the total size occupied by this table. Does BINARY storage work as LOB storage. i.e. I need to consider USER_LOBS as well for this. OR foll. will work

select segment_name as tablename, sum(bytes/ (1024 * 1024 * 1024 )) as tablesize_in_GB
From dba_segments
where segment_name = 'XML_TABLE_1'
and OWNER = 'SCHEMANAME'
group by segment_name ;

- Also if I am copying it to another table of same structure as:

Insert /*+ append */ into XML_TABLE_2 Select * from XML_TABLE_1.

Then how much space in ROllbackSegment do I need. Is it equal to the size of the table XML_TABLE_1?

View 2 Replies View Related

Backup & Recovery :: How To Find Corruption Block

Jun 9, 2012

how to find the corruption block and judge whether it is physical corruption or logical corruption?

View 3 Replies View Related

Enterprise Manager :: Querying Grid Control Tables To Find Size And Name Of Database?

Sep 25, 2012

query to get the name and size of all the databases associated to grid..

I need to find this to do capacity planning in our environment.

View 6 Replies View Related

Forms :: How To Find Sum Of Item From Multi-record Block

Apr 21, 2010

i have form have one multi record block and sing record block. In multi record block having an item namely Excise_value. I want to find the sum of total Excise_Value for all the record. How to accomplish this.

PS: I want to use the Formula/summary property in forms

View 2 Replies View Related

Forms :: Clear Block B Once Click FIND Button

Jul 6, 2011

I am working on form builder 6i.I have FIND widnows and MAIN window.

FIND Window: contains field1 and field2, FIND Button.

block A: Multi record data block on table t1. It contains field1,field2,field3.
block B: non datablock, it contains field4, field5.

If i enter something and click FIND button, it will populate data in Block A.If i put the cursor in any record in block A, and after that put the cursor in Block B, it will populate block B related to Block A record.For this, In Block A--> post record(block level) trigger, i am capturing values in variables.

:GLOBAL.f1:=:BlockA.field1
:GLOBAL.f2:=:BlockB.field2

In Block B--> When-New-Block-instance(Block Level)

select field3, field 4 from t2 where t1=:global.f1 and t2=:global.f2;

and populating data in block B.It's working fine.

REQUIREMENT: If i click the FIND second time, in Block B--> it's retaining previous value. I want to clear the block B once i click the FIND button. I tried to write in POST-BLOCK (Block B-->block level)

CLEAR_BLOCK('NO_VALIDATE');

But it's not working.In which trigger i have to write code to clear block.

View 3 Replies View Related

Server Administration :: Move Partitioned Table Between Table Spaces Of Different Block Size?

Apr 4, 2011

I was about to move some tables from one table space to another but it seems it is not possible to move partitioned tables between table spaces of different block sizes.

So far the only option I have is to export and then import back the data.

know if there is any way to move a partitioned table between table spaces of different block size?

View 14 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 :: Multi Data Block And Checkbox Field Based On Control Block

Nov 19, 2010

i have multi data block filed. and checkbox field which based on control block...My task is when i check checkbox only one field should enabled and my mouse goes to that field

e.g

item11 item21 item31 chkbox1
item12 item22 item32 chkbox2

Scenario like this :

My item field based on data block and checkbox based on control block,while i checked chkbox1 , only item31 on that current record should be enabled and i changed value only on that field

when i checked chkbox1 , my cursor goes to item31...not item32

View 12 Replies View Related

Forms :: Distribute Master Block Total Amount In Detail Block Line Wise

May 5, 2012

i have a master detail form, In Master block we have one field cheque amount and in Detail block we have field receiveable amount invoice wise. if company paid us a cheque amount we will enter this amount in Master block field Cheque amount and in detail block there will be invoice wise receivable amounts. i want to distribute the cheque amount in detail block invoice wise for example

Cheque amount in master block = 291

Invoice wise receiveable amount is as follows

Invoice No , receivable amount , Received amount

10, 196 , 0
20 , 95 , 0
30 , 54 , 0

Result should be as follows:

Invoice No , receivable amount , Received amount

10, 196, 196
20 , 95 , 95
30 , 54, 0

Received amount field should be distributed according to the receivable amount when recevied amount = cheque amount then remaining will be 0.

View 2 Replies View Related

Backup & Recovery :: Error / Corrupt Block Relative Dba / 0x01c12a58 (file 7 / Block 76376)

Jan 25, 2011

i have an error with block corruption

Error: Corrupt block relative dba: 0x01c12a58 (file 7, block 76376)

What all the ,methods I can go for if we are working on a production environment with out any down time.

I can go for dbms repair package and restore and recover

View 3 Replies View Related

Forms :: How To Read Values In A Multi Record Control Block Using Pre-insert Trigger (block Level)

Jul 24, 2010

I have a multi record control block (basically a text item displaying 6 records) where user enters values and I want to process the values using pre-insert trigger.

I want to read value in each record and then do some tasks using a pre-insert trigger before I commit the values. To navigate between the records I was using first_record, next_record, clear_record built-ins but it gives errors like "40737-illegalrestricted procedure next_record in pre-insert trigger".

View 3 Replies View Related

Size Of Database

Aug 24, 2009

i have few questions to ask.

1)How to find out the total size of my database.

2)what is dblink and how to find out the same.

View 5 Replies View Related

Row Size Of Two Different Row In Table?

Sep 13, 2011

One of my user is asking to give me the size(bytes) of row 39 and size(bytes) of row 49 of a table ZETR.

as i am not aware of how to collect size(bytes) for a particular row.

View 3 Replies View Related

SGA And PGA Size Allocation?

Nov 21, 2012

I Have a server System Configuration with

RAM size: 16GB Ram & Hard disk Size of 1TB.

I Installed Oracle 11g R2 in the server SystemI want to Allocate Dedicated Memory for oracle..How Should i calculate the Memory size of SGA+PGA for good Performance..

View 2 Replies View Related

RMAN Backup Size?

Apr 18, 2012

I have Oracle database.I take rman backup everyday.Also I set a scheduled backup script.But scheduled backup size is 166MB,but if I take manual rman backup(rman>backup database) this backup size will 2.8GB.This backup isn't incremental backup.

I wrote 3 batch script.Finally this backup script call

backup script:

run
{
backup database plus archivelog delete input format 'C:\db_11g_backup\backup\oracle_scheduled_backup\backups\%d_%t_%s.rman';

[Code]...

View 2 Replies View Related

Increasing Data Size

Oct 3, 2013

How to increase ASM DATA free size? I tried deleting expired backups and old archive logs which are backed up more than one time. Still no success ..

View 1 Replies View Related







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