 | | | Oracle List | | Steve
Here are a few thoughts -- for what they 're worth. I 'm sure others on
this list can offer much better feedback.
1. You did not say how your NetApp storage is connected. I presume NFS
bDoes anyone know of a way to invalidate or completely flush a single
cursor?
I 'm doing some performance testing of queries that are having trouble
with bind variable peeking and sharing plans betwee
select name value from v$parameter where name in
( 'db_writer_processes ' 'dbwr_io_slaves ')
dbwr_io_slaves 0
db_writer_processes 1
...on windows this single dbwr is doing async IOSolaris allocates the sga_max_size amount at instance start-up. sga_target
is what the database actually tries to use. The difference between them can
be used if you want to increase the sga_target pI 'm assuming from your subject line that you are talking about Oracle Apps.
You will want to look at metalink note 230672.1 for sure.
I 'm afraid that there isn 't an 'easy ' way - nor to be honest do Iobj$.ctime
> > Your assumption is wrong. The fixed SGA contains variables that
are known at oracle compile time or point to structures in variable
part. So the answer is that generally speaking all x$ are How does ASMM handle a system with high volumes of non-shareable SQL? When
manually sizing the shared pool we have always been reminded that a large
shared pool size could lead to serious performancYou can always use the standard
and column + 0 number_value
Or
and column || ' ' 'string value '
> > >
> > >* ) What is the best clusterware for this configuration
> > >(Veritas cluster / Sun Cluster / Oracle Clusterware). Are
> > >there any risks if I don 't use veritas cluster / sun cluster ware.
OrAdi
> * Large number of records >200million rows
> * Tables have a unique "id " for each row (generated using sequence).
> * The rows can be logically grouped per "user_id "
> * The rows are primarily thanks poeple the respons was very nice
I have found the problem
as of solaris 9. solaris desided that they wanted to take more of the
semsys seminfo_semmni. On solaris 8 i did with 7 databases and Hi Mirza
Check the size of rman input buffer
select set_count device_type type filename buffer_size
buffer_count open_time close_time
from v$backup_async/sync_io
order by set_count Hi
We have a 6 node cluster on Solaris 64 bit 10.1.0.5 RAC and SFRAC 4.1
We do something like 400 transactions/sec and around 500 000 logical
reads/sec and are very much a producThanks Giri for the info.
Qs 1 Has Veritas CFS been tried & tested on very High Hybrid Transaction
Loads with Solaris 10/Oracle10g on RAC at production sites?
Qs 2 What Other Filesystems are adviHi Dave
I 've never been a fan of multiple sized tablespaces because of the
complication & segregation it introduces to your buffer cache. I would
recommend just looking at the top queries on the tHi Paula
I am sure that there are different ways of doing it - here is mine (build on
top of your code
> > >I 'm not trying to promote the creation of tables w/o PKs
> > >but just FYI - I work with the Baan ERP application (you 've
> > >probably never heard of it but I think they used to be #5
> > >behind Is there a way to find out which tables are "hit " the most in a 9i database
without setting up full scale auditing? (I 'm just trying to get a sense of
which tables are the popular ones roughly)
THaI 'm moving to the Big Apple tomorrow and my new address will be mgogala@(protected)
as soon as my DSL starts functioning. Verizon promised that for Wednesday 8/23. Until
then I 'll have to unsubscri
Folks
As part of Long Term planning one of our customers is planning to move
to RAC from currently a Single DB Server (NON-RAC) setup.
Existing Production Setup is using VXFS with Solaris 9/OracThe basic steps are in the quick install guide.
Yes you can install GCr2 into a 10.2.0.2.0 DB instance.
rr
How much physical memory is on the machine?
Try running "/usr/sbin/psrinfo -v "
With both instances shut down see if there is some shared memory
allocated but not really used.
Try "ipcs -m " and/or "iVivek
Is the application normally on a different server from the database? If they
are normally separate then using a different server for one piece won 't
change your result. But if they are normal > > >
> > > <Bug 4404952 > DG BROKER DOES NOT SUPPORT COLD-FAILOVER CLUSTERS
> > >
> > > I was told my Oracle support that giving dataguard a vip
> > >makes it think that you 're running RAC and that there
On 08/16/2006 05 07 14 PM joseph.m.coffey@(protected) wrote
>
> My question is - why was this time reported as Execute rather than
> Parse? Shouldn 't the contemplation of what plan to run be Probably because the CBO optimization is being performed in the Execute
phase rather than the Parse due to bind variable peeking.
Does anyone know if it 's possible to insert an Oracle hint (e.g.
USE_HASH) into the SQL statements produced by Crystal Reports?
Thanks
Brandon
Privileged/Confidential Information may be containeORACLE Financials DBA -
Salary $90 000 - $110 000
Location Boston MA (No Relocation Assistance Available)
Year(s) Exp 5-10
Description
Client has a fulltime requirement (possibly temp
Hi I need some feedback on upgrading to 64-Bit. We are a state
public health agency. My project team has proposed that during our
regular server replacement cycle that our next purchase to r |
|
|
