Yeah, I was reading and reading for hours studying the fine print of his
presentation :-).
Niall Litchfield wrote:
All of it? how did you plough through all the detail?
Niall
-Original Message-
*From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On
Behalf Of *Jamadagni,
Read ur interesting reply for the query Mladen and learnt
a new rule of thumb from u today.
i sent the doc. to Raju ONLY adn NOT to the list.
it's just the body of the mail u r seeing there.
Regards,
Jp.
22-09-2003 15:49:40, Mladen Gogala [EMAIL PROTECTED] wrote:
Attachments are stripped from
There is a Metalink note 77574.1 entitled Guidelines on When to Rebuild a B-
Tree Index which explains how to use validate structure and index_stats
table. It is far too scientific to ever put into the script. Explanation
for the rule of thumb is simple: if number of index blocks is big that
Hi Listers
Any idea about
this Bug in 9.2.0.4.
If you try "select 'Hello' from dual order by 1 desc;" you may run
into the bug. It creates a dump in udump and could disconnect your session.
Oracle is creating a one-off patch to fix. The bug is for any order by
x, where x is a number,
Anand,
it's the same doc. mentioned by Mladen.
i have sent it to your email address ONLY.
Jp.
22-09-2003 16:20:21, Anand Kumar [EMAIL PROTECTED] wrote:
Prem,
Can you mail me the same document
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
set serveroutput on size 100
set pagesize 0
set feedback off
set echo off
set trimspool on
spool c:\reb_index1.sql
DECLARE
dbname varchar2(20);
wdayvarchar2(11);
BEGIN
That's the doc. i mailed raju.
Thanx Mladen.
can i add a question here :
when is it appropriate to use BITMAP index ?
seems it has lot of restrictions.
read docs about it ...still confused.
say, i have a big table with 50,000,000 records in a OLTP env.
it has column SEX which will have either
Yes, I do this every days for hundreds of tables. But they are not large
tables (max table size about 1.5 million rows). Comparison script is
automatically generated from a table holding a list of the tables to be
compared. These SQL comparisons are wrapped up in scripts which then mail me
if
Err, not quite, actually.
The solution presented below will simply generate the cartesian product of
the sum of attributes from the table.
The (grossly pedantic) solution is:
select distinct a.col1, a.col2, a.col3||b.col3||c.col3
from fred a, fred b, fred c
where a.col3 = 'A'
and b.col3 = 'B'
Munish,
i posted the same content to the LIST this morning.
i tried it on my instance and it happens :((
Jp.
22-09-2003 17:19:39, Munish Bajaj [EMAIL PROTECTED] wrote:
Hi Listers
Any idea about this Bug in 9.2.0.4.
If you try select 'Hello' from dual order by 1 desc; you may run into the
Careful! After a week, the consensus view of the employees was very positive
- they found they had far more time to get on with their work and regarded
the ruling as worth while. External email was not affected. The rule was
merely an attempt to cut down on the amount of internal email
Thanks for all who responded.
--
From: Prem Khanna J[SMTP:[EMAIL PROTECTED]
Reply To: [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: How do we know that an index need to be rebuilt.
SQL select * from v$version;
BANNER
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
PL/SQL Release 9.2.0.2.0 - Production
CORE9.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.2.0 -
Can any body try the following in 9.2.0.4
SQL select object_name,object_type,owner from dba_objects where
object_name like '%DUAL%';
OBJECT_NAME
OBJECT_TYPEOWNER
--
Hi,
and also verfy that X$dual is access after this , this can checked with
explain plan.
If x$dual is not acces then consider to drop dual table, and do
followings:
conn sys as sysdba
desc x$dual
create or replace view v_dual as select dummy from sys.x$dual where inst_id
=
That was the case, back at highschool days...
I think you're still there... at least according to your posts. :)
I call it active learning :)
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services
Title: two instances on same box (Suse Linux ES 8)
Hi!
We are running 2 Oracle instances on one Suse Linux box (under the same Unix oracle user).
We have two oracle homes
9.0.1 (/opt/oracle/iasdb)
and
9.2.0 (/opt/oracle/loga)
The first instance starts up fine, but the second one
What are the error messages??
Should be able to run w/o problems
Jack
-Original Message-
Sent: Monday, September 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Hi!
We are running 2 Oracle instances on one Suse Linux box (under the same Unix
oracle user).
We have two
well superman is poorer than batman
-Original Message-
Sent: 22 September 2003 13:45
To: Multiple recipients of list ORACLE-L
Yeah, Superman had Super powers. Batman just relied on a bunch of gadgets.
Of course my original post was implying the classic it depends. There
are some
Title: two instances on same box (Suse Linux ES 8)
Hi
Helmut,
when
you do switch user
su -
newuser
use
the "-" it will run the .profile of that user, I assume your problem is because
the env variables.
Otherwise(or) you can open a new telnet windows to startup the
other database?
Title: AW: two instances on same box (Suse Linux ES 8)
Hello Jack,
The problem is that the NLS environment does not get reset when using oraenv.
It resets ORACLE_HOME and ORACLE_SID, but ORA_NLS33 always has the values of the first instance.
I had a look at the oraenv script, and there
I tried it on 9.2.0.4 in Win2k and it does indeed disconnect my session :(
Nothing in udump, but it does write to core.log in cdump.
regards
Jo
Munish Bajaj [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/22/2003 10:19
Please respond to ORACLE-L
To: Multiple recipients of list
Have you ever succeded in starting the 9.2.0 database?
jack
-Original Message-
Sent: Monday, September 22, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
Hello Jack,
The problem is that the NLS environment does not get reset when using
oraenv.
It resets ORACLE_HOME and
There is a patch fix for this - patch Number 2990413 - this is for Solaris - I
haven't checked any other O/Ss
-Original Message-
Sent: 22 September 2003 11:55
To: Multiple recipients of list ORACLE-L
I tried it on 9.2.0.4 in Win2k and it does indeed disconnect my session :( Nothing
Ooops - Sorry Monday morning cut paste error - patch number should read 3110923
-Original Message-
Sent: 22 September 2003 11:55
To: Multiple recipients of list ORACLE-L
I tried it on 9.2.0.4 in Win2k and it does indeed disconnect my session :( Nothing in
udump, but it does write
Hi List,
I have placed an order for Cary's book @bookpool.
Does someone know when it will be in stock ?
Can Mr.Cary Millsap let me know that ?
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network
Ohhh ! ...i don't find 3110923 patch fix for Ms-Win :(
22-09-2003 20:39:52, Nigel Bishop [EMAIL PROTECTED] wrote:
Ooops - Sorry Monday morning cut paste error - patch number should read 3110923
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET:
Title: AW: two instances on same box (Suse Linux ES 8)
yes, by starting the 9.01 instance first, then editing /etc/profile.d/oracle.sh file and then start the second instance from a second terminal window. Not very elegant, but it worked...
-- Helmut
-Ursprüngliche Nachricht-
Thanx for the info' Ranganath.
it's too late now.i have placed my order.
that's okay.i will finish it b4 i come there.
it will help me a lot ;)
Regards,
Jp.
22-09-2003 19:59:24, Ranganath K [EMAIL PROTECTED] wrote:
Hi Prem,
The book should be out during first week of October. BTW the
low
Hi gurus,
Could you explain that.
Working with tablespace in locally managed, with uniform extends size, we
want to create LOB but we must have the uniform extend size 3 times the
db_block_size, right?
Otherwise we got ORA-03237.
With dictionnary managed tablespace we don't have this problem.
It's up to the publisher as to when they will print more, Cary has no
control over that.
However... it apparently never GOT to Amazon, as I had it on pre-order
there, and it is still listed as to be released and not shipping :(
--- Prem Khanna J [EMAIL PROTECTED] wrote:
Hi List,
I have
Title: Message
was there much (in that paper) ??
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an
Ron,
Doesn't matter. On the way to your car, or the gym, or to watch your kids
play ball - my Uncle Guido can find you anywhere you go!! :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 19, 2003 5:20 PM
To: Multiple recipients of list
Luc,
got this for u from metalink.
Solution Description
You need to ensure that the extent size specification in the tablespace is at least
four times the
db_block_size. i.e:
Hi List,
Does any know the URL or the code to get Tom's(asktom)
PRINT TABLE procedure? I did search asktom.oracle.com
but i couldn't find out.
Any help would be appreciated.
TIA
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
hope O'reilly prints some more soon.
Jp.
22-9-2003 22:09:40, Rachel Carmichael [EMAIL PROTECTED] wrote:
It's up to the publisher as to when they will print more, Cary has no
control over that.
However... it apparently never GOT to Amazon, as I had it on pre-order
there, and it is still listed as
Title: FW: ADMN errors in startup sometimes with 9ias - help?
Here is the startup output. Any ideas why we might sometimes get these errors?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September 22, 2003 7:01 AM
To: [EMAIL PROTECTED]; [EMAIL
what was the initial printing?
congrats Cary. Hope I can get a copy soon.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/09/22 Mon AM 09:09:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Cary's book -- Out of stock !
It's up to the publisher as to
I also searched asktom and found this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:1035431863958
At 05:29 AM 9/22/2003 -0800, you wrote:
Hi List,
Does any know the URL or the code to get Tom's(asktom)
PRINT TABLE procedure? I did search asktom.oracle.com
but i couldn't
Download it for yourself from
https://www.oracleworld2003.com/published/36849/36849_Kolk.ppt
and see for yourself. But you better have a high speed connection.
At 05:19 AM 9/22/2003 -0800, you wrote:
was there much (in that paper) ??
Raj
Looks as if tech workers are learning the basics of protesting.
http://informationweek.com/story/showArticle.jhtml?articleID=15000146
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS
Title: RE: oraperf.com is now Veritas
Thanks Wolfgang ...
I already had the paper ... I pity the tree.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
Hi Juan,
I read the link this morning but be the server seems to have gone bonks
-Page Not Found error!!
I hope the doc has not been maliciously deleted!!
Any other reference to the doc??
Best regards,
CSW Simon.
-Original Message-
Sent: Thursday, September 18, 2003 3:40 PM
To:
If you want to try and remove a single point-of-failure, you'll want to look
into using replication with OiD. We tried to use version 9.0.1. tried
being the operative word. Granted, in retrospect, I think some of our
problems were due to us trying this on Linux. When we placed TARs, the OiD
Looks like an excellent presentation, both content-wise and visually. Maybe
the latter's due to it being Acrobat and not a PowerlessPoint... :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
We could make a splash by organizing a DBA union. I'm sure that all heads on
the Capitol Hill
would turn when both members show up with banners, demanding better pay for
starved database
administrators. What do you think, should we mandate 9i OCP for joining the
union? If we were
in London, we
The labor unions would definitely be interested. Teamsters, Steel Workers,
AFSME?
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 10:09 AM
We could make a splash by organizing a DBA union. I'm sure that
I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 database
to a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.0.2 to 9.2.0.4] database
through a Database Link.
{I use the 9.2.0.1/Tru64 Database to monitor a number of other
8.0--9.2.0.2/NT-Solaris-Tru64
databases using the
What they REALLY need to do is schedule a meeting. Yes. More meetings.
(because None of us is a dumb as all of us. ... www.despair.com )
-Original Message-
The subtext was - 'why don't you speak to that person instead
of emailing them?'
--
Please see the official ORACLE-L FAQ:
Please make sure SGA_MAX_SIZE works on your h/w platform. It does not work on AIX as
advertised,
and I think Sun Solaris needs some tweaking (related to ISM use) to make it work.
- Kirti
--- Tanel Poder [EMAIL PROTECTED] wrote:
In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL
and
Title: RE: Re: Cary's book -- Out of stock !
UPS just delivered my copy of Cary's book to the office! Can't wait to read it, but first I plan to finish the books I'm currently reading:
- The Art and Science of Oracle Performance Tuning (Chris Lawson)
- Oracle SQL High-Performance Tuning (Guy
Job well done, Tom, the embarrasment is of no consequence. The routine was
modified to include Ron's pointer.
Stats for Tom's first routine below: load table 1.3 million rows, results table
(deduped rows) 48,307. Completion time (via sqlplus over network) 63 seconds.
Second routine (same tables)
Definitely steel workers. We are being left to sweat in dark and we
frequently
get burnt by fire.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of KENNETH JANUSZ
Sent: Monday, September 22, 2003 11:30 AM
To: Multiple
Title: Message
And
don't forget the new Harry Potter book
--Walt
Weaver
Bozeman, Montana
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED] Sent: Monday, September 22,
2003 10:00 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Re: Cary's book
Hello:
Was watching Larry Ellison's key note and he mentioned that they still have
SQL Plus in 10g.
I heard rumor that it was removed. Since it seems as though some from this
list have seen it does it still have SQL Plus or has it been removed?
Thanks In Advance,
Jay
David - You're torturing us man! Lend me your copy so I can read it while
you're working your way down to it. Only fair!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 22, 2003 11:00 AM
To: Multiple recipients of
Title: Message
Also Hillary Rodham Clinton Rodham's book
-excellent fiction.
Ken Janusz, CPIM
- Original Message -
From:
Weaver,
Walt
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 22, 2003 11:09
AM
Subject: RE: Re: Cary's book -- Out of
But do we have to beat up people who refuse to join...
Or make an offer they can't refuse. ;-)
-Original Message-
Sent: Monday, September 22, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Definitely steel workers. We are being left to sweat in dark and we
frequently get burnt
Hi!
Sqlplusw is gone, the windows gui version.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 7:19 PM
Hello:
Was watching Larry Ellison's key note and he mentioned that they still
have
SQL Plus in 10g.
I
You'll have to check with Tony Soprano.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 11:34 AM
But do we have to beat up people who refuse to join...
Or make an offer they can't refuse. ;-)
-Original
Affirmative. I used SQL*Plus during one of the Hands-On 10G Database sessions at
OracleWorld.
Brian
- Original Message -
Date: Monday, September 22, 2003 11:19 am
Hello:
Was watching Larry Ellison's key note and he mentioned that they
still have
SQL Plus in 10g.
I heard rumor
Hi Simon,
seems to be there now, just tried it 4:50pm UK time.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see
No problem with beating people up. Violence is, contrary to Chris Lawson's
book,
an integral part of DBA job. BTW, Chris Lawsons' Art and Science of Tuning
Oracle
reads like Dale Carnegie for database administrators. Basically, we should
give up
our cynical attitude, become indistinguishable from
I'm not sure what's up with Amazon. It was released last week, and it's
showing up at people's houses now when purchased from other sources.
Consider canceling your Amazon pre-order and buying it direct from
oreilly.com.
...I'm pretty sure it's going to be several months before O'Reilly sells
I'm not sure what's up with Amazon. It was released last week, and it's
showing up at people's houses now when purchased from other retailers.
Consider canceling your Amazon pre-order and buying it direct from
oreilly.com.
..I'm pretty sure it's going to be several months before O'Reilly sells
Actually, they will have SQL*PlusPlus, an object oriented extension of
SQL*Plus.
Then there will be Enterprise Plus Stringbeans, Pluslets, active plus pages
and so forth.
Ultimately, they'll end up with fclstwkgr (Freaking Command Line SQL Tool
Which
Keeps Getting Renamed).
--
Mladen Gogala
According to the Oracle rep at a 10G demo, SQLPLUS and PL/SQL still
exist.
Ron
[EMAIL PROTECTED] 09/22/03 12:19PM
Hello:
Was watching Larry Ellison's key note and he mentioned that they still
have
SQL Plus in 10g.
I heard rumor that it was removed. Since it seems as though some from
this
Did you check if it is a privilege issue because the access privilege is granted thru a role. roles are not recognised in PL/SQLHemant K Chitale [EMAIL PROTECTED] wrote:
I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 databaseto a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to
Going from svrmgrl in 8 to srvctl in 9iRAC, I keep typing in svrctl
and then can't figure out why it doesn't work...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From:
dba union could be considered a trust. doctors tried doing it and because they are
'independent businesses' its not a union its a trust. they did it to fight high
mal-practice suits.
From: Orr, Steve [EMAIL PROTECTED]
Date: 2003/09/22 Mon PM 12:34:40 EDT
To: Multiple recipients of list
Title: RE: Re: Cary's book -- Out of stock !
Yey just received my copies of Cary's and Tom's new books. I'll get Toms autographed no 24th, for Cary's it will have to wait till Hotsos'04.
now the sad part ... with the new baby at home, don't know how much time I'll get ... well there is
Have any DBA's ever been sued for malpractice?
I used to belong to a union. One day the union told us to go on strike,
and we did.
22 years later, we're still on strike. I'm sure we'll be going back to
work any day now. Then I can quit this temporary IT career I've been
working at for 22 years
Hej Jay
Yes it stil there :-)
Jay Wade wrote:
Hello:
Was watching Larry Ellison's key note and he mentioned that they still
have SQL Plus in 10g.
I heard rumor that it was removed. Since it seems as though some from
this list have seen it does it still have SQL Plus or has it been
A trust? That is only marginally better then the axis of evil. Do we
risk getting bombed if we establish a trust?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 1:15
SQL*Plus windoz version is removed, not the ubiquitous command line tool.
How can they remove SQL*Plus, the proverbial cockroach tool of the Oracle
world?
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 12:19 PM
Yea they do, i was forced to be part of a union when employed by the
State of OH EPA. There were your typical state employees(lazy and not
doing much, didnt want to learn anything new, etc) and us DBAs working
like nuts and capped on what we could make(back in those days, '94-96,
it was like
It's in the beta 1 software.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Ron Rogers
Sent: Monday, September 22,
Jimmy Hoffa would probably agree with you, once they pull him out
from beneath Meadowlands.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Weaver, Walt
Sent: Monday, September 22, 2003 1:35 PM
To: Multiple recipients
Hi
No this is not true sqlplusw.exe on w2*k is stil there in the beta kit
and I can not find anything about desupport in the manuals :-)
Tanel Poder wrote:
Hi!
Sqlplusw is gone, the windows gui version.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
It's still in oracle\bin in the 10.1.0.0.0 software for MSWin.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Tanel
Mladen Gogala scribbled on the wall in glitter crayon:
A trust? That is only marginally better then the axis of evil. Do we
risk getting bombed if we establish a trust?
maybe, but remember some of us can bomb back.;-)
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I
I read some posts on here with shared storage such as SAN and Network Appliances its
no longer necessary to multiplex datafiles on different disks, since the storage array
handles that for you.
How do you ensure that control files and redo log files are kept safely apart so that
no one disk
Monday, September 22, 2003, 9:09:40 AM, Rachel wrote:
RC However... it apparently never GOT to Amazon, as I had it on pre-order
RC there, and it is still listed as to be released and not shipping :(
Have faith. The books only left O'Reilly's warehouse on the
16th. They would have gone out to
Weaver, Walt [mailto:[EMAIL PROTECTED] on Monday, September 22, 2003
12:35 PM said;
I used to belong to a union. One day the union told us to go on strike,
and we did.
22 years later, we're still on strike. I'm sure we'll be going back to
work any day now. Then I can quit this temporary IT
Monday, September 22, 2003, 7:39:38 AM, Prem Khanna wrote:
PKJ I have placed an order for Cary's book @bookpool.
PKJ Does someone know when it will be in stock ?
We, as in O'Reilly, shipped Cary's books *to* Bookpool on
the 16th. Actually, we shipped some on the 12th and more on
the 16th, which
under the goalpost right?
joe
Mladen Gogala wrote:
Jimmy Hoffa would probably agree with you, once they pull him out
from beneath Meadowlands.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Weaver, Walt
Sent: Monday,
Monday, September 22, 2003, 12:19:41 PM, you wrote:
JW Was watching Larry Ellison's key note and he mentioned that they still have
JW SQL Plus in 10g.
JW I heard rumor that it was removed. Since it seems as though some from this
JW list have seen it does it still have SQL Plus or has it been
The problem that rebuilding indexes is attempting to resolve is sparseness.
Lots of folks think that indexes become unbalanced over time and that is
the reason for rebuild, but Oracle B*Tree indexes are always balanced.
Sparseness is the symptom, however, not the cause. The problem with
Amazon changed status on my order, saying it will ship on 9/24. Are you sure
that
O'Reilly didn't use western style stage coach or wagon train as shipping
method?
Ye-haw!
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
In my opinion, SAN storage begs the question about whether OFA makes sense
anymore. If you can configurte the SAN storage so that all files are
striped across all disk, then everything is spread. And if the SAN is
mirrored, then just why are we working so hard?
EMC SAN disk has such an
Title: RE: download metalink articles - save target as
When I right click on a metalink article to try to save it to a local directory and use save target as - it only provides a blank file. What's the easiest way to save these files locally? I want to because sometimes the more useful ones
Fyi,
I just received confirmation from Amazon that my pre-order was shipped.
American Express made the following
annotations on 09/22/2003 10:46:31 AM
--
Title: RE: Cary's book -- Out of stock !
Ah Cary, you're not giving yourself enough credit. It'll probably be sold out by the end of this week at the latest. It's like the hottest book out there now (seriously). I know I showed someone here the pre-released copy you gave us in the Hotsos 101
While I wouldn't say I was anti-union, when I worked unionized jobs
(construction, teaching, civil service) a long time ago -- it was like working
for two bosses. If you disagreed with the union you had no recourse and were
likely to experience problems if you did. And you really don't want to
Yes. he was under the visitors
goalpost, but I heard he didn't like it
and moved to the home team's goalpost.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 2:14 PM
under the goalpost right?
joe
Mladen Gogala
Title: RE: OFA and Shared Storage
we use a single/double file system.. The LUN is made up of multiple physical disks, striped/mirrored across the multiple spindles based on the storage requirements.
The disk technology has come a long way. Plus there have been several bench marks/white
hi all:
Oracle's explain plan for a report I'm trying to tune
is referring to several temp tables. Is there a way
for me to see any info aobut these tables. Here is my
explain plan:
1.118473 SELECT STATEMENT (56700, 5386500,
118473)
2.0 TEMP TABLE GENERATION (, , )
2.0 TEMP
Files are kept safe simply by RAID-5 mechanism. RAID-5 protects against any
single disk failure (double disk failure can wipe it all out) and that is
precisely
why Mogens is such a zealous proponent of RAID-5 systems.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL
Title: RE: OFA and Shared Storage
Greg,
I
agree that OFA is a great concept for basing your standards on. At least
DBA's who manage several servers can find stuff without spending time querying
the database to find stuff.
But I
worry less and less about spreading and balancing files
Well, its beyond no need to multiplex - it rolls right into might not be
possible (though that's an extreme case). Basically, since today's large
arrays have several layers of abstraction between the storage consumer and
the physical spindles, it can be difficult to determine what physical
1 - 100 of 157 matches
Mail list logo