while rebuilding indexes i gave parrallel 2 . But I see there are
four ora_p00 processes . ???
-ak
but you have probably 2 CPU-us
mac
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: mac
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Package can be obtained from
http://oracledba.pwp.blueyonder.co.uk/cron.html
Use at your own risk.
Garry Gillies
CONFIDENTIAL:
The information contained in this email (including any attachments)
is confidential, subject to copyright and for the use of the
intended recipient only. If you are
Thanks for the suggestion, Mike. I had hoped that the smiley had indicated
that this was put forward in a (supposedly) humorous way. I had the great
pleasure to spend some time with Cary during his stay in Iceland and I would
not have posted my remark if I thought there was any danger of him
I'm 15
going on 24 (the OT guys know what I mean ;) ).
I'm 24
really. Been using this Oracle stuff for around 5 years now.. I'm not a DBA by
job title, though I am DBA trained (on Oracle SQLServer) and feel I could
do the job quite competently..
I
think I'm the youngest whippersnapper
Guys,
SQL SELECT NAME,AGE,MEMNO,BLOODTYPE,HIGHT,LOOKSLIKE,CONTENT,PICID FROM PROFILE
WHERE PREF = :PREF AND SEX = :OP_SEX AND FLAG = :FLAG AND ENTPC = :ENTPC
AND NAME IS NOT NULL AND FACCESS SYSDATE - 14 ORDER BY ENTDAY DESC;
NO ROWS SELECTED
ELAPSED: 00:00:00.07
EXECUTION PLAN
I've used RPT/RPF as a programmer and some of them are still used.
Now as a DBA , I see them still running against 8.1.7
and i am only 31 yrs young.
Regards
Madan
DBA
bitmaps are stored within the datafiles themselves. You would add the
extra space to EACH datafile.
Tablespaces are logical constructs they have no physical reality
other than the corresponding datafiles.
If the bitmap were stored in only the first datafile, Oracle would need
to access that
Title: Extproc setup Q?
Hi All,
I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora listener.ora)
Attached are my files that look OK to me
Anybody??
Hi!
(B
(B the env. is 9.2.0.3/win2k-sp3.
(B
(B it is built on "profile" table .
(B the index has the columns "entpc,sex,flag,pref,entday" in it.
(B the order of the columns in the index is also the same as i have
(Bmentioned.
(B
(B 1.so ,does it mean that "idx_profile_shinki" is a bad
Daniel,
To understand this better I conducted a mini-experiment. If my findings are
correct then this is simpler than I thought.
Before the Oracle kernel emits a line to the 10046 trace file, it seems to
check the timestamp of the last line it emitted. If more than x number of
seconds have
Hi Tanel,
(B
(Bquote
(Bdid you analyze your table in addition to index as well?
(Bfirst time you were probably using RBO, which always counts index access
(Bbetter than table access.
(B/quote
(B
(Bi have analyzed PROFILE table also and hope it's CBO by default in 9i.
(Banyway,it is CBO
Title: Extproc setup Q?
Please add the line in red to your listener.ora file.
Extproc has been made secure in Oracle 9i. The following line has to be added to
execute your own external procedures.
LISTENER =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
Linux)(PORT = 1521))
Title: Extproc setup Q?
I
found this item on the 'net this morning:
http://rootprompt.org/article.php3?article=5475
Patrice.
I'm doing research for an article on union queries. I'm
interested in finding examples of problems that were solved
using UNION, UNION ALL, INTERSECT, or MINUS, with the latter
two being of special interest because I don't see them used
very often. If you can think of an interesting problem
you've
There is a rumour going around here that 9i Release 2 is not as finished
as 8i Release 3 is.
i.e. that there are still problems with 9i Release 2.
I have been running it on Tru64 for months now for our OEM repository, no
problems.
I have been running it on my WinXP Pro workstation for months
Title: Extproc setup Q?
Heh-heh, Burleson talking about running Oracle on
WINE and IBM dropping AIX..
What a joke...
Tanel.
- Original Message -
From:
Boivin, Patrice J
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 24, 2003 3:34
PM
Subject:
Dave, yes you have the responsibility to get them off disk, ie: the
database will appear to halt processing if the archive_dest gets full.
RMAN is good for that, you can back them up and purge them in one step.
Feel free to email direct if you want to talk in depth about it.
joe
Farnsworth,
Title: RE: Oracle 9i Release 2 and Oracle 8i
We have had some... opportunities... but so far the worst one was connected to APPS and depreciation. It was fixed in 9.2.0.3
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come
- Original Message -
I'm doing research for an article on union queries. I'm
interested in finding examples of problems that were solved
using UNION, UNION ALL, INTERSECT, or MINUS, with the latter
two being of special interest because I don't see them used
very often. If you can
I don't know what the triggering event is for the kernel to decide when to
emit a timestamp line to its trace data. But I have found that the frequency
is nicely convenient for adjusting for clock drift. You could set up an
experiment to figure it out as follows:
Make a program that
Ah. I think that the kernel will only emit a timestamp line immediately
before writing a db call or wait event to the trace data. This is a similar
trigger to the one that the kernel uses for writing a PARSING IN CURSOR
(PIC) section to the trace stream. You'll only see the PIC section
immediately
Title: RE: Oracle 9i Release 2 and Oracle 8i
We experience not many problems on 9202 database we have had very
good uptime. Touch wood ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views
what do you mean by 'arc'?
From: Nuno Souto [EMAIL PROTECTED]
Date: 2003/07/24 Thu AM 09:39:29 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Union quries: INTERSECT, MINUS, etc
- Original Message -
I'm doing research for an article on union
Title: Message
Tried that still the same error
message.
Any other hints tips for me to try?
Just curious though ,why is it DLLS if I'm working on
LINUX
Jack
-Original Message-
From: Munish Bajaj [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 2:30 PMTo:
1 CREATE INDEX myIndex
2 ON myTab (myCol)
3PCTFREE 1
4STORAGE (
5 INITIAL 5M
6 NEXT5M
7 MINEXTENTS 1
8 MAXEXTENTS UNLIMITED
9* PCTINCREASE 0)
10 /
ON POS (ACCT_NO)
*
ERROR at line 2:
ORA-08103: object no longer exists
i try
At a previous job, I used MINUS as part of a package to perform
automated testing of transaction processing. Compared actual result set
with expected result set via minus. IF rows returned then if failed and
returned rows were written to error table for review. Worked well for
what we needed it to
You'll want to modify your statement first to have different file names for
each datafile. Just pointing it out in case the obvious was overlooked...
BTW, anyone know what that statement would do? Would it error out? Gotta
get another playground for testing...
Rich
Rich Jesse
Tanel,
I read it differently. Don talked about the different os that you
could run and when talking about WINE it was in reference to the client
os being Linux and being able to run the standard office packages that
Windows provides. I found no reference to running Oracle on WINE.
Ron
[EMAIL
I tried it.
I got the message error creating the file, file exists. Tablespace
was not created (as expected). However the FILE itself also was not
created, as if Oracle cleaned up after itself.
--- Jesse, Rich [EMAIL PROTECTED] wrote:
You'll want to modify your statement first to have
In the middle of the article:
Using WINE, you can run Oracle for Windows, using Linux as the underlying
operating system
I think Burleson mixed up Wine with WMWare, WINE isn't even able to run
notepad correctly, not to talk about complex multithreaded app like
Oracle...
Tanel.
- Original
Title: Recommendation for cheap HA solution
Hi!
We are looking into establishing some sort of high availability solution here. We are running 9.2.0 on Sun Fire 280 (2 processors).
Since we are on a tight budget, we are looking into various solutions for HA.
One option would be to use Sun
The trace seems to be from when the index is not analyzed. The CBO then
uses defaults for the index statistics - leaf_blocks=25 and clustering
factor=800. These defaults are much lower than when the index is analyzed
and the resulting cost for using the index is very low (7 compared to 1676
Thursday, July 24, 2003, 10:09:25 AM, Dave wrote:
DP Compared actual result set
DP with expected result set via minus.
I've done that too. I need to search the cobwebs of my
memory a bit, but I recall having use MINUS both ways to be
sure:
results MINUS expected_results
tells you whether the
Rich noticed at a large number of executions for a trigger on a table the
header looks like this and now we are a bit confused. Consider the
following:
AFTER INSERT OR UPDATE ON BLAH.PARTMASTER
FOR EACH ROW
WHEN (NEW.commodity_code != OLD.commodity_code OR OLD.commodity_code IS
NULL)
BEGIN
There is a marketing term in the USA (at least) called bait and switch.
Yeah, sure! We have Linux. Here, take a look at our Linux.
But, while you are doing that, you might as well look at AIX.
-Original Message-
Heh-heh, Burleson talking about running Oracle on WINE and IBM dropping
I'm sorry, but I really can't remember how an Oracle SQLPlus client is supposed
to behave when the database server's network interface is pulled out.
We were testing a new Sun Cluster and tests for Storage FC Path Failure,
Instance Failure,
Node Failure, HeartBeat failure and single Network
(Tried sending this yesterday. I'll try again)
Dan,
I was running a 10046 (level 12) trace on an awful piece of PeopleSoft SQL
today and got some really odd results in my trace file (8.1.7).
*** 2003-07-23 15:40:59.149
WAIT #1: nam='db file scattered read' ela= 0 p1=65 p2=6041 p3=18
***
Aha. Big guy ;). 34yrs, 6'6'', 225lbs. The 5 miles still work and at least
due to my height, I'm able to cheat at the chin-up bar ;).
Don't panic.
Stefan
-Ursprüngliche Nachricht-
Von: Gogala, Mladen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 23. Juli 2003 20:14
An: Multiple
Hi All!
I tried create histogram in Oracle 7.2 with the following statement:
SQL ANALYZE TABLE nai_parameters COMPUTE STATISTICS FOR COLUMNs prompt
SIZE 75;
ANALYZE TABLE nai_parameters COMPUTE STATISTICS FOR COLUMNS prompt SIZE
75
*
ERROR
Title: RE: Trigger Firing and Execution of Body Code
brad,
you have got it right but to prove your assumptions .. it is very easy ...
alter session set events '10046 trace name context forever, level 4'
/
run some dml on the table
alter session set events '10046 trace name context
Hi there
Who is running this.
Would like to hear opinion and experiences.
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: (+27) 82 655 2466
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
Do you have Oracle Enterprise or Standard?
If Enterprise, you are licensed for Oracle's Adv.
Replication feature. You may want to consider this as an
option since it could provide an HA solution without
spending any additional $$$ except for duplicating your
current db server. You don't need
Oracle RDBMS 9.2.0.4??? I thought that the latest version was 9.2.0.3?
Where did you get 9.2.0.4?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, July 24, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Hi there
Who is
Title: Recommendation for "cheap" HA solution
Hi!
When not having any cluster manager, there's 3 main
issues what you have to deal with:
1) hearbeat - verifying whether primary node (or
other nodes) are alive
2)storage - making failed node's storage
accessible to backup node
3)
Henry,
I'll make an attempt, but I am still learning a great deal about wait events
and trace files. Cary, Mogens, Anjo, Tim, Jonathan, Wolfgang, et.al. are better
authorities, so any corrections are very welcome.
The time between waits is the elapsed time. If we equate elapsed
One of or developers is work on a routine that will trigger a procedure
that will use a dblink to update a table on another database. It seems
like I remember that something about a problem with procedures, dblinks,
updates? Does anyone remember anything about that?
Thanks!
Ron
--
Please see
Hemant,
You are right it does get a timeout from the TCP stack, but the default
for the connection timeout is 30 minutes. There is a sqlnet parameter where you
can modify the timeout to make it shorter (sqlnet.expire_time?) Check metalink
note 151972.1 for more info.
HTH
Mike
I think that the table is synonym created in your schema on some other table
on other schema. You don't have rights on this table except select rights.
This is my opinion. Please check again..
Regards
Munish Bajaj
-Original Message-
Sent: Thursday, July 24, 2003 19:34
To: Multiple
Hi!
About the second one, you see the first read started from 6041 and was 18
blocks, the second one which was executed 7 minutes later, started from 6042
and was 17 blocks. Probably the extent boundary is at block 6059. Multiblock
reads don't cross extent boundaries.
So, probably your query
Jack,
This is a post from a few weeks ago that gives a setup
TNSNAMES:
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = extproc_agent) --- Key1
)
(CONNECT_DATA = (SID = 11) --- Key2
(server=dedicated))
)
Listener:
You can have a single disk array shared by two computers. Each box has its
own OS file system(s) which can be on the disk array or on private drives
not in the disk array; but all the Oracle stuff is shared on a single set of
file systems mounted only by one box at a time. If the primary
- Original Message -
what do you mean by 'arc'?
have a look:
http://www.docm.mmu.ac.uk/online/SAD/T07/erd2.htm
much better explanation than I can give here.
Cheers
Nuno Souto
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuno Souto
Title: RE: Update through a DBLink
No ..
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
Hi!
This sqlnet.expire_time affects server, not sqlplus itself AFAIK. The issue
is likely, that sqlplus has sent a sqlnet request to server, but hasn't got
any response since you pulled the network cable. Thus it'll wait until TCP
connection gets timeout.
Also, sqlplus is different from normal
Title: RE: backwards export
I'm not sure of the export compatibility, but you should know that 9i
clients won't talk to a 7.3.4 database,
True
and 7.3.4 clients won't talk to a
9.2 database,
False
A Oracle7 client can, will, and does talk to a 9.2.0 database
with no
My interpretation would be as follows:
The wait entries are written whenever a wait ends, so at 15:40:59.149 the
session has just been waiting .00 seconds for a scattered read of 18
blocks. At 15:46:06.340 it just had been waiting on a latch free event. For
the almost seven minutes between, it
I'm having no luck resolving the following PL/SQL
errorsfor afinal examclass project.We do not have access
to metalinknor do we have access to Oracle PL/SQL documentation. We are
being taught from a PL/SQL text book that does not provide ora error message
information or where to
If the remote table uses object types, you will have trouble
updating it from your local procedure.
Richard
-Original Message-
Sent: Thursday, July 24, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
One of or developers is work on a routine that will trigger a procedure
that
Title: bad press for oracle
http://rss.com.com/2110-1017_3-5053453.html?type=pt=rss=feed=news
There is or at least was a
problem if you had a autonomous transaction across a dblink with a
commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM
One of or developers is work on a routine that will trigger a
procedurethat will use a dblink to update a table on another database.
It seemslike I
Title: Message
quantity is neither a column name or a valid column alias. That's
what your error is telling you.
Allan
-Original Message-From: Milton C.
Craighead, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday,
July 24, 2003 11:39 AMTo: Multiple recipients of list
Milton, do yourself a favor and sign up for OTN(http://otn.oracle.com)
you got access to full oracle docs online.
joe
Milton C. Craighead, Jr. wrote:
I'm having no luck resolving the following PL/SQL errors for a final
exam class project. We do not have access to metalink nor do we have
Title: Computing resource consumption
Does anyone know any papers or techniques to compute resource consumption by users in a DB systems? This may or may not be for computing charge-back to the client, but my questions are
1. What do you compute?
2. are there any standard methods and or
For the error: SP2-0158: unknown COLUMN option "line", "column total line" must be one word.. no spaces allowed. Can be total_line or just total.
Shamita
Shamita "Nelson, Allan" [EMAIL PROTECTED] wrote:
quantity is neither a column name or a valid column alias. That's what your error is
and 7.3.4 clients won't talk to a
9.2 database,
False
This is sort-a false. If the 9.2 database is in a new characterset such as UTF8, the
old sqlnet
clients will have difficulties if the client machine is also not in UTF8.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new
Dan,
I see what you are saying but something doesn't feel right (see, say, feel.
Should be some pun in here about not making sense). CPU time of 7 minutes
after a single read??? This is an ugly INSERT on a 5 table join, but that's
about it. Unfortunately I don't think there is a way to
Hi guys, I'm looking for some orientation about
Quality Assurance for Oracle and databases, anyone has
experience with this? This issue about QA is
completely new to me, I know the OFA document and how
to aplly it, but don't know what else to do, maybe
something about QA for SQL statements?
Fair enough then. Good luck with it.
-Original Message-
Sent: Thursday, July 24, 2003 1:54 AM
To: Multiple recipients of list ORACLE-L
Thanks for the suggestion, Mike. I had hoped that the smiley had indicated
that this was put forward in a (supposedly) humorous way. I had the
Would you ever want to use multiple data files for the system tablespace?
Title: Computing resource consumption
Does anyone know any papers or techniques to compute resource consumption by users in a DB systems? This may or may not be for computing charge-back to the client, but my questions
I agree sqlnet.expire_time does only effect the server, but normally when the
server kills the connection the client side will drop. But in this case it
won't because there is no network for the client to get the dead connection
timeout from the server. It sounds like Hemant is running OPS
Hi everyone,
I have a development, test and production databases (They are on HP-UX 11.0
with Oracle 8.1.7.4). The development and test databases are setup for Multi
Threaded Server (MTS) and production is not (We are still considering
whether or not to put it on production, another story). But
Title: bad press for oracle
Lets
see, if memory is serving, Dial is signing an IT outsourcing deal with
EDS. EDS Oracle are NOT friends. EDS IBM are.
Oracle apps do not run on DB2, SAP does. SAP EDS are friends.
Do we see a connection there??
Dick GouletSenior Oracle DBAOracle
Hi,
We're using Silverrun data modeling tool (RDM).
I know that the Enterprise version has a central repository that allow to
share the data models and other component.
I'm used to Oracle Designer and Sybase PowerDesiger and liked those
products.
To the user of Silverrun Enterprise version,
Don't really know. I'll pass this on to the developer and the main DBA on
that box. Thanks!
Jay Miller
Sr. Oracle DBA
x68355
-Original Message-
Sent: Wednesday, July 23, 2003 6:39 PM
To: Multiple recipients of list ORACLE-L
Jay - In Java parlance, bind variables == PreparedStatement.
Title: bad press for oracle
Microsoft is buying IBM?
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 24, 2003 2:29
PMTo: Multiple recipients of list ORACLE-LSubject:
Jonathon,
I've got a query for you that uses all 3 set operators at once!
I wrote it to compare two different versions of our 3rd Party Student
Information System (SASI) in two different databases. We were getting
ready to upgrade Production, having already upgraded a Test instance. The
query
Henry,
I completely agree, something did not feel right (hence my obvious
reluctance). I did a very poor job of trying to explain that we cannot extrapolate
system waits/activity by looking at database waits/activity. I should have learned my
lesson (bad dba...go sit in the corner) from
Hi Gabriel,
for the database or applications as well?,
a suggestion - you could do worse than follow Steven Feuersteins
standards for PL/SQL - see the many books he has written on PL/SQL for
O'Reilly.
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site:
Title: bad press for oracle
What
the heck, why not. Then Mr Gates can figure out what to do about
SCO. Of cource, buy them as well!!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]Sent: Thursday, July
Title: bad press for oracle
Hasnt he already settled once with
SCO? I read somewhere about SCO buying the license rights to some obscure
version of DOS and then suing Microsoft. There was some kind of settlement
made.
--Walt Weaver
Bozeman, Montana
-Original Message-
Dan,
No reason to stay in the corner (unless that's where the fridge is). I'm
trying to decide where to look on the OS. When I looked at vmstat, there was
no paging, and ~20% idle cpu. Maybe set up a cron to take snapshots of
something(??) every few minutes? Support from the Sys Admin side
Hey all,
We recently had a problem with a 3rd-party app getting ORA-1000 max open
cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in
the init.ora -- should be more than generous for a tiny app on a tiny DB --
we started looking into how many cursors the app actually has
20% idle = 80% busy? How many cpus?
If it is 20% idle that should lay to rest the theory that the process may
wait for a cpu. But, if it is a 5-way join, maybe it is reading a set of
blocks from file 65 and then collects the corresponding rows from the other
4 tables, which must be all pure
Ryan - The only time I did was when I needed to expand the SYSTEM tablespace
because it was too small. Normally you can just expand the datafile. For
some reason I couldn't do that, it was awhile ago, probably the Oracle
version. Creating another data file went just fine.
The more important
Wolfgang,
There are 4 cpu's, and file# 65 block# 6041 is from the driving table of
the 5 table join (all NL joins). I will take a look at v$bh to see what
blocks from the other tables are in memory next time I run this. Aside from
this indirect approach, any other suggestions on confirming
Gabriel
QA is a really broad subject. How this applies to Oracle will vary a lot,
depending on how your site implements QA. For some sites, this means test,
staging, and production databases. Other sites would be happy if they just
had a test system. If you don't have any more to go on, you
It's been about a decade that I have been working with AIX. There must be
tools that give you a breakdown by cpu. Else you can do a ps -ef or ps aux
and watch your process. If I'mm right you should see it consuming 99% cpu
all the time.
I have been looking after Peoplesoft systems for several
Hi!
How does the list server here operate?
I sent a reply to one message several hours ago (see below), but it never
reached my mailbox again. Also, sometimes I get the reply first to my
mailbox than the original post (I mean several minutes before, it couldn't
be a SMTP latency issue).
Is this
Sorry I was still setting it all up, the datafiles will be numbered 1
thru 5 :-)
I was more concerned if I should add the bitmap header overhead to each
datafile or just the first one.
-Original Message-
Sent: Thursday, 24 July 2003 11:59 PM
To: Multiple recipients of list ORACLE-L
I
Biddell, Ian would like to recall the message, Datafile sizing.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Biddell, Ian
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
Sorry I was still setting it all up, the datafiles will be numbered 1
thru 5 :-)
I was more concerned if I should add the bitmap header overhead to each
datafile or just the first one.
-Original Message-
Sent: Thursday, 24 July 2003 11:49 PM
To: Multiple recipients of list ORACLE-L
Biddell, Ian would like to recall the message, Datafile sizing.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Biddell, Ian
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
Recall request denied. Resubmit in 30 days for further disapproval.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 7/24/2003 5:29 PM
Biddell, Ian would like to recall the message, Datafile sizing.
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
If you have a 10046 trace file, and the means to process/analyze it, then it
will tell you what you need to know. If it's IO, you will see IO related
waits. If they are not there, and no other significant wait events, then
it's all processing time, which probably equaits to LIO's. Thats my take.
Jonathan,
I can't think of any specific examples but the four operators all have
their place:
UNION - A quick way to merge result sets. If, for example, you have actual
financial data in one table and budget financial data in another table and
need to spool all data to a file then UNION is an
If you have a 10046 trace file, and the means to process/analyze it
For processing and analyzing a 10046 trace file I think nothing compares to
the Hotsos Profiler. It's very reasonably priced, too.
Gudmundur
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
10046 Trace files are a peak into how an application and Oracle operate. In looking at
one generated by a web server, I identified that the application (user) was sorting to
a temporary tablespace that was dictionary/permanent without at the data dictionary. I
saw a query performing DML against
Hello,
Yes , you sure need to delete the old archive files becuase if you don't, it will eat up your space. I keep my arch files for 1 week. the arch files oder than that, I just have a job to delete it. But besure to backup it first
UK
Farnsworth, Dave [EMAIL PROTECTED]
Sent by: [EMAIL
If the sort requires disk you'll the direct write/reads in the trace. They
do not count towards LIO and PIO as they are not using the buffer pool.
At 03:49 PM 7/24/2003 -0800, you wrote:
Another significant area of processing can be sorting. I don't know if
sort processing is counted along
hi, friends:
I have a rac running linux as2.1/kernel 2.4.9-e25/oracle 9.2.0.3(with
some intermit patches). The server switched from old rac server/storage to
current server/storage on July 16.
But on July 24, there is some new oracm process running, too many oracm
process than I have ever
1 - 100 of 117 matches
Mail list logo