Title: Message
You are not running the RMAN you thought you are -
check your $PATH.
Original Message -
From:
Ramon E.
Estevez
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 17, 2003 2:19
AM
Subject: RE: Configuring RMAN
Thanks
Ruth and
ng of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.ora
and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containi
://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spe
; and b.order_id is null ;
>
> This query will return order ids 2 and 3, the ones I want to KEEP. The
query returns the same value in Oracle 8.1 and Oracle 9.2
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> > B
e of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City
Actually, you can capture SQLs relatively
inexpensively by using FGA - simply add the "audit_condition => '1=1'" when
adding a policy to each table.
For OLTP, this wouldn't make much sense. For ad-hoc
(DSS), what you are going to do with all those captured SQLs is another
story.
-
Title: RE: URGENT REPORTS
An X-DISPLAY application (Reports) needs to access
an X-display terminal in order for it to run. You can either give it a real
X-terminal, or you can simulate the functionality (pretend X terminal) with
software, either Xvbf or VNC. Since the application doesn't need
e. So is
> this garbage Or not.?
>
> Niall
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San D
f 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subs
hence a higher setting may be possible.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
different in DW.HTH.Arup Nanda- Original Message
- From: "Binley Lim" <[EMAIL PROTECTED]>To: "Multiple
recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday,
October 21, 2003 10:24 AMSubject: Re: using temp tables for staging
databases?
Title: Message
What is a "VIF on the filer"?
- Original Message -
From:
Matthew Zito
To: Multiple recipients of list ORACLE-L
Sent: Friday, October 24, 2003 7:59
AM
Subject: RE: comparison HP-san vs
netapp
Depending on the number of hosts on your the
What you have described is expected behaviour -
if "the next insert would drop amount of free space less than PCTFREE", the
block is unlinked.
What I had not considered is what
happens when the block is still below PCTUSED? As usual, Steve Adams'
website explains this very nicely - it is
-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE y
eads', value,0)))
> > / ( sum(decode(name, 'consistent gets',value,0))
> > + sum(decode(name,'db block gets', value,0)) ) * 100
> > from v$sysstat
> >
> > What exactly should the number returned by this query tell me?
> >
> >
> >
om). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Analyzing stats would be the first thing to try,
but I suspect the non-elimination is the way the SQL is written.
Assuming you did not miss any brackets around the
"or call_id", the "or" part of the statement would cause a visit to all
partitions. Re-write the "or" section as a join so the
; San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
asting on that and the java pool for other areas.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
ntaining: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
F
gt;
> So has anyone seen this before? I opened a tar yesterday and promptly
confused support.
>
> Lisa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://
may be contained in this message.
> If you are not the addressee indicated in this message
>(or responsible for delivery of the message to such person),
> you may not copy or deliver this messag
go, California-- Mailing list and web hosting services
> ---------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'L
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNS
4
> > 10767 2
> > 10768 1
> > 10769 1
> > 10770 1
> > 10771 1
> > 10772 1
> > 10773 1
> &g
f from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command
.com
> San Diego, California-- Mailing list and web hosting services
> ---------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bin
n advance,
>
> Bart
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web
p
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney
> - Hotsos Symposium 2004, March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
>
> -Original Message-
> Bin
u want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
S
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP
scribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
p://hkchital.tripod.com
--
Rodd Holman <[EMAIL PROTECTED]>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
o be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Californi
Would have thought:
1. A developer would have known this - a SQL
many-to-many join
2. A DBA would have known this - how else would you
know what's happening with your tablespaces? (Clickety-pointy answers not
allowed)
- Original Message -
From:
[EMAIL PROTECTED]
To:
, November 15, 2003 1:19
PM
Subject: Re: SQL Query
Sorry, don't understand the
DBA part ( #2 ).
"Binley Lim" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/14/2003 02:09 PM
Please respond to ORACLE-L
cate.
> I can imagine that Oracle 10 will use that data to recommend indexes - as
> Daniel suggested.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include
self from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command fo
exes are the only way to go -- I've never
> > understood the point
> > of global indexes on partitioned tables -- maybe someone else can?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services
removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
That trick with "still-open" files (don't
shutdown) does not appear to be an option anymore in this case.
As for those _parameters, they could force the
instance to start, but you are likely to have questionable data somewhere - not
something tolerated in a "Financials" application, I would
clude a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS
Title: Message
Since the DB is 40GB, one 70GB drive will do. All
the OS, Oracle binaries as well as the DB should fit in nicely. And no BAARF
problems either ;-)
- Original Message -
From:
Matthew Zito
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August
be Comical Ali, the second?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing lis
mplaining when it doesn't need to. Key
thing is "found valid data" at the end. Happens only in 8i, should no longer
appear in 9i.
However, you can also get the message in 9i with no corresponding "found
valid data". Now - that is a real problem!
--
Please see the officia
o REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send th
perspective.
- Original Message -
> For example, if I am building indexes it is useful to move the table to
attached disk and
> then build the index on the NetApp to reduce bidirectional traffic.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley L
.
>
> Patrice.
> --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
l fields not identical)
> 4) Instance crashes (may not record termination in alert log).
>
> I am wondering if there is an issue with AUM and a large number
> of segments. Any thoughts, experiences, etc. are greatly
> appreciated.
>
> Daniel Fink
>
--
Please see the offici
to interpret
that how you like.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting servi
ock
> yourself into reactive mode versus proactive mode. I leave you to
interpret
> that how you like.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Binley Lim
> INET: [EMAIL PROTECTED]
>
> Fa
es or workarround tips, beside
> disabling
> hash joins?
>
> Thanks,
> Vladimir
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and we
spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.ne
t having an opinion is an art!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
; I
> > am just now starting to
> > gather information on the inner workings of the
> CBO.
> > I know it is where I
> > want to be, I am just looking to see how
> > painful/painless the transition
> > will be.
> >
> > Steve McCl
reference the date field, but do join
>the tables by charge_id still benefit?
No for the same reason as above. It would be also interesting to check
whether you should rather have a LOCAL or GLOBAL index on charge_id in
this case.
--
Please see the official ORACLE-L FAQ: http://www.or
IA
-rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Intern
p a valid measure of IO wait?
2) Is a high io wait an issue to be concerned about?
3) how else can it be accurately measured?
4) How can I link IO wait to what is happening inside
the database?
Thanks,
Jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
LE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (85
listed in a specific order, which I presume matches the file# in
sys.file$. So, if you don't know the proper order, the file information in
the controlfile and data dictionary will be mismatched and thus the db
cannot be opened. Right or wrong?
Thanks to all for the ideas and information.
Da
anks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.o
rom). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Publ
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE y
/www.orafaq.com
--
Author: George Schlossnagle
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yours
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
xt we are getting the wait
> >"buffer busy wait" _& wait on "latch free" for "cache buffer chain"
> >
> >Could an excessively Large db_block_buffer cause this ?
> >
> >NOTE - Transaction OLTP in nature
> >
> >NOTE - freelists i
released to me so that I can upgrade it to
8.1.7.2.1+1967363 (our production is still 8.0.5 !!).
What other bugs are you talking off ?
Hemant
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5
derstanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is
the way to go.
Thank you,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
lease see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
number(10).
>
> I need to partition this table in such a way that
> the data for a given year
> and week number should go to a specific partition.
> Searched Metalink and
> Oracle docs but didn't get an answer.
>
> Is there a way to accomplish this without addi
across this and has some experience to share?
PS: The fix mentioned in 8.1.7.2 (ie recompile/relink) does not make any difference.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
v8.1.7.3 in January 2002?
TIA
Brian
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- P
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACL
ECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: h
te histograms on columns that are frequently
used in WHERE clauses of queries and have a highly skewed data distribution--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also s
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing lis
ifornia-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a lin
85 matches
Mail list logo