Buffer Gets And Logical Reads?

Jun 27, 2012

Does the counter of event buffer gets include the logical reads ? Does the mertic buffer gets include the event of reading from undo buffer ?

View 4 Replies


ADVERTISEMENT

Data Guard :: How To Change Logical Database Primary To Logical

Jun 9, 2011

We have 2 node (n1 nad n2 ) RAC and 3rd node (n3) with Dataguard logical database for reporting ..

1. logical database (n3) not syn with primary (n1,n2)
2. During repair above mentioned problem by mistake my logical(n3) also become primary
3. now how I will again change my n3 to logical
4. I got following error

RE: ORA-16009: remote archive log destination must be a STANDBY database

View 1 Replies View Related

Difference Between Cache Buffer Chain Latch And Buffer Busy Wait

Jul 30, 2012

Does cache buffer chain latch and buffer busy wait event are related to one any another.

Latch definition from Google says : Latches are simple, low-level serialization mechanisms to protect shared data structures in the system global area (SGA).

what does it mean my protect. Does this mean protects from aging as per LRU algorithm and getting removed from SGA
or
protect from other processes ,say from example from simultaneously DML operations.
or
both

Does buffer busy wait event occurs , because of the cache buffer chain latch ?

View 3 Replies View Related

AWR Report (SQL Ordered By Physical Reads)

Aug 30, 2013

AWR Report regarding ' SQL ordered by Physical Reads (UnOptimized))'. SQL ordered by Physical Reads (UnOptimized)UnOptimized Read Reqs =

Physical Read Reqts - Optimized Read Reqs %Opt - Optimized Reads as percentage of SQL Read Requests %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs Total Physical Read Requests: 3,311,261 Captured SQL account for 13.5% of Total Total UnOptimized Read Requests: 3,311,261 Captured SQL account for 13.5% of Total Total Optimized Read Requests: 1 Captured SQL account for 0.0% of Total UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%TotalSQL IdSQL ModuleSQL
[code]....

I want to know what is the mean by 'UnOptimized Read Reqs' and 'Optimized Read Reqs 'Question 2) what is 'SQL ordered by Physical Reads tuning'.

View 2 Replies View Related

SQL & PL/SQL :: Query Taking 80000 Reads To Execute

Apr 23, 2012

Attached query taking 80000 reads to execute...

View 8 Replies View Related

Performance Tuning :: Definition Between 2 Metrics Physical Reads

Nov 21, 2011

On 10gR2, I cannot find the exact definition of the 2 following metrics :

"Physical Read Total Bytes Per Sec"
and
"Physical Read Bytes Per Sec"

I would want to know what is the difference between them.

View 3 Replies View Related

PL/SQL :: High Consistent Reads / Cannot Replicate In Test Environment

Feb 8, 2013

I am having performance issues on a query in a production environment that I cannot replicate in our test environment. Our test environment is an import of production. Version information is:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE     10.2.0.3.0     Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - ProductionWhen I run the query in test, I get the following results using TKPROF
[code]....

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWSThis performance problem started a few weeks ago and the problem seems to be in the high number of consistent reads during fetch. The DBA tried restarting the instance and gathering fresh stats on the tables but that has not made a difference. Now he wants to export the tables, drop the schema and re-import.

View 8 Replies View Related

SQL & PL/SQL :: Write A Code Which Dynamically Reads The Table Name From User_tables?

Oct 7, 2013

Firstly the table structures :

Create table cd_patient (pat_mrn varchar2(100)) ;
Create table cd_encount (pat_mrn varchar2(100), encounter_id varchar2(1000));

I need to write a code which dynamically reads the table name from user_tables (starting with cd) & load the data from remote database which has the same table name & structure based on the load number..

Static PLSQL statement would be :

declare
BEGIN
INSERT INTO "cd_patient" C-- DYNAMICALLY GET THE TABLE NAME
SELECT C1.PAT_MRN -- DYNAMICALLY GET THE COLUMN NAME
FROM REMOTE_DB.CD_PATIENT@XXX C1
WHERE C1.LOAD_NUMBER > 2;

[code]....

View 11 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
[code]...

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

View 3 Replies View Related

Logical Standby / Streams?

Feb 3, 2012

Source DB is logical standby 10.2.0.5
Destination DB is 11.2.0.3

Is it possible to set up streams on the logical DB to replicate some schemas to the 11gR2 DB?

View 10 Replies View Related

Creating MV Logs In Logical Standby DB?

Dec 10, 2010

I am trying to create materialized views based on a few tables in a logical standby database.

The target database (11g R2) where the MVs will be created is a stand-alone database.

The DB where the base tables reside is a logical standby database (11g R2).

The requirement is to do a "FAST REFRESH" of the Materialized Views.

My questions are :

1. Can I create MV logs in the logical standby DB?

2. If the answer to question no. 1 is "Yes", do I need to do anything different or configure the logical standby DB in a specific manner in order to create MV logs. From what I understand, the objects in the logical standby database are in a locked state.

View 2 Replies View Related

SQL & PL/SQL :: Logical Difference Between Delete And Truncate?

May 7, 2012

when we try to truncate the parent table data although its child tables are empty, the oracle oracle throws an error--"ORA-02292: integrity constraint test_id_constr violated - child record found" , but when we delete this parent table data by "delete" statement then it gets deleted. what is the logic behind "truncate".

View 3 Replies View Related

Data Guard :: Windows To Aix (logical)

Oct 18, 2010

I have a Windows 2003 server with Oracle 10.2.03 database residing in one datacentre, with Dataguard configured to a physical standby in a similar location (proven process that works great).

I now have a requirement to transfer and synchronize the same live database to a database in a different country (AIX box), purely for data purposes not failover etc. I can transfer an export of the Database and have this up and running as a logical database of the live on AIX, but is it then possible to configure dataguard on the Windows server to also send updates to this logical database on the AIX system? Thus keeping them in sync with each other?

View 1 Replies View Related

Can Logical Database Be Applied From Physical Standby

Jul 24, 2013

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?

View 2 Replies View Related

Data Guard :: Oracle 9i Logical Standby

Feb 28, 2012

There are two servers.one in HP-UNIX and another is solaris.

I would like to configure a logical standby using oracle 9i...Is it possible in 9i?

View 7 Replies View Related

Real Time Apply For Logical Standby

Nov 15, 2012

Oracle 11.2.0.3.0

I have a primary database orcl and logical standby database orcl_std.

Real time apply is enabled. I have standby redologs in both primary and standby sides and I`ve started recovery with below command:

ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

When I create a new table in primary database, I am unable to see it on standby database (Although real time apply is enabled) However, when I switch log in primary, I can see the new table in standby database.

My question is, why realtime apply is not working in my scenerio ? I was expecting to see the new table immediately in standby database once it is created in primary database. Why am I supposed to wait for log switch in real time apply ?

View 5 Replies View Related

Logical Backup Of All Application Tables At Regular Intervals

May 18, 2010

I want to maintain the logical backup of all the application tables At regular intervals. Which option would i use?

View 1 Replies View Related

Recovery Manager (RMAN) :: Physical And Logical Standby?

Aug 29, 2013

,I have a test environment with Primary DB Server, Physical Standby and Logical Standby.The Logical Standby DB (cur_log_stdb) is backed up every evening by RMAN and I have a question:If I recover my Logical Standby DB from backup and switch replication to new Logical Standby DB (new_log_stdb) it will work or not?My steps e.g.:1. Make a new server for my new_log_stdb and repair structure of catalogs;2. Repair listener.ora and tnsnames.ora files from cur_log_stdb to new_log_stdb;3.

Restore DB with RMAN from backup to new_log_stdb;4. On cur_log_stdb execute "alter database stop logical standby apply";5. Change a DNS name from cur_log_stdb to new_log_stdb;6. On new_log_stdb execute "alter database start logical standby apply immediate";I'm not sure that archivelogs will apply to the new_log_stdb for period since rman backup was created.  Configuration:Oracle Linux 6.4Oracle Database 11.2.0.3Primary and Physical with Data Guard

View 1 Replies View Related

Data Guard :: Convert Logical To Physical Standby?

Oct 9, 2012

Can we convert a logical standby to physical standby? Yes or No, if yes how ..

View 7 Replies View Related

Data Guard :: How To Skip Delete On Logical Standby

Oct 11, 2013

On next month i will have plan to delete history data on my Primary database, but i still want to keep them in logical standby as the data warehouse. So, how can i skip delete statement from primary database apply to logical standby.

Oracle SQL apply only support for Skip DML but not for keep delete statement

(on 10g and 11g)SQL>exec dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT');BEGIN dbms_logstdby.skip(statement => 'DELETE',schema_name => 'SCOTT', object_name => 'DEPT'); END;  *ERROR at line 1:ORA-06550: line 1, column 7:PLS-00306: wrong number or types of arguments in call to 'SKIP'ORA-06550: line 1, column 7:PL/SQL:

View 15 Replies View Related

Logical Corruption In Oracle Database - Invalid RowID Error

Jul 30, 2012

I observed logical corruption in one of the database, while running select on some tables observed ORA-01410: invalid ROWID error. These errors or errors related to this logical corruption are not reported in alert log file.

Since our database is in NOARCHIVELOG mode and regular backups are not happening through RMAN (weekly cold mount point backup to tape),
i was not able to use RMAN to investigate block corruption.

So used DBVERIFY on all datafiles of database to check the consistency of datafiles, and found DBV gives error for one of the datafile - 'Completely zero block found during dbv:' As i mentioned earlier, we are not taking regular backups using RMAN and database is in NOARCHIVE mode.

View 2 Replies View Related

Data Guard :: Logical Standby On Windows Server 2008

Sep 8, 2010

Can i create logical_stand_by for windows server 2008, the primary data base is HP UX , both operating systems are 64 bits and data bases are Oracle 10g 10.2.0.1.0.

View 6 Replies View Related

Data Guard :: RAC To Single Instance Logical Standby Creation

Jul 24, 2012

I am not able to find any document that shows steps to create a SINGLE INSTANCE LOGICAL STANDBY database for a 2 NODE ORACLE RAC database. I have found documents for RAC to Single Instance Physical standby database. But not for Logical Standby.

Details:

OS: Redhat 5
DB: 10.2.0.4(shared file system, not using ASM/Standby also file system)
Status: Single instance physical standby database created, need to convert it to Logical standby.

View 11 Replies View Related

Data Guard :: Can A Logical Database Be Applied From A Physical Standby

Jul 25, 2013

I have a setup where i have one physical and logical standby from a primary database. In case of switch over between primary and physical database my logical apply gets stopped. Can a logical database be applied from a physical standby ?

View 5 Replies View Related

Server Administration :: Split Existing Schema Into 3 Logical Divisions

Mar 2, 2011

Presently have one instance, one Schema on my DB Server. Want to split the existing schema into 3 logical divisions. Have created the 3 Schemas. Through Oracle Export from the old Schema am able to Export (using wild cards) the tables and indices for each grouping and am able to Import into the new specific schema. The problem i'm having is that i cannot seem to Export the specific sequences due for each of the new schemas. Is there an easy way to accomplish this?

View 6 Replies View Related

Automatic Storage Management :: Create A Raw Device On A Logical Volume?

Mar 4, 2013

The db is 11.2.0.3 on a linux machine.

Is it possible to create a raw device on a logical volume WITHOUT cluster service from os vendor such as HACMP(AIX), Service Guard(HP)?

The following is os information.

[aa@mm01(abc):/home/abc] uname -a
Linux aa 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[aa@mm01(abc):/home/abc]

View 3 Replies View Related

Data Guard :: Implement Logical Standby Database For Reporting Purposes

Apr 14, 2010

I working on a Production Environment, where our Database is running on a IBM-AIX platform.I need to implement Logical standby database for reporting purposes, in order to improve the performance.Now the transaction and the reporting is done at the same site itself.I want to know that, operating system and platform architecture (RAM size, no. of CPUs, ORACLE_HOME etc..) on the primary and standby systems must be same or can be different. complete configuration for Dataguard. My os version is,

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 1 Replies View Related

Data Guard :: Restoring Logical Standby Rman Backup On Production

Oct 9, 2012

I have One Production and one logical standby database . Due to tape problem we are unable to take backups of primary . And due to business , we cannot take back up on disk in hot period(Bank database ) .

If i take logical standby database backup(level 0 ) using RMAN , then will i be able to restore it on production dtbs (In case Production down) ? . Logical standby is in sync with primary .

View 2 Replies View Related

Backup & Recovery :: Logical Block Corruption - Recreate SYSMAN Schema Index

Mar 3, 2010

I am facing problem of logical block curruption.

SQL> select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
3 61454 1 1417157166 LOGICAL
3 31256 1 1417011117 LOGICAL

OWNER CONSTRAINT_NAME C TABLE_NAME
------------------------------ ------------------------------ - ------------------------------
SYSMAN MGMT_METRICS_RAW_PK P MGMT_METRICS_RAW

Can i recreate the SYSMAN schema index by dropping this one?

View 17 Replies View Related

Buffer Used In Export?

Apr 12, 2013

I would like to know the buffer size using by our dba when he set export?

I know that it's possible to define it when we realize the export but its possible to know this value after export?

There's a sql*plus command to find this value?

N.B : we dont have documentation

Its for an urgent need.

View 1 Replies View Related







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