Title: RE: Re[2]: performance questions
Mark,
I do not think this thread is OT ... this is till very much on topic. I have been gaining so many views on SLA ... I love this topic.
Raj
Rajendra dot Jamadagni at
just put it in quotes and add execute immedite. you can also use concantenation and
variables ot make it more dynamic.
declare
begin
execute immediate 'CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
TABLESPACE PBKIX PCTFREE 10
go to your:
(B%ORACLE_HOME%\oo4o\VB\SAMPLES
(B
(Bit has a lot of example which should help
(B
(BRegis
(B
(B-Original Message-
(BSent: Thursday, June 05, 2003 1:00 PM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BGuys,
(B
(Bcan someone give a simple example ( piece of
April,
and you thought you were alone ... on our most
production systems, we have everything that we need. But when we talk about the
machines in the DMZ (outside the firewall), The security group sometimes goes
overboard. Once we had to put a new oracle install on a new machine. We have
Begin
EXECUTE IMMEDIATE 'CREATE INDEX ART_HIERARKI_LOCKEDIX1 ON
ART_HIERARKI_LOCKED(SELSKAP, SETT_ID, VGRP, ART_GRP, ART_UGRP)
TABLESPACE PBKIX PCTFREE 10 STORAGE(INITIAL 65536 NEXT PCTINCREASE
)';
EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX PK_ART_HIERARKI_LOCKED ON
Title: RE: Shite of the day
Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7,
and 9.0.2 just to give it a try.
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]Sent: Wednesday, June 04, 2003
7:30 PMTo: Multiple recipients of list ORACLE-LSubject:
Check out http://asktom.oracle.com
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
===
-Original Message-
Khanna J
Sent: Thursday, June 05,
DUDE... they won't let me PUT a machine in the DMZ (our DMZ is inside one
firewall and outside the other 2). I have been trying to 'creatively' put
a machine just inside the first firewall (these are NT machines and I do have an
account and the IP... so you have me there) and install just
Kumar,
If u sendme youremail address and I can send u a paper that describes how to completely clean up an NT system (i.e de-install).I've successfullytested multi instance and single instance de-installs for NT (adv server).
Due to multi-instance Apps 11i install cloning challenges on NT
Binley,
If you really want to know, instead of just insulting me outright:
1. I followed Note 159657.1 for a manual upgrade. And in step 31 it directs to use
u0807010.sql. I then applied patch 2878462, and went on to apply patch 2761332. So
as you can see, I did my homework here. The
Title: RE: Cost info in Explain Plan
Eric,
Don't you hate it when that happens!
You also won't see cost info if you are using the Rule hint naturally enough.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From:
With optimal, the rollback segment shrinks back to its optimal size as soon
as the update, insert, or delete transaction is committed. However, there
may be a long running query that is using that rollback segment for a
consistent view of the database. If the rollback segment shrinks, the
query
the thing is Im not doing any of that.
Here is waht Im doing.
update,inserts and deletes on tables
select on data dictionary.
Im also doing 'create table as'
Transactions do NOT overlap. for example update,insert,and delete will not use the
same tables in different transactions.
and Im not
I found this link really helpful during my development projects using oo4o.
http://technet.oracle.com/doc/oracle8i_816/nt.816/a8/o4o00259.htm
From: Regis Biassala [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: example to
Snapshot Too Old Maybe caused bcos of Delayed Block Cleanout Problems.
Now this Bock was updated an Hour ago and u are now selecting it.. It
finds that there are ITL Entries in there and oracle wants to see if the
Transaction has been commited.
He Goes back to the Transaction Table of the RBS
Actually when are u getting this error..
There are a Lot Of reasons for ORA-01555 and primary one is DB Block
Cleanout or Long Running quries...
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn
Are you hitting ORA-1555 because of a fetch across commit?
[EMAIL PROTECTED] wrote:
why would removing optimal setting help with snapshot too old?
what I dont understand is that each of my DML transactions are independent of each other. They query and perform DML on different tables.
We have been given the funding toinstall a productionOracle RAC environment. I am wondering if Solaris 9 has any bugs we should know about.
Looks like we will be installing the following:
Oracle 9.2 (64-bit)RAC
Solaris 9 (64-bit)
Veritas DBE/AC version 3.5 - Veritas has a advanced cluster for
(BAs we found out last night, the "fix" doesn't fix anything. The online
(Bindex rebuild will still hang indefinitely and lock the table.
(B
(BSince there is bound to be some inquisitive mind out there wanting know why
(Bwe have a nightly online index rebuild: This is on tables that have
http://www.doag.de/orafaq/faqoo4o.htm#BINDVART
(B
(BRoy Pardee
(BProgrammer/Analyst/DBA
(BSWFPAC Lockheed Martin IT
(BExtension 8487
(B
(B-Original Message-
(BSent: Thursday, June 05, 2003 5:00 AM
(BTo: Multiple recipients of list ORACLE-L
(B
(B
(BGuys,
(B
(Bcan someone give
The rbs does not shrink to optimal when the transaction commits. The 2nd
transaction to 'find' that the rbs has extended beyond optimal will
cause the rbs to shrink.
--
Daniel W. Fink
http://www.optimaldba.com
Thomas Day wrote:
With optimal, the rollback segment shrinks back to its optimal
Title: RE: Good technical documents/references on tuning restores
10/100 Mb/sec ethernet. So, if it is slow any advice?
Thanks,
Paula
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 04, 2003 5:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Position: Lawson Oracle DBA
Location: Memphis, Tennessee
Salary Range: 78K range -depends on experience.
Relocation assistance is provided.
Please do not send your resume unless you have a stable work history.
This is a full time staff position so no sub-contractors or third parties
please.
What asked for 9.0.2? Are you sure you didn't misread 9.2.0 ?
You said you set COMPATIBLE to 9.0.2 and then started getting these
errors -
ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version
8.1.7.0.0
Sounds like maybe you ran a migrate or downgrade script with an invalid
Not as soon as the Update is Over.. Only after a Certain period of Time.
This operation is done By SMON.
HTH
Best Regards,
Ganesh R
DID : +65-6215-8413
HP : +65-9067-8474
===
Live to learn... forget... and learn again.
Title: RE: Benchmarking of ASP.NET with Oracle v/s MSSQL
Really want an objective study. Would like to find out if ASP.net against Oracle has any performance limitations as compared to ASP.NET against MSSQL. Also, would like to know if there are any maintenance/administration/coding
You never know. It might be the some anti-Arabic extremist got loose at
Oracle. Have you tried:
COMPATIBLE=IX.II..III
???
-Original Message-
From: Seefelt, Beth [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Why not just drop and recreate the indexes nightly instead of rebuild?
(BOracle provided a cool little package called DBMS_METADATA that allows you
(Bto extract the DDL from the database. If you use this package you don't have
(Bto worry about managing table/index changes as you simply extract
Try a search on support.microsoft.com. There are several
articles there detailing to to use Oracle from MS languages.
Jared
Prem Khanna J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/05/2003 04:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Now I'm curious.
If the index size grows 5 fold in a day, is it noticably affecting
performance?
If not, then why are you rebuilding the index?
If so, can you provide some traces detailing the waits?
I would suggest that rebuilding the index nightly is hurting performance
during
the day with
Title: RE: 9.2.0.3 online index builds resolved (we hope)
(B
(B
(B
(B
(BCurious me ... how big is the table that gets 'complete turnover of data in 15 minutes' ...??
(B
(B
(BRaj
(B
(BRajendra dot Jamadagni
Wow... It's been awhile since we've seen Mr Law on the list... I wonder if
this means the market is picking up?
-Original Message-
Sent: Thursday, June 05, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Position: Lawson Oracle DBA
Location: Memphis, Tennessee
Salary Range:
If this is a public ( internal ) network, maybe that is the best you can
do.
How much bandwidth is available?
It could be too that this is as fast as your tape library can provide the
data.
Ask your admin about the throughput. Or is it a single tape drive?
RMAN tuning? ie. open more
Title: Message
Oracle
9i RAC on Solaris is problematic. Here's why:
There
are two choices for the underlying cluster server: Sun Cluster 3.0 and Veritas
AC for RAC. If you decide to use Sun Cluster, you still need to buy
Veritas Volume Manager with the cluster option, since Sun doesn't
Title: RE: Shite of the day
The ways of man (and Oracle) are mysterious and not to be questioned, I guess. If some document said set the COMPATIBLE parameter to 9.0.2 I would bet it's a typographical error.
Good luck with your database! Let us know what happens. I've upgraded several
-Original Message-
(B
(B Why not just drop and recreate the indexes nightly instead of rebuild?
(B
(BAn index rebuild starts with an index create.
(BAnd, as we have learned, the problem is with online index create.
(B
(B Oracle provided a cool little package called DBMS_METADATA
Title: RE: Good technical documents/references on tuning restores
Weve had this occur before. Check
connections at the physical layer they might be loose. We changed the Ethernet cable
and it seemed to work optimally after that. The cable should ideally be better
(more insulated) than the
Maybe. You know who knows Lawson Financials, don't you? Here is a hint ... At
mny laaast job.
Johnston, Tim
Title: RE: Benchmarking of ASP.NET with Oracle v/s MSSQL
I
haven't done any formal benchmarking, but I've modified an ASP.NET appto
connect to both MSSQL and Oracle. What I did was convert a couple routines that
were getting employee information from the MSSQL database to get the same
(BEight tables. Size depends on the table and the time of day. I don't think
(Ball tables get complete data turnover at this rate, but I've not had the
(Btime to check with the Q continuum to verify. I know that the data in all
(Bthe tables is super volatile. We (i.e. me) got stuck with
FYI -
When this message came in to me it had the PE_BUGBEAR.B virus.
Mike
-Original Message-
Sent: Thursday, June 05, 2003 11:07 AM
To: undisclosed-recipients
Michael Hasenstein wrote:
Which SuSE Linux?
SLES 8
Which kernel (run rpm -q k_smp)?
k_smp-2.4.19-195
What
Is the error only occurring when you do the create table as select? Are
any other processes modifying data in the source table?
What is the db_block_size?
[EMAIL PROTECTED] wrote:
nope. My process is rather simple.
A flag comes in... either we do a create table as, drop the old table, and
(B
(B
(BI prefer to use courier new 9 points as
(BI send too much SQL (which I like formatted all the time). But I sometimes use
(Boriginal fonts in the original email. The reason I asked was, if you have multiple tables and super
(Bvolatile and smallish (less than million rows or so),
The ways of man (and Oracle) are mysterious and not to be questioned, I guess. If some
document said set the COMPATIBLE parameter to 9.0.2 I would bet it's a typographical
error.
Good luck with your database! Let us know what happens. I've upgraded several database
from 8.1.7 to 9.2.0 with no
Title: RE: Good technical documents/references on tuning restores
Check
on the server for packet loss, collisions, retransmissions if you think it is a
network problem. Also test the transfer of some binary files to see what
they benchmark at and compare that against the network RMAN
As subject line indicates standard (level 5) snapshots
make vmstat 1 or sar -u 1 100 show 100% CPU
utilization (75% system mode) for about 3 seconds.
Is this normal? Is statspack that brutal on CPU? And
why would that be a system mode primarily?
Environment:
Oracle 9.2.0.2 on Mandrake 9.0
Gurus,
We would like to load data from MS Access 97 database
to Oracle 8.1.7 database with MS scheduler? Is it
feasible? It could be done in MS SQL server with the
helps of DTS package.
Please share your experience in this regard and let me
know what could be the best method to automate loading
Tim,
Market is still so bad atleast in NJ and NYCInspite of posting resume on
so many sites , no positive results...Whe I posted my resume in year 2000 ,
within 12 hours I was getting calls and now nothing...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Hi Dick, Thanks for the tip. Metalink
says the bug applies to RDBMS 8.0.4. I tested it as well, using a modified
version of their test case. I did not encounter this bug at all.
Perhaps it is OK on Oracle 7.3.4?
Sam Bootsma
George Brown College
[EMAIL PROTECTED]
416-415-5000
(BEveryone around here recognizes that some serious rewriting of the app is
(Brequired, and that is happening. So (they say) the need for this rebuilding
(Bstuff should go away. But until that happens .
(B
(BWe can cause the problem in test, and Oracle has a trace file. Stay tuned
Hi,
I am accessing a table over database link, which I am able
to select, insert, delete from etc.
Now I have a package locally that does insert, delete on that
remote table but when I run the package, I get ora 1017. But
from SQL*Plus I can do my select, insert, delete just fine.
If I drop the
Lizz,
Here are a couple of things you will need if you want
to implement RAC on Solaris 9 with Veritas DBE/AC 3.5.
Veritas only certifies Storage arrays that support
SCSI-III persistent reservations so that leaves
XIOtech out as the storage array using Veritas DBE/AC
3.5.
If you use Solaris 9
me too. But it was blocked and filtered before coming to me!
-Original Message-
Sent: Thursday, June 05, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
FYI -
When this message came in to me it had the PE_BUGBEAR.B virus.
Mike
-Original Message-
Sent: Thursday, June
Never mind, I solved. Man, that error message is misleading. :)
-Original Message-
From: Richard Ji
Sent: Thursday, June 05, 2003 4:46 PM
To: Multiple recipients of list ORACLE-L (E-mail)
Subject: ora 1017
Hi,
I am accessing a table over database link, which
and what did you do to solve it?
Richard Ji [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/05/2003 03:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:FW: ora 1017 -solved
Never mind, I
Matt, Actually the Oracle note is correct and
Veritas's note is incorrect. Veritas is aware of that
the note you mention is incorrect. I believe the
problem is the 4 nodes where not supported until
Veritas released Maintenance Pack 1 (MP1) last
December. Veritas has also indicated to me that they
Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as
brutal, but it is a significant hit, so you wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you
can adjust the amount of data collected with the level if you feel the
Veritas only certifies Storage arrays that support
SCSI-III persistent reservations so that leaves
XIOtech out as the storage array using Veritas DBE/AC
3.5.
Well, you just killed her budget!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/5/2003 4:40 PM
Boris,
The default statspack snapshot is at level 5, which collects Top SQL (by
buffer and Phys reads, etc.) from the Shared pool, and that would cause
significant latching for a large shared pool which in turn results in a high
CPU usage. You could try a level 0 snapshot and look at the CPU
FYI
I got this with an interception of a worm tanatos-b virus and this virus
Is spreading out very fast because we got it from different sources
yesterday in just a couple of hours.
Jeroen
-Oorspronkelijk bericht-
Van: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
Verzonden:
Good afternoon everyone,
I'd like to know if anyone out there is using the export/import method to copy data
from a LONG column to a CLOB column. I've been doing this for a number of months now,
but one the DBAs I spoke to thinks that this method is not supported and there may be
issues around
Since the creation of an Index is DDL and DDL can not be written directly
into a procedure then you need to use Execute Immediate (or a couple of
other options, but if you have Oracle 8 or later this works fine) to call
the statement. The trick - don't put the semi-colon at the end within the
Hi All,
I'd like to get some information on how to
upgrade a 9iR2 32 Bit Installation to 9iR2 64 Bit.
Can I Upgrade just the software and use the
same datafiles and control file etc. or do I need to create a new database again
and do export/import of the old database.
Thanks and Best Regards
It could be that your own process is causing the error by committing between
DML operations. Take a look at metalink note 40689.1. My hazy
understanding of which is as follows: -
When you change a block in the buffer cache, a pointer to the rollback entry
is placed in the block header. When
read the migration guide
Munish Bajaj wrote:
Hi All,
I'd like to get some information on how to upgrade a 9iR2 32 Bit
Installation to 9iR2 64 Bit.
Can I Upgrade just the software and use the same datafiles and control
file etc. or do I need to create a new database again and do
Hi list
On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service
OracleServiceSID, most of the times, the database will also be mounted and
opened !
Doesn't matter wether I start the service via gui or via net start
OracleServiceSID or oradim -STARTUP -SID SID -USRPWD PWD
On behalf of Lee Robertson
Please include his address ([EMAIL PROTECTED]) in reply
-Original Message-
Sent: Friday, June 06, 2003 12:36 PM
To: [EMAIL PROTECTED]
We have a potential new client coming up who requires a 500Gb
database, a mix of OLTP and batch work, about 400 users of
Having read that bind variables will solve all our problems ;-) I've
tried to get the developers to use them. There response being: how? I
don't know much VB and they don't know what a bind variable is. So I
read with interest J Prem's question. Now knowing what to look for, I
read further, and
Is there a performance equality between COUNT(*) COUNT(0) ?
Is it same , indpendent of the Oracle Version ?
Forgive the repeat raising , as this issue seems to have come before .
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL
Stefan,
This is due to a registry entry - ORA_SID_AUTOSTART.
Open a registry editor, and navigate to
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEn (where n is the number Oracle home
of the instance in question, should there be multiple instances), and you
should see ORA_SID_AUTOSTART set to TRUE,
More info here:
http://vil.nai.com/vil/content/v_100358.htm
Regards
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
Where are they advantageous to use where not ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
I need more coffee, please excuse my weekend ready brain from it's grammar
fart.
Mark
-Original Message-
Mark Leith
Sent: 06 June 2003 13:00
To: Multiple recipients of list ORACLE-L
Stefan,
This is due to a registry entry - ORA_SID_AUTOSTART.
Open a registry editor, and navigate to
hi all,
this is purushottam hegde from Bangalore(IND)
i am relatively new to oracle and so to this group.
iam having a problem with function...
it goes like this.
SQL CREATE OR REPLACE FUNCTION EMP_SEL(ename IN Varchar2) return varchar2 is 2 resex varchar2(3); 3 Begin 4 SELECT sex into resex
Thanks for all the suggestions.
After playing about, it was apparent that the stats were wrong for the
table and screwing up the CBO. I had done analyze ... calculate, but
they were still wrong. I dropped the stats, estimated at 5% and things
are now back to normal. I had thought that analyze ...
function cannot be called with EXEC. u have to call it within a
procedure...
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of purushottam krishna
hegdeSent: Friday, June 06, 2003 5:05 PMTo: Multiple
recipients of list ORACLE-LSubject:
Title: Oracle bidding for Peoplesoft?
http://news.com.com/2100-1012_3-1013893.html?tag=lh
http://oracle.com/corporate/investor_relations/FINALpsft.pdf
Raj
Rajendra dot Jamadagni at nospamespn dot com
All
Maybe the obvious
But
Is the registry key ORA_SID_AUTOSTART set to true??
Jack
-Original Message-
Sent: Friday, June 06, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Hi list
On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service
OracleServiceSID,
Hi,
Either -
1) ORADIM -EDIT -SID SID -STARTMODE MANUAL
or -
2) regedit. Change HKLM\Software\Oracle\HomeX\ORA_SID_AUTOSTART.
Change the value to FALSE.
HTH.
-Original Message-
Sent: Friday, June 06, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
Hi list
On Oracle
That's why developping server side code will help as you can bind in
PL/SQL...period !
Avoid using thick clients...instead put all your logic in Oracle server side
(i.e: write package, procedure and function)
Regis
-Original Message-
Sent: Friday, June 06, 2003 12:35 PM
To: Multiple
Hi
purushotam,
since
it is a function that you are creating , its return value needs to be
collected.
hence
after BEGIN clause give a statement like
v_ret:=EMP_SEL('gali'); where v_ret
is a local variable of type varchar2
Thiswill work.
Regards
Kesh
-Original
What I remember from an old post regarding this issue, You don't have to
create another object, view, to workaround your requirement.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
VIVEK_SHARMA
Sent: Friday, June 06, 2003 8:10 AM
To: Multiple recipients of list
The error message tells you all: EMP_SEL is not a procedure, it's a function.
You cannot execute functions like that. Functions are called and not executed.
try something like
declare
ret varchar2(3);
begin
ret:=emp_sel('gali');
dbms_output.put_line('RET:'||ret);
end;
/
On 2003.06.06 07:35
http://www.theregister.co.uk/content/53/31079.html
OoooOO
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
declarea varchar2(20); b:=varchar2(20):='gali'; begin a:=EMP_SEL(b); dbms_output.put_line(a); end;
You cannot call the functions like this, only procedures can be.Venkat
- Original Message -
DATE: Fri, 06 Jun 2003 03:35:11
From: purushottam krishna hegde [EMAIL
exec only works with procedures. you can execute a function by calling to from sql as
such
select emp_sel('gali')
from dual;
or with a pl/sql block
declare
resex varchar2(3);
begin
resex := emp_sel('gali');
end;
From: purushottam krishna hegde [EMAIL PROTECTED]
Date: 2003/06/06 Fri AM
Title: Oracle text question
I briefly looked over the documentation and wasn't able to find what I was looking for so I thought I would check here before I spend the rest of my day searching
Anyone familiar enough with Oracle Text to give some estimates on the total amount of storage
you
need to accept the return value of the function in a variable. the correct way
to do is
SQL var a varchar2(1000)
sql execute :a := emp_sel('gali')
SQL print a
OR
SQLdeclare
SQLa varchar2(1000);
SQLbegin
SQLa := emp_sel('gali');
SQLDBMS_OUTPUT.PUT_LINE(a);
SQLend;
SQL/
Regards
Naveen
Title: A new form of ORA-1555
A sighting in alert log ...
SMON offlining US=102
SMON offlining US=104
Fri Jun 6 08:42:06 2003
ORA-01555 caused by SQL statement below (Query Duration=41895 sec, SCN: 0x0010.c2bd0c24):
Fri Jun 6 08:42:06 2003
SELECT ROUND(G_1/:SYS_B_00) G_1,
Mark, Jack
Thanks for the hint. I guess I need more coffee ... Autostart was set. Ouch.
And by the way ... which grammar problems ? Can't find any, since English is
not even my mother tongue ;).
Stefan
-Ursprüngliche Nachricht-
Von: Mark Leith [mailto:[EMAIL PROTECTED]
Gesendet:
Thanks, Dennis.
I've been using statspack for quite some time now, but
I've never bothered to ask myself an obvious question,
namely what overhead does statspack impose on the
system (taking about Heisenberg's principle of
uncertainty, he-he)
I guess part of the reason is the fact that
Chris,
Could you share the 11i install/cloning challenges you are facing
on W2000AS. We just installed AS and installing/cloning are
not behaving as they have in the past.
- Original Message -
From:
chris blais
To: Multiple recipients of list ORACLE-L
Sent:
Stefan,
Have you tried using the NOMOUNT switch somewhere in your db instance
startup?
Julio
-Original Message-
From: Stefan Jahnke [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Service on Win2k
Hi list
On
I have used an inline view to reduce network traffic when retrieiving
data from a remote db. Instead of using a nested loop and making
multiple trips, it made 1 trip and brought over all of the data. The
query time was reduced from 30 minutes to 5 minutes.
--
Daniel W. Fink
Having tested both forms... it looks like to be the
same...
asktom has a detailed thread about this...
sorry, because I'm not posting the url link, but in
this moment the site is experiencing 'technical
difficulties'
:-)
HTH
JL
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
Is there a
Hi
Question: Are you sure that the binding you're referring to (your book
excerpt) doesn't mean early bindig versus late binding in VB using ADO ?
Stefan
-Ursprüngliche Nachricht-
Von: Regis Biassala [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 6. Juni 2003 14:50
An: Multiple recipients
Title: RE: inline views
it is also useful when you DBA won't allow you to create a new view ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD:
Thanks, John.
Any insight as to why is it primarily the system mode
CPU? I've seen high system mode CPU utilization in
non-Oracle stuff (like NFS), but for Oracle I thought
it should be primarily user mode?
Does Oracle's CPU used by this session represents
user-, kernel-mode or both? And what
Hi,
I'm facing a bit of an struggle with this SQL statement. The one below
results in the correct number of records (601). However, when I add the
tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get
fewer records (526). The reason is because there are item numbers which
do not
Hang around and we'll learn you some grammer.
Oh, and Oracle acknowledge they have a bug in the index builds. Multiple
users had reported it, but it was Oracle's decision to sit on their thumbs
and rotate until somebody handed them a trace file proving it. Now, they
want us to set up a test
1 - 100 of 192 matches
Mail list logo