Oracle Database Concepts 11gr2 - Incremental Checkpoints Behavior?
May 3, 2012
Oracle database concepts 11gr2 manual states that "An incremental checkpoint is a type of thread checkpoint partly intended to avoid writing large numbers of blocks at online redo log switches. DBWn checks at least every three seconds to determine whether it has work to do. When DBWn writes dirty buffers, it advances the checkpoint position, causing CKPT to write the checkpoint position to the control file, but not to the data file headers."
As i have understand the DBWR write DIRTY BUFFER (that are under active checkpoint requests in the ACQ) to the datafiles from The Buffer Checkpoint Queues and after that the CKPT process may write the checkpoint RBA to the control files.[URL]...
The CKPT porcess write the chekpoint RBA to the controlfile after that the DBWR write the Dirty BUFFER in the datafiles, so as i understand at some point the datafiles containt block with higher RBA than the controle files. am i wrong ?
So if the instance craches before the CKPT record the chekpoint RBA in the controlfile what will be the recover behavior.Will the redo record be reapplied from the last recoded chekpoint RBA in the controlfile to the tail of the log ?
View 2 Replies
ADVERTISEMENT
Aug 29, 2012
the rman backup script for weekly full backup and daily incremental backups with configure commands for oracle 11g database.
View 10 Replies
View Related
Jun 26, 2012
I have oracle 10g running on oracle ASM 11.1, I want to know that if i install oracle 11gr2 database , can i use oracle 11.1 ASM which is already installed ?
View 5 Replies
View Related
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
Feb 19, 2013
1. oracle 11gr2 64 bit database software installed
2. oracle 11gr2 32 bit clinet software installed
The above software has been installed on server, Pop pup- Error messages coming during installing 3rd party software packages...on server.
Error is - igrORASPConnect412.dll not register...
what could be issues & how to resolve this problem? do we need to reinstall client software again not available this DLL file after searching on oralce home directory .
View 1 Replies
View Related
Mar 18, 2011
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
View 1 Replies
View Related
May 28, 2012
"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"
Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
View 4 Replies
View Related
Oct 31, 2013
I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.
View 6 Replies
View Related
Mar 24, 2013
i have a .dmp file and i want to use the data in this file for my further practices. so, i need to dump the data in the .dmp file to the any schema exists in data base.
View 1 Replies
View Related
Feb 9, 2012
We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.
I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.
We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.
Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.
This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.
View 4 Replies
View Related
May 2, 2011
I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.
View 6 Replies
View Related
Jul 23, 2013
The full statement is:
SELECT v.key$ FROM VERSION_TABLE v, DOCUMENT_TABLE d, CLASS_TABLE z WHERE
v.documentKey = d.key$ AND
d.classKey = z.key$ AND
z.key$ IN (SELECT zz.key$ FROM CLASS_TABLE zz
START WITH zz.name = 'esDTTemplate'
CONNECT BY PRIOR zz.key$ = zz.parentKey) AND
v.ESGROUP = 'SearchOperatorsMapping' ORDER BY d.name
Now I noticed that the subquery is never used to seed the join: indexes - if any - are used. Otherwise a full table scan is performed.In the example - if ESGROUP is indexed, then it's chosen to start the join evaluation. If not, a full table scan is performed.Is there any way to suggest to the optimizer to use the subquery in case there are no indexes - as a fallback ?
In the above example where VERSION_TABLE contains nearly two million records, the no index solution takes 60 secs. vs. less than 1 sec. in the index case.Wrapping the hierarchical query in a inline view leads to same result.
PS: the execution plan (without index) is:
-------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
-------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 9 (100)| |
| 1 | SORT ORDER BY | | 1 | 171 | 9 (23)| 00:00:01 |
|* 2 | HASH JOIN SEMI | | 1 | 171 | 8 (13)| 00:00:01 |
[code]...
View 3 Replies
View Related
May 1, 2011
The logic between Oracle and MySQL's functionality is reversed in a way that ctx_rule will allow for logical operators within the columns index, allowing for plain text to be passed without any logic e.g
Oracle:
usa OR united states of america AND michigan
MySQL:
usa united state of america michigan
and MySQL expects it before hand.
In the above example, I have to figure out the operator logic before sending the credentials to MySQL e.g.
MATCH (location_rule) AGAINST ('+usa +"united states of america" +michigan' IN BOOLEAN MODE) AS score
I don't want or have the capability of figuring out the operators before hand with the user input
How can I mimic oracles rule index with MySQL?
View 2 Replies
View Related
Oct 15, 2012
In Oracle 11g/R2, I created replica of HR.Employees table & executed the following statement (+Although using SUM() function is non-logical in this case, but just testifying the result+)
STEP - 1
SELECT /+ RESULT_CACHE */ employee_id, first_name, last_name, SUM(salary)*
FROM HR.Employees_copy
WHERE department_id = 20
GROUP BY employee_id, first_name, last_name;
EMPLOYEE_ID FIRST_NAME LAST_NAME SUM(SALARY)
-------------------------------------------------------------------------------------------------------
202 Pat Fay 6000
201 Michael Hartstein 13000
Elapsed: 00:00:00.01
Execution Plan
----------------------------------------------------------
Plan hash value: 3837552314
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | 130 | 4 (25)| 00:00:01 |
| 1 | RESULT CACHE | 3acbj133x8qkq8f8m7zm0br3mu | | | | |
| 2 | HASH GROUP BY | | 2 | 130 | 4 (25)| 00:00:01 |
|* 3 | TABLE ACCESS FULL | EMPLOYEES_COPY | 2 | 130 | 3 (0)| 00:00:01 |
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
*690* bytes sent via SQL*Net to client
416 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
2 rows processed
STEP - 2
INSERT INTO HR.employees_copy
VALUES(200, 'Dummy', 'User','Dummy.User@email.com',NULL, sysdate, 'MANAGER',5000, NULL,NULL,20);
STEP - 3
SELECT /*+ RESULT_CACHE */ employee_id, first_name, last_name, SUM(salary)
FROM HR.Employees_copy
WHERE department_id = 20
GROUP BY employee_id, first_name, last_name;
EMPLOYEE_ID FIRST_NAME LAST_NAME SUM(SALARY)
--------------------------------------------------------------------------------------------------
202 Pat Fay 6000
201 Michael Hartstein 13000
200 Dummy User 5000
Elapsed: 00:00:00.03
Execution Plan
----------------------------------------------------------
Plan hash value: 3837552314
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 3 | 195 | 4 (25)| 00:00:01 |
| 1 | RESULT CACHE | 3acbj133x8qkq8f8m7zm0br3mu | | | | |
| 2 | HASH GROUP BY | | 3 | 195 | 4 (25)| 00:00:01 |
|* 3 | TABLE ACCESS FULL| EMPLOYEES_COPY | 3 | 195 | 3 (0)| 00:00:01 |
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
4 consistent gets
0 physical reads
0 redo size
*714* bytes sent via SQL*Net to client
416 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
3 rows processed
In the execution plan of STEP-3, against ID-1 the operation RESULT CACHE is shown which shows the result has been retrieved directly from Result cache. Does this mean that Oracle Server has Incrementally Retrieved the resultset?
Because, before the execution of STEP-2, the cache contained only 2 records. Then 1 record was inserted but after STEP-3, a total of 3 records was returned from cache. Does this mean that newly inserted row is retrieved from database and merged to the cached result of STEP-1?
If Oracle server has incrementally retrieved and merged newly inserted record, what mechanism is being used by the Oracle to do so?
View 2 Replies
View Related
Aug 6, 2012
After upgrading 11gR1 database (11.1.0.7.0) to 11gR2 (11.2.0.3.0), the datapump exports have been taking quite a bit longer. When database was 11gR1, a full expdp took approx. 40-45 minutes. After upgrade, it takes approx. 1 hour 40-50 minutes. These times were with parallel=4. I tried with parallel=8 and parallel=12, both of these took around 1 hour 5-10 minutes, better but still quite a bit slower than pre-11gR2 upgrade. I tried with exclude=statistics, index_statistics, indexes; it still took approx. 1 hour 40-45 minutes. This is a PeopleSoft database so there are many, many objects to be exported. The database was upgraded using dbua.
View 1 Replies
View Related
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
Jul 27, 2012
I 'm trying restore database 11GR1 on other host with 11GR2.Using this steps:
>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jul 27 09:00:32 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/password@PRD
Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 11.1.0.7 required
[code]...
QUestion:
Is posible do this?
View 6 Replies
View Related
Jun 26, 2012
I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies
View Related
Sep 10, 2013
I have stand alone 11gR2 database. Do I need to configure the listener and have the tnsnames.ora file entries under Grid home and start the listener from Grid home or do I need to start from Oracle database home?
View 5 Replies
View Related
Mar 28, 2012
Can we restore database password file in ASM for 11gR2 version.
View 4 Replies
View Related
Dec 15, 2012
I am trying to restore 11gr2 database to point in time. using following steps:
Control files are fine, that are not restored.
RMAN> run
{
set until time "to_time('2012-12-13 12:12:00','YYYY-MM-DD HH24:MI:SS')";
}
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
Here my problem is it is restore complete data what ever i was having, but i don't was it, i has to restore up to specified time only.
View 2 Replies
View Related
Jul 15, 2013
How to connect to database with windows authentication:
OS system: 2008 R2 windows
oracle : 11.2.0.3
sqlnet.ora set to NTS.
also user is created on database externally "domain/username"
i want to connect to the database with my windows account!
View 4 Replies
View Related
Sep 12, 2013
here is the error faced when installing oracle 11gR2,
ERROR:
Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/.colorls9rT/OraInstall2013-09-12_03-59-57PM/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751)
[code]...
View 1 Replies
View Related
Aug 8, 2011
I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?
View 3 Replies
View Related
May 11, 2011
Any experience before on Oracle 11gr2 RAC to RAC via EMC SRDF setup?
View 5 Replies
View Related
Nov 25, 2011
Im planning to upgrade oracle10g to 11gr2.. i have query on that ..
my 10g having ORACLE_HOME=/app/ora/10.2.0, orainventory =/app/ora/oraInventory
new 11g ORACLE_HOME=/app/ora/11.2.0 .orainventory =?
my question is where i need to set ora inventory location for my new 11g? or it will create new location for that?
OS version : IBM AIX
View 3 Replies
View Related
Sep 29, 2010
Yesterday I was installing 11.2.0.2 patch to our Oracle 11gR2(11.2.0.1.0) Two node RAC cluster on OEL 5.4 x86 Linux.Before installing I have read [URL] support note which says "Note: All Oracle Grid Infrastructure patch set upgrades must be out-of-place upgrades, in which you install the patch set into a new Grid home. In-place patch set upgrades are not supported. "
During Installation I found following Installation Option :
1) Install and configure Oracle grid Infrastructure for a cluster
2) Configure Oracle Grid Infrastructure for a Standalone Server
3) Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management
4) Install Oracle Grid Infrastructure Software Only
Which option should I have to choose here ?
View 1 Replies
View Related
Sep 13, 2010
I have Windows server working Oracle 8.0.5.I have to migrate to another server that is Oracle 11gR2 on Windows 2008.Some say I can't do Export and Import directly.And some say DBlink is not working from 11Gr2 to 8.
What can be fewest step to migrate?Somebody try to use 'Oracle directory' and VB and Powerbuilder program to send data and DDL from 8 to 11Gr2.
migrating from Oracle 8.0.5 to 11Gr2 machine.
View 6 Replies
View Related
Oct 16, 2012
I am building a database to store call quality statistics for VOIP networks. It is a very insert heavy application, and data reliability is of relatively minimal importance (in the sense that a few corrupt call records here and there doesn't matter the way corruption does in for example a banks database). Long term storage is also unimportant, most customers only wish to keep 3 months of data readily available in the database. Most do not even archive the older data.
To that end I am searching for every possible way to improve my insert performance and the internet has turned me onto the idea of NOLOGGING. These are the steps I have taken to reduce my IO consumed by the Redo and Undo logs.
1. I am inserting with the APPEND_VALUES hint.
2. I have disabled force logging at the database level
3. I have disabled force logging at the tablespace level
4. I have disabled logging on the relevant table and each of its indices
As best I can tell this is all I can do to minimize Redo/Undo, but based on my observations of the Disk portion of the WinServer2008 Performance Monitor, this has made little to no change in the amount of IO to my REDO and UNDO files. IO to the .dbf containing my table makes up less than 20% of the total disk IO for oracle.exe, the rest is the REDO and UNDO logs.
asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:897564200346274711
The above article is a little over my head but I am able to extract from it that I will never entirely eliminate REDO/UNDO, which is fine, but I would think I could get it lower than it currently is.ted.
View 26 Replies
View Related
Jun 6, 2013
oracle 11gr2
linux
how to generate insert script by using command prompt. Actually am using toad generating insert statement but it is taking too long time to generate.
View 4 Replies
View Related
