f



Comparisons Oracle 11.1.0.7 to Oracle 10.2.0.4

I have made some performance comparison tests on test computers and it has 
turned out that the Oracle 11 databases are in general slower compared to 
the Oracle 10 databases by 10 to 30%. The databases are running on Windows 
Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gives 
some enhancements because in general there are not many advantages regarding 
new features useable for us.

Has someone made similar comparison results?

Arne Ortlinghaus
ACS Data Systems 

0
10/22/2009 9:37:25 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

12 Replies
1514 Views

Similar Articles

[PageSpeed] 43

On Oct 22, 5:37=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:

snip

> I have made some performance comparison tests on test computers and it ha=
s
> turned out that the Oracle 11 databases are in general slower compared to
> the Oracle 10 databases by 10 to 30%. The databases are running on Window=
s
> Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gi=
ves
> some enhancements because in general there are not many advantages regard=
ing
> new features useable for us.
>
> Has someone made similar comparison results?

That has not been the case for us but we are running on Linux 64 bit
systems.

When you say "on test computers" that makes me nervous.  One has to be
very careful to get identical environments.  One has to look very
carefully at oracle settings between the environments.

0
johnbhurley (2707)
10/22/2009 11:18:49 AM
On Oct 22, 5:37=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> I have made some performance comparison tests on test computers and it ha=
s
> turned out that the Oracle 11 databases are in general slower compared to
> the Oracle 10 databases by 10 to 30%. The databases are running on Window=
s
> Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gi=
ves
> some enhancements because in general there are not many advantages regard=
ing
> new features useable for us.
>
> Has someone made similar comparison results?
>
> Arne Ortlinghaus
> ACS Data Systems

I have tested the performance of 10.2.0.4 and 11.1.0.7 on 64 bit
Windows.  If I recall the test results correctly, you will find that
with STATISTICS_LEVEL set to ALL you will see that 11.1.0.7 is
significantly faster than 10.2.0.4 in all but the most simple SQL
statements - in such a case 10.2.0.4 might consume a lot of system
(kernel) mode CPU time, while 11.1.0.7 consumes considerably less.

While testing 10.2.0.4 and 11.1.0.7, I found that 10.2.0.4 was
typically slightly faster than 11.1.0.7 when the exact same execution
plan was obtained for a SQL statement and the STATISTICS_LEVEL was set
to TYPICAL.  11.1.0.7 occasionally found a different execution plan
than 10.2.0.4, partially influenced by the presence (or absence) of
system WORKLOAD statistics.

If you would, please determine if the execution plans are identical
between the two Oracle releases.  You might also check the system
statistics in SYS.AUX_STATS$, and the various initialization
parameters to make certain you are comparing the two Oracle releases
with the same inputs.  The location of the data files for the two
releases could also influence performance - more data passes under the
read-write heads per revolution on the outer tracks of the hard disks,
so that could yield better performance for the Oracle release with
data files located closer to the outer hard disk tracks.

What do you find is slower?  Are you checking the execution time of a
process with a stop watch, checking the wait events, monitoring the
CPU utilization, creating a Statspack Report, or something else?

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
0
hooperc2000 (791)
10/22/2009 11:27:43 AM
John and Charles,

thank you for your answers.

Testcomputers mean in this case that I installed on each of these computers 
two databases with identical data. Then I made performance tests against 
both databases one or multiple times. For the performance tests I used 
evaluations on own data and I took "Swingbench" from Dominic Giles using the 
"Order entry benchmark". Then without looking at the exact statement 
executions I compared the overall times. Of course there are so many 
possible parameters that the results may depend from the type we use the 
databases. So it is interesting to hear your results.

I will try STATISTICS_LEVEL set to ALL and will tell you the results.

Arne Ortlinghaus
ACS Data Systems

0
10/22/2009 12:45:08 PM
On Thu, 22 Oct 2009 11:37:25 +0200, Arne Ortlinghaus wrote:

> I have made some performance comparison tests on test computers and it
> has turned out that the Oracle 11 databases are in general slower
> compared to the Oracle 10 databases by 10 to 30%. The databases are
> running on Windows Vista and Windows 2003 64 Bit. We hope that the
> release 2 of Oracle 11 gives some enhancements because in general there
> are not many advantages regarding new features useable for us.
> 
> Has someone made similar comparison results?
> 
> Arne Ortlinghaus
> ACS Data Systems

This is meaningless unless you explain the exact meaning of the word 
"test". I still remember the fuss around the so called "Marketing 
Invention for Pushing Sales" or MIPS for short. It was a number, 
determined by running something called "Dhrystone test". It turned out 
that computer manufacturers were even putting special options into the 
compilers, to detect if they were compiling the Dhrystone test. As a 
result, the number produced was quite meaningless and did not have 
anything to do with the actual performance.
The statement that 11.1.0.7 is slower than 10.2.0.4 doesn't mean anything 
unless you tell us what exactly is slow? Oracle 11g has different memory 
management, it does full table scans differently, sometimes using direct 
reads into PGA, and has significantly improved optimizer.  I dislike the 
new memory management and moving memory from SGA to PGA and back. I don't 
have any numbers to substantiate my disliking it, but I think that the 
two kinds of memory should be kept separately as they're being used in 
completely different ways. 
Did you optimize the SQL in question on both 11g and 10g? Did you run the 
10046 trace to see what is it that the process is waiting on and 
addressed the gripe?



-- 
http://mgogala.freehostia.com
0
gogala.mladen (1153)
10/22/2009 12:51:36 PM
On Thu, 22 Oct 2009 14:45:08 +0200, Arne Ortlinghaus wrote:


> I will try STATISTICS_LEVEL set to ALL and will tell you the results.

Oh my god, you're playing a guessing game!



-- 
http://mgogala.freehostia.com
0
gogala.mladen (1153)
10/22/2009 12:59:17 PM
On Oct 22, 8:45=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
(snip)
> I will try STATISTICS_LEVEL set to ALL and will tell you the results.
>
> Arne Ortlinghaus
> ACS Data Systems

Just for the record, I only mentioned STATISTICS_LEVEL as a
demonstration of how a parameter could affect the execution time.
Setting the parameter to ALL at the SYSTEM level is not recommended.
I found one of my test results which is specific to a SQL statement
that had performance problems when I migrated the databases from
Oracle 8.1.7.3 to 10.2.0.2.  The test with the same SQL statement was
repeated on Oracle 10.2.0.4 and 11.1.0.7 on a different box running 64
bit Windows.  A brief summary of the results follows:
10.2.0.4 STATISTICS_LEVEL=3DTYPICAL                      6:56.73
10.2.0.4 STATISTICS_LEVEL=3DALL                       1:06:44.31
11.1.0.7 STATISTICS_LEVEL=3DTYPICAL                      5:35.58
11.1.0.7 STATISTICS_LEVEL=3DALL                          7:34.21

10.2.0.4 STATISTICS_LEVEL=3DTYPICAL (hinted access path)   14.39
10.2.0.4 STATISTICS_LEVEL=3DALL     (hinted access path)   16.36
11.1.0.7 STATISTICS_LEVEL=3DTYPICAL (hinted access path)   16.73
11.1.0.7 STATISTICS_LEVEL=3DALL     (hinted access path)   17.11

10.2.0.4 STATISTICS_LEVEL=3DTYPICAL (hinted,no phy read)    0.28
10.2.0.4 STATISTICS_LEVEL=3DALL     (hinted,no phy read)    2.65
11.1.0.7 STATISTICS_LEVEL=3DTYPICAL (hinted,no phy read)    0.23
11.1.0.7 STATISTICS_LEVEL=3DALL     (hinted,no phy read)    0.29

Depending on the environment, the above shows a performance spread of
0.28 seconds to 1 hour 6 minutes 44.31 seconds for Oracle 10.2.0.4.
Depending on the environment, the above shows a performance spread of
0.23 seconds to 0 hours 7 minutes 34.21 seconds for Oracle 11.1.0.7.

Note that the above is for a single SQL statement on the same server
with the same initialization parameters in both Oracle releases.  The
execution plan and wait events, however, differed for 10.2.0.4 and
11.1.0.7.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
0
hooperc2000 (791)
10/22/2009 2:02:49 PM
On Oct 22, 2:37=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> I have made some performance comparison tests on test computers and it ha=
s
> turned out that the Oracle 11 databases are in general slower compared to
> the Oracle 10 databases by 10 to 30%. The databases are running on Window=
s
> Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 gi=
ves
> some enhancements because in general there are not many advantages regard=
ing
> new features useable for us.
>
> Has someone made similar comparison results?
>
> Arne Ortlinghaus
> ACS Data Systems

See http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_sql_plan_ma=
nagement_11gr2.pdf

jg
--
@home.com is bogus.
http://www3.signonsandiego.com/stories/2009/oct/17/hedge-fund-billionaire-i=
ndicted-stock-fraud/?uniontrib
0
joel-garry (4553)
10/22/2009 5:55:26 PM
Mladen,

yes, you are right. It is true that with the tests I make I can see only few 
aspects. Since I try to use the new initialization parameters if possible it 
is also important to get some feedback.
For example until Oracle 10 we needed the two parameters
optimizer_index_cost_adj = 10
optimizer_index_caching = 99
in our database to have good performance. Until now the database 
underestimated always the benefits of indexes. In my tests until now it 
seems that Oracle 11 is predicting better without explicitly setting these 
parameters. But I have to make some further tests to be sure about that.

The results Charles has given in the email above are also interesting. In my 
eyes they show that there are no disadvantages moving to Oracle 11.

Our databases are a mixed type OLTP and Datawarehouse. Since we started with 
Oracle 8 we are used to try to simplify statements and to add indexes where 
possible. Surely every new version of Oracle gives new capabilities in 
executing complex queries better but possibly needs more overhead in 
processing simple statements. We will move to Oracle 11, but it depends a 
little bit on the actual results of our (subjective) tests when we will do 
this: in the following months or may be in half a year. Our problem is that 
with the same applications we have many small installations (one or two 
workplaces), where the database is on the pc of the user. We have many 
installations with 5 to 10 workplaces, and few important installations with 
50 workplaces or more. The smallest databases have few GB of data, the 
biggest are still below 1 Tera Byte of data and all of them should work with 
the same set of tables/indexes without optimizing each database differently.

Arne Ortlinghaus

0
10/23/2009 6:34:39 AM
Interesting,

so it seems that we can expect new possibilities in release 2?

Arne Ortlinghaus

"joel garry" <joel-garry@home.com> schrieb im Newsbeitrag 
news:f627ce99-0452-4db5-8bca-170fc1932f60@w37g2000prg.googlegroups.com...
On Oct 22, 2:37 am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> I have made some performance comparison tests on test computers and it has
> turned out that the Oracle 11 databases are in general slower compared to
> the Oracle 10 databases by 10 to 30%. The databases are running on Windows
> Vista and Windows 2003 64 Bit. We hope that the release 2 of Oracle 11 
> gives
> some enhancements because in general there are not many advantages 
> regarding
> new features useable for us.
>
> Has someone made similar comparison results?
>
> Arne Ortlinghaus
> ACS Data Systems

See 
http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_sql_plan_management_11gr2.pdf

jg
--
@home.com is bogus.
http://www3.signonsandiego.com/stories/2009/oct/17/hedge-fund-billionaire-indicted-stock-fraud/?uniontrib 

0
10/23/2009 6:40:51 AM
On Oct 23, 8:34=A0am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> For example until Oracle 10 we needed the two parameters
> optimizer_index_cost_adj =3D 10
> optimizer_index_caching =3D 99
> in our database to have good performance. Until now the database
> underestimated always the benefits of indexes. In my tests until now it
> seems that Oracle 11 is predicting better without explicitly setting thes=
e
> parameters. But I have to make some further tests to be sure about that.

What kind of System Statistics have you been using since Oracle 9i?
Instead of using optimizer_index_cost_adj (OICA) you should have a
look at System Statistics, which are enabled by default from Oracle
10g on, although their NOWORKLOAD defaults might not be appropriate
for your specific environment.

The optimizer_index_caching (OIC) is set to an extreme value, this
shouldn't be required under normal circumstances, in particular
together with OICA (which will lower the cost of certain operations
even more). You basically should see mostly NESTED LOOP joins with
index access. The question is then why Oracle with default settings
doesn't favor these access paths automatically.

Can you provide an example of an execution plan with default settings
and above custom settings that requires the settings to get the
desired "good" performance?

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/
0
mahrah (83)
10/23/2009 2:16:58 PM
This is a multi-part message in MIME format.

------=_NextPart_000_000F_01CA540C.5CE4F510
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Yes, it is true, there are normally nested loops in these execution plans. 
But nevertheless the results are coming faster then without. And this 
happens in many cases. I will furnish some execution plans next week.

The system statistics should be the standard ones. Attached I have one 
initora for Oracle 10 (InitA10...) and one for Oracle 11 (InitA11...) as we 
use it typically for the creation of databases only with the difference that 
the sga_target is much greater.

Arne Ortlinghaus
ACS Data System


"Randolf Geist" <mahrah@web.de> schrieb im Newsbeitrag 
news:0d5f7479-b657-42a1-9a55-f9bab2c2849c@r31g2000vbi.googlegroups.com...
On Oct 23, 8:34 am, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> For example until Oracle 10 we needed the two parameters
> optimizer_index_cost_adj = 10
> optimizer_index_caching = 99
> in our database to have good performance. Until now the database
> underestimated always the benefits of indexes. In my tests until now it
> seems that Oracle 11 is predicting better without explicitly setting these
> parameters. But I have to make some further tests to be sure about that.

What kind of System Statistics have you been using since Oracle 9i?
Instead of using optimizer_index_cost_adj (OICA) you should have a
look at System Statistics, which are enabled by default from Oracle
10g on, although their NOWORKLOAD defaults might not be appropriate
for your specific environment.

The optimizer_index_caching (OIC) is set to an extreme value, this
shouldn't be required under normal circumstances, in particular
together with OICA (which will lower the cost of certain operations
even more). You basically should see mostly NESTED LOOP joins with
index access. The question is then why Oracle with default settings
doesn't favor these access paths automatically.

Can you provide an example of an execution plan with default settings
and above custom settings that requires the settings to get the
desired "good" performance?

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/ 

------=_NextPart_000_000F_01CA540C.5CE4F510
Content-Type: application/octet-stream;
	name="INITA10AORI.ORA"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="INITA10AORI.ORA"

# ACS Data Systems Oracle Initora.ora
#
=20
###########################################
# Archive
###########################################

log_archive_dest_1=3D'LOCATION=3DC:\ORADAT\A10A\ARCHIVE'
log_archive_format=3Dlog%S_%R_%T.arc

=20
###########################################
# Cache and I/O
###########################################
db_block_size=3D8192
db_file_multiblock_read_count=3D16
=20
###########################################
# Cursors and Library Cache
###########################################
open_cursors=3D300
=20
=20
###########################################
# File Configuration
###########################################
control_files=3D("C:\ORADAT\A10A\ctl1A10A.ctl", =
"C:\ORADAT\A10A\ctl2A10A.ctl", "C:\ORADAT\A10A\ctl3A10A.ctl")
db_recovery_file_dest=3DC:\ORADAT\A10A\FLASH
db_recovery_file_dest_size=3D214748364800
=20
###########################################
# Database Identification
###########################################
db_domain=3D""
db_name=3DA10A
global_names =3D TRUE
=20
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=3DC:\ORADAT\A10A\BTRACE
core_dump_dest=3DC:\ORADAT\A10A\CTRACE
user_dump_dest=3DC:\ORADAT\A10A\UTRACE
utl_file_dir=3DC:\ORADAT\A10A\UTRACE
max_dump_file_size =3D 10240
timed_statistics=3DTRUE
statistics_level =3D typical
=20
###########################################
# Job Queues
###########################################
job_queue_processes=3D10
=20
###########################################
# NLS
###########################################
nls_language=3D"AMERICAN"
nls_territory=3D"GERMANY"
=20
###########################################
# Processes and Sessions
###########################################
=20
 processes=3D300  =20

=20
###########################################
# Memory
###########################################
sga_target=3D393216000
db_cache_size=3D100000000
shared_pool_size=3D50000000
pga_aggregate_target=3D131072000
=20
=20
###########################################
# Security and Auditing
###########################################
audit_file_dest=3DC:\ORADAT\A10A\UTRACE
remote_login_passwordfile=3DEXCLUSIVE
os_authent_prefix =3D ""
=20
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=3DAUTO
undo_retention=3D10800
undo_tablespace=3DUNDOTBS1
 log_buffer =3D 4194304         =20

=20
###########################################
# Miscellaneous
###########################################
aq_tm_processes=3D1
compatible=3D10.2.0.3.0
=20
=20
###########################################
# Instance Identification
###########################################
instance_name =3D A10A
service_names =3D A10A
=20
###########################################
# Optimizer
###########################################
query_rewrite_enabled=3DFALSE
star_transformation_enabled=3DFALSE
_gby_hash_aggregation_enabled=3Dfalse
optimizer_index_cost_adj =3D 10
optimizer_index_caching =3D 99
=20
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=3D300
=20
=20

------=_NextPart_000_000F_01CA540C.5CE4F510
Content-Type: application/octet-stream;
	name="INITA11CORI.ORA"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="INITA11CORI.ORA"

# ACS Data Systems Oracle Initora.ora
#
###########################################
# Archive
###########################################

log_archive_dest_1 =3D'LOCATION=3DC:\ORADAT\A11C\ARCHIVE'
log_archive_format =3Dlog%S_%R_%T.arc

=20
###########################################
# Cache and I /O
###########################################
db_block_size=3D8192
db_file_multiblock_read_count=3D16
=20
###########################################
# Cursors and Library Cache
###########################################
open_cursors =3D500
=20
=20
###########################################
# File Configuration
###########################################
control_files =3D("C:\ORADAT\A11C\ctl1A11C.ctl", =
"C:\ORADAT\A11C\ctl2A11C.ctl")
db_recovery_file_dest =3D C:\ORADAT\A11C\FLASH
db_recovery_file_dest_size =3D214748364800
=20
###########################################
# Database Identification
###########################################
db_domain =3D""
db_name =3D A11C
global_names =3D TRUE
=20
###########################################
# Diagnostics and Statistics
###########################################
timed_statistics =3DTRUE
statistics_level =3D typical
###########################################
# Job Queues
###########################################
job_queue_processes =3D10
=20
###########################################
# NLS
###########################################
nls_language =3D"AMERICAN"
nls_territory =3D"GERMANY"
=20
###########################################
# Processes and Sessions
###########################################
=20
 processes =3D300

=20
###########################################
# Memory
###########################################
memory_target =3D 524288000
db_cache_size=3D100000000 =20
shared_pool_size=3D50000000=20
=20
###########################################
# Security and Auditing
###########################################
remote_login_passwordfile =3DEXCLUSIVE
os_authent_prefix =3D ""
SEC_CASE_SENSITIVE_LOGON=3DFALSE=20
=20
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management =3DAUTO
undo_retention =3D10800
undo_tablespace =3DUNDOTBS1
 log_buffer =3D 4194304

=20
###########################################
# Miscellaneous
###########################################
compatible =3D11.1.0.0.0
=20
=20
###########################################
# Instance Identification
###########################################
instance_name =3D A11C
service_names =3D A11C
=20
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target =3D300
=20
=20

------=_NextPart_000_000F_01CA540C.5CE4F510--

0
10/23/2009 4:12:20 PM
On Oct 22, 11:40=A0pm, "Arne Ortlinghaus" <Arne.Ortlingh...@acs.it>
wrote:
> Interesting,
>
> so it seems that we can expect new possibilities in release 2?
>

All I know is what I see on the glowing liquid crystals.

(Also, this group prefers if you don't top-post).

jg
--
@home.com is bogus.
I remember when you picked up the phone and it worked!
http://www3.signonsandiego.com/stories/2009/oct/23/stubborn-few-not-dialed-=
cell-phones/?uniontrib
0
joel-garry (4553)
10/23/2009 4:33:16 PM
Reply:

Similar Artilces:

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

Patching Oracle 8.1.7.0.0 to Oracle 8.1.7.4.1
Hello, my configuration is Windows 2K Server SP4 and Oracle 8.1.7.0.0. Where can i find a patch to upgrade to Oracle 8.1.7.4.1 Many thanks for your attention -- Sitta many thanks!!!! Have a nice work "Rauf Sarwar" <rs_arwar@hotmail.com> ha scritto nel messaggio news:1106137485.286119.307110@f14g2000cwb.googlegroups.com... > > Sitta Davide wrote: >> Hello, >> my configuration is >> >> Windows 2K Server SP4 and Oracle 8.1.7.0.0. >> >> Where can i find a patch to upgrade to Oracle 8.1.7.4.1 >> >> >> Many thanks for your attention >> >> -- >> >> Sitta > > http://metalink.oracle.com > > Regards > /Rauf > ...

Rolling upgrade from oracle RAC 10.2.0.4 to 11.2.0.1
Has anyone done a rolling upgrade of oracle RAC 10.2.0.4 to 11.2.0.1. Recently I was trying to upgrade a 2 node RAC using logical standby database and evertime it is failing at upgrade of cluster. Hven't found any useful doc in metalink or internet. Will be very helpful if someone who has done this can provide a direction to me. Thanks ...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.com> schreef in bericht . > How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 > > 1-what scripts are to be used > 2-Where i can find these scripts. > > Thnks. Hi, I guess oracle dosen't support backword comatibilty.then how it is possible?? Thanks Alok. On 9 Aug 2005 22:05:49 -0700, alok.behria@gmail.com wrote: >Hi, > > I guess oracle dosen't support backword comatibilty.then how it is >possible?? > >Thanks >Alok. Oracle is backwards compatible provided you have the definition of backwards compatible correct. You can connect (again) *lower version client* to a *higher version database* The other way around has nothing to do with backwards compatible, though it usually works, *with the exception of export/import, AS DOCUMENTED* (but I guess no one ever reads the docs) -- Sybrand Bakker, Senior Oracle DBA Hi, ...

Copying Oracle 10.2.0.4 Database to 11.2
Hi, We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris 5.9 in, say, servera. We are looking to copy it, and rename its Oracle SID, to a Solaris 5.10 server (serverb) running Oracle 11.2. The tentative plan is as follows: (i) Install SAP/Oracle 11.2 on serverb. (ii) Copy a cold backup of the servera database from tapes to serverb. (iii) Rename the database to the new SID using "Create controlfile set database....". (iv) Run the SAP tool that upgrades Oracle to 11.2 so that the database is upgraded (Skip the part that install the Oracle binaries). SAP documentation indicates that this step works. My question is on step #(iii). On 11.2, will the "Create controlfile" command work if the database is 10g? Thanks, QZ In article <2e5d62d9-0155-4ab2-9c55-dff6c8ecc0f2@k3g2000vbz.googlegroups.com>, if_investor@yahoo.com <basis_consultant@hotmail.com> wrote: >We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 on Solaris >5.9 in, say, servera. > >We are looking to copy it, and rename its Oracle SID, to a Solaris >5.10 server (serverb) >running Oracle 11.2. Why rename the SID? >The tentative plan is as follows: > >(i) Install SAP/Oracle 11.2 on serverb. >(ii) Copy a cold backup of the servera database from tapes to serverb. >(iii) Rename the database to the new SID using "Create controlfile set >database....". >(iv) Run the SAP tool that upgrades Oracle to 11.2 so that th...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy the Oracle CD to the hard drive. I copied it to a subfolder directly to C:\Oracle9i 2. Change the file c:\oracle9i\install\ORAPARAM.INI to reflect the actual name of the directories listed in the install directories of the cd I just copied. I did this and next took out some "."s and put the absolute path to the java program and something called the "OUI_LOCATION". JRE_LOCATION=C:/oracle9i/stage/Components/oracleswdjre/13110a/1/DataFiles/Expanded OUI_LOCATION=C:/oracle9i/stage/Components/oracleswdoui/220120/1/DataFiles/Expanded Okay so good so far. This time the installer actually started. The problem occurs in the next few steps, when I click "next" (weiter in German) from the welcome screen- please understand if I translate something wrong here. Then I am shown the installation directory screen, where I select the default listed: Source : C:\Oracle...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard disclaimer: http://www.dbainfopower.com/dbaip_advice_disclaimer.html "kumu" <forlist2001@yahoo.com> wrote in message news:a44abd39.0402161837.6badb9ed@posting.google.com... > Hello All, > I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or > 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? > > Also I had a bad experience with my development server when applying > 9.2.0.3 patchset. Is there anything you recommend before I start > again? > > Thanks > Kumu "Ron" <support@dbainfopower.com> wrote in message news:<QqWdnRM_cMiwWqzdRVn-vg@comcast.com>... > Hello Kumu, > > What is the reason for upgrade? Any specific bugs or issues you > experience? > > You can open TAR as well to get support recommendations for your > situation. > > New patches can introduce new...

Oracle Update 8.1.7.0.0 -> 8.1.7.4.1
I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLISH (French Keyboard) to 8.1.7.4.1 Everything looks fine, the services were started - but in the Event Log I have a lot of errors of oradim.exe (.. can't read memory ..) and also when startin tools like sqlwplus.exe i get the same error. Any suggestions??? Please help me! Regards, Stephan buckenmaier@tka-presta.thyssenkrupp.com (Stephan@TKA-Presta) wrote in message news:<ba9d45ff.0401282332.127ac2f0@posting.google.com>... > I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLISH (French > Keyboard) to 8.1.7.4.1 > Everything looks fine, the services were started - but in the Event > Log I have a lot of errors of oradim.exe (.. can't read memory ..) and > also when startin tools like sqlwplus.exe i get the same error. > > Any suggestions??? > Please help me! > > Regards, > Stephan No suggestions by anyone I am afraid, as your post provides nothing to work on apart form vague clues like 'lot of errors of oradim.exe' We need *exact* errors, not *paraphrased* ones. We didn't look over your shoulder when it happened, did we? Sybrand Bakker Senior Oracle DBA sybrandb@yahoo.com wrote in message news:<a1d154f4.0401290213.913f792@posting.google.com>... > buckenmaier@tka-presta.thyssenkrupp.com (Stephan@TKA-Presta) wrote in message news:<ba9d45ff.0401282332.127ac2f0@posting.google.com>... > > I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLI...

Upgrading oracle db 10.1.0.5 to 10.2.0.2 java issues
Hi all, We are upgrading our oracle database from 10.1.0.5 to 10.2.0.2. has anyone had previous experience with this that they can point out potential pitfalls? I am talking more on the java side than actually the installation. We have a java system talking to the oracle database. One system is using hibernate, the other is using a DAO pattern with direct JDBC calls. Does anyone know if this change will effect the application and what changes we must do to accomadate? For example I know that oracle 10.2.0.2 has a different timestamp (oracle.timestamp) than that of it predecesor (sql.timestam...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

Oracle 10.1.0.4 Windows XP Oracle Installer
After upgrading my Oracle 10g to 10.1.0.4, I am no longer able to start the Oracle installer. It does not appear to copy the jre folder into the temp directory and gives me an error that it cannot find the jre. This did not occur previous to installing the upgrade. Anyone else have a similar problem? GregK wrote: > After upgrading my Oracle 10g to 10.1.0.4, I am no longer able to start > the Oracle installer. It does not appear to copy the jre folder into > the temp directory and gives me an error that it cannot find the jre. > This did not occur previous to installing the upgrade. Anyone else > have a similar problem? No. Worked perfectly on mine. Check metalink to look for others with similar experiences. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond) ...

oracle 9i (9.2.0.1.0)
Hi! when I call the oracle performance manager I get the following errors: VTM-0002: error when displaying graph java.lang.null.pointerexception at oracle.sysman.vtd.VtdCartridge.lookupClass(VtdCartridge.java:1313) ..... what is my problem? Thanks! ...

Best Way to Access remote Oracle 10.2.0.1.0 DB from a Linux server
I want to use a perl or unix script running on a linux server to access an Oracle v. 10.2.0.1.0 database on a remote machine, and process the output with the script. What is the best way to do this? I'm thinking some possible options are: install Oracle 11 cllient (assume it is backwards compatible), install the entire Oracle database v.11, or install Oracle express. Appreciate your comments. Johan Johan <johango99@yahoo.com> wrote in news:db01b8d1-577b-4310-89af- 97465a3623c3@w28g2000hsf.googlegroups.com: > I want to use a perl or unix script running on a linux server to > access an Oracle v. 10.2.0.1.0 database on a remote machine, and > process the output with the script. What is the best way to do this? > I'm thinking some possible options are: install Oracle 11 cllient > (assume it is backwards compatible), install the entire Oracle > database v.11, or install Oracle express. Appreciate your comments. > > Johan > I vote for Oracle client & PERL On Nov 17, 3:13 pm, "Ana C. Dent" <anaced...@hotmail.com> wrote: > Johan <johang...@yahoo.com> wrote in news:db01b8d1-577b-4310-89af- > 97465a362...@w28g2000hsf.googlegroups.com: > > > I want to use a perl or unix script running on a linux server to > > access an Oracle v. 10.2.0.1.0 database on a remote machine, and > > process the output with the script. What is the best way to do this? > > I'm thinking some possib...

how do I chg administrator pwd on oracle 11g 11.2.0.1.0 on Windows Professional 7?
help much appreciated. I have 7 days. Regards, Ken Quirici On Saturday, March 10, 2012 12:49:28 PM UTC-7, Ken Quirici wrote: > help much appreciated. > > I have 7 days. > > Regards, > > Ken Quirici Do you want to change the SYS password in Oracle or the Adminstrator password for Windows? David Fitzjarrell On Mar 10, 6:56=A0pm, ddf <orat...@msn.com> wrote: > On Saturday, March 10, 2012 12:49:28 PM UTC-7, Ken Quirici wrote: > > help much appreciated. > > > I have 7 days. > > > Regards, > > > Ken Quirici > > Do you want to change the SYS password in Oracle or the Adminstrator pass= word for Windows? > > David Fitzjarrell The SYS password in Oracle I would imagine. Let me fill in a little more: when I open sql developer it shows a connection to my database ORCL2 - when I click it it asks for a password. It's THAT password. Does that answer your question fully? I get the message that the pwd is expiring when for example I run sqlplus from the cmd line. I think also when I opened the sql developer window. Thanks for the reply. Regards, ken Quirici On Saturday, March 10, 2012 5:29:38 PM UTC-7, Ken Quirici wrote: > On Mar 10, 6:56=A0pm, ddf <orat...@msn.com> wrote: > > On Saturday, March 10, 2012 12:49:28 PM UTC-7, Ken Quirici wrote: > > > help much appreciated. > > > > > I have 7 days. > > > > > Regards, > > > > > Ken Qui...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's On Jul 27, 11:58=A0pm, ranganadh <ranganadhkod...@gmail.com> wrote: > Dear Group members, > > =A0I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> =A0"ORA-03134: Connections to this server version are no longer > supported." </b> > > Can i install, 2 or more =A0version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. > > if, it can be possible, what kind of things i take care, ...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's > I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> "ORA-03134: Connections to this server version are no longer > supported." </b> > > > Can i install, 2 or more version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. Yes you can, I currently have 3 versions Oracle 8.0.4, Oracle 9.2 and Oracle 10.2 on my work PC. No problem. > > if, it can be possible, what kind of things i take care, before > installation .. If yo...

SSL with Oracle 7.3.4 and Oracle Application Server OAS 3.0
Hello, I want to have SSL with my Oracle-Web-Server. It's an very old Version (OAS 3.0) I have configured SSL exactly - read in the documentation. But it doesn't work ! Is it possible to upgrade the OAS 3.0 up to a newer one ? That could be a solution. I hope, someone can help me. The problem is, that we need https-connects on the website. Thanks first ! Joerg Mueller wrote: > Hello, > I want to have SSL with my Oracle-Web-Server. It's an very old Version (OAS > 3.0) > I have configured SSL exactly - read in the documentation. > But it doesn't work ! > > Is it possible to upgrade the OAS 3.0 up to a newer one ? > That could be a solution. > > I hope, someone can help me. The problem is, that we need https-connects on > the website. > Thanks first ! > > Of course, mentioning the full error(s) would help, as well as Operating System and other details... If that would not be asked too much... Pretty Please? -- Regards, Frank van Bortel Top-posting is one way to shut me up... Here are the details: OS is Solaris 2.6 on a SUN Ultra 10 I have done the setup as written in the following page: http://isis.sra.com/ows-adoc/docs/security/wassecur.htm Here klick: "Setting Up Your Web Application Server to Use SSL" Is there a chance to get SSL with Oracle 7.3.4 and OAS 3.0 ? Or can I upgrade the OAS only ? But which version is running good ? The problem is, that we absolutely need SSL Here...

OpenVMS and Oracle 10.2.0.4.0
I've been told by Oracle that the terminal release patchset 10.2.0.4.0 will be available by the end of October AND that the Itanium 10.2 Grid Control agent will be available in the next couple of weeks. Can anyone confirm I'm not being spun the typical Oracle VMS yarn. I've had these messages in the past but nothing ever emerges. In article <fe2a785c-6541-4bf2-8bd1-8182138a32ed@m36g2000hse.googlegroups.com>, heyesr@googlemail.com writes: >I've been told by Oracle that the terminal release patchset 10.2.0.4.0 >will be available by the end of October AND that the Ita...

ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7
Hye, While running an upgrade from 8.1.7 to 9.2.0.4 I finished the upgrade successfully I started the database and wanted to change undo tablespace management to be automatic So I offline the rollback segs, offline the tablespace that holds then and drop it. I want to create a new tablespace UNDO but I got the error the the parameter compatible is set to a lower value which is true because I have 8.1.7. I disconnect, delete the compatible entry from the file and want to log again. And here's the surprise ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7 I have the database backed up so I can restore but I am hoping there is a way that will save me some time. What can I do to eliminate this error ? TIA Michal What do you mean you deleted the compatible parameter ... Did you not set it to a new proper value For example "compatible=9.2.0.0.0" Or is there a reason you would not want to change it - which do exist. It says oracle version is 8i...and redo version 9i. Are you starting the database under right environment? Sorry, I was a little too quick on my post. I should have though about the possibility that you could be using the new server parameter file, in which case you might have to execute the following -> alter system set compatible="9.2.0.0.0.0" scope=spfile; ...

Upgrading Oracle ODBC 10.1.0.2.0
Upgrading a database from Oracle 9i to 10g. I have encountered a problem with the ODBC 10.1.0.2.0 driver, it transforms the 21 numeric digits from a PK column to a scientific format. Has anyone found this problem?, is any other work around but changing the numer to varchar ? Thanks in advance Comments embedded. On Dec 31, 8:41=A0am, valigula <valig...@gmail.com> wrote: > Upgrading a database =A0from Oracle 9i to 10g. > I have encountered a problem with the ODBC 10.1.0.2.0 driver, it > transforms the 21 numeric digits from a PK column to a scientific > format. Which should be nothing more than a display issue. Try setting numwidth to a value greater than the largest exponent displayed: SQL> select empno, ename, bizarre_num 2 from emp; EMPNO ENAME BIZARRE_NUM ---------- ---------- ----------- 7369 SMITH 4.3442E+10 7499 ALLEN 8.9976E+10 7521 WARD 7.0707E+10 7566 JONES 1.7030E+11 7654 MARTIN 7.3230E+10 7698 BLAKE 1.6889E+11 7782 CLARK 1.4837E+11 7788 SCOTT 1.8196E+11 7839 KING 3.0725E+11 7844 TURNER 9.2293E+10 7876 ADAMS 6.8235E+10 EMPNO ENAME BIZARRE_NUM ---------- ---------- ----------- 7900 JAMES 5.9290E+10 7902 FORD 1.8732E+11 7934 MILLER 8.1833E+10 14 rows selected. The largest exponent displayed is 11, so set the numwidth to 12: SQL> set numwidth 12 ...

Oracle 10.0.2.0 on HPUX 11.23
Ive tried to install the oracle enterprise database above a number of times on HPUX Itanium 11.23 It keeps failing at the same place with the same error, and for the life of me I dont know what it is: (It happens at about 82% of the Linking C/C++) Error in invoking target 'relink' of makefile '/oracle101/app/precomp/ lib/ins_precomp.mk' >From the install log: Start output from spawned process: ---------------------------------- Linking /oracle101/app/precomp/lib/proc cc: +DD64: No such file or directory *** Error exit code 1 Stop. End output from spawned process. ---------------------------------- Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'relink' of makefile '/ oracle101/app/precomp/lib/ins_precomp.mk'. See '/oracle101/ oraInventory/logs/installActions2007-03-16_11-20-58AM.log' for details. Exception Severity: 1 Exception handling set to prompt user with options to Retry Ignore User Choice: Retry The output of this make operation is also available at: '/oracle101/ app/install/make.log' >From make.log: /bin/make -f ins_precomp.mk relink ORACLE_HOME=/oracle101/app EXENAME=proc/Linking /oracle101/app/precomp/lib/proc cc: +DD64: No such file or directory *** Error exit code 1 On 16 mrt, 13:57, "bomahony" <bomah...@gmail.com> wrote: > Ive tried to install the oracle enterprise database above a number of > times on HPUX Itanium...

Oracle 9i Release 2(9.2.0.4) on Slackware 10.1
Does anybody out there have had these experience in performing such an installation ... does anybody have a how-to ... or some hints ... ??? Please help me with this issue. || So many thanks in advance, looking forward to hear from you guys .. !! Oralinuxdba wrote: > Does anybody out there have had these experience in performing such an > installation ... does anybody have a how-to ... or some hints ... ??? > Please help me with this issue. || So many thanks in advance, looking > forward to hear from you guys .. !! > Issue? What issue? The issue of using a non-oracle-supported OS is easily addressed: switch to White Box Linux. -- Regards, Frank van Bortel What's "White Box Linux" .... ?? Oralinuxdba wrote: > What's "White Box Linux" .... ?? > What's slackware? I know shareware, hardware, vapourware, software, courseware,... -- Regards, Frank van Bortel White Box Linux is: " forked from the source code for Red Hat's _Red Hat Enterprise Linux_" See: http://www.whiteboxlinux.org/ and remember ... Google is you friend for "What is" questions...... Oralinuxdba wrote: > What's "White Box Linux" .... ?? What's google.com? Apparently this is some inane American game show? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) DA Morgan wrote: > Oralinuxdba wrote: > >> What's "Whi...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

Web resources about - Comparisons Oracle 11.1.0.7 to Oracle 10.2.0.4 - comp.databases.oracle.server

Comparison - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Phone Comparisons: LG Nexus 5X vs Samsung Galaxy S7
Introduction Do we have a good one for you today – the affordable Nexus 5X goes up against the new Samsung Galaxy S7. The Nexus devices are very ...

Ultimate Android comparison video pits Galaxy S7 against Nexus 6P, Moto X
The reviews poured in for the Samsung Galaxy S7 on Tuesday and they were unanimous in their praise for Samsung's latest flagship phone. The crew ...

Donald Trump "doesn’t like invidious comparisons but he’s cool with being called an authoritarian," writes ...
... paraphrasing her own question to Trump. He answered: "We need strength in this country... We have weak leadership. Hillary is pathetically ...

Donald Trump says he's "not happy" with comparisons to Hitler
The GOP frontrunner has recently asked his supporters to raise their right hands and pledge to vote for him

Trump responds to Hitler comparison
The Sun Trump responds to Hitler comparison CNN (CNN) Donald Trump on Tuesday addressed criticism of a new practice at his rallies that has ...

Wisconsin Professor Gets New Job After STALKING RANDOM FRESHMEN ON TWITTER, Hitler Comparisons
Wisconsin Professor Gets New Job After STALKING RANDOM FRESHMEN ON TWITTER, Hitler Comparisons


About That All-Time Dodgers Outfielder Comparison
Give this reporter a chance to write something in appreciation of Willie Davis,he'll grab it any ole time. And a hearty thank you to Cary Osborne ...

Sarah Silverman’s ‘Hitler’ is ‘Bummed’ by Manhood Comparisons to Donald Trump
... Silverman stepped out in full Nazi garb as Adolf Hitler during to the sound of thunderous applause, addressing the recent “unfavorable” comparisons ...

Resources last updated: 3/19/2016 9:00:47 PM