Title: Message
Sorry,
It is
not readable.
Kind
Regards,
Hatzistavrou
Yannis
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 6:40 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: Do not connect Oracle DB to
the Internet.
On 2003.10.27 00:34, Mogens Nørgaard wrote:
I have this radical idea that Oracle should include RAC in SE at no extra
price (I think that would spread the product fast :) ),
That would, quite likely, be the end of RAC. RAC is a great tool for those who
need it, but it's far too complex for
Hello Tom
From my limited understanding in OOW in Paris, the Grid is a BIG RAC, with
options to add or remove servers as you go along.
It can be used for web servers, applications servers, database servers etc.
There is a lot more in 10g that can help you manage also separated
databases.
Yechiel
Hello
Am getting an ORA-7445 and have raised a iTAR with Oracle but so far they have not hot to the bottom of the problem, so I thought I'll try this list!
When I run a package in sqlplus I get the follwing error:-
ERROR at line 1:ORA-03113: end-of-file on communication channel
The following
What you have described is expected behaviour -
if"the next insert would drop amount of free space less than PCTFREE", the
block is unlinked.
What Ihad notconsidered is what
happenswhen the block is still below PCTUSED? As usual, Steve Adams'
website explains this very nicely - it is not
Intermittent ORA-4031
errors Out of shared Pool :-
Oracle ver 9203
Solaris 9
Concurrent Users =
6000
Shared Servers /
MTS being used
Listeners = 4
Application using
Bind Variables
Application =
Banking - Hybrid in Nature
Database size = 1
TB
m/c = SF15K
How can this issue
Hi,
The walking in the freelist is just 5 blocks (or
the value of _walk_insert_threshold number of blocks) and I belive tanel
is talking
about (_release_insert_threshold) unlinking from
freelist, which also default to 5 blocks.
KG
- Original Message -
From:
Binley
Lim
Hi,
I have an online application that does a 'select count(*)' on a few tables.
The 'select counts' always runs slow (about 10secs) for the first time and
then fast again ( 1sec) after subsequent accesses. The query runs slow
again when the data is flushed out of the buffer cache.
10046 trace
Ross,
Yup. I don't recall ever excluding SYSTEM, though I generally work hard to
minimize I/O in that tablespace (i.e. make sure not being used as temporary,
no schemas except SYS, move AUD$ table to another TS if necessary, cache
sequences, etc).
Most folks put that statement into a loop, to
Hi!
Does anybody have any exprience with conflicting client JVMs?
We are installing software though Microsoft SMS software packaging on the
Clients (PC running XP).
The deal is that another application (PVCS Dimensions) works fine if it is
distributed on the systems without the Oracle 9.2
Mladen, Mogens - If Oracle were to slash prices, there are several factors
to consider. First, what does that do to Oracle's bottom line? Would sales
increase dramatically enough to keep overall revenue from falling? I think
the stagnant economy over the last few years has been tough on everyone
Yes, you are right, of course. I messed up.
On 10/27/2003 01:34:25 AM, Cary Millsap wrote:
You mean make your PCTINCREASE 0 so that SMON will *not* coalesce
them. Right? Some comments:
- You don't want SMON coalescing your tablespaces. It is a complete
waste of time. Oracle coalesces on demand
I always saw this note (and hated it):
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOTp_id=31116.1
Hope it helps,
Waleed
-Original Message-
Sent: Sunday, October 26, 2003 8:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
For those like me
Linda,
I guess that the key word is 'partition'. This type of query should not require to
access the table if (hopefully) tid is indexed. If the index on tid is also
partitioned, all index partitions have to be searched. My feeling is that in such a
case what should run faster is some
Ah yes, the squashed squirrel demo...
Connor
--- Cary Millsap [EMAIL PROTECTED] wrote:
You mean make your PCTINCREASE 0 so that SMON will
*not* coalesce
them. Right? Some comments:
- You don't want SMON coalescing your tablespaces.
It is a complete
waste of time. Oracle coalesces on
I wasn't feeling quite well when I was replying which made me confuse
things. You, of course are right. SMON was locking fet$ table during
those coalesce session, which was exceptionally dangerous in the OPS
configurations. Coalescing doesn't buy much,the coalesce operation
just combines
me too.
-Original Message-
Sent: Friday, October 24, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
I am also interested in this paer .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 24, 2003 12:14 PM
List,
I believe that Red Hat would be much better acquisition target then
PeopleSoft. First of all, Peoplesoft doesn't seem to like the idea,
second, Peoplesoft is very expensive. Red Hat would be much cheaper
and would help oracle branch into other areas, where they could
bundle database in a
Title: RE: What happened to Howard Rogers ?
I once worked for an excellent company, Southwest Research Institute, in the USA. As part of my employment agreement, I had to sign a paper saying ANY patent I was granted belonged to the company. It didn't matter if it was on my own time or not
And this is a good thing?
;)
-Original Message-
Mladen Gogala
Sent: 27 October 2003 14:24
To: Multiple recipients of list ORACLE-L
I believe that Red Hat would be much better acquisition target then
PeopleSoft. First of all, Peoplesoft doesn't seem to like the idea,
second, Peoplesoft
Bingo. I've included a few more details in a separate note sent just
prior to my receiving this one.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium
Some time ago, I've published my intention to test various file systems
on Linux for their ability to support direct I/O async I/O. Let me
remind everybody who might not know, direct I/O bypasses the Linux
buffer cache, behaving as if the file was a raw device. The primary
goal is to avoid the
It's a note created in response to hundreds of customers shouting about
how VMS and DOS need defragmenting; therefore, Oracle must need
defragmenting, too.
There *was* a cluster bug way back in release 6 that caused CREATE
statements to take a really long time if you ever let a tablespace get
Me too...
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 8:15 AM
To: Multiple recipients of list ORACLE-L
me too.
-Original Message-
Sent: Friday, October 24, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
I am also interested in this paer .
-ak
All of a sudden our em on the 9ias system v2 won't stop. We even tried to reset the
password and reauthenticate. Searching on metalink does not provide much info.
Anyone deal with stuck em process before?
Thanks,
Paula
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Cary,
Hang on a second. Oracle will not always coalesce on create to the extent
needed. It will go out either 10 or 20 extents (rusty memory here) and then give up.
In this case it will either create an extent of the size requested above all of the
other objects in the tablespace or
Title: Query Tuning Help
I'm trying to tune the following query to use an index on the FILE_DTS column, rather than a FTS on the CLASS_CONFIG table (~350,000 rows).
SELECT a2.class_config_id, a1.schedule_name
FROM class_config a2, class_schedule a1
WHERE a2.class_config_id =
Hi,
Try this url...
download-uk.oracle.com/openworld/upload/W12825.doc
Alessandro Guimaraes
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 6:59 AM
Me too...
-Original Message-
[EMAIL PROTECTED]
Sent:
I remember reading something about this a couple of years ago. Another
Larry pipe-dream. That he would keep developing the Rdbms-kernel so that he
didn't need the any op-systems.
If you think about it, the Rdbms is close to being it's own op-system. It
provides a service on a machine
Dick,
You said:
I think the Server Technologies folks need to spend a little more time with
SMON. It certainly does not appear to pull it's due.
I think they avoided the issue with Locally Managed Tablespaces. All of
these problems go away with standardized extent sizes.
Tom Mercadante
Hi All
oracle taking over redhat...makes lotta of
sense...actually..
Redhat ProductsOracle Products
Redahat DatabaseOracle Database
Redhat collabration suite oracel collab
suite
Redhat Devlopement env Oracle ids
Redhat strongholdweb
because its not always faster to use an index. try using a hint for the index and see
which runs better.
From: David Wagoner [EMAIL PROTECTED]
Date: 2003/10/27 Mon AM 10:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Query Tuning Help
I'm trying to tune
Title: Query Tuning Help
David,
The
calculation "( SYSDATE - 35)" is not causing the problem. The
To_Date(a2.file_dts, 'mmddyyhh24miss') is.
You
said you created a function based index. I think you also need to
set:
Query_ReWrite_Integrity =
TRUSTEDQuery_ReWrite_Enabled
= TRUE
for
Title: Query Tuning Help
Tom,
Thanks
for the init.ora parameter tips, I consulted the docs and did that first
:-). It just seems that the CBO would rather use an index, even though I
know that's not always the case.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Do you have query rewrite privilege? What is the
query_reqrite_inegrity set to? How about optimizer parameters
(optimizer_index_caching,optimizer_index_cost_adj)? Is everything
analyzed?
On 10/27/2003 10:34:26 AM, David Wagoner wrote:
I'm trying to tune the following query to use an index on
I need to parallelize some sql operations and Im running them from unix scripts.
I want to spawn off a few in the background from a master script, then have the master
script 'wait' for them to finish. Ive done this in Java and with dbms_alert, but I
cant dig up the syntax to do this with korn
Tom,
Well if that was the only place SMON seems to be weak, I'd wholeheartedly
agree. But it leave something to be desired when a user terminates their session
ungracefully as well. Yes I know that's primarily PMON's job, but I've been told by
OTS that some of it is also SMON's job
Title: Query Tuning Help
The
FILE_DTS column is VARCHAR2(12) NOT NULL and has data in the following
format: 07220301.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Solutions Phone: 919-466-6723
Cell: 919-412-8462
Pager: [EMAIL PROTECTED]
Fax: 919-466-6783
David,
I would probably not try to tune a query to make it use an index but tune a query to
make it run faster - I have had recently a nice example, a join between a 500K row
table and two 2K row tables (returning about 2K rows too) was running faster with FTS
(followed by hash joins) on
I know that bash has wait built in. It works like this:
GODOT=`ps -fu $LOGNAME|grep sqlplus|grep -v PID|perl -e 'while ()
[EMAIL PROTECTED] /\s+/; print $A[1] }'`
wait $GODOT
On 10/27/2003 11:09:25 AM, [EMAIL PROTECTED] wrote:
I need to parallelize some sql operations and Im running them from
I don't know about Solaris but on HP-UX and AIX you can do:
run_sql_1
run_sql_2
wait
This will wait until both have finished.
Re a specific PID $! will return you PID of the last child process and then
you can wait on that PID. Looks something like:
run_sql_1
run_sql_2
PID_WAIT=$!
wait
I would imagine that the perspectice of grid computing
offered at OOW would be somewhat Oracle centric.
Grid computing does not require Oracle - it is, here
comes an overused buzzword, a paradigm shift.
There, I've said it. I think this is the first time
I've ever used that term, and it may
Jared,
Well said. It I believe is a HYPE and NOT a paradigm shift. Heck, look at
from a marketing perspective. If we can't sell you a few high priced computers maybe
we can sell you a lot of cheap computers with high priced, grid enabled (Namely higher
priced), software. End
There is/(are)
known bug/(s) in 9.2.0.3 where the shared pool becomes fragmented and will
refuse to un-fragment itself. Attempts to flush the shared pool
fail. So far, based own our experience here, this seems to be fixed in
9.2.0.4.
Things like shared
pool details tend to leak out of my
Jerry - And they may or not be able to enforce that stipulation. A friend of
mine invented something in his spare time. When his patent was granted, the
company lawyers showed up to provide his requisite $1 and their gratitude,
per the agreement he has been forced to sign as a condition of his
Dick, Jared
If you look at the big picture, 20 years ago the idea of a PC with the
throughput of a mainframe was laughable. Not so laughable today. Large
systems use many of the same components as PCs. Whether this means the grid
is more than hype remains to be seen. But I suspect Larry would
And if your nose is raw from having nothing better to do with your time,
(Remember: You can pick your friends; and you can pick your nose; but you
cannot pick your friend's nose.)
you can tune in to some of Sun's marketing on the subject.
(from a Sun e-mail)
Whatever your business, it
Bill --
I appreciate your input to this very complex question. IMHO, however, she
turned me into a newt! is, technically, an interview *statement* rather
than an interview *question*. That being said, it can be used at the
beginning or end of the interview to set tone, but lesser candidates
Arup,
Thanks for the info. Can you elaborate a little on your understanding
of how a client would connect their own reporting tool _directly_ to
our database?
Paul
--- Arup Nanda [EMAIL PROTECTED] wrote:
Paul,
We use Advanced Security. the product is pricey and difficult to
setup; but
Stay safe, Bruce. Don't worry about us.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Bruce A. Bergman
Sent: Sunday, October 26, 2003 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject: ADMIN: Warning of potential list shut downs
I went to Oracle technology day in Milwaukee the other day and was a bit put
off by the marketing hype on 10g and the lack of 10g facts. The technology
day was promoted as a grid day...10g this and grid that. What did we get?
Marketing hype about collaboration suite. They used 10g to get people
The way things are happening now, I have a feeling that we might soon
witness the total eclipse of the SUN and that the darkness will rule.
One browser to rule them all, one browser to find them
One browser to bring them all and in the darkness bind them,
In the land of Redmond where the shadows
Here's another idea. Expand on it and modify as needed.
COUNT=1
while [ $COUNT -le 8 ]; do
## The first jobs command is to clear out any jobs completed
messages.
jobs /dev/null
if [ -z `jobs` ]; then break; fi
sleep 30
COUNT=$(( $COUNT + 1 ))
done
jobs
Well, it is marketing hype from Oracle's perspective but the Linux
supercomputing stuff is a reality and grid is not too far from that
conceptually. I supose one of these days, say around, Oracle 15X, they
may actually get it all down.
The show and tell I went too talked about bundled clustering
Jared,
Is that the book from sans.org?
Thanks,
Paul
--- Jared Still [EMAIL PROTECTED] wrote:
Yes, I will ditto the recommendation for Pete Finnigan's book.
Jared
On Fri, 2003-10-24 at 10:29, DENNIS WILLIAMS wrote:
Paul - We have some of the similar issues here
Stephane,
the execution plan for the statement is an index range scan on tid. It did
not access the table. index is not partitioned. I will testpartitioning the
index and with the parallel fast full scan. Anyone else has any other
suggestions?
Thanks.
linda
From: Stephane Faroult [EMAIL
Some of us here at work have been using grid computing to compile
programs...
http://www.gentoo.org/doc/en/distcc.xml
Standard disclaimers apply (e.g. all machines must have same versions of
copmiler, same architecture, etc. to avoid problems).
Rich
Rich Jesse
Other companies are in the mix, also... Check out:
http://www.savantis.com/product/
-Original Message-
Sent: Monday, October 27, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
Well, it is marketing hype from Oracle's perspective but the Linux
supercomputing stuff is a reality
Yes: https://store.sans.org/store_item.php?item=80
On Mon, 2003-10-27 at 09:49, Paul Baumgartel wrote:
Jared,
Is that the book from sans.org?
Thanks,
Paul
--- Jared Still [EMAIL PROTECTED] wrote:
Yes, I will ditto the recommendation for Pete Finnigan's book.
Jared
On
Thanks for the warning Bruce. Hope all is Ok by now.
Jared
On Sun, 2003-10-26 at 15:44, Bruce A. Bergman wrote:
Everyone --
Just a note of advance warning. The brush fires which are sweeping through San
Diego county MAY cause the shutdown of all mailing lists and web services at Fat
anyone use these? Oracle support said db_block_checksum can create major performance
issues.
im trying to track down an ora-600 error and oracle support said we should possibly
try using these.
anyone have any experience with this?
--
Please see the official ORACLE-L FAQ:
Title: Re: ORA-4031 errors no a high Load Database
Vivek,
You are using MTS/SS; have you configured the Large Pool to accommodate all of the UGA structures? If you do not have the Large Pool configured from its default of 0, then all of the UGA (i.e. session global areas, shared amongst the
From a first glance, that seems like a pile of wasted money. Knowing Savantis you'd
be better off with RAC.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 27, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L
Other companies are in
Title: Re: What happened to Howard Rogers ?
That is quite standard. The meaning of full time employment does not admit the concept of working on my own time; mutually exclusive in many senses. In order to segregate your own time from that of a company, you have to be a temporary (i.e. contract)
I was wondering about this, how the fires were affecting the electrical
power distribution in SoCal.
There are three power lines that come into Bozeman and supply the town
and surrounding areas with all electrical power. This summer's fires
destroyed two of the lines and came within a few hundred
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the keyword, as it is not the
default), then you will be performing indexed RANGE scans
Never mind, I see that it is. Thanks.
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
Jared,
Is that the book from sans.org?
Thanks,
Paul
--- Jared Still [EMAIL PROTECTED] wrote:
Yes, I will ditto the recommendation for Pete Finnigan's book.
Jared
On Fri, 2003-10-24 at
Monday, October 27, 2003, 12:09:25 PM, you wrote:
DW But as a
DW consequence of the discussions with his management chain, he ended up
DW agreeing to resign.
Odd. It must be really important then, when you have a
brilliant and innovative employee capable of inventing
something unique, to have him
Cary,
Under 7.1, 7.2, and 7.3, there were some very real situations where even the
most careful space management strategies came to naught. Specifically, the
habit of parallel direct-path operations on tables and indexes to trim
the last extent to avoid leaving wasted space above the high-water
if you attemp to wait after the process is complete, will it cause a problem? say the
PID no longer exists when you issue wait?
From: Dunscombe, Chris [EMAIL PROTECTED]
Date: 2003/10/27 Mon AM 11:39:34 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: wait/notify
Sounds like a management decision, not a corporate one.
As in, a shortsighted, inflexible, incapable of seeing the
forest for the trees, slave to the bureaucracy type manager.
Not that you ever see managers like that... ;-)
boss
Monday, October 27, 2003, 12:09:25 PM, you wrote:
DW But as a
On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote:
if you attemp to wait after the process is complete, will it cause a
problem? say the PID no longer exists when you issue wait?
Why don't you try it? There is this phenomenal Unix IDE called vi
which can help you to write a shell script and
Haven't you ever heard of things like modular programming,
object oriented approach, divide and conquer and alike?
What in the Wall's name are you doing when you need a distributed
compiler? Linux kernel compiles on my box in 10 minutes, modules
need another 10 and I'm good to go.
On 10/27/2003
Kernel schmernel, KDE takes something like 18 hours to compile (and I think
KDE sucks -- Enlightenment all the way!). Knock that down by two-thirds or
a half with a couple of more boxes with a 'net connection. Building an A/V
Gentoo box takes many days. Damn tight when you're done, but it takes
Sorry for the OT, but I would really appreciate it if
someone could point to a URL for this, or even better,
if you have the answer.
I am trying to do something seemingly simple: configure
Evolution to use mplayer as the program of choice to
view video files ( mpg, mpeg ) that are received in
You need to set it up under nautilus. Evolution uses the file
associations/mime types from gnome.
Rodd
On Mon, 2003-10-27 at 14:04, Jared Still wrote:
Sorry for the OT, but I would really appreciate it if
someone could point to a URL for this, or even better,
if you have the answer.
I am
And everybody else in the area too. Looks like a very nasty one.
Having been on the receiving end of a similar one back in 94, I
know how hard this can be. All the best for residents of the area
and above all, STAY SAFE!
Cheers
Nuno Souto
[EMAIL PROTECTED]
Stay safe, Bruce. Don't worry
Mladen Gogala scribbled on the wall in glitter crayon:
On 10/27/2003 01:54:25 PM, [EMAIL PROTECTED] wrote:
if you attemp to wait after the process is complete, will it cause a
problem? say the PID no longer exists when you issue wait?
Why don't you try it? There is this phenomenal Unix IDE
Title: RE: Query Tuning Help
Mladen,
Thanks for your response. Comments are in-line.
Do you have query rewrite privilege?
Yes.
What is the query_reqrite_inegrity set to?
TRUSTED.
How about optimizer parameters (optimizer_index_caching,optimizer_index_cost_adj)?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: 27 October 2003 05:34
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle pricing ain't going down
You had everybody convinced by your speach down there in
South
Title: RE: Query Tuning Help
Just
checking to see if anyone has been able to clone a 9.2 DB from one machine to
another. I have never had a problem doing this prior to 9.2, and am just
wondering if I have overlooked something peculiar to 9i.
Thanks
in adavance
John
PMFJI
How about optimizer parameters
(optimizer_index_caching,optimizer_index_cost_adj)?
optimizer_index_caching=0 Are these reasonable values?
optimizer_index_cost_adj=100
sorry for the space everyone ms outlook 101 is a class I *badly* need
like how do I reply in plain text with
Read if you are interested ...
Finally I got some time and luckily the largest message to use with dbms_profiler. And
the results shocked me dbms_profiler showed me that instead of utl_raw, substr()
was the culprit. Remember my operation is character by character.
After some long thinking
Once the lawyers get hold of an issue, common sense goes out the window.
At 11:19 AM 10/27/2003, you wrote:
Monday, October 27, 2003, 12:09:25 PM, you wrote:
DW But as a
DW consequence of the discussions with his management chain, he ended up
DW agreeing to resign.
Odd. It must be really
How about some more details? Are you cloning to a similar platform? Are
you using a cold backup with controlfile recreation? RMAN backup or
restore? RMAN duplicate? ...
Adam
John Blake [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/27/2003 02:24 PM
Please respond to
[EMAIL PROTECTED]
Title: RE: Query Tuning Help
Did it
a couple of weeks ago on Sun. No problems.
Bambi.
-Original Message-From: John Blake
[mailto:[EMAIL PROTECTED]Sent: Monday, October 27, 2003 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: Clone
db 9.2 on AIX 5L
Just
checking
We do it about 12 times (varying sizes of database) each night ... copy the raw files,
archive logs and roll forward. No problems.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Sorry,
AIX 5L to AIX 5L
cold backup copies
create backup controlfile to trace -- edited for the new file locations
keeping the SID the same
created init.ora from spfile
startup nomount pfile=init.ora
getting ora-3113
I have a TAR opened and figured I would check out here as well.
DBAs
Our database running on NT 2000 is over 200 processes today and I had to
reset to a hight No. As I know, if I set highter for this parameter, the
will be impact on Unix system, I wonder there is any impact on windows.
thanks in advance
Mitchell
--
Please see the official ORACLE-L FAQ:
Awesome, Raj!
And thank you for sharing this with us.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 4:29 PM
Read if you are interested ...
Finally I got some time and luckily the largest message to use with
Mitchell,
It would be most helpful if you supplied the Oracle Server version info.
You may have simply had legitimately 190 users connected.
You may have a problem with sessions being disconnected by the client that are not being terminated properly. It is a known issue that support for dead
Thanks Pd for your answered. The Os is window 2000 and Oracle
8.1.6.0.0. I run the query v$resource_limit after I reset processes
No to 250. andsaw the No. is up and stable to 110 process. I will keep
monitor it and make sure all session disconnected.
I wonder if processes is set to
Raj,
Jamadagni, Rajendra wrote:
Read if you are interested ...
Finally I got some time and luckily the largest message to use with dbms_profiler.
And the results shocked me dbms_profiler showed me that instead of utl_raw,
substr() was the culprit. Remember my operation is character by
Mitchell,
Oracle 8.1.6.0.0.
that is not good news. Depending upon how important the data and use of the data in this particular database is, you might want to plan on upgrading it in the immediate future, near future (or never - it might not be your problem). If you have an issue and would
Rich,
That really isn't 'grid', but I think you know that.
GC essentially makes a network look like one great big
box, with the cross platform functionality included.
In the immortal words of Scott McNeally:
The network is the computer. :)
Don't know if he said if first. John Brunner was
Hi, All
Wondering whether anyone created indexes on materialized view to further
improve the performance? What's the pros and cons of this method?
Thanks in advance.
Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally
Hi,
Execution plan looks good but the query is consuming 800 seconds CPU timewhy?
SELECT sampleavail, sample_cost_amount, sample_sale_amount,
discount_room, discount_case, discount_half_case, allow_cut,
Chuan,
You can crteate indexes on MVs if you want to - there is nothing against it;
in fact it may be specifically desirable to do so. MVs are designed to help
in query optimization by selecting against a materialized collection f
data as opposed to selecting from a set of tables as in case of
Creating Indexes on MV is pretty ok and it is good for performance.
I even create mv on mv to further improve the performance of some really frequently
executed SQL.:)
Regards.
Zhu Chao.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
Hi,
I guess you are just using RBO and did not analyze your table. Try analyze it and
run it again.
You nested loop maybe is inefficient, as it generate a lot of buffer_gets.Maybe
you can consider using hash_join instead of nested loop.
If you still plan to use nested loop, consider
100 matches
Mail list logo