- Original Message -
Hi,
Is there a website, which keeps all the messages posted to this forum,
which
can be accessed without subscribing to the forum?
try http://www.fatcity.com/ListGuru/my.php and
http://www.mail-archive.com/oracle-l%40fatcity.com/
hth,
Marin
...what
Hi,
I'm surprised nobody came up with this.
Microsoft is famous the world over for their Blue Screens of Death and even
have their own acronym BSD. I have not yet encountered these in any other
O/S.
Jack
Jamadagni, Rajendra [EMAIL PROTECTED]@fatcity.com on
29-01-2002 19:50:59
Please
Hi
Sorry Kevin missed your post
Jack
[EMAIL PROTECTED]@fatcity.com on 30-01-2002 09:05:22
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
yste
--
Hallo, is there anyone who can tell me if it ispossible run unix shell script from
PL/SQL
Anyone who has a good example too that I can use. Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
There's nothing to stop you posting on this list. My gripe has always been
that I personally would use this list as a 'last resort' (no disrespect to
anyone), after exhausting every other avenue! It's the only way to learn.
-Original Message-
Sent: 29 January 2002 21:46
To: Multiple
Roland,
Please see the example I posted some time ago to this list. I'm sure Sam
Roberts will be able to point you in the direction of it.
Failing that please see.
Date: Tue, 11 Sep 2001 07:20:24 -0700
Hi
Title: RE: Rman again. Long screen output removed
Jack,
Your date format is
set until time 'to_date(''29012002094700'',''ddmmhh24miss'')';
whereas one that works for me and matches the documentation is
set until time to_date('18-SEP-2001 01:00:00','dd-mon- HH24:MI:SS');
Note
Don't stop posting. I'm not a DBA either. Don't have any intention of being
one. I'm an Oracle duhveloper (as people sometimes point out..LOL). I read
this list to get a better understanding of how databases 'hang together'. I
never profess to being an expert in DBA related stuff...I'm far, far
JoJo,
Don't let this little episode put you off the list my friend.
I have seen you post to the list on a couple of occasions and they have been
valid questions. Keep reading, keep learning - stay subscribed.
Lee
-Original Message-
Sent: 29 January 2002 22:29
To: Multiple recipients
Title: RE: Web site of messages
I also found this site by searching Google for Oracle-L
http://faqchest.dynhost.com/prgm/oracle-l/
-Original Message-
From: Marin Dimitrov [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 08:00
To: Multiple recipients of list ORACLE-L
Subject: Re: Web
Thanks to all who helped.
I'll inform you how it works, maybe someone will need it too.
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hi Everyone
I am interested in purchasing some exceptionally good book on Oracle
Performance Tuning. Can anyone suggest me some very good book on Oracle
Tunning worth purchasing
Binay Kumar
Oracle Cerified DBA
London
***
Binay Kumar
Focus 3
Before you go slagging people off! Ensure you know their name!
If that was an email I sent 6 months ago (not sure, there are a few Kevins
on the list),
then fine. But I think you'll find that a) you had to search back 6 months
for a question from me
b) how many others did you find? I'll wager a
Hi John,
Tried it (and many other formats already) and still no luck.
I logged it with Oracle Support and apparantly it's a bug.
But you got it to duplicate to a certain time? or were you using restore
until time (that one works fine)
THX
Jack
Hallas John [EMAIL
Hi All,
It was an Oraclebug.
The only , very workable, workaround Oracle could come up with is to set
NLS_DATE_FORMAT at Unix level and use :
set time until 'string'; (STRING BEING IN THE FORMAT OF NLS-DATE_FORMAT AT
UNIX LEVEL)
9.0.2 is supposedly fixed.
Jack
i have these 2 errors in the log file
1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS.
Field in data file exceeds maximum length
2. Record 885: Rejected - Error on table IA_TEST.
ORA-01401: inserted value too large for column
whats the differennce between the 2?
cheers
--
Title: Alter system check datafiles
Paul Sherman wrote 'I tried an 'alter system check datafiles'
I had never come across that command before and looked at the documentation which states that 'in a distributed database system, such as an Oracle Parallel Server environment, updates an
Practically, u should get two books to have a full grasp on Oracle
Performance
Tuning :
1. Oracle Performance Tuning Tips and Techniques by Richard Niemiec
2. Oracle 8i and Unix Performance Tuning by Ahmed Alomari
If u r in an exceptionally high development environment where u have lots of
SQL
Jared,
My apologies for this being posted to the on-topic list. I read your request
to take this off-topic after I'd sent it.
Apologies,
Kev.
-Original Message-
Sent: 30 January 2002 09:11
To: Multiple recipients of list ORACLE-L
Before you go slagging people off! Ensure you know
Could you post the control file?
Kev.
-Original Message-
Sent: 30 January 2002 09:15
To: Multiple recipients of list ORACLE-L
i have these 2 errors in the log file
1.Record 2389: Rejected - Error on table IA_TEST, column COMMENTS.
Field in data file exceeds maximum length
2. Record
Binay,
The Oracle Performance Tuning book from O'Reilly (ISBN 1-56592-237-9) is an
excellent book. Covers just about everything, database, code, environment
tuning.
Regards,
Kev.
-Original Message-
Sent: 30 January 2002 10:25
To: Multiple recipients of list ORACLE-L
Hi Everyone
Title: RE: RTFM questions (formally RE: PL/SQL)
Kevin,
I am afraid your post shows a distinct lack of ambition. :-)
No flames please
John
-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 08:50
To: Multiple recipients of list ORACLE-L
Subject:
For a Particular Table Created by a One Oracle User , Is it possible to
TRUNCATE the SAME Table by ANOTHER Oracle user by Giving Some Suitable
Priviliges Other than DBA DROP ANY TABLE Priviliges ?
åy«±ç
ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+T
D)!ÀDÀ4DÕ!Q
Hp0§'(V
The 640K memory limit.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 29, 2002 8:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Microsoft plans to bundle iFS
Jared et al:
Yes, the case statement has made it into 9i. There is the CASE expression
that is usable in SQL (and PL/SQL) and two types of CASE statements as part
of the PL/SQL language specification.
Kevin
-Original Message-
Sent: Wednesday, January 30, 2002 1:25 AM
To: Multiple
heres the ctl
LOAD DATA
INFILE 'sierras.dat'
INTO TABLE ia_test
trailing nullcols
( SWREGNOterminated by ',' OPTIONALLY
ENCLOSED BY '',
commentsterminated by ',' OPTIONALLY ENCLOSED BY
'')
dat file looks something like:
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Oracle Performance Tuning 101- Oracle Press - Gaja, Kirti
Don't you know that Kimberly is The Lord Of The Rings.
Prudo is already on his way with the Ring.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tue, January 29, 2002 8:01 PM
To: Multiple
Binay,
I totally agree with this recommendation from Jared for a tuning book.
Read the first three chapters, stop and re-read them. And if you play
your cards right you can even get a question answered by an author on
this list. Cool, eh.
Dave
-Original Message-
Sent: Tuesday,
Hi,
are they up to release 5 already?
I'm 4 releases behind :-))
Jack
K Gopalakrishnan [EMAIL PROTECTED]@fatcity.com on 30-01-2002 13:30:23
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack
If I remember right, SQL*LOADER has (or used to have) a maximum field size
of 256 characters. This can be overcome by specifying the size you want to
load like:
LOAD DATA
INFILE 'sierras.dat'
INTO TABLE ia_test
trailing nullcols
( SWREGNOterminated by ',' OPTIONALLY ENCLOSED BY '',
Hello JoJo
Do not stop using the list and asking silly questions.
Of course, smart questions are a lot better.
I did a blooper myself a week ago and got the deserved responses.
So what. I learn a lot and enjoy even a good flame.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
The first is a SQL loader error:
SQL*Loader-00621 Field in data file exceeds maximum length
Cause: A field exceeded its maximum allowable length. The maximum length is
either the length specified in the SQL*Loader control file, or, for
delimitable fields without a length specified, the maximum
Hi Friends,
I am having a sql statement where
select field1,field2.. field15, sum(fieldx1), sum(fieldx2).. sum(fieldx200)
from t1
group by field1,field2.. field15;
when i execute this statement , i am getting error - 1467 which says sort
key too long
Cause Mentioned in the document :
Iashraf,
Not knowing what your table desc looks like for the columns in question
and what the actual data, (record 2389 and 885) looks like I can take a
wild guess at the explaination.
Record 2389 the comments column Delimited data was specified with a
maximun length and the data value exceeded
Seems to be down this morning must be the flu ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can
Can anyone get to the oracle sites this morning? I've tried since 7:30
EST and haven't been able to get on.
oracle.com
technet.oracle.com
metalink
Hope this isn't the Unbreakable claim being seriously broken by
hackers.
- Brian
__
Do You Yahoo!?
JoJo,
If you can not find the answer then by all means continue to post your
questions. There are only a dozen or so who are a bit touchy and
always will be. I know on most keyboards there are at least 2 delete keys
perhaps they can find one of them if they choose not to contribute
I just got on 8:41EST.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an
[EMAIL PROTECTED] wrote:
Sorry for the OT post, but I cannot find this elsewhere.
We need to get connectivity from outside our firewall into an Oracle
database using ODBC.
Our network guy thinks there should be a port designation or something to
allow these odbc connects through.
I'm clueless.
[EMAIL PROTECTED] wrote:
Well, since sed was in use while BG was still in high school...
and edlin looked an lot like UNIX ed.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta
not me
-Original Message-
Sent: Wednesday, January 30, 2002 7:30 AM
To: Multiple recipients of list ORACLE-L
Can anyone get to the oracle sites this morning? I've tried since 7:30
EST and haven't been able to get on.
oracle.com
technet.oracle.com
metalink
Hope this isn't the
It was up and running earlier on (8am-1pm GMT)
-Original Message-
Sent: 30 January 2002 13:15
To: Multiple recipients of list ORACLE-L
Seems to be down this morning must be the flu ...
Raj
__
Rajendra Jamadagni MIS,
Yeah its very good book!!!Especially I like that chapter Method behind
madness!!..Every body should read that book.
From: K Gopalakrishnan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Performance Tuning
Date: Wed, 30 Jan
Mogen
I checked log file sync is increasing
log file sync 41355 276686
I set log_checkpoint_interval and log_checkpoint_timeout is ZERO.
The diffrence between background checkpoints Completed and
background checkpoints started is always 1.
What can I do for this
yes it prevents users writing to the datafile... but it leaves your
database in a precarious state if you have to do recovery.. or if you
do a shutdown and try to open the database normal.
--- Sherman, Paul R. [EMAIL PROTECTED] wrote:
Hello Jared et al,
The Oracle Reference Manual for 8i,
Not sure, which Oracle version u r using
If it is 7.3.4.0.0 then it is a bug and this bug is resolved in 7.3.4.0.5
HTH,
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 4:10 PM
To: Multiple recipients of list ORACLE-L
Hi Friends,
I am
Hi
My instance was crashed when one of users was truncating the table.the
following are the error message in alert log
Wed Jan 30 00:15:13 2002
Errors in file pathname/udump/ora8_ora_9453.trc:
ORA-07445: exception encountered: core dump [ksqcmi()+5792] [SIGSEGV]
[Address not mapped to object]
Buried somewhere within the Forms directory tree is
a 'DEMO' directory, containing a number of .PLL files
and associated .HLP files.
It's been awhile since playing with Forms, but there's
some pretty cool stuff in that directory, and there
maybe a .PLL for using winsock IIRC.
Jared
On Tuesday
I have 2 8.1.6 instances running on a NT4 (sp6) server using the same
listener.
With Enterprise manager (oem server is a different machine), I can see -
discover one of the instances but not the other. If I use toad or sqlplus I
can connect to the other instance.
Any guesses as to what I need to
There isn't anything for Winsock.dll, but you could use FORMS_FFI interface
to hook into any DLL. For examples lookup D2KWUTIL.DLL and D2KWUTIL.PLL
these hook into windows API to get an idea. If you install FFIGEN package,
it will let you specify a DLL and import all available interfaces in
OK, lets take poking fun at Kim back to the OT list please.
Ross, I don't know how but I am going to get you back for this.
-Original Message-
Sent: Wednesday, January 30, 2002 4:30 AM
To: Multiple recipients of list ORACLE-L
Don't you know that Kimberly is The Lord Of The Rings.
Prudo
no, you can't shrink a rollback segment below the optimal value
--- Sinard Xing [EMAIL PROTECTED] wrote:
Hi,
Assume
INITIAL * MINEXTENT = 2M and also = OPTIMAL
Do you think
ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M;
will work ?
Thanks,
Sinardy
--
Please
Can't get in either. Been trying for a couple of hours (it's not 10:50 am)
with no luck. So much for checking on my tars...
-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 9:11 AM
To: Multiple recipients of list ORACLE-L
Subject:
Hi, everybody,
However, I made the following entry into init.ora file:
Event= 10046 trace name errorstack level 12 and it rebooted over the
weekend. Then I got a call from my boss on Monday morning (I was home sick)
letting me know the system had come to a crawl and was producing a trace
file
I had the same occurance on an 8.0.5 database. We had a long job running ,
also a trucate, that was killed. When this happened the database core
dumped and died. We looked it up on Metalink and found that it was a known
error with that version of the database. It appears to happen with heavy
Title: RE: Rman again. Long screen output removed/SOLVED
Jack,
We are on 8.1.7.1 on Compaq Tru64 (5.1) and we are sure that we have done both a duplicate database and a restore using PITR
(format to_date('18-SEP-2001 01:00:00','dd-mon- HH24:MI:SS');
I am not really in a position to
By setting it in init.ora, you essentially enabled it for all sessions. I'd
recommend it doing only for the processes that you think need to be tuned.
At process level you could do a alter session and set the same level.
Raj
__
Rajendra
I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had to make a choice).
the 101 book conforms most closely to Oracle's current thinking on
performance tuning
--- SARKAR, Samir [EMAIL PROTECTED] wrote:
Practically, u should get two books to have a full
no
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
For a Particular Table Created by a One Oracle User , Is it possible
to
TRUNCATE the SAME Table by ANOTHER Oracle user by Giving Some
Suitable
Priviliges Other than DBA DROP ANY TABLE Priviliges ?
I'm reposting this because it got bounced back to me, so this might show up
twice.
When I was purchasing my CD pack a couple of weeks ago, the site was so
slow, it would take 2-3 minutes for any page to load (on my DSL). I finally
gave up and called Sales on the phone. I asked him up was up
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 17:20
I have 2 8.1.6 instances running on a NT4 (sp6) server using the same
listener.
With Enterprise manager (oem server is a different machine), I can see -
discover
Must be entire Oracle - technet.oracle.com or www.oracle.com
seem to be down too.
www.microsoft.com is alive ;-)
(I don't want to start another OT thread)
Witold
On 30 Jan 2002 at 7:50, Murray, Margaret wrote:
Can't get in either. Been trying for a couple of hours (it's not 10:50 am)
with
I can't get into drudge either... Maybe they are on the same server ???
; )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, January 30, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Unbreakable
We had implemeted the following design in my previous project (a Mortgage
Origination System) to accomplish this.
We had marketing tables to keep track of mortgage products, rates etc. These
tables were query intensive. Inserts/Updates/Logical deletes were less.
The primary key was made up with
Sergey,
There is no LEVEL clause associated with the ERRORSTACK. When u use
ERRORSTACK, Oracle creates a stack to store the information relating
to a particular error. Your syntax should have been :
10046 trace name errorstack forever
Hope this helps,
Samir
Samir Sarkar
Oracle DBA - Lennon
Maybe u r right, Rachel.since except for me, all the others have
suggested the 101 book. Thing is, I bought Rich's book based on the
customer reviews on Amazon and I must say that I am not disappointed but
then,
I haven't read the 101 book. At the same time, TUSC is supposed to have some
of
If I'm remembering this correctly, you can get around this by creating a
pl/sql procedure that uses dbms_sql to truncate the table. Then you can
grant the user execute privilege on the procedure.
Worth a shot.
Barb
--
From: Rachel Carmichael[SMTP:[EMAIL PROTECTED]]
Reply
Down for me, too... :( Maybe I should log an iTA...whoops...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET:
There are more hacking attempts against oracle.com since Larry declared that
Oracle is unbreakable.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, January 30, 2002 12:31 PM
To: Multiple recipients of list ORACLE-L
Subject:
On Wed, 30 Jan 2002, Babich , Sergey wrote:
However, I made the following entry into init.ora file: Event=
10046 trace name errorstack level 12 and it rebooted over the
weekend. Then I got a call from my boss on Monday morning (I was
home sick) letting me know the system had come to a
Not directly, but you may have the owner of the table create a stored procedure
that performs a truncate and then grant execute on that procedure to whoever
he wants to run this procedure. by default a stored procedure runs under
the privilege of the compiler of the procedure.
Hope this helps,
I read this on another list this morning;
The database may be unbreakable, but that doesn't
matter if the network or hardware is broken. There's
a major network failure outside of Oracle.
Apparantly, there's a network issue outside of Oracle's site.
-Original Message-
From: Murray,
Rachel,
Thank you so much for you kind words and the very interesting comparison..
:)
- Kirti
-Original Message-
Sent: Wednesday, January 30, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
I would perhaps suggest Oracle Performance Tuning 101 instead of Rich's
book (if you had
Hi Hamid,
We upgraded our peoplesoft db from 8.1.6 to 8.1.7 last year. This is
just give you a reference check. You HAVE TO read the upgrade note do
exactly what the notes said. Since all the platform is different, it
might change the procedures according to your platforms.
Joan
Oracle 8.1.7
Just went into the OEM console and choose Navigator from the menu.
It says: discover NODES.
Discover is discovering the computer that the instances are on.
After the discovery query the node and you should see the two instances.
BTW: Marin, I think that the OEM agent is one per node(computer)
Umm, how do you really feel about it? grin I have to concur though -
OPT101 is excellent!
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]]
You know what? I thought the same thing... But, the curious side of me
decided to give it a try to be sure... And guess what... It works? Learn
something new everyday...
SQL select segment_name,sum(bytes) from dba_segments where tablespace_name
= 'RBS' and segment_name
= 'RBS17' group by
Yes, it can be shrinked below optimal as per following details specially R03
rollback segment
Regards
Rafiq
before:
NAME EXT MB OPTSIZE ACTIVE WATER SHRINKSWRAPS WAITS
STATUS
--- --- --- --- --- --- --
---
My.oracle.com is down too.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, January 30, 2002 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Unbreakable Oracle - Metaslink
Can't get in either. Been trying for
Kevin wrote:
I hope its fixed in 8.1.7 because thats where we are heading to.
Just to remind you all:
8.1.6 IS NO LONGER SUPPORTED (al least for NT).
I had a problem two weeks ago with snapshot too old during analyze table
that crashed the instance and they refused to back port
a correction
Rachel IS kind but her words are also true and I think this was her
main focus in this case. ;-)
My Alomari book was for v7 and was good but is now dated...
Is it up to date for 8i/9i?
-Original Message-
Sent: Wednesday, January 30, 2002 10:11 AM
To: Multiple recipients of list
Here is the confirmation of what Sandeep posted:
SQL select a.usn, b.name, a.optsize
2 from v$rollstat a, v$rollname b
3 where a.usn = b.usn;
USN NAME OPTSIZE
-- -- --
0 SYSTEM
1 RBS01
Seema,
It looks like the user tried to cancel the operation. ORA-01013. after
they started the truncate. Could be it caused the insanity and crashed
the system. That might be why you never saw it before. Try to create the
same failure on a test system and see if the cancel causes a crash.
ROR
Shaw,
Check these things.
1. Check whether OEM agent is running on NT4. (On unix the command is -
lsnrctl dbsnmp_status). Perhaps on NT this might work.
2. One OEM agent is enough on one machine. This agent would monitor all the
databases running on that machine.
3. Now, in the second step,
Hi John,
Have you bounced the IA since this instance was created. My
understanding is that upon discovery the IA looks in a file called
services.ora and/or snmp_ro.ora to see which services have been
discovered. On NT this file is created with the IA is started by
checking listener.ora,
My developer asked me this.
can sharepool error cause sna to go down?
Has anyone heard of this? I don't think so.
Thanks in advance.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wong, Bing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
I have been trying since 8.00 AM Central standard time. No matter what ORACLE claim, it appears to be broke.
From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Oracle sites 1/30/2002 ?
Date:
Not sure if this 'unbreakable' stuff is completely broken..
May be it has 'bent' completely out of shape..
'cause, I just received an automated e-mail after they did something to my
'iTAR'.. I can access it yet, however!
So it may be working for some 'privileged' ones.. hiding behind the
From Eastern PA, there are quite a few west coast web sites that are not
available right now. www.sun.com and www.amazon.com to name two.
On Wednesday 30 January 2002 11:35 am, you wrote:
I read this on another list this morning;
The database may be unbreakable, but that doesn't
matter if
And make sure the 2nd instance is in your services.ora.
-Original Message-
Sent: Wednesday, January 30, 2002 12:20 PM
To: Multiple recipients of list ORACLE-L
Shaw,
Check these things.
1. Check whether OEM agent is running on NT4. (On unix the command is -
lsnrctl dbsnmp_status).
Thanks a lot. That's what a lack of knowledge does...
Regards,
Dummy
-Original Message-
Sent: Wednesday, January 30, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait
On Wed, 30 Jan 2002, Babich , Sergey wrote:
However, I made the
Hi, Samir,
Yes, I received it. Thank you very much. Maybe, I shouldn't have done that
cause, anyway, the problem is poor SQL code...
-Original Message-
Sent: Wednesday, January 30, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Session_wait
Sergey,
No... we are not.. still at #1.
Must be something wrong with K.Gopal's keyboard or mouse (or finger;)
I sincerely thank you all for 'discussing' our book.
Gaja is still catching up with his office e-mail after returning from a
long vacation.
But he will join the list soon..
Regards,
-
Columbus, Ohio company is looking for an Oracle DBA who has Siebel and Unix
AIX experience
to join their I.T. staff.
General duties will include data management, upgrades, patching, tuning,
security,
capacity planning and back/up recovery.
*Candidates should currently reside in the Mid-West
Yes, Mohammad is right !!
I messed up by not seeing the correct column...
Oracle will not honor the size you asked for (to shrink), if there are other
transactions using up space more than what you asked for, but it can go
below the OPTSIZE...
Thanks, Mohammad.
- Kirti
-Original
Here is the answer:
SCOTT, is the last name of Bruce Scott, who was the early Developer
working with Bob Miner (Larry's Technical Partner in 1980),
TIGER, was the name of Bruce's cat.
Source: Oracle8i for Dummies Foreword by Ned Dana, who worked with Bruce
and Bob in rewriting the Oracle
I cannot translate sna this morning. What is it? Is it
as in SNA; i.e., System Network Architecture? If so, then the statement alluding to
no one ever hearing of a sharepool error bringing down SNA is undoubtedly correct.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
Title: Oracle standby strange behavior
Hi,
I ran into a strange behavior of a standby database.
On the primary db I have an application schema and a query schema.
All tables from the appl schema have public synonyms and a grant select to public.
User query is created with connect and resource
what are the minimum extents on the rollback segments (specifically
r03) as well as initial and next sizes please?
If optimal is higher than the minimum extents, you're right, it can
shrink down to minimum extents*initial
but it doesn't make a lot of sense to set things up that way
---
1 - 100 of 195 matches
Mail list logo