best place for forms and reports are the odtug listservs at fatcity
there is one called Developer 2000 and one called Designer 2000
>
> From: "Ajay K. Garg" <[EMAIL PROTECTED]>
> Date: 2003/05/29 Thu AM 08:45:40 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: is this
Koivu, Lisa wrote:
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2? I’m
trying to use dbms_stats gather schema stats with the stale option and
it just isn’t working in 8.1.7.4. This is documented on Metalink. I’d
love to hear from someone else if this is fixed
Ajay,
The Oracle Development Tools
User Group (ODTUG) has about a dozen different list serves and many are focused
on development. Check out the web site www.odtug.com and you can register for those
lists with a few mouse clicks. Good Luck! Maggie
Respectfully, Maggie Tompkins - DCII
There are also dev-specific lists tho:
Developer 2000: ODTUG-DEV2K-L, and
Designer 2000: ODTUG-DES2K-L.
Send an e-mail w/the text (for instance)
SUB ODTUG-DEV2K-L
To the address
[EMAIL PROTECTED]
to subscribe.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extens
FBI is supported on 8.1.6 (that is what I use them on), but you may be right
(Babout the compatible setting.
(B
(BDennis Williams
(BDBA, 80%OCP, 100% DBA
(BLifetouch, Inc.
(B[EMAIL PROTECTED]
(B
(B
(B-Original Message-
(BSent: Thursday, May 29, 2003 7:46 AM
(BTo: Multiple recipi
Okay, I've got a question for you people knowledgeable in SAP. Who would
trust their financial and payroll data to MySQL? I'm not saying this to
knock MySQL. It is just that your financial and payroll data is among your
most valuable data in the corporation. Only recently was a transaction
capabili
I am compare the SUN server performance with ORACLE
database. Can anyone
tell me following 4 values which one most import for
ORACLE database:
CINT2000
CFP2000
CINT2000 rates
CFP2000 rates
Thanks.
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with
Hey Lisa (Monkey?),
Yes, I had a problem with the stale option, too, at least under 8.1.6. It
would bomb out with "no more rows" or something like that. Under 8.1.7.4 on
Solaris, I no longer had that problem but I did have some poorer explain
plans than with good ol' ANALYZE. See the "Burned by
I'll
quote the list manager Jared's comments which he made in a mail long
back
"This
is an Oracle mailing List"
So
you should be allowed to post anything related to
Oracle.
Regards
Naveen
-Original Message-From: Ajay K. Garg
[mailto:[EMAIL PROTECTED]Sent: Thursday, May 2
Ajay - While most of us are DBAs, we also deal with SQL and PL/SQL a lot.
When the developers get stumped, who do you think they ask? Their DBA of
course. I don't work with Forms, but I've seen plenty of Forms questions
asked and answered here. There are people here who work with the Oracle
Apps, s
so GTT's help reducing redo when you do inserts and deletes? but not for deletes?
there was a post by tom kyte on dejanews from a few years back where someone asked the
redo question and he recommended GTTs.
here is the link... did I misread it?
http://groups.google.com/groups?hl=en&lr=&ie=UTF-
Darrell,
I put dbms_stats into production, on 8.1.7.4, over two months ago & have not
had a problem. Here is what I did to compute the stats automatically. (BTW: this
runs under system)
create procedure compute_daily_stats is
begin
for a in (select distinct table_owner from dba_tab_
I am running an Oracle 8.1.7 export on a 2G table which contains a Long
column. The export runs for several hours and then just dies with no error
anywhere. I tried to use direct=y but I get an error about character sets.
Any ideas?
Thanks!
Ron Smith
If you are not the intended recipient of this
oh it wasnt none, it was cut in half. I skimmed it.
my bad
> From: Richard Foote <[EMAIL PROTECTED]>
> Date: 2003/05/29 Thu AM 08:45:46 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Which method is more efficient
>
>
> - Original Message -
> To: "M
I
haven't used it, but here is what we are doing: we created a simple package
which loops through dba_tab_modifications and finds itself (the same way as
oracle would) which tables are stale: where the sum of inserts, updates and
deletes is more than 10% of the number of rows, and than run d
You can find the Oracle documentation at technet.oracle.com. This is free,
but you must register. Each new version of the Oracle documentation has a
section titled "New Features".
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday,
Oh yeah, for the export consistent=N
-Original Message-
Sent: Thursday, May 29, 2003 9:14 AM
To: '[EMAIL PROTECTED]'
A certain alignment of the planets occurred creating a good ole ORA-01555 error... A
user level export received the snapshot too old error and terminated. Concurrent to
On 9.2.0.3, I have experienced a problem with online index creation. When
creating indexes on what I suppose most would consider to be large tables
(with nasty, sharp, pointy teeth and a bad disposition), when Oracle is
doing its initial data gathering, sorting, slicing, and dicing in
preparation
Thanks, Wolfgang! I really hope to meet both you and Cary one of these days.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, May 28, 2003 11:05 PM
To: Multiple recipients of list ORACLE-L
I was about to post the results of my te
All
Im need to concatenate my log_date and log_time field (the 2
physical records into one logical record).
I can find how to do it with a fixed length file but my case is a
delimited file. Looking at the docs, it seems the continueif is used for
delimited dtaa, I cant seem to get the syn
A certain alignment of the planets occurred creating a good ole ORA-01555 error... A
user level export received the snapshot too old error and terminated. Concurrent to
this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on
the same schema being backed up via the u
So,
that means that our posts may be about the oracle of Delphi, the early
leader
in the
executive decision support area?
Idis
redibis nunquam in bello peribis.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Naveen Nahata
[mai
Jared - Thanks. Wow, I learn a new trick each day on this list!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, May 28, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
There are easier ways to test redo generation than
Hi Niall,
We´ve already tried this.
Anyway , thanks for your help.
Antonio
"Niall Litchfield"
Got my first look at the 10i beta last night. I can't tell you much about it
except to say that looking at some of the new stuff
h
;-)
While I'm certain many of the new features will not work perfectly for
several releases afterwards, they look very cool
Lisa,
I'm still using Analyze so I have no direct experience with this package.
That being said, would the SET_TABLE_STATS work for the partitions that
haven't been loaded yet?
Mike Hand
Polaroid Corp.
-Original Message-
Sent: Thursday, May 29, 2003 10:46 AM
To: Multiple recipients of l
Oracle doesn't do heavy maths so integer benchmarks should matter the most.
My advice is not to rely on standardized benchmarks but to ask the vendor
for references and then check those references as step one and then organize
a
little benchmark of your own that would use typical transaction(s) of
Hi Darrell & Kirti -
It was late last night when I was looking at this. It seems I should be using GATHER
EMPTY instead of GATHER STALE. However this will put statistics on partitions with no
rows.
When I load new partitions tomorrow (they are empty prior to the daily load), the
number of r
Wow, there sure are a lot of Scott's in India...
-Original Message-
Sent: Thursday, May 29, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
JP,
In the EXPLAIN PLAN, it says "Card=262146", indicating that the query
expects to retrieve over a quarter-million rows. Is that in fact
c
You will want to repost this to [EMAIL PROTECTED] Many users as well as
the TOAD development team are on this list.
Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could
try http://www.quest.com/support/
HTH! GL!
Rich
Rich JesseSystem/Database Admi
used to own the process. DEC no longer exists, people do not remember VAXBI,
LAT,
DECNET, SET HOST, SET DEFAULT, VT220 or even the KED/EDT/EVE editors. DEC
hey, i resemble that remark... i even have all my DCL scripts and
customizations for edt and eve.;-)
--
Bill "Shrek" Thater
Has anybody used the Capacity Planner (SYSMAN) part of OEM? We are trying to
monitor usage of the Application Server, and have the repository set up to
do so. However, I can't quite figure out what "busy servers" means. The
number of busy servers is always very low, and doesn't seem to correlate
wi
Yes, I am in archive log mode and I have had 2 occurances of filling up the
archive log filesystem, but I don't want to change one problem for another.
Bryan
-Original Message-
Sent: Wednesday, May 28, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
have you run it? isnt that alot
You know, of all the impressive things I've ever heard Cary Millsap say (and
there have been a heck of a lot), the one that stands out the most in my
memory is a series of quotes from his keynote at the 2003 Hotsos Symposium:
"An experiment that disproves a conclusion is a success."
"Knowledge in
What are the wait events of the slowed sessions?
What is the correspondence with v$session_longops phases for the
rebuild?
Really, the answer to 75% of the questions in this group is "look at
v$session_wait."
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 29 May 2003, Stephen Lee
Hi,
I can't speculate as to why the export dies, but you can correct the
direct=y character set error by setting the NLS_LANG variable in your user
profile to whatever character set it is trying to export from.
--
Joe Frohne
Rawson Oaks Consulting
http://www.rawsonoaks.com
[EMAIL PROTECTED] or [E
DBAs
only. No trespassing! Trespassers will be shot at. Do not go beyond
this
point
if you're not a DBA. We do not want developers to learn or secrets. That
might
give
them an idea that we're mere mortals.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Ori
Title: RE: Which method is more efficient
Jared,
Agreed, but what about the resources needs to find _which_ column changed ?? Would that offset the extra redo generated? Heck, I'd just generate the update statements based on two tables to _only_ update the changed columns. It is pretty easy,
I am reposting this in the hopes that someone can help me with this puzzler.
I am working on determining which objects have 'hot blocks'.
In two different sessions, I issue "select count(*) from random_data
where rowid_rownum in (1,2,3);" repeatedly to see what happens with the
touch count (x$bh
Title: Unbreakable, my buns. Upgrade to 9.2/w2k
For my OID testing I decided to go with
9.2.0.3.
I installed 9.2.0.1 (software only) and the upgraded
to 9.2.0.3 with no problems.
Since I also documented the process so I will have all the
steps down when I will do it in production I did it twi
Lisa et al,
Am I missing something or did someone ever mention that for STALE to work,
one needs to set MONITORING on required objects? Straight from the Fine
Manual:
Enabling Automated Statistics Gathering
The GATHER STALE option only gathers statistics for tables that have stale
statistics and
Hi,
Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration?
For example:
Box-A (production db server)
Box-B (rman db server)
A cron job runs on Box-B which backups up the d
Mladen - Excellent points. When someone points out the vendor with the
highest benchmark results, I ask "Jeff Gordon is a consistent NASCAR winner
and he drives a Chevrolet, does this mean that you will be buying a Chevy
next?". To me the published benchmark results have about as much to do with
da
Title: RE: HELP - Microsoft Access error SQLSetConnectAttr failed error.
However, I was able to independently through odbctest and tnsping confirm that the odbc driver working and the alias working through Oracle's Net8. I also noticed with the odbctest that the user had a very small and limi
Someone else told me it was blocked.
Personally, I would take it up with my security admin.
tinyurl.com simply redirects your browser, it isn't a
back door to anything, and has no objectionable content.
If a tinyurl url points to a URL that is caught by your firewall,
that is an entirely differe
Robert - Does this mean we can expect a new book "Oracle10i New Features" by
that respected Oracle author Robert Freeman coincident with the 10i release?
I'm ready!
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 29, 2003 10
Everybody is under cost pressures these days, right? Recently my boss required
that I attend a few "webinars" hosted by Microsoft to hear their line on TCO
because he didn't want the choice of our next platform to be a "technical
decision" (we're on Tru64 unix). I don't think I'll be encouraged t
dunno about that. I was making the assumption that *which* columns
changed was already known.
This would require testing by someone familiar with the data.
Jared
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/29/2003 10:24 AM
Please respond to ORACLE-L
Dennis,
We're making very restricted use of MySql, but a greater use of PostGreSql
which has atomic transactions already. I would say the two biggest reasons for
converting are $$$ and speed. Otherwise if $$$ are the only consideration go with
PostGreSql, it's totally free. MySql ha
HELP...
Has anyone encountered rollback problems while running dbms_stats?
-Original Message-
Sent: Thursday, May 29, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Oh yeah, for the export consistent=N
-Original Message-
Sent: Thursday, May 29, 2003 9:14 AM
To: '[EMAIL
TEASE!
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Hi John,
Yes, monitoring was set. I wouldn't see anything in *tab_modifications if monitoring
wasn't set.
Here's a new twist. What percentage are you comfortable with for valid estimates? I
attended a seminar given by Jonathan Lewis a few weeks ago, and he stated that
adequate statistics
Title: RE: skip scan index
Mladen,
Come to Hotsos 2004 ... I can meet you too (unless you are attending 06/09 CTOUG meeting).
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
ok so your goal is not speed. its reducing redo, correct?
so you dont care if its slow?
try using a global temp table. that may cut down your redo significantly.
>
> From: "Rodrigues, Bryan" <[EMAIL PROTECTED]>
> Date: 2003/05/29 Thu PM 12:44:52 EDT
> To: Multiple recipients of list ORACLE-L <
Hi Mike,
Yes, I could use it... but the GATHER EMPTY option set stats on the empty partitions
correctly. I'm more concerned about having old stats on a partition that is now
loaded.
Thanks
-Original Message-
Sent: Thursday, May 29, 2003 12:30 PM
To: Multiple recipients of list ORAC
Dennis,
What he probable means is the OCP upgrade exam will be just like the
first OCP exams, Multiple and expensive..." looking at some of the new
stuff"
Ron
>>> [EMAIL PROTECTED] 05/29/03 01:24PM >>>
Robert - Does this mean we can expect a new book "Oracle10i New
Features" by
that respected
Just a
thought. Possibly to assist in recovery of the database box. If you
have a complete media failure on the DB host, you greatly simplify the recovery
process if your RMAN database is somewhere safe.
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
The incentive? $$$, and lots of it.
Larry E talked folks into trusting Oracle at it's inception, and I'll bet
it
was quite a bit less robust then than MySQL is now.
Give MySQL a couple years and see what happens.
It may never be appropriate for certain apps, but for small to medium
plain vani
how would you do that? if you dont know which columns have changed values? you would
have to compare every column? how else can you do it?
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/05/29 Thu PM 01:24:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> S
A Large Load or Update Before the Exp ...
Delyed Block Clean out is one Reason that really pops out.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
===
Well
How about if you are performing BCV snapshots of the storage
under Box-A (prod server) and then mounting those BCVs on
Box-B, mounting (not opening!) the database on Box-B, and
performing RMAN backups?
That would remove any resource consumption from the
all-important Box-A as far as back
I am trying to track this down for a buddy, any ideas, I know nothing about
C++.
Thanks,
Ethan
Our application currently has presentation programs written in Microsoft
Visual C++ that read Oracle Version 7.3.4 data
-w
A simple disk crash containing the database and the RMAN data woulf
wipe you out. If bax-a crashed you could use box-b to recover your
data.
Ron
>>> [EMAIL PROTECTED] 05/29/03 12:54PM >>>
Hi,
Can anyone think of a reason(s) why one WOULD want to backup a database
from a box other than the dat
You are running into the classical problem with monitoring an experiment:
To what extent (no pun intended) does the monitoring change the experiment.
Referencing dba_extent pulls in the segment headers of all segments owned
by 'BCA'. When you interrogate x$bh have nothing else in your sql. Dump
Need more info:
What are you doing when the error occurs? If it's vb code, can you post it?
Can you connect from the erroring machine via sql*plus?
Can you link a table via the odbc connection & open it interactively?
Does it make a difference if you define a new odbc data source & link
through t
They don't want the choice to hardware, OS and software to be a "technical
decision"?
Why not? TCO is part of technical decision-making, is it not?
Sometimes they decide before input from below then try to force a solution
on the tech people.
In that kind of world, the firm which is best at mar
Title: RE: skip scan index
I just put the Hotsos Symposium 2004
announcement on our web page yesterday. The event will be held March 7–10
in Dallas. It’s early yet, but we already have speaker commitments
from Tom Kyte, Jonathan Lewis, Mogens Nørgaard, and me. We’ll add many more speakers
Thanks, Pete.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 29, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L
You know, of all the impressive things I've ever heard Cary Millsap say (and
there have been a heck of a
Steve,
You may have to dig a little further...
What happened to those table(s) in that schema prior to starting the export? Heavy
DML, may be?
This could be a case of 'delayed block cleanout'. Export triggered the cleanout and
wanted to
access the rollback segments.
If no table data was
After reading the documents I've recommended using LOCAL, UNIFORM, AUTO as
the options for tablespace management. Does anyone have any bad
experiences with these? AUTOALLOCATE seems to come up with extents that
are much smaller than I want and MANUAL segment management requires the use
of FREELI
[EMAIL PROTECTED] scribbled on the wall in glitter crayon at Thursday,
May 29, 2003 2:05 PM:
> Someone else told me it was blocked.
>
> Personally, I would take it up with my security admin.
who is the same as my exchange admin. no thanks, his head is still reeling
from the last encounter.;-)
I wouldn't call 1.4% [ (603826-595500)/603826 ] "way wrong". Actually, for
a 1% sample I find that pretty good. The problem I found with low sampling
percentages is if you have skewed column values. If some values occur very
often and others rather seldom, a 1% sample may only encounter the
fr
Jared,
That is correct the fields that are changed is known before going to this
point.
Bryan
P.S. I just want to say thank you for all the responses to this question. We
are still talking about the issue, but I am thankful for the input.
-Original Message-
Sent: Thursday, May 29, 2003
> We do not want developers to learn or
secrets. That might
>give them an idea that we're mere
mortals.
Yeah,
I've learned from reading this list that not all DBAs are the super-smart gods
they set themselves up to be. Some are actually not too bright, based on
things I've seen here. Th
Hey, with all that praise being heaped on you for publicizing your
"wrongness", who would ever want to be right?
:-)
At 10:51 AM 5/29/2003 -0800, you wrote:
Thanks, Pete.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex C
Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think
Oracle viewed RMAN as a high-level feature that would help you manage the
backups for large server farms. They emphasized that the catalog was the way
to go. With the catalog on another box, if the server was toasted, you coul
Sure, several:
1) Centralized backup management, maybe there will eventually be a
Box-C which can also be backed up by Box-B.
2) Maybe Box-B is a Veritas master media server or the equivilent with
other backup software.
3) Most important: Box-A has a 'crash and burn', you don't lose your
RMAN ca
Thanks, Kip, Jared, Dick - that makes more sense. I now recall that Lawson
also ships a free (non-relational) database with its software. Some sites
use it for their first year conversion activities (and some much longer). It
is much faster than Oracle or the other relational databases. When the
cu
Lisa,
Have a look at ML Note:44961.1 (and maybe Note:114671.1 could also help).
The 1% sample may work for larger tables - I am not sure
John
> -Original Message-
> From: Koivu, Lisa [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2003 11:05 AM
> To: Multiple recipients of list
Thomas - Oracle recommended Local and Uniform, so that is what I use for
everything. It has worked out great. I even use autoextend and that hasn't
bitten me but a couple of times. This is on 8.1.6 and 9.2.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Me
I thought the database was going to manage itself!
Now I'm disappointed, I thought they were going to implement just one nice
big GUI button that does everything.
Patrice.
-Original Message-
Sent: Thursday, May 29, 2003 4:01 PM
To: Multiple recipients of list ORACLE-L
Dennis,
What he
The executable is looking for the oracle-related variables in registry.
Export registry and import it into another box and it will work.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 29, 2003 2:52 PM
To: Multiple recipients o
Hi Wolfgang,
In the grand scheme of things, that probably isn't awful. However, if the analyze
can't get the row count right (how easy is that?) then how can I trust it to get the
rest of the statistics correct? Just my two cents.
Thanks for your reply.
Lisa
-Original Message-
Sent:
heretic!
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/29/2003 12:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: is this DBA's only mailing list?
> We do not want developers to learn or
Title: RE: 10i
Don't know about manage itself. Is supposed to find its own patches, download them and patch itself!
HEY... if it has one big GUI button... and it is a GREEN button (Like SQL Navigator) ... our developers will LOVE it!
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Syste
I looked at bug 1890016 on MetalClink and I'm confused.
Did you run ANALYZE COMPUTE before running DBMS_STATS like the bug's test
case? I thought this was a no-no??? If so, I'm wondering if it would it
help to ANALYZE DELETE then rerun DBMS_STATS w/EMPTY, insert/update/delete
test rows, force an
Hello Bob,
My first thought is to try something like:
...
log_date CHAR
"TO_DATE(:log_date || ' ' || :log_time,'ddMon hh:mi:ss'",
log_time FILLER char,
...
I may not have the syntax just right, and I can't take time
to test it until later this evening (shouldn't be reading
ORACLE-L now any
Ethan
Get him to install the 8.1.7 Client (Programmer) option on the Win2K
Visual Studio machines. I noticed some slight source changes needed
going from the 7.3.4 Proc*C version...i.e. EXEC SQL DECLARE's are
needed everywhere nowbut they should be able to pre-process,
compile and link. the q
Hi Kirti,
Sounds like you have the same suspicions as do we. So far as we know there isn't any
heavy duty DML before the export and there isn't any other activity on the schema
other than RMAN and DBMS_STATS. We don't understand how RMAN or DBMS_STATS ***could***
be the culprit but we've seen W
I haven't read the note yet, but what Rich mentions here may explain why
I haven't encountered any problems.
I started out testing with copies of prod tables which had no stats at
all. So their first stats were gathered with gather_shema_stats.
>>> [EMAIL PROTECTED] 05/29/03 03:14PM >>>
I looked
I knew a guy name Dawson who worked for Lawson which was keen on Informix.
-Original Message-
Sent: Thursday, May 29, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Thanks, Kip, Jared, Dick - that makes more sense. I now recall that Lawson
also ships a free (non-relational) databa
The answer is as usual "it depends". If the table has a reasonably uniform
row size and the blocks are approximately evenly utilized, then the analyze
can extrapolate the total number of rows fairly accurately even from a
small sample. However, if the row size fluctuates wildly, or if the block
Dave,
Promote them to their level of incompetence and then slide them
sideways?
Ron
>>> [EMAIL PROTECTED] 05/29/03 03:31PM >>>
> We do not want developers to learn or secrets. That might
>give them an idea that we're mere mortals.
Yeah, I've learned from reading this list that not all DBAs are
Patrice - Hush up! I would be forced to seek honest employment.
Years ago I worked on non-IBM equipment and was shocked at how primitive the
IBM MVS scripts were. I wondered why the developers weren't up in arms. Then
I realized that their expertise was what made them valuable and they
probably wou
Woo Hoo! I got to be the first one to register!!!
(not that I am interested or excited about going to this or anything
)
Rachel
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see the offici
Ron Rogers scribbled on the wall in glitter crayon:
> Dave,
> Promote them to their level of incompetence and then slide them
> sideways?
> Ron
nope, i've been beyond that level for a long time.;-)
-
-
Bill "Shrek" Thater Oracle DBA
[EMAIL PROTECTED]
We currently have a database on Solaris 8. The database is 8.1.7.4 32-bit. The
vendor wants us to upgrade to 9.2 and change to 64-bit. In reading the documentation
from Metalink, I find that I have to do the upgrade seperate from the change to 64-bit.
Does anyone have any recommendations for
OK everyone. Traffic cop time. Everyone that is a beta partner for 10i
MUST KEEP THEIR MOUTH SHUT. Don't get anyone in trouble, please. We as
partners pushed Oracle for these beta programs. Conversations like this
only hurt the process.
Thank You
Stephen P. Karniotis
Product Architect
Compuw
For a second there, I thought I was one of Those...
Then I remembered I'm an idiot. The difference between me and other idiots
is that at least I know I'm an idiot.
SSg-In-Training (for the next 50 or so years I hope),
Rich
Rich JesseSystem/Database Administrator
[EMA
They have but it's an added feature, and you thought the current license was expensive.
> -Original Message-
> From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2003 4:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: 10i
>
>
> I thought the databa
1 - 100 of 161 matches
Mail list logo