funny how my previous email seems to have been truncated where I put
three dots [ie , .] to
signifiy 3 lines.
Resend :
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
Sent: Friday, September 19, 2003 6:24
PM
Subject: Fwd: Re: Tempfile
weirdness
funny how my previous email seems to have been truncated
where I put three dots [ie , "."] tosignifiy 3 lines.Resend
:For a critical database where I want to be SURE that the file system
has en
It also can be caused by bad sectors or other hardware errors, but I'd bet
on sparse file problem as you described.
When I create temp tablespaces, I either copy the tempfile into another
filename and then rename to original using cp, that way the file isn't
sparse anymore, thus no problems using
Heh, look what happens if you try to help someone ;)
(an automatic reply to my message)
---
Trend SMEX Content Filter has detected sensitive content.
Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = Tanel Poder
Subject = Re: Tempfile weirdness
Delivery Time
.
Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = Tanel Poder
Subject = Re: Tempfile weirdness
Delivery Time = September 18, 2003 (Thursday) 05:43:08
Policy = Sexual Discrimination
Action on this mail = Quarantine message
Warning message from administrator
.
Place = Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = Tanel Poder
Subject = Re: Tempfile weirdness
Delivery Time = September 18, 2003 (Thursday) 05:43:08
Policy = Sexual Discrimination
Action on this mail = Quarantine message
Warning message from administrator
= Multiple recipients of list ORACLE-L; ; ; [EMAIL PROTECTED]
Sender = Tanel Poder
Subject = Re: Tempfile weirdness
Delivery Time = September 18, 2003 (Thursday) 05:43:08
Policy = Sexual Discrimination
Action on this mail = Quarantine message
Warning message from administrator:
Notice: A message you
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION
Any comments on the following??
When creating index, got
ORA-00603: ORACLE server session terminated by fatal error
apparently caused by
ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 121 (block # 149)
ORA-27063: skgfospo: number of bytes read/written is incorrect
We also ran into the IO error situation on a few of our 9i R2 databases using
TEMPfiles.
DBAs forgot that the file system contained those tempfiles and created other datafiles
on those.
We are now considering using dedicated file system naming convention that will hold
TEMPfiles. We
already
Please disregard my previous post--the problem was that the
sga_max_size was set very low.
__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ:
Hi Listers:
Has anyone ever seen something like this before? Can somebody
explain it to me?
Thanks,
Mike
SQL
SQL select file_name from dba_temp_files;
File Name
-
E:\ORANT\ORADATA\ECRMP\TEMP01.DBF
1 row selected.
SQL select /*+ RULE */
I was able to duplicate this on my 9.0.1.1.1 database running on Win2K.
-Original Message-
Sent: Tuesday, November 19, 2002 1:17 PM
To: Multiple recipients of list ORACLE-L
Hi Listers:
Has anyone ever seen something like this before? Can somebody
explain it to me?
Thanks,
Mike
SQL
Same happens under 9.2.
But,
select /*+ RULE */ name from v$tempfile;
works fine.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 1:16 PM
Hi Listers:
Has anyone ever seen
I forgot to mention - there are no statistics on any SYS or
SYSTEM objects - per the FMs. Anybody know why this happens?
-Original Message-
Sent: Tuesday, November 19, 2002 10:50 AM
To: Multiple recipients of list ORACLE-L
I was able to duplicate this on my 9.0.1.1.1 database running
Same thing in 9.2.0.2 on linux
Clark, Tommy R wrote:
I was able to duplicate this on my 9.0.1.1.1 database running on Win2K.
-Original Message-
Sent: Tuesday, November 19, 2002 1:17 PM
To: Multiple recipients of list ORACLE-L
Hi Listers:
Has anyone ever seen something like this
-L
Subject: RE: Win2k/8.1.7.3/Optimizer Weirdness
I was able to duplicate this on my 9.0.1.1.1 database running
on Win2K.
-Original Message-
Sent: Tuesday, November 19, 2002 1:17 PM
To: Multiple recipients of list ORACLE-L
Hi Listers:
Has anyone ever seen something like
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness
9.2 on AIX ... same problem ... Wait they must have fixed it in 10i
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness
Here
are the different explain plans. This is on an 8.1.7.0 db on Solaris.One
idea isthe problem could be on the merge-join. I've heard of some problems
with this operation.
SQL select file_name from dba_temp_files;
FILE_NAME
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness
It is
very hard to believe that there is a big problem with merge join as it is the
oldest join method, next to
the
nested loops. Hash join and star schema are much newer. I remember merge joins
at least from version 5.
Merge
join
ORACLE-L
Subject: Weirdness
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This
has improved the
query performance however, its going to slow down the load.
Thing that has
me confused is that I tried this as an IOT and it actually
hurt
Smith [mailto:[EMAIL PROTECTED]]
Sent: 24 October 2001 18:55
To: Multiple recipients of list ORACLE-L
Subject: Weirdness
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This
has improved the
query performance however, its going to slow down the load
:[EMAIL PROTECTED]]
Sent: 24 October 2001 18:55
To: Multiple recipients of list ORACLE-L
Subject: Weirdness
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This
has improved the
query performance however, its going to slow down the load.
Thing
-L
Subject: Weirdness
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This
has improved the
query performance however, its going to slow down the load.
Thing that has
me confused is that I tried this as an IOT and it actually
hurt performance
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This has improved the
query performance however, its going to slow down the load. Thing that has
me confused is that I tried this as an IOT and it actually hurt performance.
This table is joined to another table
Title: RE: Weirdness
First off... Did you place a separate index on every column or one index that included every column? Second, either of those is methods is probably overkill... The real questions you have to ask are...
Have you determined the execution plan of the statement yet?
What
I don't think BSIDBA and OPS$BSIDBA are the same Oracle user. (Check in
dba_users). So ops$bsidba probably doesn't own the tables? (Maybe the install
went wrong because of the value of the initializaion parameter
os_authent_prefix which I think could be null or could be ops$ or some other
Check whether FA_IDNT is a public synonym which is pointing to a
non-existing table.
HTH
Prakash
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
Hope everybody had a good weekend -
Working on HP-UX and Oracle
Agreed, _Oracle_ users BSIDBA and OPS$BSIDBA are not the same (spelled and
pronounced differently :) , even though the _UNIX_ user BSIDBA would run as
OPS$BSIDBA.
Can you select count(*) from BSIDBA.FA_IDNT?
If so, you could try creating a synonym FA_IDNT for BSIDBA.FA_IDNT.
Jim
-Original
Hope everybody had a good weekend -
Working on HP-UX and Oracle 8.1.7.0.0
I've got a third party app that 's written in COBOL and stores some of the
information it needs to generate screens in the database. I am trying to
practice restoring this beast, and it turns out I must run a utility to
David,
Is FA_IDNT a view that you didn't know about that the package uses?
Just a thought.
ROR mª¿ªm
[EMAIL PROTECTED] 06/18/01 03:16PM
Hope everybody had a good weekend -
Working on HP-UX and Oracle 8.1.7.0.0
I've got a third party app that 's written in COBOL and stores some of 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
Title: Serious Weirdness: Open VMS and Oracle 7.3.3
Has anyone ever seen the Oracle backgroiund processes owned by a different os user? We're having probs with one of the db's here (it's on Open VMS, so I don't know anything about how to fix it) but I have NEVER seen this behavior. Anyone
Generally whichever account was used to startup the database is shown as
owning the processes.
Denise Gwinn
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Koivu, Lisa wrote:
Has anyone ever seen the Oracle backgroiund processes owned by a
different os user? We're having probs with one of the db's here (it's
on Open VMS, so I don't know anything about how to fix it) but I have
NEVER seen this behavior. Anyone?
Thanks
Lisa Koivu
35 matches
Mail list logo
