 | | | Oracle List | |
>Our UNIX SA says " Cooked Filesystems have their own
Asynchronous Mechanisim that equally replaces Oracle Async IO "
...Uh tell him to keep his day job. Having buffers copied into
kernelCurrently we run Oracle standard edition (32 bit) on RHEL release 4 on an IBM
345 (x86) with 6GB of memory.
Here 's what I am trying to accomplish
1. Trying to figure out whether 64 bit Oracle will Hi
We noticed somethimes that available physical RAM is going around 0 so
need to get details into command to look into which process is using how
much memory
Oracle 10g installed on solaris 10Have you done this
Set up user equivalence. (If on Unix set up remote copy (rcp) to all
the nodes including the local node. If on Windows issue "NET
USE \\node_name\C$ " for each node.)fyou know that Oracle documents all this stuff and is freely available on the
web you could have found it yourself by the time you wrote the email to
send to this list
http //download-west.oracle.comHi List
Does anyone have a script that shows how to create a 9i physical standby manually without using OEM or Grid Control?
I went to a 10g Data Guard class and they only showed how to do it usingIs there a way to view the current SQL that is executing while running a DBMS_JOB in 10g? When you query v$session the sql_address is set to 00 and the sql_hash_value is set to 0 for that session.
Hi
Another way of doing it might be to configure MTS with multiple
dispatchers all having their own port. This is what we do for
DMZ-- >firewall-- >database connections
Regards
-----OorspronkeHi
Oracle 9i Rel2
I have an objective to show last working days transaction (Friday) on
Saturday and Sunday
AND
if the next day is also a Holiday then i have to post previous days
transactions Hi there
the way i remember the listener working is that 1521 specified in the
listener.ora file is just the port where the initial hello happens on. it
say hi then and gives you the port where the lmake sure the listener only listens on 1521 - thats the only port people can
connect on then
On 06/09/06 George <george@(protected) > wrote
>
>
>
> Now. how can you define the possible range for reHi
It is not from a production system (YET) they told me to put this in
production when I upgrade this to 9i in 2 weeks time. So I dont have
Statspack whatsoever. They say is to prevent performance 20 DB Writers is way too high.
what kind of an application is this? Even for a
'write-only-will-not-select-any-data ' application 20 is high questionable.
normally you don 't need to dab around with
Hi all
HOW ???
normally the connection process goes something like.
1. enter username password and service name and hit enter.
2. this makes the sqlplus tool query tnsnames.ora to find where the
Hi Murtuja
The odtug website also has a few very good articles available for free
download at
http //www.odtug.com/pls/htmldb/f?p 500 815 6729629124491114353 815 P815_TOPIC 6
I would recommend
DataWhat about using a continuous build harness like cruise control
basically it runs continuous builds and will report success and failure
of the build and the resultant testing. If you point a build of[...]
> In other 10.2 database where the global_name is nice <db name > (without
> the domain suffix) I have no such problems. I guess the fix is to get rid
> of the domain name from the global_name.
>Hello
I came across an article which mentioned about using the dumpsga command and followed by strings command to see the Oracle Wallet Password. As per the note Oracle has fixed this with patch updaOn 9/5/06 Mark Strickland <strickland.mark@(protected) > wrote
>
> Our testing
> indicates that any DML that impacts over 100 000 rows in a single
> transaction will slow down linearly (or is that expoSo what you really want is a job that runs 3 times a day at 9 00am 3 00pm and 9 00pm?
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"A human being should be ableHi
Anybody running Oracle 10g ASM instance on Veritas Cluster server. THis is non-RAC single Instance environment where Veritas Cluster is used for Failover purpose. I am trying to use Veritas CHi Charles - I just read your post quickly and I 'm not sure about this
but it sounds to me like maybe there is no "First K " rows calculation
for the DISTINCT query because anytime you have a DISTINCT > As we 're getting firmly ensconced in 10g Land I want to
> update my very old diagram of the Oracle instance processes.
> So I grabbed the Oracle Database Concepts manual for 10g
> Release 2 (10MetaLink- >Patches and Updates- >Quick Links to the Latest Patchsets Mini
Packs and Maintenance Packs
Find your product platform and patchset. Patchsets are cumulative.
You can apply 10.2.0.3 patcWe are facing acute problem installing 10g in a local Zone.
At DBCA time it locks at 45% and and when I run a prstat command I see the
memory for that zone at
100%. So I gues its just churning away veonly a guess
you are loading a java class compiled with a more recent java version.
Oracle 9 supports java 1.3
Oracle 10 supports java 1.4
what is the output of the os command
java -version
Giovanni
Well I don 't have the insights Jonathan does but I 'll take a shot
here with regards to parallelism and when to parallelize.
In my opinion parallelism is something you use when you are dealing
witI 'm not sure of your timeframe for the purchase IBM Sun and HP are all
releasing new or updated 4 socket AMD Opteron systems based on the new
Socket F.
select * from dba_registry
On 9/5/06 Peter Hitchman <pjhoraclel@(protected) > wrote
> Hi
> My scenario is
>
> Duplicated a 9.2.0.6 database to a server running a Oracle home patched up
> to 9.2.0Some test can be built like below.
Begin
For I in
(select * from v$session ) loop
dbms_lock.sleep(...)
--- Fetch data do something
end loop
|
|
|
