Yep.
Long
-Original Message-
Sent: Wednesday, 13 June 2001 11:16 PM
To: Multiple recipients of list ORACLE-L
Did anyone else on the list get this stupid spam besides me?
thanks, joe
-Original Message-
To: [EMAIL PROTECTED]
Sent: 6/12/01 5:48 PM
OraKnowledge eBoot Camp for
Hallo all you DBA's
Can anyone help me with this?
I would like to check if some views ar einvalid and then if there are I would like
them to be compiled immediately .
How can I write this in a pl/sql-procedure?
Please give me some good examples, all you experts!
Roland Sköldblom
--
Please
PROS
Got much more done, or at least thats how it appeared
Better coffee/tea/snacks in the house.
No hour long drive to/from work
Nobody can just wander up to your desk to get you to do something.
I can start getting dinner ready for a reasonable hour for us both.
CONS
Although
Hi all,
When I do
SELECT name from v$datafile;
NAME
-
...
/disk1/Oracle8i/dbs/MISSING7
/disk1/Oracle8i/dbs/MISSING8
Where are these files came from ?
do I lost anything ?
When I quickly do ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Why
Hi All,
I am unable to get the information of Oracle 7.3.4 software for Sun Solaris
. This product information is not available in
otn.oracle.com/store.oracle.com.
When I am contacting Oracle India - Delhi , they are asking me to go thru
the web site.
When I am contacting local software
Yep
Jack
=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is,
Kevin,
You might want to check out bug 1540560 ANALYZE TABLE
ESTIMATE STATISTICS NOT ROUNDING VALUE FOR NUM_ROWS
closed as not a bug.
Are you saying that the CBO produces a different
explain plan for a table with NUM_ROWS = 500.25
vs. NUM_ROWS= 500? This would definitely be a bug
and
me too
--
On Wed, 13 Jun 2001 23:06:12
Nguyen, Long (ITS, Limestone Ave) wrote:
Yep.
Long
-Original Message-
Sent: Wednesday, 13 June 2001 11:16 PM
To: Multiple recipients of list ORACLE-L
Did anyone else on the list get this stupid spam besides me?
thanks, joe
-Original
Uh oh,
What has happened here is there are a couple of datafiles in the data
dictionary that you have missed in your create controlfile statement.
You should be able to rename them to whatever the files are called on the
OS. Check out Chapter 12 of the Oracle Backup and Recovery Guide Manual
Agh!! Ice. Chills the taste buds. Impairs the flavour. Sometime a little water
if it's a strong malt.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
Hi,
You have probably created this database by cloning another one and left out
the temp tablespace or something.
I clone without the temp tablespace because test needs smaller temp
tablespace and I get the same messages. They should also show up in your
alert log.
Jack
I find dirty martinis a tad too salty. My favorite is
still a vodka martini (preferably made with Ketel One
or Belvedere and a dash of extra-dry vermouth) with a
lime twist.
Definitely hits the spot!
-- Anita
--- Jared Still [EMAIL PROTECTED] wrote:
On Tuesday 12 June 2001 13:39, Koivu, Lisa
Mogens,
Thanks. Jonathan Lewis' book does talk about setting events. Thanks for
that tip and the example.
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
A session trace on event 10053 CBO detail for a plan
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 13 Jun 2001 12:00:37 -0800
I have limited access to the client and time availavble so want to avoid
10053 traces at present.
What's a 10053
I would like to add to this, also from a United Kingdom point of view.
I have found that the biggest issue has been the negative commenting from
other
workers who *have to* go into work. On the odd occasions when they try to
contact me and I
cannot for some reason get to the 'phone (responding
Sean,
As Paul already mentioned 30 seconds is probably not
long enough, but even so you're probably hitting bug
1336566.
As for the specific versions:
7.3.3.0.0
7.x will never shut down cleanly when stopping the
services or the server as the registry entries
controlling this weren't
Paul Drake wrote:
Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2
for 6 weeks.
Thanx for the patch info Paul.
Debbie wrote:
It is really hit and miss with Oracle on NT. I have all servers set up
the same (including the registry settings) and some will shutdown the
Jothish,
If all that's needed is a read-only snapshot of the
data from the non-Oracle sources, then the
heterogeneous services should be sufficient (more
sophisticated usage might require the gateway product
for that specific db).
This is discussed in the Distributed Database Systems
manual.
- Original Message -
After all, how do they manage accountability when you are in the
office? By
the number of hours you sit at your desk or by the work that gets
done, to
deadline and correctly?
In Australia, unfortunately it's the first option. Most managers
wouldn't
have a clue
FYI,
I got one of these at home, but not at work.
At home I have logged into the oracle.server newsgroup, but never Jared's
list.
At work I subscribe to Jared's list, but never went to the newsgroup.
This tells me that unless I received the e-mail at work as well and didn't
notice, our
My opinion is, technology has a marked effect on politics when... those who
sell technology have a lot of money to influence politicians.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
I use Forte free agent http://www.forteinc.com to surf newsgroups to avoid
spammers getting my email address, It is set up with a bogus address to
post on the lists.
I wrap my address up in text in a signature for those that want to talk to
me directly.
Peter
At 04:00 AM 14/06/2001 -0800,
All
Does anyone have any experience of either of these products. I am about to
do a comparison/evaluation so any experiences with either would be helpful.
Both will be interfacing with Netbackups tape management system, on
predominately HP-UX.
Regards
Simon
Wander over to www.techrepublic.com and check out there for thing that
justify allowing staff to telecommute. For those of you who don't know
Gartner are behind the site and so some interesting information comes to
light.
Mostly companies see a positive return because people don't take a
Anita:
I am saying that sometimes when the num_rows is not an integer oracle will
sort/merge join 2 multi-million row tables when a nested-loop join will
return much quicker. If a compute stats is done (or an estimate stats
returns integer values for the num_rows) then the optimzer chooses the
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Which user owns the process (I am
I work better at home as well, but I don't think it would ever fly here.
I could certainly push it if I wanted to. But I don't want to get into that
battle.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
Kevin,
It would be very interesting to know if when you have
the explain plan doing the sort/merge if setting
num_rows to the integer value of the current num_rows
(using dbms_stats, see note 130899.1) causes the
explain plan to change to N/L.
-- Anita
--- Toepke, Kevin M [EMAIL PROTECTED]
It was
a joke.
Generally when there is a :) or a :-) or something similar near the
end of a comment, it is ussually noted to be sarcastic.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
So what do they serve at the new stadium in Balmer (Baltimore)? I grew up
with the Orioles at Memorial Stadium.
Die Hard Oriole Fan in Montana,
Steve Orr
-Original Message-
Sent: Wednesday, June 13, 2001 6:55 PM
To: Multiple recipients of list ORACLE-L
Well, the G. Heileman
I haven't received anything from this list today. Is it up? I am just
wondering because our internet server was hacked on Tuesday and may be I am
the only one who is experiencing difficulties.
Thanks!
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth
DBAs
Does anyone have or know of a site where I can find a white paper for Pro*C.
Thanks.
Much appreciated.
Surjit
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 14, 2001 10:50 PM
All
Does anyone have any experience of either
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Patrice Boivin wrote
This tells me that
We are thinking of possibly purchasing the Precise Insight, SQL and
Pulse products. Has anyone had any very good or very bad experiences
with these products?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Connie Milliken
INET: [EMAIL PROTECTED]
Fat City Network
ROFL!!
don't forget the fava beans, Ruth!
-Original Message-
Sent: Wednesday, June 13, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L
I now have an image of Ross wearing a Speedo, drinking single malt scotch,
and smoking a Cuban cigar...I need to go lie down.
Ruth
you're
kidding, right? ;)
Tom Mercadante Oracle Certified Professional
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 10:07
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
OT RE: Forever running Analyze
It
Helo guru's
i found one ? in self test as follows:
q)why is it not bebeficial to use RMAN when performing incomplete recovery?
a) A full offline backup is required after the recovery operations are
complete.
Now my question is, In general, in case of incomplete recovery we should do
the
fixed as of 10:23am EST.
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 14 Jun 2001 07:23:17
Orr, Steve wrote:
Here's what I just got logging in to MetaLink...
Thu, 14 Jun 2001 14:12:33 GMT
ORA-04031: unable to allocate 2550012 bytes of shared memory (large
pool,unknown object,session
IIRC, you can still get a cold Natty Boh at the O's new digs (Oriole Park at
Camden Yard), but they now also offer a variety of microbrews.
-Original Message-
Sent: Thursday, June 14, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
So what do they serve at the new stadium in
After I sent the message I started receiving posts from the list. Thanks
to all who replied.
Regards,
Ruth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
:)
Yea,
it was me.
heh
heh
-Original Message-From: Henry Poras
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 1:06
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SMP/MPP and PQO
Oh
oh. Ross, were you the one who initially recommended this? Did I
Henry,
Are you suggesting I lose my speedo for Linda?
Hmm.
-Original Message-
Sent: Wednesday, June 13, 2001 1:13 PM
To: Multiple recipients of list ORACLE-L
Ross,
It looks like you may have to lose that speedo. I saw this in yesterday's
newspaper.
The Warnaco Group filed for
Perfect timing. I was putting togeter some recompile scripts for work.
Here is a modified one that can be used for views. With a few changes it
can be used to recompile any invalid object.
1. Create a cursor on the Catalog Table ALL_OBJECTS where OBJECT_TYPE =
'VIEW' and STATUS = 'INVALID'.
Hi,
If you are using Oracle8i, there is a way to do this.
Review the following post:
On Thu, 6 Jan 2000, Joseph Testa wrote:
Why would you want to do that, well, i'm at a place where the developers
have the schema owner password but we DBAs(being retentitive as we
are)dont
want them to
On Thu, 14 Jun 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:
-FYI,
-
-I got one of these at home, but not at work.
-
-At home I have logged into the oracle.server newsgroup, but never Jared's
-list.
-
-At work I subscribe to Jared's list, but never went to the newsgroup.
-
Here's what I just got logging in to MetaLink...
Thu, 14 Jun 2001 14:12:33 GMT
ORA-04031: unable to allocate 2550012 bytes of shared memory (large
pool,unknown object,session heap,bind var buf)
DAD name: plsql
PROCEDURE : per_hom.startup
USER : mrorracle
URL:
was that you I saw wandering by then? I wondered who the other human was :)
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Digestive
Date: Thu, 14 Jun 2001 07:23:15 -0800
I plan to buy something from the
Hello
I have a problem with the reserved size of shared pool. It does not seam to
be used for packages even if I have big packages (200K).
Do you have an idea where the problem can be? Do I have to move the packages
somehow (like pin to shared pool)?
Regards
Ivo Libal
FREE_SPACE AVG_FREE_SIZE
Coincidentally, when you open Disk3 in Winzip the 'packed' size is almost
exactly a tenth of the size reported on the TechNet site.
I think someone put an extra 5 on the end of the size on the web page.
I haven't tried to use it yet though. It's being burned to CD right now.
Regards,
Mike
Joe;
For those of us not on
8.1.7 ..
Besides .. I had no idea that
was there.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 10:55
AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE:
Invalid views
Why not just
Title: list of good links
Greeting to all,
My machine got totally hosed and I need to rebuild a new one. I recall a little while back there was a post with a bunch of links to good dba sites. Can someone please send this to me? Thank you very much. Ivan
Try to uncompress it and if it works then it's the right size.
Regards,
Waleed
-Original Message-
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Technet
has anyone had any luck downloading file 3? It SAYS 800+MB, it downloads
79+MB and says it's
Why not just use(8.1.7 thing)
$ORACLE_HOME/rdbms/admin/utlrp.sql
joe
[EMAIL PROTECTED] 06/14/01 11:47AM Perfect
timing. I was putting togeter some recompile scripts for work.Here is
a modified one that can be used for views. With a few changes
itcan be used to recompile any invalid
I need some help. I was an Oracle DBA with ADC Telecomm
in Minnesota and was laid off along with 7,000 other ADC
employees. The job market here in the TCs has been
very slow.
Any assistance finding another Oracle related position
would be greatly appreciated. Please contact me directly
Paul,
But where is this patchset. It's not on Metalink or the ftp sites.
Saul Solomon
PPG Industries
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 13, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L
O'Neill, Sean wrote:
I'm trying to configure systems to
Fixed is a subjective term.
This error has come and gone for the last couple of months.
I wouldn't consider it fixed until it does not re-appear for a year.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, June 14, 2001 11:41 AM
To: Multiple recipients
All,
Can some there PLEASE clarify this question..
what is the corelation between user calls in the statspack report to
number of sql's executed during the timeframe..
This is what i am doing please correct me !!
We are trying to capture the total number of sql's calls during two time
events
So far my download is at 296mb out of 393mb(for the first download file) and
it's still going.
robin
-Original Message-
Carmichael
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Technet
has anyone had any luck downloading file 3? It SAYS 800+MB, it
I propose a fund to purchase and FedEx a towel to Ross before he loses his
Speedo. Let's try to maintain some level of decorum.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
-Original Message-
Sent: Thursday, June
Our security group delete the Guest account from the NT server. Now SQLMail
does not work.If we add Guest back to the server SQLMail still doesn't work.
What is the security loophole with the Guest account? Can another account
be used for SQLMAil? Should we be able to just add the Guest
IXOra.com (Steve Adam's Site)
http://ixora.com.au/
Oracle Technet
http://technet.oracle.com
OraPub (Craig Shallahamer's Website)
www.orapub.com
DBA Support
http://www.dbasupport.com/
Thomas Kyte's Website
http://osi.oracle.com/~tkyte/
Connor McDonald's Web Site
I haven't been able to recreate it in development yet...will let you know if
i can.
-Original Message-
Sent: Thursday, June 14, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
Kevin,
It would be very interesting to know if when you have
the explain plan doing the sort/merge if
Does anyone know what causes waits on this latch ?
Thanks
Ben
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ben Jones
Waleed,
Believe it or not, I do know about gunzip. Uncompressed the file is 84MB,
instead of 80MB. The files in the .cpio file seem to be java files, and I
think that the contents of some of the directory structures listed in the
cpio file are not there).
In any case, the size listed on the
uh uh, I'm not contributing to that fund, I want to see him lose that Speedo
EG
From: Norrell, Brian [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Speedo be gone
Date: Thu, 14 Jun 2001 09:13:49 -0800
I propose a fund to
It unzipped cleanly and the cpio reported no errors so I believe you are
correct. I hope you are correctly I want to play with this puppy
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Oracle 9i database for Linux
Ken,
Welcome to the club. Are we starting a trend? At least
we're not competing against each other.
Good luck,
Yosi
[EMAIL PROTECTED] wrote:
I need some help. I was an Oracle DBA with ADC Telecomm
in Minnesota and was laid off along with 7,000 other ADC
employees. The job market here in
FYI,
I am on the list and not on newsgroup and I did not receive that message.
Another clue: I had joined just recently so it might've been some time ago
some one got a hold of the list..
-Original Message-
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Ivan, here it is, hth, suren
-Original Message-
Sent: Wednesday, June 06, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L
Just to add
http://www.jlcomp.demon.co.uk
for Johnathan Lewis's excellent site
Cheers
Connor
--- Christopher Spence [EMAIL PROTECTED] wrote:
Try patch 1711240 for getting from 8.1.7.0 to 8.1.7.1 and then patch 1797438 to get
from
8.1.7.1 to 8.1.7.1.3. I know I found them on MetaLink, so if I recall the navigation
I'll
let you know.
HTH,
Mike
Solomon, Saul M. wrote:
Paul,
But where is this patchset. It's not on Metalink or the
If you will kindly download and review my .PPT slides for section 7 of of
the much slandered OCP exam (#2) for professional peer review. I will be
greatly appreciative. Please send your recommends to me offline unless you
think the discussion is worthy of public comment.
Here is my assesment.
Pulse is very weak in terms of dba monitoring. They rebound this with the
ability to add up to 20 custom packages.
I think I/Watch is a MUCH better product for this. With them (Precise)
buying Savant I suspect Q Diagnostics (Great package minus notification) and
Pulse
I received this update today about IBM creating a database release that is suppose to
be SMART and self tuning. Was Oracle one step ahead or was there a leak at IBM?
==
IBM looks to get SMART with DB2 7.2
Self-managing and resource tuning (SMART) features, deep integration
with the
Sorry, too many lists!
Ron
-Original Message-
Sent: Thursday, June 14, 2001 12:31 PM
To: Multiple recipients of list ORACLE-L
Our security group delete the Guest account from the NT server. Now SQLMail
does not work.If we add Guest back to the server SQLMail still doesn't work.
What
All I would add is that the last time I looked at Savant, I thought it was a
good product. It let you compare your current state with yesterday, last
week, last month, ... This was an easy way to measure changes. Unfortunately
this product was skewed heavily to using hit ratios and not wait
Speaking of which, I have not been able to get 9.0.1.0.0 to install on HPUX 11.
Has anyone gotten it to work? I have a suspicion that it is for 32 bit instead
of 64 bit.
My download file sizes are:
disk1: 587,823,750
disk2: 647,038,861
disk3: 341,722,333
Are these the same sizes that the rest
I second that.
Julie Fisher
Sandia National Laboratories
Oracle 8i DBA
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator
-Original Message-
Sent: June 14, 2001 12:04 PM
To: Multiple recipients of list ORACLE-L
uh uh, I'm not contributing to that fund, I want to
Title: RE: list of good links
Thanks to all who replied. You guys are great! (like the cereal). Later, Ivan
I remember someone asking whether Oracle was going to release Oracle for NT
first, or Oracle for LINUX.
We have our answer.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
Hi,
Looking for an english like reference for
interpretation of statistics and cooresponding actions
and modifications. Any clues?
=
Vicky D. Foster,
Senior Oracle DBA Consultant
email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Spot the
I downloaded the file and it's 81013KB.
The file gets uncompressed successfully.
It's 82956567 bytes = 82956KB.
They added 5 to the size of the file by mistake.
If the file has a problem you wouldn't be able to gunzip it.
(B.T.W. I'm playing with 9i for two months on Solaris and the last beta
So much leaks between releases that alot of the top vendors tend to use the
same goal list when releasing products.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday,
I too got it, so I'm presuming they harvested this list. I'll take a look
into the logs when I return from this business trip I'm on. I appreciate
all the confirming responses. Should I find that they harvested the list,
they will be removed and banned from all lists here (this is policy).
yea except its only certified on Suse(us RH people look like
we are SOL) and min quals are 512M of physical ram, guess that kills any more
demos at conf based on my current 192M maxed out laptop :(
joe
[EMAIL PROTECTED] 06/14/01 03:05PM
I remember someone asking whether Oracle was going
Metalink has some articles on E/B Stat, Oracle Publishing has great
Statspack docs.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, June 14, 2001 2:51 PM
To:
I'd prefer the list be kept closed.
Paul Baumgartel
InstiPro Group, Inc.
[EMAIL PROTECTED]
212 813-0829 x103
-Original Message-
Sent: Thursday, June 14, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Certified DBA in 5 Weeks)
I too got it, so I'm presuming they harvested this
vote for
close [EMAIL PROTECTED] 6/14/01 3:25:48 PM
I too got it, so I'm presuming they harvested this list.
I'll take a lookinto the logs when I return from this business trip I'm
on. I appreciateall the confirming responses. Should I find that
they harvested the list,they will be removed
great thanx!!
--- K Gopalakrishnan [EMAIL PROTECTED] wrote:
Hi !
There is a book from Oracle Press called Oracle
High
performance Tunign with Statspack by Don Burleson. I
am waiting for my copy.
Just do a search in AMAZON for statspack
=
Have a nice day !!
Vicky:
Check out the set of articles on perf tuning on MetaLink at Doc
#61998.1. Look specifically at Doc #Note:62161.1.
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--- Original Message ---
From: Oracle DBA [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
I get an error when migrating from 8.1.6 to 8.1.7 on a Sun box.
After editing the /var/opt/oracle for the fbs to the new Oracle Home - when
I attempt to start svrmgrl - i get an error below:
ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol
kgsmp789_compat_: referenced symbol
Funny thing about that - is that you actually have to read the book for it
to be any benefit.
I'm still working on Gaja's Tuning 101 book.
The Statspack book has been sitting here for 3 weeks - hadn't opened it yet.
and there are other book stores - such as Bookpool - where the price was
I actually work for a company that is ok with working from home and have
done
it but I am now at a client that was quite insistent that everyone be here
from 8-5.
So we all pretty much said ok and we all now work much less hours. Sucks to
be them.
VPN is a god send though. When I have to take
Have you checked your LD_LIBRARY_PATH? As of 8.1.7 you can not have
$ORACLE_HOME/bin in your LD_LIBRARY_PATH.
-Original Message-
Sent: Thursday, June 14, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
I get an error when migrating from 8.1.6 to 8.1.7 on a Sun box.
After
you mean it doesn't work if I just sleep with it under my pillow? Okay,
okay, but the to-be-read pile is getting bigger and bigger and no matter
how fast I read, I'm falling behind.
I'm beginning to feel like the Red Queen in Through the Looking Glass.
Rachel
From: Paul Drake [EMAIL
Off the cuff I would say something did not get linked.
-Original Message-
Sent: Thursday, June 14, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
I get an error when migrating from 8.1.6 to 8.1.7 on a Sun box.
After editing the /var/opt/oracle for the fbs to the new Oracle
OID installation on a new 9i database ended with
Creating OiD schema...
Parameter orahome = /d00/oracle/product/901
Parameter oidschema = true
OID Schema Creation succeeded
OIDMON started
Unable to bind to the OID server
/d00/oracle/product/901/ldap/postcfg/postcfg: -1: bad number
Has
Hi All,
Reading about the SORT_MULTIBLOCK_READ_COUNT init.ora
parameter, I am wondering why it should ever be
anything smaller or larger than the SORT_AREA_SIZE.
Has anyone changed the default setting of this
parameter for the better?
Johnson Job
Good afternoon,
I have seen on this list some time ago PL/SQL to convert a number to/from
decimal and hex.
Does anyone have PL/SQL to convert a number to/from a binary representation?
TIA,
Steven Haas
Opus Consultants, LLC
Opinions expressed, right or wrong, are my own.
--
Please see the
I too am on the list, but not the newsgroup and did not receive the spam.
Also, I am new to the last 6/04/2001.
Teri
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject:
Steven,
For decimal to hex, a to_char function using the X element can be used.
There are certain restrictions -- refer to the Number Formats table in the
SQL manual for more info. Here is an example:
1* select to_char(10,'XXX') from dual
SQL /
TO_C
A
For a more robust solution that
1 - 100 of 120 matches
Mail list logo