 | | | Oracle List | | Thank you Ranko.
Of course I was simplifying for the purpose of explanation.
As it happens the platters all spin synchronously and -- as you point out
yourself -- the heads all move synchronouslHi
Dan Norris wrote
> Checkpoints are instance events not database events
That 's a very important point.
By using the thread checkpoints the instance "protects " the changes to
the blocks in its I wouold guess that this might be to do with the optimizer looking at different access paths to the table. For example it might be not be much more selective to access the table via
"RCRAPP1 ".Ajeet
I would suggest looking at some tips at
http //structureddata.org/2007/11/21/troubleshooting-bad-execution-plans/
ajeet ojha wrote
> Hello
>
> In my database environment for many of the qHi
Does anyone know if there is any way to force ASMM memory component to
shrink. Eg. Instance has just been bounced and say shared pool is using 1GB
and db_cache is using only 100MB. If one wantAre you also running with Unicode?
If so the PeopleSoft implementation of that will aggravate the situation
further.
Prior to Apps 9.0 every character column in the PeopleSoft schema is
implementedI wish to use the "Shared Pool Minimium Size Calculator " script in
Metalink Note 105813.1 to find out how the shared pool of an Enterprise
9.2.0.8.0 database is divided up between objects like packageHello All
This is just FYI post As i found out that the solution to my problem was
not
documented any where. I tried both metalink and google.
we were trying to clone our Windows - Oracle 11i Eb
Hi
Oracle makes the following statement in a metalink note on 8.1.7 desupport
" "Oracle offers Sustaining Support on Database Release 8.1.7.x for an indefinite period of time in accordance withFirst allow me to apologize for our Lotus Notes throwing my ID in all
caps. If someone knows how to turn that annoyance off please tell me!
We have a fairly sizeable sort order-by (1.2 million roHi All
In the off-chance that anyone was interested in the outcome of this....
I traced the OMS sessions to try to find the query being used to populate the bar graphs (not immediately obvious whicHi
I 've just received a promotion and now have responsibility for all my
organizations databases. Since the position was gapped for about 3
months I am trying to find out what is out there. The lismorning everyone
Anyone out there familiar with setting up very big and very fast Oracle? If
you could start from scratch how would you architect your system? What are
some of the options that shI have a few standalone 10.2.0.3 databases on which need to be migrated into
a RAC environment. Due to the sizes I 'd like to do this using RMAN if
possible... has anyone here tackled this scenario? In working with Oracle on this issue they had me recreate my controlfiles then add a second channel allocation as part of the DELETE OBSOLETE this one to disk.
All backups perform the following On Oct 31 2007 10 02 AM David Barbour <david.barbour1@(protected) > wrote
> Did you get this solved? What version of Oracle are you on? What is the
> platform? How are you performing the restore -
I 've been reading through the Oracle PL/SQL Users Guide and Reference
from various years and noticed that the 11g documentation seems to be
"lightening up " a little. The jovial and personal tonHi Mark
1 there are only two tables in the KEEP buffer.
2 Each if there are block cleanouts(or update for the table) there is no
read from the disk(only write the data from buffer to disk) thatJon
*Unless I 'm missing something* chances that Jacob has memory
management issues are small. Looking at semaphores statistics is a
very indirect way of troubleshooting to say the least. Buffer cac
Hey all has anyone ever used LD_PRELOAD to resolve performance issues?
Our Unix guy says that they have used this setting in the past with
great results. I 've searched metalink and the documentatbounced the DB. Ran it again and it worked.
I was looking at the raw trace file.
thanks guys.
i 'm a unix guy not a windows guy. at the new job we use windows and
8.1.7. could someone point me at the FM that shows me how to create a
service so i can get a database with files already in place Hello Niall
I also installed 11g on windows 2003 sp2 machine running on vmware esx with
1 CPU and 1 GB. And I experienced no problems.
Regards
Derya.
On 10/31/07 Andre van Winssen <dreveewee@(protected)This is far away from the real oracle pga usage
Another guy told me v$process_memory in 10g is pretty close. In 9i it does
not work.
not much knowledge updated about 10g and 11g is out!
On 10/23/07hi
Does anyone have experience on adding new CPU to a existing box like
upgrade from 8CPU to 16 CPU for example.
I am curious about two things
1. How many CPU usage% drop do we expect? Like
I ran this query on a non rac 10.2.0.3 database and it returned the rows very quickly. It may be some RAC related issue.
Regards
Rafiq
Date Fri 2 Nov 2007 08 35 40 +0100From exriscer@(protected)
I think I 'm about to have demonstrated to me (offline)
that the comment below is complete garbage. So my
apologies and please ignore it.
It 's a bit sad in some ways because I 'd already blogged abouhi
querying blocking_session is the problem if you dont query that columnd
then it should be fine
I have a customer who requested a backport to fix the bug but the one-off
patch has no effect so miHi Friends
We are planing to upgrade one of customer 's Oracle AS 10g from 9.0.4 (on Solaris) to portal 10.1.4. i have gone through the variuos docs on otn/tahiti for this and also would like toHmmm... Your description sounds like the classic story describing havoc
wreaked by bind-variable-peeking. The story goes like this
I have a database supporting my high-volume accounts receivabl |
|
|
