Hi, friends:
How do you use dbms_stats.gather_schema_stats in OLTP production system?
I ever used estimate statistics =20% percent, and some time have serious
performance impact while two big table join in my production changed. Later I changed
to compute and till now , It is ok.
Hi again
Your example is a good one of what I meant by treating OMWB as a test bed. The code is
merely there to emulate the sqlserver/sybase trancount variable, this is almost
certainly not needed in your procedure and you could *probably* replace the entire
statement with
IF (
As others have pointed out 6 tables, 2 joins does not a happy execution plan make -
and it also looks like some of your tables are views to add to the mix.
My diagnosis, this is an ad-hoc query constructed by an end user. To find the source
of the problem you'll need to listen carefully, the
Whilst not disagreeing with the practical outworkings of what you, and others, have
been saying for a while now I think that I disagree with the statement that tuning, or
indeed database management more generally is 'science'. I think that the correct term
is 'engineering'. In case this is just
Well, if they are serious about staying in the big db market, they'd better
keep trying. And, where do you catch the attention of managers and
journalists? Show some big commitments to your platform by major companies
or show performance benchmark results that rival or exceed your
competition's.
Yes, that's the problem. Thanks for the help.
Craig Healey
-Original Message-
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]
Sent: 27 February 2003 18:16
To: Multiple recipients of list ORACLE-L
Subject: RE: Deleting rows (ORA-01403)
Is there a pre-delete trigger on the table?
Metalink WAS down when I came in to work this
Friday morning [Singapore time]. The site itself was
up but I couldn't login.
It came back online around 0100 UTC.
Hemant
--- Ferenc Mantfeld [EMAIL PROTECTED] wrote:
I'm getting in just fine !
Ferenc Mantfeld
Dreaming costs you nothing. Not
Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love
it.
I'm thinking of building a tool that intercepts dumb SQL and emails back a
raspberry. Whaddya think, is there a market for such a utility?
Oh yeah ... I'll buy two copies, so long as I can customise the second one
to
Hello List,
Have the one question from subj please.
I'd like to get some initial experience with Oracle Financial. What is
the best way to do so? I couldn't download this package or
manuals/books from OTN for practise... But I need to have some
knowledge of it to get new job.
Thank you for your
tds-3 has a feature whereby if someone scans your machine, you can (via a
script or manuallY) send the person a message back.
I know who you are is a default I think.
Something like that would be useful.
Ad hoc querying and 3rd party tools can be a problem, esp when users don't
know anything
To be honest if you can't download manuals, books or software you don't
leave yourself many options.
It's not clear whether you've been unable to download manuals or won't. The
manuals are all available at
http://download-uk.oracle.com/docs/cd/A99488_01/html/erpdoc.html.
You can't download Oracle
http://www.theregister.co.uk/content/4/29519.html
Hm
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
I like this - it nearly fits in, give or take a little
flexibility in interpretation, with my comments:
Tuning (engineering) is what you do before the system goes live
Trouble-shooting (science) is what you do after the system goes
live
Regards
Jonathan Lewis
www.opensource.org and other sites (The Register) and
www.globetechnology.com (Globe Mail's technology news site) mentioned that
MS considers LINUX a threat.
Last week I attended an OS security class where each student had two PCs,
one was a Windows2000 machine, one was a LINUX machine. The
Alex, from time to time offers for OraApps are appearing for sale on
www.ebay.com For 90-100USD
you can buy 50 CDs with a lot a (OraApps more )stuff there... These CDs
are for educational pusposes only and are not time-constrant (at least the
sellers state so ;))
HTH. Milen
-Ursprüngliche
Alternatively, rather than playing the E-Bay lottery you can go to the
Oracle store and buy the same for 39.95 USD. Theoretically you should also
order a trial license but these are free so what's the point. Anyone? Am I
missing something here?
Cheers,
Mike
-Original Message-
Sent: 28
So it appears that Oracle 8.1.7 databases and 9.2 databases can not
co-exist on the same server, i.e. AIX 4.3.3 32 bit. If this is the case,
then all databases on the server must be upgraded at the same time?
Current Env: AIX 4.3.3 32 bit Oracle 8.1.7
Proposed Env: AIX 5.2 64 bit Oracle 9.2
Precisely.
In our environment, great care is taken with
adding/modifying data. But when it comes to
reporting, there's no standardization of products or
concern about what's being reported. The DBA's find
out about a bad query when it hits the this sql
really sucks list (or when the whining
Jared,
SQL-Slammer Virus may be.
DBA's don't Panic
--
On Thu, 27 Feb 2003 16:04:07
Jared.Still wrote:
It appears that MetaLink has just taken a dive.
Anyone else notice, or is it just me?
Maybe I'll try another site.
Jared
--
Please see the official ORACLE-L FAQ:
Hi
Alternatively, rather than playing the E-Bay lottery you can go to the
Oracle store and buy the same for 39.95 USD. Theoretically you should also
order a trial license but these are free so what's the point. Anyone? Am I
missing something here?
I have ordered the Linux version of 11.5.7
[I know this isn't an Oracle question, but I like this list better
than the others and someone might just know]
We just upgraded to Solaris 9 on our sandbox machine (Ultra 2) for the
same reason that the bear went over the mountain.
On all our machines, we measure a variety of parameters and
Darrell Landrum [EMAIL PROTECTED] wrote:
Reply to///Thanks very much to everyne!I should've told you, first mistake sorry, that this is ORACLE 8.0.6 - can I run STATSPACK? Or should I stick with bstat/estat? I will be running stats during times when performance is normal nomal. But what steps in
Beware of the Beast, aka Axis, aka MS Access. Yesterday a user called
to have his Axis query killed because it had been running 10 minutes when it
should only take about a second. After snooping the SQL, Axis was sending
separate SQL statements for each table (in two different sessions), and was
Fresh in memory because 2 days ago I had meeting with MS SQL people from
Microsoft.
I will talk about MS SQL 2000 Enterprise.
1. MS SQL cannot handle exception. There is nothing like EXCEPTION WHEN ...
THEN.
2. MS SQL has nothing like package.
3. MS SQL has nothing like partitioned table
If you can get away with export import (no
huge databases), I'd go for the second option.
1. Saver
2. Not all apps need to be upgraded to
oracle 9i database
3. More breathing time when murphy
strikes
Jack
-Original Message-From: Gene Sais
[mailto:[EMAIL PROTECTED]Sent:
Our Current Environment: 64-bit AIX
4.3.3 running 32-bit 8.1.7.4 and 64-bit 9i.
Here is what we are thinking of testing...
(a very high level task list, there will be App testing in all these steps).
First, upgrade databases to 64-bit 9i
Second, upgrade AIX to 5L, install
64-bit 9i
Hi,
I have never had to insert pictures/documents in the oracle database before
and would like to give it a go. Does anybody have some scripts that I can
tear apart to look at how to do it (examples I find more usefull than
books). I tried finding useful info on the net but did not find any
We are running 64-bit Oracle on HP-UX 11.11. My logical and physical IOs get out of
whack after about a day. I can never get a good BHR. They appear to have passed a
defined integer value and start looking like this;
SQL column logical_reads FORMAT 999,999,999,999,999,999,999
SQL column
The major misconception is that open source is free (As in no charge, al
la Free beer). This this not the case. It is free, as in you can see
the source code, play with it, and distribute it. However, you need
support, maintenance, etc. This is where the costs are.
My company uses Linux for
Mike,
could you provide a link on Oracle site, where I can purchase OraApps (not
only updates - see
http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536).
Further on
http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=10391
what I am reading is:
Trial
Patrice,
As a Win2K and Linux user, Linux is cheaper on two fronts, 1) at $900 per
site for a Linux Advanced Server license vs. MS$ $1200 plus license (boy I hope
memory is working here) and 2) Yes you can use older, lighter hardware get the
same or sometimes even better performance than MS.
Hello everyone. I have just rejoined this list after a couple of years
hiatus. Quick question. Are HTML posts acceptable on this list or is
everything supposed to be done in plain text?
Thanks,
Chuck Hamilton
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck
I think it was Ian MacGregor who posted on this thread that he had a
case where they had mapped two filesystems to the same drive, and gee,
it caused problems.
Here's the post-mortem from one of our senior internal people. Names
changed to protect the guilty:
Good news we have gotten to the
I find it interesting that some foreign countries like China and Russia have
expressed interest in Linux for just this reason. They realized that maybe
someday the CIA could bury some code to send information back to itself. In
response, Microsoft is opening some of their source code to selected
Jared,
SQL-Slammer Virus may be.
DBA's don't Panic
--
On Thu, 27 Feb 2003 16:04:07
Jared.Still wrote:
It appears that MetaLink has just taken a dive.
Anyone else notice, or is it just me?
Maybe I'll try another site.
Jared
--
Please see the official ORACLE-L FAQ:
I don't have much experience developing applications using blobs but here
is a link to help get you started.
http://developer.iplanet.com/appserver/samples/database/docs/blob.html
Gene [EMAIL PROTECTED] 02/28/03 10:04AM
Hi,I have never had to insert pictures/documents in
the oracle database
I have been asked what the Best Practices are for Oracle Apps
installation, patching and upgrade.
I have looked at what Oracle/OTN/Appsnet/metalink can offer with that
search, and I am still struggling. I have tried Google and still can't find
what I really am looking for.
Does anyone have
Question:
Opening source code. Then what, go to the local store and buy a
precompiled Windows binary?
What these governments should do is see the code and compile Windows
from the code that they see.
What guarantees are there that the binary you buy from stores were
compiled from the source
Thanks to all who replied. It took filing an iTAR to get the answer and then it
took OTS 2 days to find the fat finger that caused the problems.
Dick Goulet
Reply Separator
Author: Adrian Roe [EMAIL PROTECTED]
Date: 2/25/2003 7:09 AM
Looks fine. We
Here' my fave...
1) DBA's are to create simple easy to follow with ample documentation..
with infrastructure work. In the long run it serves the company well
as well as your fellow dba's trying to support your work at 3:00am.
2) The work should be developed with a corporate perspective as
Advanced Linux is free, but if you choose to buy prepackaged distribution then
you have to pay for it. But you will find the same software as in
downloaded distribution. :-)
I'm using SuSE workstation for Oracle developing and everyday office work more
than 2 years now and, personally (!), to
I encourage you to keep pushing Oracle Support on the bug. The kernel
should emit the right numbers in the first place.
There is a workaround. Push Oracle Support for that, too. Tell them that
someone in Oracle knows the answer, because tkprof knows which bits to
ignore and swap in order to print
Germany did that too I think, or were going to.
Peru. Other South American contries.
The EU is considering it.
Pat.
-Original Message-
Sent: Friday, February 28, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
I find it interesting that some foreign countries like China and
Sorry but point 7 isn't exactly true.
Transaction logging does take place and can be backed up for reapplication
to a database backup.
Its not perhaps as well implemented as Oracle's but I have a system with the
transaction log backed up every 30 minutes.
The implementation is different but
Not sure if this is true... I heard that to back up the transaction log, the
database has to be stopped.
???
Pat.
-Original Message-
Sent: Friday, February 28, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Fresh in memory because 2 days ago I had meeting with MS SQL people
David - I haven't taken all the exams yet, but the advice I heard was not to
take the SQL exam first. On the surface it sounds easy, but it tends to be
more of a SQL trivia test. For most of us practicing DBAs, I heard that the
DBA exam tends to be the easiest, and is a good place to start and
I really wish you to communicate this with Oracle Magazine. ...At the
risk, of course, of having your heavily edited letter published in the
magazine.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101,
What's the current recommendation for gathering statistics on system schema
objects like SYS, and OUTLN? Are they still saying not to do it? I am on
8.1.7.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network
We run DBMS_STATS.GATHER_TABLE_STATS nightly as cron job using this script
to spool the result to a temp file, then use sqlplus to run that file.
select 'execute DBMS_STATS.GATHER_TABLE_STATS('''||owner||''','''||
segment_name||''',cascade = TRUE);'
from ( select owner,segment_name,
Hello,
1) How big (max) can an Oracle SGA be in a 32bit platform (Windows and
Linux on ia32)?
2) How big (max) can an Oracle SGA be on a 64bit platform (Sparc
Solaris, AIX PowerPC)?
Thanks.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon
Excerpt from
http://www.siliconvalley.com/mld/siliconvalley/business/columnists/gmsv/5286
438.htm
Microsoft committed to providing Chinese government with information
necessary to buy Microsoft products: The Chinese government will soon be
able to view the source code for the Windows operating
Title: RE: Purely for your amusement
hmmm...
ok, let's give one of the largest known hacking/cracking/virii producing countries in the world, the source code to the most common desktop in the world for 'security' purposes?
Bill has got be to smokin' something...
Any bets on how long it
Hello,
Anyone here used Oracle on a PAE enables ia32 hardware? Can Oracle use
more than the 3GB limitation?
Thanks.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Chuck,
HTML makes a mess in my e-mail package, at least right now.
Dick Goulet
Reply Separator
Author: Chuck Hamilton [EMAIL PROTECTED]
Date: 2/28/2003 7:44 AM
Hello everyone. I have just rejoined this list after a couple of years
hiatus. Quick
Nope. Can backup online. However certain actions can't be perfomed while the
transaction log is being backed. eg. Add new database file to the system.
This also applies to database backups.
David
From: Boivin, Patrice J [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
Hi
I saw this list posted on an Oracle Newsgroup a while back :-)
Oracle has multiversioning. SQL Server has no equivalent
In Oracle reads don't block writes and writes don't block reads
In Oracle there are unlimited row level locks
In Oracle there is no such thing as lock escallation or page
Yes and no. If your logs are backed up every 30 minutes, then you are
effectively saying that you are willing to lose up to 30 minutes of
transactions, in the event of failure on the TX logs (e.g. hardware). OTOH,
Oracle can easily be made to be completely recoverable up to the last
transaction
Title: RE: Purely for your amusement
I
thinkthe reason that Microsoft does this is to keep the control of OS
market in China. MShas a huge market share in China, almost exclusively.
Iread a report a while ago saying some local goverment (Beijing
Minucipal?) isconcerned about OS security
Title: RE: Purely for your amusement
Do not fear. Australia is catching up quickly. I've
gotten two "MS security patches" emailed to me in the last two days from a ISP
in AU. I wonder if anyone actually falls for this stuff.
- Original Message -
From:
Nick
Wagner
To:
RE: Purely for your amusementSorry for that HTML reply. OE usually asks me
if I want to send HTML or plain text whent he recipient is marked as text
only in the address book. Apparently the fact that oracle-l was in the
reply-to and not the from header confused it and it never asked. It just
sent
I have a table - messages. I couldn't access one column in this table
when I do
Select name from messages;
I get an error message - ORA-00904: invalid column name
All the other columns I could select from this table. When I checked
the table structure through OEM, I found this column has
last time I worked with SQL Server (at least 5 years ago, so this may
be totally out of date)
if the log file filled completely you had to truncate it to clear
space, you could not archive off. If it was not filled, you could
archive and clear it.
--- Jesse, Rich [EMAIL PROTECTED] wrote:
Yes
Hello Folks,
Many thanks for your help.
I found this in Oracle Store:
* We do not offer trial licenses for our E-Business Suite Applications
From Mike's letter it is avoidable ;)
But this...
OracleR Applications 11i Release 8 CD Pack for Linux Intel
NOTE: This CD Pack is only for existing
I agree with Dennis, it depends on what you work with most. I found the
DBA exam the easiest one, and the Backup the hardest one.
Luck
-Original Message-
WILLIAMS
Sent: Friday, February 28, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
David - I haven't taken all the exams
What's wrong with plain text?
Should we start using XML too? Where is the world going?
--
Lyndon Tiu
Quoting [EMAIL PROTECTED]:
Chuck,
HTML makes a mess in my e-mail package, at least right now.
Dick Goulet
Reply Separator
Author: Chuck
I think you are not supposed to collect statistics on sys tables till 9i...
Babu
Chuck Hamilton
Title: RE: Oracle Performance Tuning Exam
I used to interview perspective Oracle DBA's for Oracle. I was always unimpressed with the certificate. However, once I heard that I might have to pay $1000 for another class just to take the 9i exam I took the 8i OCP DBA exams just so I could take
Use: Select name from messages;
See this example:
SQL create table t1 (col1 number);
Table created.
SQL desc t1;
Name Null?Type
-
col1
Rao,
Change your select to
select NAME from messages;
to fix this, you will either need to drop and recreate the table (without
the quotes), or add the column NAME (
alter table messages add(name varchar2(n))
update messages
set name = NAME;
alter table messages drop column NAME
good luck!
By default, Windows imposes a 2g per process limit on all processes
including the OS itself. Oracle runs as a process with each session running
as a thread within that process so the entire Oracle process including SGA,
sessions, DLLs, executables, etc. must all fit within 2g. There is a
boot.ini
Chuck - Don't do it man! People have had very bad problems due to this.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, February 28, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
What's the current recommendation for
Title: RE: Invalid column in table - how to access it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a table - messages. I couldn't access one column in this table
when I do
Select name from messages;
I get an error message - ORA-00904:
Rich - on your first point - that's why you would choose to mirror the
transaction log in SQeal Server. Same effect.
the transaction log is a fixed size. it can be extended while the db is
online. but shrinking it is quite a bother (at least was back in the day -
it's been a while). if the
Rao - And you'll save yourself a lot of trouble if you just drop this table.
If it has valuable data in it, you can use Guang's methods to move the data
into a new table. The quicker you do this, the less pain in the long run.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL
Pat
The thing this article doesn't mention is that Microsoft is creating
development centers in foreign countries. China hopes Microsoft establishes
a large development center in China. Therefore, China won't publicly say
much against Microsoft.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch,
Thanks to Cary, Jared, Ferenc whose inputs helped a lot in solving the
problem.
Ferenc's document did the trick... Once we converted the files to use Qio,
the performance was much much better...
Thanks a lot...
Babu
_
This e-mail transmission and any attachments to it are intended
Hi All,
Thanks for the replies.
I tried to select the column with --- select NAME from messages;
I am getting the ORA-904 error.
I would try to recreate the table, import the data and let you know.
Rao
-Original Message-
Sent: Friday, February 28, 2003 2:05 PM
To: Multiple recipients
What about on OUTLN and DBSNMP?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:16 PM
Chuck - Don't do it man! People have had very bad problems due to this.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
Hmmm. I should have asked that last over the phone interview for that
prospective job what hardware platform they run their databases on.
They claimed all their database is cached in memory, as in all. I
know they use Linux, but on what hardware platform. 3GB buffer cache
(less than this since
Steve, when you say mirror are the writes duplicated from SQueaL Server or
hardware? My DBA instructor had distributed some e-mails from a student who
left the mirroring of redos up to hardware. One controller firmware patch
is all it took to corrupt both copies of the redos.
So, if the mirror
We are an 11i shop. You don't mention what module list so I'll confine
myself to general remarks. First most of the books on the market are
either functional in nature or rehashes of Oracle documentation. 11i
has, through much of its life, been a work in progress. Early releases
were plauged
bio oracle-l
begin 666 bio.txt
[EMAIL PROTECTED]%M:6QT;VX-D]R86-L92!$0D$-E%60R!);F,N#0H-D)OFX@
M,3$M,CM,3DU. T*2EG:!38VAO;VPZ(%-U;[EMAIL PROTECTED],L($%S=]N
M(%!!#0I#;VQL96=E.B!-87AW96QL($ENW1I='[EMAIL PROTECTED]FES=]W;B!0
M02P@,3DW. T*#0I)(%M(AA'!I;'D@;6%RFEE9!W:71H(#,@8VAI;1R
Put NAME into lower case and enclose it in double quotes.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:39 PM
Hi All,
Thanks for the replies.
I tried to select the column with --- select NAME from messages;
I am
I remember it was noted here that dbms_stats.gather_database_stats
was busted in 8i, it went about attacking system ts. Is that fixed in
9.2.0.2?
On Fri, Feb 28, 2003 at 11:16:17AM -0800, DENNIS WILLIAMS wrote:
Chuck - Don't do it man! People have had very bad problems due to this.
Hey, I just remembered that Oracle on Linux runs as multiple processes
, unlike Oracle on Windows which runs as one big process. Does this
mean each Oracle process on Linux can access 3GB of memory? So that in
the end the whole of Oracle can actually use greater than 3GB of memory?
--
Lyndon Tiu
no problem Rich. the transaction log mirroring can be done by the DBMS.
and SQueal Server has disk devices much like a tablespace that can be placed
on different disks and such. transaction logs are kind of like tables in
that they must be placed in a device. so yes, these mirrored transaction
I recreated the table and loaded the data into it again.
Thanks to Guang, Tom Mercadante, Dennis for the suggestions.
Rao
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:39 PM
Hi All,
Thanks for the replies.
I
Title: RE: Statistics on SYS?
Ray,
I *never* would do a DB stat ... I rather do a schema stat (for small schema) or a table wise stat so I can run multiple scripts in parallel.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any
Oops, Posted to the wrong address. Sorry folks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:53 PM
bio oracle-l
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET:
The txn log is just a separate database file(s) and they can autogrow in
increments (MB or %). The growth can be unrestricted or restricted to a
fixed MB size. Though command line TSQL can create the files with space
allocated in units (KB/MB/GB/TB). The wizard isn't quite as flexible. There
Group,
I have a requirement to build an On Insert' trigger from my Solaris 9i
database and update a table in our Teradata warehouse. Anyone have a laundry
list of things I need to set up and watch out for?? Also, just as important,
what should I ask of the Teradata folks??
IE. 1) Do I use JDBC
Title: What to check?
Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in
That 3g limit only applies to Windows (2g w/o the boot.ini /3g switch).
Linux is a whole other bowl of wax. Having never run Oracle in Linux I'm
afraid I can't answer your question. My best guess would be the per process
limit is 4g, but on most unix platforms the SGA (which the OP was about) is
Hello Mike,
Friday, February 28, 2003, 11:48:49 AM, you wrote:
HMNI To be honest if you can't download manuals, books or software you don't
HMNI leave yourself many options.
HMNI It's not clear whether you've been unable to download manuals or won't. The
HMNI manuals are all available at
HMNI
There is actually now a comment in the 9iR2 doc's that it's ok to start
generating stats on the SYSTEM tablespace (in prep for the removal of RBO in
10i). Has anyone actually done that in 9iR2, and what is your experience?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Title: RE: Statistics on SYS?
Robert,
Although we would like to (on devl only), because TOAD 7403 is *so* broken on 9ir2 logon time sometimes is about 7-8 minutes ... but I fixed that using outline.
So far we have resisted the temptation of analyzing sys and system schema ... I'll also
Title: RE: multiple oracle homes
Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 10:54 AM
If you are an Oracle DBA and management switches to SQL Server no Oracle DBA
in the world is going to sway that decision.
By the the time an Oracle DBA will hear about that he or she is already
slated for re-tooling.
You were very lucky to be able to present to management.
Many times the deal
Nguyen, David M wrote:
Someone writes a SQL script to dump a table on three different
database on three different Solaris8 machines, he complaines one of
machines took 6 hours to dump a table while other two's only take one
hour. He asks me to investigate why. I log into the machine in
The wait events.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 28 Feb 2003, Nguyen, David M wrote:
Someone writes a SQL script to dump a table on three different database on
three different Solaris8 machines, he complaines one of machines took 6
hours to dump a table while
1 - 100 of 106 matches
Mail list logo