Following Stephane's advice, I rewrote the query to use underlying tables rather than the view.
The execution plan looks much better and the elapsed time came down appreciably.
My Question is , Since I was simply selecting from the view, eliminating a lot of columns and adding a few more
http://www.ixora.com.au/q+a/0011/21013327.htm
http://www.ixora.com.au/newsletter/2000_11.htm#sort_area
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 19, 2003 6:34 AM
Saw your post on o racle.server. I didnt see the
Hi!
You can have spread your datafiles in 1, 2, 3,4 ..100 different directories
or mount points, but the performance remain the same for all of them as long
as all the mount points are striped on the same disks.
If you think of mount points as different sets of disks, e.g. when adding a
new
Title: IBM AIX 32-Bit
Yes it can be done - 64 bit oracle
can be run in 32 bit os mode.
Regards
Shiva Subramaniam
-Original Message-
From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
11:30 PM
To: Multiple recipients of list
ORACLE-L
Have you checked number
of queues lately?
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003
Title: IBM AIX 32-Bit
Hi,
Sorry
for intruding, But just curious that how can a 64 bitapplication run on a
32 bit OS. I always thought that it was never possible.
Can u
please explain how is this possible
Regards
Munish
-Original Message-From: Shiva Subramaniam
Title: IBM AIX 32-Bit
Blind
guess: I guess youneed to allocate 2 words in order to fit in a 64 bit
word.
Sounds
easy ;).
Stefan
-Ursprüngliche Nachricht-Von: Munish Bajaj
[mailto:[EMAIL PROTECTED]Gesendet: Freitag, 19. September 2003
13:05An: Multiple recipients of list
Title: IBM AIX 32-Bit
how
can I wrap package bodies in oracle8i
Title: IBM AIX 32-Bit
Look at wrap command (under
oracle_home)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Friday, September 19, 2003 3:37
PM
Subject: wrapping packages
how
can I wrap package
Even on a Windows client:
the thing is called WRAPxx.exe
(version dependent).
[EMAIL PROTECTED] 19.09.2003 14.37 Uhr
how can I wrap package bodies in oracle8i
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guido Konsolke
INET: [EMAIL PROTECTED]
Fat City Network
Ryan,
You can have separate mount points from your server's perspective, but once
you get into the NetApp it's just a pool of disk drives that are allocated as
necessary by their WAFL (Write Anywhere File Layout) system. Therefore in reality you
get zero benefit.
Dick Goulet
Senior
The following query will give you an idea how to tune sort area size:
1 select n.name,s.value
2 from v$statname n,v$sesstat s
3 where n.statistic#=s.statistic#
4and n.name like '%sort%'
5and s.sid in (select sid from v$session
6* where
Hi
Absolutely great. Interesting details about LMTs and extent allocation for
example. I loved his other books, too.
Stefan
-Ursprüngliche Nachricht-
Von: Tanel Poder [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 19. September 2003 00:15
An: Multiple recipients of list ORACLE-L
Hi List,
Could you please help to see the errors in the package
compilation? Please see below
SQL @xyz_pkg.sql
DOCCREATE OR REPLACE PACKAGE XYZ_PKG
DOCAS
DOC--
DOCPROCEDURE UPDATE_TEST(COL1 IN DROP_ME.C1%TYPE);
DOCEND XYZ_PKG;
DOC
DOC*/
Warning: Package Body created with compilation errors.
Title: RE: Package Body created with compilation errors-
the code you provided and the oracle error message do not rhyme ... you are showing us the wrong code.
Raj
-Original Message-
From: Oracle DBA [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 19, 2003 10:35 AM
To:
Try compiling without the quotes around the package name:
CREATE OR REPLACE PACKAGE XYZ_PKG
-Original Message-
Sent: 19 September 2003 15:35
To: Multiple recipients of list ORACLE-L
Hi List,
Could you please help to see the errors in the package
compilation? Please see below
SQL
Try show err package body xyz_pkg instead or select directly from
user_errors.
It seems to be a sqlplus problem, that it doesn't always show the error - or
maybe it's expected behaviour... I've not read the docs on sqlplus that
much..
Tanel.
- Original Message -
To: Multiple recipients
The command would be:
Show errors package body XYZ_PKG;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Oracle DBA
Sent: Friday, September 19, 2003 9:35 AM
To: Multiple recipients of list ORACLE-L
Hi List,
Could you please help to see the errors in the package
Hi,
I have the following data in a table:
col1 col2 col3
1 2 A
1 2 B
1 2 C
I want to display this as :
col1 col2 col3
1 2 A B C
How can i do this?
Regards
Imran
--
Please see the official ORACLE-L FAQ:
It seams that u didn't create any body to the package
-Mensagem original-
De: Oracle DBA [mailto:[EMAIL PROTECTED]
Enviada: sexta-feira, 19 de Setembro de 2003 15:35
Para: Multiple recipients of list ORACLE-L
Assunto: Package Body created with compilation errors-
Hi List,
Could you
Yeah, that's what I thought, though I'm not familiar with UPI.
Sorry, question was kind of tongue in cheek -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Tanel Poder
Sent: Thursday, September 18, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
No it doesn't,
Sami,
Why do you have a */ as the last line? And why is the script prefaced with
DOC ?
It looks like you have either an unbalanced comment indicator (*/) or the
whole thing is a mess. Further, the error indicates that you have errors in
the package body but you are showing us the package.
If
Has anyone successfully installed 9iAS R2 V9.0.2.0.1 on Solaris 9?
I'm asking because I've tried failed numerous times.
I opened a TAR with Oracle on the 10th and am still waiting for
an answer from them.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET:
funny how my previous email seems to have been truncated where I put
three dots [ie , .] to
signifiy 3 lines.
Resend :
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
No question here. Just something weird. This is a long-running insert with
NO NONE ZERO ZIP ZILCH NADA commit. It makes me wonder if something weird
is going on, or if I am overlooking something in the query.
SQL select a.username,sum(b.used_ublk) x from v$session a, v$transaction b
where
Hi
Is there any script available for comparing tow tables
in different databases using DB_LINK?
Thanks
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
Just FYI : Quotes do not mean anything here. Quotes are generally used to create lowercase objects. Without quotes everything is converted to uppercase. "Virk, Istifad" [EMAIL PROTECTED] wrote:
Try compiling without the quotes around the package name:CREATE OR REPLACE PACKAGE XYZ_PKG-Original
This is actually platform dependent. For example, if you're using UDP
mounts under Linux, you can only have one request outstanding per mount.
Consequently, multiple mounts can improve performance by allowing parallel
operations.
A side benefit of Oracle on Netapp is WAFL, which as Dick
Title: RE: weird
try committing and see if the number changes too ... me thinks it is showing the number of undo blocks used by your current transaction. Since this info is mainly coming from v$, it isn't dependent upon your transaction committing ...
Raj
Hi,
We have around 120
databases. Most applications have 5 environments (dev, test, integrated test,
acceptance, prod) some applications have more.The applications are a mix of
home developped and bought application (peoplesoft, harvest,
compass,...)
New applications are
coming in.
New
I just hit a description of async IO in Oracle docs, it is very simply
described there:
quote
With synchronous I/O, when an I/O request is submitted to the operating
system, the writing process blocks until the write is confirmed as complete.
It can then continue processing.
Asynchronous I/O
Hi!
Try with 2 dots, you might get the same behviour.
Or put a space before every dot. Some old unix mailers considered dot in
beginning of the line as end of mail...
Tanel.
- Original Message -
From:
Hemant
K Chitale
To: Multiple recipients of list ORACLE-L
Ryan
NetApp is in another class of devices labeled NAS for Network Attached
Storage. Because its connection with your server runs over a network
connection, the performance is very much dependent on the speed and
configuration of the network connection.
As has been explained to me, and I
Hi,
Looking at v$sort_segment also can gve you a good idea of how much space you
are using in your temporary tablespace, across the current uptime of the
instance, assuming that it is a true temporary tablespace.
Regards
Pete
-Original Message-
Sent: 18 September 2003 23:35
To: Multiple
Assume your table is name fred:
select a.col1 a.col2 a.col3||b.col3||c.col3
from fred a, fred b, fred c;
Allan
-Original Message-
Sent: Friday, September 19, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have the following data in a table:
col1 col2 col3
1
And on some platforms, like OpenVMS, async IO isn't an option -- it's the
default. :)
Rich
OpenVMS bigot, despite not having any more VMS boxen around... :(
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
Matt,
Well I'm happy to see that you consider WAFL as crafty. In my book it does
not have such a nice connotation. Consider the typical disk drive where you layout
your files as contiguous blocks of space around the disk drive. So long as the file
remains it's current size all of
available raid stripe that's free and writes the block there, then updates
the tree. Besides being rather crafty, it creates a situation where
And the tree is living in batter backed cache?
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
That gives you only the current use of sort segments. The same applies
to reasoning based on v$sort_usage and V$TEMP_SPACE_HEADER. The only
True Way(TM) of tuning sorts is by using v$sysstat and v$sesstat values,
That gives you an overview of the sort statistics since the instance (or
the
I have seen more requirement for individual
development databases ( where ind schema is not possible ) due to complexity of
application . Developers step on each other if they work of same database . A
pl/sql developer is invalidating procedure while a java developer is trying to
make his
Hi!
Just few additions about 9i's nice features for tuning sorts, hash joins
other work area operations:
SQL select n.name,s.value
2 from v$statname n,v$sesstat s
3 where n.statistic#=s.statistic#
4 and n.name like '%workarea executions%'
5 and s.sid in (
6 select sid from
That gives you only the current use of sort segments. The same applies
to reasoning based on v$sort_usage and V$TEMP_SPACE_HEADER. The only
True Way(TM) of tuning sorts is by using v$sysstat and v$sesstat values,
I think tuning sorts based on in-memory sort vs not-in memory sort
calculations
Well, the other semi-unique thing about WAFL is the fact that all meta-data
stored in files, rather than custom structures. So, the tree I was
describing is actually three files- the free inode map, the free space map,
and the inode file. The most important one for our purposes here is the
Tanel, you are a genuine treasure and a very nice addition to this list.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tanel Poder
Sent: Friday, September 19, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L
I'll amend The True Way (TM) based on your suggestions.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tanel Poder
Sent: Friday, September 19, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
As long as your management doesn't base its decisions on the ratio of
databases per DBA. Otherwise, you may cut the number of databases and then
management will say why do we need so many DBAs.
I can see performing server consolidation. That can reap a real ROI in terms
of Oracle licensing.
The real differences between NAS and SAN is how data is accessed - NAS is
file-based (open this file, read that file, lock this other file) while
SAN, like direct-attached, is block based (read block 45345 from disk 7,
write block 2442 from disk 3). SAN runs over Fibre Channel, which is a
That reminds me of structures called BITMAP.SYS and VOLUME.SYS
directory
names like SYS$SYSTEM:[SYSEXE], but unfortunately, those things belong to
the
forgotten past in a galaxy far, far away where Billy Bitsandbites was
fighting
VMS demons.
--
Mladen Gogala
Oracle DBA
-Original
Janet,
Sorry, I'm just going through the list. I've run into the same problem.
Have you got any answers? I got it resolved by using the following code
that I found but I don't remember where/who I found it from. Something like
this:
String FChar =
True, true - snapshot management in database environments is certainly a
pain point with Netapps, and its also true that the performance degradation
due to filesystem aging is negative as well. However, a lot of that is
mitigated through the use of lots of spindles, the fact that tied disk
Matt,
Question: What else do you have running on your Fiber Channel? Answer: Nothing
Question: What do you have running on your TCP/IP network? Answer:
Everything.
For this one can see that a SAN's fiber channel is dedicated to handling data
from one server to
Mladen Gogala scribbled on the wall in glitter crayon:
That reminds me of structures called BITMAP.SYS and VOLUME.SYS
directory
names like SYS$SYSTEM:[SYSEXE], but unfortunately, those things
belong to the
forgotten past in a galaxy far, far away where Billy Bitsandbites was
fighting
VMS
British Company Declares War On Internal E-mail
British telephone retailer Phones 4u expects to save about $1.6 million
a month by prohibiting employees from sending interoffice e-mails.
http://computerworld.com/newsletter/0,4902,85174,00.html?nlid=AM
Dick Goulet
Senior Oracle DBA
Oracle
I have installed 9iAS R2 v9.2.0.1, Solaris 9 on a Sun E250. What type
of problem are you experiencing?
Carol
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Has anyone successfully installed 9iAS R2
Here
we have 3 environments formost applications (dev, QA andprod) and
all Oracle version are the same (8173 now). It works fine. And to save Oracle
license costs, we also consolidated some db servers byputting multiple
instances onone server machine.No problem so
far.
Guang
The way SQL*Plus works:
if you run a script with set echo off, but the script has a multi-line comment
beginning with /* and ending with */,
every comment line after the first one will show in the SQL*Plus output with DOC in
the line prefix instead of SQL.
The show errors will not show errors
Speaking of Britts, here is an innovative do not work at home
money making opportunity, originating in the UK.
http://www.wewantyoursoul.com/
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Goulet, Dick
Sent: Friday,
I just dumped all my old VAX/DEC Professional mags a month or two ago. I
miss the Bruce Ellis, KGB, and Goat Hunter articles. Great tech stuff. At
least someone younger than me is now experiencing Bitsandbites.
I still have my VAX Architecture Reference Manual though...
Rich
Rich Jesse
I saw that on cnn.com too. Didn't the article say the guy has broken his
neck three times? Maybe that tells you something.
-Original Message-
British Company Declares War On Internal E-mail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
Maybe we should ban all email mailing lists also, including this one. List
members will have to communicate either face-to-face or by phone (that is:
user group meeting or call other list members with questions).
Guang
-Original Message-
Goulet, Dick
Sent: Friday, September 19, 2003 1:55
Looking for an a sample cursor routine to load a PK enabled table to eliminate
any dupes from the load table.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
To counter that...
If our network admin had our NAS traffic on the same backbone as our internet/itranet
traffic, they
would very quickly be looking for employment elsewhere...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Title: Message
Thanks for the suggestions. I already have planned to move all our
instances to one server and move all schemas (in all instances) to sys schema.
This way I can have better use of system tablespace and drop all other
tablespaces. Also I will put in a cron job to "rm" all
Title: Message
Unfortunately, thats what we
have! And yes, my resume is on-line Our database configuration and
installation was outsourced and so was the installation of our ERP. So guess
what happened? No consultation with the support analyst and now
they want to split the
Ron
I think you are correct. However, most network administrators might not
understand Matthew's suggestion of gigabit + jumbo frames. In fact, I'm
not sure every system vendor has gigabit network cards available, and even
if they do, the price may be an issue.
Dennis Williams
DBA, 80%OCP,
Well, it is certainly true that the advantage of dedicated infrastructures
is that they're guaranteed to be useless for other tasks. :) However, the
notion that because TCP/IP is used by many applications it is unsuitable for
storage traffic is simply not true.
Proper network and infrastructure
Johann,
how about the following. what this does is, using the inner begin/end
block, catches when an insert would fail because of the PK failure and
ignores the error.
This is very quick and dirty - it will work fine if you are not working with
a huge amount of data.
declare
cursor c1 is
Easy way:
delete from table where rowid not in (select max(rowid) from table group by
PK);
Complicated way:
Alter table mytab enable constraint PK exceptions into exceptions;
Then, you should see how many rows are duplicated and use the method 1
on that set of rowids. If the table in question is
except your too_many_rows exception should be dup_val_on_index...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
OK my first usage of log miner seemed to go exactly by the book until I went
to look at the data in v$logmnr_contents. The sql_redo column was filled
with strings like the following.
update UNKNOWN.Objn:3167 set Col[43] = HEXTORAW('7867090f010101') ...
I created the dictionary file, and didn't
You know, I never use that exception, so I can't remember it correctly.
You are correct, of course - thanks for embarrasing me in front of thousands
and thousands and thousands (how many Jared??) of people! :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Check SQL Reference for exception_clause when creating Primary Key.
Could help to do what you need just using SQL (no PL/SQL).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mercadante, Thomas F
Sent: Friday, September 19, 2003 2:55 PM
To: Multiple recipients of list
Hi
Research the wrap command, the binary is located in $ORACLE_HOME/bin and
running it for example would be like this for instance:
$ wrap iname=./test.sql oname=./test.plb
kind regards
Pete
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
components.com writes
how can I wrap package
Thanks Tanel,
cheers
pete
In article [EMAIL PROTECTED], Tanel Poder
[EMAIL PROTECTED] writes
Hi!
Take look at the following link if you want to have a taste of Tom's new
book.
http://www.osborne.com/products/0072230657/
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
The case for Fibre is getting less and less compelling all the time. The
last holdout was those who are serious about block-based storage access
(which is understandable), and iSCSI has effectively filled that gap.
Fibre
isn't going away anytime soon, but whenever it does, its not soon enough
This is the true way only until more advanced mechanisms for digging into a
problem become available.
(They might already be here, without our knowing ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 19, 2003 8:29 PM
Hi Tom-
Submitting to a listserve is like living in a small town. Make 1 little oops and
everybody knows
about it.
Do I need to look over my shoulder on the way to my car tonight??? ;)
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. --
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch126.htm#1015367
I backup once a week. Default as per the manual is 7 days.
I might skip taking backup due to various reasons i a week. How will
i ever know what % of my control file records are avbl.for
rewriting and that i
SQL describe chanarch_nlc.archive_wave_i
Name Null?Type
- --
PV_ID NUMBER(38)
TIMESTAMP DATE
Of course, that is the default for Windows NT, 2000 and 2003 as well.
;)
On Fri, 2003-09-19 at 09:29, Jesse, Rich wrote:
And on some platforms, like OpenVMS, async IO isn't an option -- it's the
default. :)
Rich
OpenVMS bigot, despite not having any more VMS boxen around... :(
Rich
I think the 'wierd' part that is referred to is the
fact the undo blocks dropped from 893 to 2, then jumped
back to 3181.
Without a commit in the middle, that does seem a little weird.
Jared
On Fri, 2003-09-19 at 08:54, Jamadagni, Rajendra wrote:
try committing and see if the number changes
Hrrrmmthe on-topic-ness of this has strayed far from Oracle. My
apologies.
Not sure I agree with the last statement... I think it is on topic... Many
of us DBA types are often involved in these kinds of discussions internally
and the more informed we are the better off we are... It
Send the man a pair of Madonna's panties. He noticed!
-Original Message-
I think the 'wierd' part that is referred to is the
fact the undo blocks dropped from 893 to 2, then jumped
back to 3181.
Without a commit in the middle, that does seem a little weird.
Jared
--
Ron,
We are 'in the process' of moving from 11.5.7/8.1.7.4 to 11.5.8/9.2.0.4 -
planning/testing starts after approval. We went ahead and installed a test
db in any case. Make sure that you start out with 9.2.0.4 - the older
9.2.0.3 is buggy and Oracle seems to have ratified .4 recently.
John
MacGregor, Ian A. wrote:
SQL describe chanarch_nlc.archive_wave_i
Name Null?Type
- --
PV_ID NUMBER(38)
TIMESTAMP
John,
Thanks for the info.
You may want to skip 11.5.8 and go to 11.5.9. There are major patches (the family
pack variety) to
apply subsequent to 11.5.8
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
OK seems I must have fat fingered something when I typed in my dictionary
location in start_logmnr. Odd though I saw no errors.
-Original Message-
Steve McClure
Sent: Friday, September 19, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
OK my first usage of log miner seemed to
one caution:
there is no unwrap cmd/exe
Regards
On Sat, 20 Sep 2003 Pete Finnigan wrote :
Hi
Research the wrap command, the binary is located in
$ORACLE_HOME/bin and
running it for example would be like this for instance:
$ wrap iname=./test.sql
Folks,
We are in the process of evaluating - migration from Oracle Names to 9i OID
and will be glad to know
your experiences.. I understand that clients should be 8i. we have Oracle
Ver. 7 thru 9i.
Listed below is an overview of the procedures..
a) Installing 9i OID on the database server
b)
You need to monitor it on the transaction level not rolled up to the user
level.
Waleed
-Original Message-
Sent: Friday, September 19, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
No question here. Just something weird. This is a long-running insert with
NO NONE ZERO ZIP
Great idea, Mark!
By the way, does anyone remember the yes command in UNIX? Same concept.
I think it was invented to answer ³yes² to any program which mindlessly
prompt for ³yes/no² responses in situations where only ³yes² makes sense.
Case in point: ³fsck². As in: ³Do you want to repair this
If you want to get the same effect entirely from the SQL prompt (i.e.
without having to issue operating-system copy commands), you can first
create a tablespace (named DUMMY_TEMP?) with datafiles of the name and size
you want for your TEMP tablespace. Then drop the DUMMY_TEMP tablespace and
Plus, no more jinitiator in 11.5.9! Finally, the removal of
SQL*Form/Oracle*Forms/Forms is complete...
on 9/19/03 4:24 PM, Ron Thomas at [EMAIL PROTECTED] wrote:
John,
Thanks for the info.
You may want to skip 11.5.8 and go to 11.5.9. There are major patches (the
family pack
Don't know for sure, but I'll bet that OCFS doesn't bother with a buffer
cache and simply performs direct I/O, just like raw devices. Besides better
performance for databases, it also eliminates the need for cache coherency
mechanisms like the innards of RAC.
Sometimes the simplest explanation
Sorry for the last response in this thread which was truncated. Very
annoying! The full response looks as follows (hope this goes through in
it¹s entirety)...
-- Forwarded Message
Date: Fri, 19 Sep 2003 22:05:19 -0700
To: [EMAIL PROTECTED]
Great idea, Mark!
By the way, does anyone
95 matches
Mail list logo
