HI everyone
I recently joined the list, and I think it is meant
only for DBAs. Is that true?
Also, can anyone suggest any similar mailing list
meant for Oracle developers (that is those working with SQL, PL/SQL, Forms,
Oracle apps, etc.) and those who are not DBAs?
Thanks in advance
Ajay
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
Subject: lengthy URL's
Just a slightly OT post here.
It isn't unusual when writing to this list to come up with
a few URL's
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 correct?
If so, the CBO is making the correct decision to perform a FULL table scan.
What was the comparison of elapsed times between the two plans, the one
Yes,
we even let developers use this list. Heck, if you want to throw out a
perl question cuz I bet you'll get an answer.
;o)
Dave
-Original Message-From: Ajay K. Garg
[mailto:[EMAIL PROTECTED]Sent: Thursday, May 29, 2003 7:46
AMTo: Multiple recipients of list
Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the
synonym so that it refers to a valid table, view, or synonym.
looks to me like one of the data dictionary views that toad
Interesting, I use dbms_stats with gather stale in 8.1.7.4 it
behaves beautifully.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003
11:15 PMTo: Multiple recipients of list
Naveen , these parameters look to be already set
Doesn't FBI come in with 8.1.7 and Prem is on 8.16 and a comapatible of 8.10 is in
place
Failing that, as my second guess, 2 privileges need to be assigned to the user
(QUERY_REWRITE and CREATE INDEX). The 2nd one is obviously in place to allow
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 3:14 AM
1. to totally eliminate redo, load your staging records into a global temp
table. it has absolutely no redo and is very fast.
Hi
The above is not quite true. Global
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 DBA's
Koivu, Lisa wrote:
Hello everyone,
Is anyone using dbms_stats and gather stale or gather auto in 9.2? Im
trying to use dbms_stats gather schema stats with the stale option and
it just isnt working in 8.1.7.4. This is documented on Metalink. Id
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
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
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
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
youshould be allowed topost anything related to
Oracle.
Regards
Naveen
-Original Message-From: Ajay K. Garg
[mailto:[EMAIL PROTECTED]Sent: Thursday, May 29,
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,
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?
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
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
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: Multiple
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
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
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
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
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
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
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
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
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
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
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
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
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
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]
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
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
Title: Unbreakable, my buns. Upgrade to 9.2/w2k
For my OID testing I decided to go with
9.2.0.3.
I installed9.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
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
Hi,
Can anyone think of a reason(s) why oneWOULD 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 upthe
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
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
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
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
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 to
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
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 [EMAIL
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
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 Oracle
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
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]
Subject:
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
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
-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 database
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
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
Title: RE: skip scan index
I just put the Hotsos Symposium 2004
announcement on our web page yesterday. The event will be held March 710
in Dallas. Its early yet, but we already have speaker commitments
from Tom Kyte, Jonathan Lewis, Mogens Nørgaard, and me. Well add many more speakers in
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
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
[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
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,
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. The
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
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
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
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
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
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
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-
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
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
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
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
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
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 at
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)
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 the
1 - 100 of 160 matches
Mail list logo