Gogala,
If cardinality is high, then data is evenly distributed.
If cardinality is low, then data is not evenly distributed and
hence skewed.
Is my understanding correct...atleast to some extent ?!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: orababy
INET: [
Hi List,
Could you please help me out to resolve this issue?
Basically i have created one stored procedure(show_space) in
SYSTEM schema, then granted execute rights to PUBLIC and created
public synonym.
When i conenct as diff user(MUT) I am not able to execute the
procedure. Any help would be rea
Hi Hrishy
Just try with /*+INDEX (ICWOIMP,PK_ICWOIMP) */
^^ ^^
No space Comma
I am not sure.
hrishy writes:
> Hi
>
>
>
> Oracle 8.1.7.0.0 on HP-UX 11.0
>
> We have following query .
> /
> SELECT
> A.CANNO "INVOICE NO",
> A.CANDATE "INV
Gogala,
so , if there is an index on a column like SEX , then it means
data ( in that index ) is skewed. am i right ?
for an index , if cardinality is low OR clustering_factor is high
--> it means data is skewed.
sorry if i sound stupid :-|
Is "SKEW" used with respect to index or table or bot
Hi
Oracle 8.1.7.0.0 on HP-UX 11.0
We have following query .
/
SELECT
A.CANNO "INVOICE NO",
A.CANDATE "INVOICE DATE",
--B.NAME "CUSTOMER NAME",
A.CANAMT "REVENUE AMOUNT",
C.RCPTDOCNO "RECEIPT NO.",
D.RECEIPTAMOUNT"RECEIPT AMOUNT",
C.RCPTDATE "RECEIPT DATE"
FROM
ICWOIMP
Hi, All,
Is there any data dictionary in Oracle to check out creation statements of
materialized view? Something like the user_source view about object
creation. I have checked user_mviews, user_mview_joins, etc, but I haven't
got one.
TIA
Chuan
Important: This transmission is intended only for
Well, there have been situations when CBO made me use obscene language
by stubbornly refusing to use and index which was utilized when RBO
was used. I believe that the vast majority of old and balding DBA geezers
like me can make the same claims. Thus the name.
On 2003.07.25 02:04, Guido Konsolke w
Hi Mladen,
nice one. Never heard that.
Still lol,
Guido
>>> [EMAIL PROTECTED] 25.07.2003 07.54 Uhr >>>
(snipped)
chapter about indexes, statistics and the Curses Based Optimizer, am I right)
(snipped even more)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guido
Hi Tanel,
you took the words right out of my mouth (anyone recognizing
the song?). The same at my place. I tend to think it's a kind
of mystery. Answers whithout questions, answers don't appear
to be send... But I'm too tired to think about it.
As I'm writing this, it's 7 AM here in Germany. Big
There is also usual practice by some companies to charge by the CPU. Charge
the customer $100 per user per CPU or $10,000 per CPU for unlimited number
of users. That will bring the prices to the same level charged by some very
successful software companies. You are bound to stay competitive.
On 2
It's actually a substitute for another word which is not to be repeated on
this list because of the presence of the ladies, much like "heck", "darn" or
"frigging". It means that the data in the index (you found that word in the
chapter about indexes, statistics and the Curses Based Optimizer, am
row row row your boat..row level that is
BTW - If you were wondering more about how I tested. I had about 10,000
rows in table_a, and ran the statement "insert into table_b as select *
from table_a". I did it without, and with one or more triggers on table_b.
Maybe triggers are faster in v9
List,
Came across "~data is skewed~" while reading the docs.
what does it actually mean ?
can someone explain this for a novice dba like me.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: orababy
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
Title: Computing resource consumption
Raj,
A pretty common (and actually pretty
accurate) chargeback unit is the LIO. You can get this information by using the
standard AUDIT CONNECT feature, and using the LREAD value as your basis. If you
wanted to get fancy, you might also charge by
I absolutely agree with Wolfgang. This pattern of behavior in the trace file
is common for applications that do an excessive amount of LIO processing.
(LIO = "logical I/O," or a fetch of a buffer's content from the database
buffer cache.)
Henry, you don't show the database call whose line was even
Jonathan,
I've used MINUS heavily in sql scripts and pl/sql
to determine the differences in schemas: both
structure and data.
Of interest to DBA's and developers, and least when I
did it it was for the developers.
Jared
On Thu, 24 Jul 2003, Jonathan Gennick wrote:
> I'm doing research for a
Brian,
Were those row level or statement level triggers?
Jared
On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote:
>
> I did some trigger timings about a year ago on v8.1.7.4. I did the testing
> using a trigger with only 1 statement in it, and that statements was
> "null;". I found that my transa
Thanx Breitling.
Leave the index un-analyzed if it works for you
as u said,index IDX_PROFILE_SHINKI is not analyzed now.
that works fine.
but there are seperate indexes on column PREF, FLAG and SEX.
when those indexes are used ,cost=999.
whereas when IDX_PROFILE_SHINKI ( a composite index on EN
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 s
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 with
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:
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
> 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: Gudmundu
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 e
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.
L
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
-
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
You'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
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 tri
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 li
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 y
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 coul
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
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 is
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 lo
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 o
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
Title: bad press for oracle
Hasn’t 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--
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
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: http://www.petefi
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
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
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:
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.
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, what
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 DBAOrac
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 du
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 wh
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
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 great
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?
Commen
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 meas
>> 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
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 i
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 stan
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
acces
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
ORA
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 seemsl
Title: bad press for oracle
http://rss.com.com/2110-1017_3-5053453.html?type=pt&part=rss&tag=feed&subj=news
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 wil
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 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 find th
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
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 n
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 tel
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 !
- 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 Sout
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 compute
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:
E
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 acqu
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 r
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
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 th
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 ti
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) connecti
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 ru
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 clus
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
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 off
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 a
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 recipient
(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
*** 2003-07-2
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 In
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 drop
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
(Tr
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 th
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
for
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 Su
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
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 di
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
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
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
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 to
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:
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 art
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 express
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
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 exec
- 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 c
1 - 100 of 119 matches
Mail list logo