Server Administration :: Location Of A DB Block?

Feb 7, 2011

) How to find out, whether my Query return the output from the block of BUFFER CACHE or from DATAFILES?

2) How to calculate the no of data blocks were used to return a single output.

View 2 Replies


Server Administration :: Unable To Use Existing OraInventory Location During Installation?

Jan 5, 2010

i am installing oracle 11g rel2 ( o/s : hp ux 11.31 ). already we have 11g rel1 installed in the machine where oracle inventory location is /oracle/oraInventory where /oracle is ORACLE_BASE directory..

cd /oracle
ls -ltr
drwxrwxr-x 4 ora11gr1 dba 8192 Aug 30 00:19 oraInventory

now when i install oracle 11g rel2 on the same machine, it should use the existing oraInventory..but it is prompting us to enter the new location for oraInventory during installation....but as per the naming convention, we need to keep inventory directory under /oracle/oraInventory only..

when i select oraInventory location as /oracle/oraInventory from wizard, iam getting below error:

[INS-32055] The Central Inventory is located in the Oracle base.

[INS-32035] Unable to create a new central inventory at the specified location.

should i uninstall the exisitng oracle 11g rel1 and then should i install rel2 (i.e what iam trying to install now ) ?if so, after instlaling rel2, then should i install rel1 ?

View 4 Replies View Related

Server Administration :: Location Of Table In Tablespace / Data File

Jul 6, 2010

I was wondering if there is any way to know in which Tablespace and Datafile my Table is located. I have exported a table and about to delete it as i am partitioning it.

View 9 Replies View Related

Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies View Related

Forms :: Get Block Name From Cursor Focus Location?

Jul 27, 2010

I have a delete button at the bottom of the form and have two blocks on top of it. I need to know which block i have the focus on or selected the record on pressing the delete button so that I go to that block and do a delete_record from that block. I came across :system.trigger_block which says it gives the name of the block where the cursor was located when the current trigger initially fired. But whenever i use it only returns the name of the block the delete button is located in. Instead i wanted to know where the focus of the cursor was or which record was selected in the above 2 blocks to go to that block and delete the record.

View 1 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 :: How To Get Number Of Empty Block

Mar 31, 2012


------------- --------
683 8




no data found


------- ----------
686 1
684 1
687 1
685 1
688 1
683 4


in the ⑧ step,why block#685,block#686,block#687,block#688 in the buffer cache after i query data from scott.T2012?

in the ⑨ step,what's the block number of the empty block?just like DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID).

View 2 Replies View Related

Server Administration :: Calculate Used Space In A Block

Nov 17, 2011

Is there any way I can calculate percentage of space used in a block.Eg if a table size is 100 blocks,How Can I check the percentage of used space in block.

View 6 Replies View Related

Server Administration :: How To Know Which Block Contains Free Space

Feb 26, 2013

for some reason,i want to know which data block contains free space,or which table/index contains free space.

View 6 Replies View Related

Server Administration :: Data Block Corruption

May 12, 2011

1) What is PHYSICAL/LOGICAL Corruption.
2) How it occurs.
3) Will RMAN works on both the types of corruption or only Physical (My senior told it works on both).

View 3 Replies View Related

Server Administration :: Status Of Anonymous Block Program?

Jan 4, 2012

One of our developers team member had created a Anonymous block program to do something in the Database, and he forgotten and terminated the session without confirming the program's status, whether it was fully ran or not.

Is there any way to check out the status of this, which happened yesterday?

View 3 Replies View Related

Server Administration :: Specifying Nonstandard Block Sizes For Tablespaces?

Jan 6, 2011

We are creating non standard blocking size for 16k and so accordingly have to set the parameter db_16k_cache_size.

if have any thumb rule for setting the value for this parameter.

View 5 Replies View Related

Server Administration :: Fractured Block During Buffer Read?

Nov 17, 2011

I am in charge of several instances located on a Linux server CentOS, virtualized on a ESX 3.5 environment.

From time to time (every 4 to 5 days), I have some errors in the alert.log. Last occurence was last night :

Corrupt block relative dba: 0x01004e12 (file 4, block 19986)
Fractured block found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x01004e12
last change scn: 0x0000.131aaa5b seq: 0x2 flg: 0x04
[Code] ........

We are doing user manual backup (with BEGIN/END BACKUP) every night at 8PM, ending at 9PM approx. Then, fractured blocks never occur during backups. At 1AM, the maintenance window is opening, thus explaining the GATHER_STATS_JOB job.

When I check corruption on early morning, I am always unable to reproduce the problem. DBV is OK without issues. We never had a problem with the data itself, whatever it is a table or an index in the reported failed block.

I would like to know what could cause these logical corruption, and how to stop them ?

View 7 Replies View Related

Server Administration :: Block Corruption - Segment Not Found

May 16, 2012

I have a database where view v$database_block_corruption shows a corrupted block

SQL> select * from v$database_block_corruption;

---------- ---------- ---------- ------------------ ---------
4 756652 1 5.5157E+12 CORRUPT

I am not able to get the relevant segment from the above information

SQL> select segment_name, segment_type, owner
2 from dba_extents
3 where file_id = 4
4 and 756652 between block_id
5 and block_id + blocks -1;

no rows selected

DBVERIFY - Verification complete
Total Pages Examined : 3932160
Total Pages Processed (Data) : 3119107
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 755048


I have uploaded the complete logfile.

Below is a part of logfile

DBVERIFY - Verification starting : FILE = /prd/dvp/ora/oradata/LHF/disk06/gds_t01_01.dbf
Block Checking: DBA = 21728172, Block Type = KTB-managed data block
**** kdxcoavs = -84 < 0, avail = 3129
---- end index block validation
Page 756652 failed with check code 6401
##not here that 756652 is the same block# mentioned in v$database_block_corruption

here i tried finding the OBJECT ID as below

SELECT dbms_utility.data_block_address_block(21728172) "BLOCK", dbms_utility.data_block_address_file(21728172) "FILE" FROM dual;
---------- ----------
756652 5

Now for the same BLOCK it is giving different File, again the segment_name or segment_id could not be found from the above information.

View 4 Replies View Related

Server Administration :: Control File And Database Block Size?

Oct 24, 2011

SQL> select block_size from v$controlfile;


SQL> show parameter db_block_size;

------------------------------------ ----------- ------------------------------
db_block_size integer 8192

the 2 can have difference block size?

View 3 Replies View Related

Server Administration :: ORA-01578 - ORACLE Data Block Corrupted

Sep 4, 2012

I am having 3 oracle database instances running on 3 seperate Linux Node(RHEL Node).

Instance -1 named - DS
Instance -2 named - MIS
Instance -3 named - OAS

Among of these 3 nodes, we are facing Block Corruption issues with sysaux tablespace.Error in Instance name DS is

Errors in file /u01/home/dba/oracle/diag/rdbms/ds4db/DS/trace/DS_j000_655388.trc (incident=300847):
ORA-01578: ORACLE data block corrupted (file # 2, block # 38428)
ORA-01110: data file 2: '/DSdb1/dssysaux.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
GATHER_STATS_JOB encountered errors. Check the trace file.

for this I googled and found some solution as oracle doc [430230.1] related to sysaux couruption.After this again we are facing the same issue in sysaux tablespace.

View 19 Replies View Related

Server Administration :: Ora-00333 / Redo Log Read Error Block 203 Count 8192

Apr 17, 2010

When i was starting my database .there was an error

ora-00333:redo log read error block 203 count 8192.

View 1 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. */
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;


View 1 Replies View Related

Server Administration :: Multi-block Disk Reads For Index Range Scans?

Aug 31, 2010

My understanding of DB_FILE_MULTIBLOCK_READ_COUNT parameter is that it affects only Full Table Scans and Fast Full Index Scans - all other disk retrieval is single block.If so, then maybe I'm reading this trace incorrectly:

select /*+ first_rows */ pk
from test_join_tgt
where pk >= 0
and rownum > 1

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 21.48 27.77 22368 22134 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 21.49 27.78 22368 22134 0 0

What the heck is going on with the Multi-block reads in the Range Scan?

View 3 Replies View Related

Server Administration :: ORA-00607 / Internal Error Occurred While Making A Change To A Data Block

Mar 12, 2010

Error is occurred during the transaction...i.e.

ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [89], [83], [], [], [], [], []

View 7 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 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

Backup & Recovery :: RMAN Restoration To New Location In Same Server

Nov 29, 2012

We need to test mean time to restore from rman backup. So can we restore the data file to new location on the same server without effecting the Database.?

View 4 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 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


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

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

Oct 5, 2010

We are working on migrating from 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 - 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 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path


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

Bash_profile Location In IBM AIX?

Sep 30, 2010

Where will i find the bash_profile location in IBM AIX server.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved