Apology accepted. We had to do a lot of hard work to get those
superman-style crystal shafts. Among the things we had to do the get
the shaft:
- Stand on a piece of masking tape on the stage
- Not make fun of the OCM program while we were getting the award
- Not make fun of any of the other
hi ,
Is Any body using 170systems ?
Can you please send me the documents or any info you have.
Also we are planning to interface 170systems to Oracle Financials .
If anybody has already done this please can you send me the docs.
Waiting for replies..
Regards
Kirtish P. Gaonkar
--
Title: RE: wintercorp survey
DSS has a bunch... and if you do platform Unix you only get 3 results, adn they are all Oracle.
-Original Message-
From: Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: 12/11/2003 6:04 PM
Subject: wintercorp survey
Can this be right?
I change it with an alter rollback segment, but when i bounce the instance, it goes
back to the default of 1m.
is there a way to make the change permanent?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network
Hi Jonathan,
SQL create tablespace bowie_test
2 datafile 'c:/bowie/bowie_test01.dbf' size 100m
3 extent management local uniform size 1m
4 segment space management auto;
Tablespace created.
SQL create table bowie_assm (ziggy number)
2 tablespace bowie_test
3 storage (initial 1m
Yechiel,
Thanks for the clerification. I thought that Veritas purchased
BackupExec and renamed it to NetBackup.
When you say that Veritas provided an output option for RMAN are you
referring to the storing of the RMAN output on disk or tape in a format
that Veritas uses for it's tape drives?
Hi Robert,
That's all very interesting.
The various press releases at the time (e.g.
http://www.dulcian.com/PRESS%20RELEASE_OCM.htm) all suggest that the 6 best
Oracle experts in the world were handed these prestigious awards. Even the
TUSC website only makes mention of these awards being handed
Hey Richard,
One of my desktop treasures is an autographed copy of
Jonathan Lewis' book, Practical Oracle8i. The humorous,
self-deprecating caption in the author's own hand:
'Never believe all you read.'
Scott
[EMAIL PROTECTED] 12/12/03 7:24:24 AM
Hi Jonathan,SQL create tablespace
Jeremiah,
You really had to expose your self to get the shaft as you so
stated. I just have to show up at work.
Congratulation on receiving the certification and being recognized for
the knowledge you so willingly share.
Is there really a live after being a DBA? I prefer creating furniture
for
All this nonsense about who got what and did they deserve it. Only one
questions comes to mind.
Are we all in High School or something? Did I miss the throwback in time?
sheesh.
Tom Mercadante
Oracle Certified Professional
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
how many people are actually OCMs? and those of you that are, has it helped you in
getting work?
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi
Title: RE: Re[2]: char is going away?
On Informix, at least as late as 9.1, using varchars was down right dangerous. There were numerous bugs associated with them. In my last shop we would not allow the use of varchars because of the grief they would cause. A few months after I moved on, I
Title: RE: Re[2]: char is going away?
Lucky us ... we are staying put on Oracle ... until the powers to be
decide otherwise.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
Tanel,
Thanks for sharing the presentation in the 10g features.
I started looking at the slides and I have a question about the cross
platform transportable tablespaces and the command you used.
From what I gather in the command I can take a Unix based datafile and
convert it to a Microsoft
extreme parallelism:-) A share-nothing
architecture. and some specific software that takes advantage of a hardware
configuration.. It's pretty cool stuff for the high end in size DB's. I
have seen/performed several comparisons.. And when you are spinning thru large
result sets (millions of
But if you run it on small server, ie Windows
2000/XP with less than 1GB memory, Teradata performance is aweful. It hangs from
time to time and even some simple query takes considerable time, while Oracle
and Microsoft SQL Server never behave like that.
- Original Message -
Jonathan is correct - WalMart uses Teradata.
And they're selling gallon-sized Vlasic pickles. I always wondered who
was buying such a monstrosity. It's a bi-annual pickles supply in a single
package.
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
-Original Message-
Sent: Friday, December 12, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
Jonathan is correct - WalMart uses Teradata.
And they're selling gallon-sized Vlasic pickles. I always wondered who
was
LOL perhaps I was wrong then... I could have sworn you all had to go
through a beta trial of the program, but maybe I've got some false memory
stuck in my head, wouldn't be the first time. I stand corrected.
Cheers!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I have accidentally deleted my table in development env. RMAN is the only backup
available here. How do i recover the droped table?
Any help would be really appreciated.
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat
Mladen
I'm pretty confident of one thing -- if they weren't selling, Wal-Mart
would quickly stop selling them at that store. Most people don't think about
it, but Sam Walton figured out a couple of things early on:
1. If you don't have the item on the shelf, people can't buy it.
2. Hire a
You probably think you're joking.
Unfortunately . . .
We've been fighting with Oracle for several months
about SEVERE performance degradation on an OpenVMS
application after we upgraded the database to 8.1.7.4
One of Oracle's recommendations taken directly from
our TAR just 2 weeks ago:
o
Title: RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
A 9 year old little girl who will BUY pickle juice at school will insist on gallon jars of (good) pickles. Walmart isn't dumb, they know what they can and can't sell.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate
Friday, December 12, 2003, 10:54:25 AM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG And they're selling gallon-sized Vlasic pickles. I always wondered who
MG was buying such a monstrosity. It's a bi-annual pickles supply in a single
MG package.
I just read an article about that, somewhere.
http://pr.caltech.edu/media/Press_Releases/PR12465.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
We are running 170 Systems. Unfortunately over dblinks to a database
hosted by our parent corporation. It is abysmally slow. I'll try and
find some docs for you. Please reply to me off list with an email
address capable of accepting mulit-megabyte pdf's at
[EMAIL PROTECTED]
Allan
Take a look at TSPITR (tablespace point in time recovery), I believe that's
how it's performed as I've never tried it. Essentially RMAN creates a
temporary database, recovers the objects in the tablespace targeted for
recovery, and then you can recover the data in the object(s) in question.
At
April, I wasn't saying that they were dumb and I know that the stuff is
selling but I must admit that I would have a problem consuming a gallon
of pickles before they get moldy and yucky. I'd probably turn into a pickle
after that. I wasn't critical of Wal-Mart, they're only catering to the
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do
a flashback query. If not, you must recover the database to the specific
time, you cannot recover just a single table. You should probably read
the TSPITR recovery chapter in Rob Freeman's book. I have, a long time
ago, but I've
LG,
Is it possible to establish further downstream snapshot replication from a
snapshot site in 8.1.7.0.0/Solaris 2.8? I know this can be done in 8.1.7.4.x
and 9i and I can not build multi-master replication due to restrictions :-(
i.e. I'd like to perform: master -- snapshot (new master) --
Mladen,
Have you been to Sam's club or Costco?
Those are the amounts they sell. Well, almost :)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Friday, December 12, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Ouch.
Suddenly, it seems not so funny
-Original Message-
Sent: Friday, December 12, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
You probably think you're joking.
Unfortunately . . .
We've been fighting with Oracle for several months
about SEVERE performance
Mladen
Okay, now you've done it. Bear in mind that I grew up about 100 miles
from Bentonville.
Yew fancy-schmancy city slickers just don't know what good eatin is. Get
a couple of your buddies, their coon dawgs, copius quantities of beer, and
just relax in the back yard, drinking, eatin
Friday, December 12, 2003, 11:49:27 AM, Mladen Gogala ([EMAIL PROTECTED]) wrote:
MG but I find it incredible that market demands gallon sized jars of
MG pickles. What is next? 50 LBS bag of Hershey's kisses?
You have to understand the way of thinking here in the
States. Bigger = better. I once
You may have something there. Lots of people with a real thing for
chocolate would probably bless your name. Can you just here the Hail
Malden calls rising up from Hershey PA and great centers of chocolate
consumption across the nation, followed by cheers from cardiac
specialists! :-)
Allan
Metalink Note:223543.1 has good information on how to recover just a single
table using a modified TSPITR. I performed this operation successful on a
data warehouse.
Josh
-Original Message-
Sent: Friday, December 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Jay, if it is
Title: RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT
A six pack of beer per person sitting outside near a swamp on a hot summer night watching a bug-zapper. Now that's entertainment!
Jerry Whittle ( born and somewhat raised in Kentucky )
ASIFICS DBA
NCI Information
how do you move over to the academic database world? it seems like the most
interesting stuff is going on there?
From: MacGregor, Ian A. [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 11:29:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: More Advances in
Hi!
Tanel,
Thanks for sharing the presentation in the 10g features.
I started looking at the slides and I have a question about the cross
platform transportable tablespaces and the command you used.
From what I gather in the command I can take a Unix based datafile and
convert it to a
Dear Andy Mladen
Thanks for your immediate help.
BTW what is the best book for RMAN in the market( ver 9i). I heard some positive
comments about Robert Freeman's book.
Thanks
Sami
- Original Message -
Date: Friday, December 12, 2003 11:34 am
Take a look at TSPITR (tablespace point
Just trying to keep this On-topic! See extract of Wal-Mart's IT approach vs
K-Mart
http://searchcio.techtarget.com/originalContent/0,289142,sid19_gci938869,00.
html?track=NL-35
Wal-Mart's step change approach to IT investment during the 1990s is a
great example. First, the company installed
Hi!
I believe flashback query works only on existing tables, you can query
deleted data from it for example, but you can't see dropped tables with it.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 6:59 PM
Jay,
Dear Gurus,
What is the difference FGRD and ARCH in v$archived_log.creator column.
I understand FGRD is foreground process. Exactly in what scenario the value will
be populated as FGRD?
I see something like below in my db.
select recid,creator from v$archived_log
RECID CREATOR
- ---
You can use export and flashback to recover a dropped table.
The only time I needed it, it gave a warning on the export but still
worked OK.
Simon Anderson
SciSys
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/12/2003 17:49
Please respond to ORACLE-L
To:
Time to kill this thread folks.
Jared
Whittle Jerome Contr NCI [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/12/2003 09:24 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Re[2]:
All,
This sounds wy too familiar to me.
My (blind) guess is that sql*net round trips is killing performance.
System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after.
We brute forced the issue of
FIRE
IN THE HOLE! FIRE IN THE HOLE!
BO!!
MISSION
COMPLETED SIR.;-)
--
bILL "sHREK"
tHATER oracle dba
"i'M GOING TO
WORK MY TICKET IF i CAN..." -- gILWELL SONG
[EMAIL PROTECTED]
tHERE'S
No idea how many there are at this stage. I'd suspect less than 100,
and possibly even less than 50 at this stage.
As for helping in get work, I haven't changed my job since I got it, but
that really wasn't why I did it anyway. I did mine as one of the beta
testers, so my reasons for doing it
The Oracle documentation. It's pretty good and that combined with Metalink
should give you most everything you need to know.
At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote:
Dear Andy Mladen
Thanks for your immediate help.
BTW what is the best book for RMAN in the market( ver 9i). I
by
definition, their product is a combination of software/hardware. Their hardware
runs an NCR flavor of Unix, has specific disk farms, and has a specialized piece
of hardware/software for the BY-NET(their version of the interconnect). you
combine their nodes into cliques (4 nodes to a
Rob Freeman's book is actually excellent. I wholeheartedly recommend it,
not only because Robert is paying me commission but also because you have
every hing in one place and you don't have to search endlessly for useful
examples and explanations. Robert's very clear and to the point style of
Do you know any script for doing export and backup of Oracle 9i R2
server?My oracle is on a SuSE linux.
Mladen I'll send you $10 payment fee via paypal :)
joe
Mladen Gogala wrote:
Rob Freeman's book is actually excellent. I wholeheartedly recommend it,
not only because Robert is paying me commission but also because you have
every hing in one place and you don't have to search endlessly for
Sami,
While you are purchasing the reading material also look at the 101
series as excellent references. Oracle Performance tuning 101, Oracle
dba 101, Oracle backup and recovery 101.There are a lot of excellent
references on the market and a lot of authors participate on this list.
You can
That
is the case. I do have tablespaces that are locally managed - I did the
migrate with compatible set to 8.1.7. I did startup the database.
However, my system tablespace is dictionary managed - all others are not.
The
migration worked. I have large databases and have been using
More weirdity based on the situation from the last email...
SQL insert into junk values ('Y');
1 row created.
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
T T
- -
Y X
SQL insert into junk2
Sorry for the repost... I got all excited there...
More weirdity based on the situation from the last email...
SQL insert into junk values ('Y');
1 row created.
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2
Hi!
I have a query that I think is behaving oddly; and, it may just be that I'm
blind and am doing something silly (*there's* a first!), or it may be
environment specific, but, I'm thinkin it may just be a bug. I have filed a
TAR with Oracle, and they keep sending workarounds, when I told them
The scripts depend on your set up and environment.
Cold backup..
Shutdown database
copy all datafile,controlfiles,.ora files, etc to a separate disk
startup database
Hot backup..
place the tablespace in backup mode
copy the datafile to a different disk
place the tablespace in normal mode
...
My Question:
I just tried to locate the web site for Joe's scripts,
and I got an error or something. Wasssup?
My Contribution (xmas season and all...):
http://www.secunia.com/internet_explorer_address_bar_spoofing_test
Is it too early to wish merry xmas to all?
Thanks in advance.
Regards,
Mike
Yes. It's called RMAN.
On 12/12/2003 02:04:46 PM, John wrote:
Do you know any script for doing export and backup of Oracle 9i R2 server?
My oracle is on a SuSE linux.
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET:
Has anyone actually installed Oracle on Fedora? I don't want to be the first one.
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
well, somebody has to be first. why not you? come-on - go out on a limb
for once!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 12, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
Has anyone actually installed Oracle on Fedora? I don't
What is Fedora???
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:19 PM
Has anyone actually installed Oracle on Fedora? I don't want to be the
first one.
Mladen Gogala
Oracle DBA
--
Please see the official
Again what is FedOra? Too lazy to run google at this time...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:29 PM
well, somebody has to be first. why not you? come-on - go out on a limb
for once!
Tom Mercadante
Title: RE: Strange behavior continued...
bambi -
not that I can provide any insight on your strange behavior, I mean the SQL:-)
But this provided some thought on some chaos going on here on a nice Friday afternoon in Atlanta. thanks for the help:-)
-Original Message-
From: Bellow,
See RedHat.com...
It is the open source for the linux started by RedHat
Ron
[EMAIL PROTECTED] 12/12/2003 3:29:40 PM
What is Fedora???
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:19 PM
Has anyone actually
Junk minus junk2 results in no rows, and when you do the implied
cartesian join between view a and view b, joining no rows with one row
gives no rows.
Makes sense to me.
Carol Bristow
DPRA Inc.
1300 N 17th St Suite 950
Rosslyn, VA 22209
Work: 703-841-8025
Fax: 703-524-9415
-Original
Come on Mladen, Since when do you not want to be first?
Ron
[EMAIL PROTECTED] 12/12/2003 3:19:33 PM
Has anyone actually installed Oracle on Fedora? I don't want to be the
first one.
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen
But you weren't lazy enough to post to the list TWICE???
http://tinyurl.com/yzq3
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Friday, December 12, 2003 2:40 PM
To:
eric king wrote:
Again what is FedOra? Too lazy to run google at this time...
http://fedora.redhat.com/
http://www.linuxjournal.com/article.php?sid=7257
--
Bricklen Anderson
PresiNET Systems
http://www.PresiNET.com
Demo: https://www.presinet.com/secure/login
--
Please see the official ORACLE-L
REdhat freebee...
-Original Message-
Sent: Friday, December 12, 2003 2:40 PM
To: Multiple recipients of list ORACLE-L
Again what is FedOra? Too lazy to run google at this time...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of eric king
Sent: Friday, December 12, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Fedora (pink hat)
Again what is FedOra? Too lazy to run google at this time...
The
That's what I was thinking, too. I tried it on 8.1.7.4 and it works the
same way, as I expected. You would need an outer join to get something
back.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you put
into it. - Tom Lehrer.
Thank you Carol!
Bambi.
-Original Message-
Sent: Friday, December 12, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Junk minus junk2 results in no rows, and when you do the implied
cartesian join between view a and view b, joining no rows with one row
gives no rows.
Makes
Thanks Ron.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 3:44 PM
See RedHat.com...
It is the open source for the linux started by RedHat
Ron
[EMAIL PROTECTED] 12/12/2003 3:29:40 PM
What is Fedora???
-
Bellow, Bambi wrote:
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
no rows selected
SELECT a.*
, b.*
FROM (SELECT dummy x FROM dual WHERE 1 = 2) a
, (SELECT dummy x FROM dual) b
WHERE b.x
No problem. You are trying to create a cartesian product of the two queries.
Now, what is a Cartesian product of the two sets, A and B? It is a set of
all ordered pairs (a,b) where a is element of A and b is element of B.
The result of your firs query is an ampty set:
SQL select * from junk
On Fri, 12 Dec 2003, Mladen Gogala wrote:
I haven't but I've got a machine up and running with Fedora (fedora.redhat.com for the
person who asked previously) and would be willing to give an install a shot. Latest 9i
I assume? Any particulars you'd like me to look for?
Has anyone actually
Bambi,
I don't think there's a bug here.
Junk contains A,B,C.
Junk2 contains A,B,C,X.
Junk2 minus junk will yield X.
Junk minus junk2 will yield 'no rows'.
So, if you select from the cartesian join of the two inlines, and one of the inlines
has no rows, then the output will have no rows. In
Hi,
I have attempted to install 9.2 on Fedora. If you follow the
www.puschitz.com instructions for RHAS 3, it installs. I haven't
created a new DB yet, but have mostly been looking at the OEM tools.
Which, by the way, only partialy work.
At least I haven't gotten them to fully work yet. The
If it's from Oracle, I would believe it, i.e., I would believe
somebody did actually say that ;) But it does not make it right. Now
only if management knew/believed that.
Some more from Oracle,
- Oracle writes to one log member and then the other. So you need both
log members for recovery.
Nope. I'll try it myself this weekend (9.2, of course).
On 12/12/2003 03:59:42 PM, Daniel Hanks wrote:
On Fri, 12 Dec 2003, Mladen Gogala wrote:
I haven't but I've got a machine up and running with Fedora (fedora.redhat.com for
the person who asked previously) and would be willing to give an
If no one fesses up by tonight, I will spend 2 hours
and do it myself. Quite a simple task.
I will install the 9.2.0.4 Enterprise with all
optional S/Q for the test. Does anyone have special
requests? E.g.
Number of disk drives?
Amount of RAM?
Database type (DW,OLTP,GENERAL,etc)?
Character set?
Title: RE: Strange behavior continued...
Any
time, Greg!
:)
Bambi.
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Friday, December 12,
2003 2:39 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Strange behavior
continued...
bambi -
oracle provides a toolkit.
- Original Message -
From:
VIVEK_SHARMA
To: Multiple recipients of list ORACLE-L
Sent: Friday, December 12, 2003 1:14
AM
Subject: RE: Code Conversion from MSSQL
into Oracle
Are there any
TOOLs for converting Sample Code
Can we, please, change terminology and use the term log file
instead of log member. I distinctly remember backup recovery
class in NYC when a guy with a heavy accent popped the following
question:
Can I recover the database if I lose my member?
It was the time after lunch while we
Thanks, Michael. No requests, just let me know how did it go.
Thanks!
On 12/12/2003 04:19:26 PM, Michael Thomas wrote:
If no one fesses up by tonight, I will spend 2 hours
and do it myself. Quite a simple task.
I will install the 9.2.0.4 Enterprise with all
optional S/Q for the test. Does
I will try to get the output of v$system_event and will send it you guys. In the mean
time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over
looked rest of the chapters but didnt find an easy way to analyze thousands of lines
trace
Paula,
since you use the export utility - patch to 9.2.0.4.
a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0.
regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its not yet available) or the SSL-related issues in Oracle Security Alert #62. but the patchset
I was
just wondering if setting compatible back to 8.1.7 for the CBO reasons was still
necessary?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Paul DrakeSent:
Friday, December 12, 2003 4:49 PMTo: Multiple recipients of list
if you have compatible set to 8.1.7, I'll bet that optimizer features from 9.2.0 aren't available.
you would have to decide if you want to use the 9.2 CBO or the 8.1.7 CBO.
The only reason that I can think of that you'd want to use the 8.1.7 CBO is if your code ran well in 8.1.7 and some
Has anyone kicked the tires on RH AS 3.0?
There is a strong possibility that in a migration early next year, that a client wants to move off of MS w2k adv svr and onto either RH AS or SLES (they are an HP (compaq) shop).
It seems like a bad idea to start them off on RH AS 2.1 now, when they likely
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
I will try to get the output of v$system_event and will send it you guys. In the
mean time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and
over looked rest of the chapters but didnt find
I had installed 9.2 on Fedora and created a new DB. Everything has been
working fine so far. oemapp console, sqlplus and dbca all work fine.
Haven't tried other tools.
As Joe mentioned, puschitz.com is the place to go for installation
instructions, which include downloading a couple of
Hi Jeremiah,
I find the mental image of the six of you holding up your shafts for a
publicity shot profoundly disturbing...
Cheers ;o)
Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 5:19 PM
Apology accepted. We
[EMAIL PROTECTED] wrote:
What is FGRD and ARCH in v$archived_log.creator column.
I see something like below in my db.
select recid,creator from v$archived_log
Oracle9i Database Reference Release 2 (9.2)
V$ARCHIVED_LOG
CREATOR VARCHAR2(7)
Creator of the archivelog:
* ARCH - ARCH process
*
Comments in-line
At 00:49 11-12-03 -0800, you wrote:
But the last time I looked at it, you had
to enable supplemental logging at the
database level if you wanted to use logical
standby. Two side effects -
Yes, indeed, supplemental logging must be switched on.
1) As you said, you need a
Hi Allan ,
Thanks for your quick reply.
I tried mailing you but it rebounced saying unknow host .
Please reply me at [EMAIL PROTECTED] .
Also you can send me the docs on the same email id .
Please zip and send so that none of the files get deleted because of
firewall.
Once again Thanks For the
Hi All
How can I findout what is the version of the jdbc driver installed with oracle client
install.
Thanks and Regards
B S Pradhan
1 - 100 of 101 matches
Mail list logo