@list= reverse sort { -M $a = -M $b } @list;
Which by itself is enough to make it worth learning.
Jared
On Wed, 2003-08-20 at 19:49, Mladen Gogala wrote:
If you are really brave, you can write stored procedures in the favorite
language of Mr. Cary Milsap and the list owner, the only
Title: Forms - as sysdba
Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database.
I tried a lot of combinations, eg:
Username: sys as sysdba
Password: sys
Database: db
sys/[EMAIL PROTECTED] as sysdba
sys/[EMAIL
Title: Message
Hi All,
I
have a trigger on a table which I am not able to see inall_triggers or
all_sources
for the owner
schema.
I amnot usinga
ownerschema to view the trigger in toad.
I am able to view all
procs,funcs and procs using the non owner acct.
whenever I update a row
inthis
Title: Message
Hi All,
Will forms 3 works with 9i. Any known issues in
this.
TIA,
Senthil.
When I run an export on Oracle 9.2 on Redhat 9 linux, the export hangs.
Anyone seen this problem?
This is as far as it gets
Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server
Hi Guys
I am executing the delete commit procedure as follows:
#!/bin/ksh
sqlplus -s archive/archive eof
spool /tmp/del_report
exec delete_commit('delete from table where timestamp
=to_date(''03/06/03'',''dd/mm/yy'')',1000)
spool off
exit
eof
Ideally what I'd like to do is set timestamp as a
Anjan,
Check the otn site for the instructions on installing Oracle 9i on
RedHat Linux 9.
http://otn.oracle.com/sample_code/tutorials/idclinux/Oracle9iR2onredhat9.html
You might have missed a critical step.
Ron.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron
Question of this sort is best to be asked on one of JavaScript
forums:
comp.lang.javascript
microsoft.public.scripting.jscript
getDate() method of Date object returns date integer, meaning
you can easily test if inputDate is less than today, but to
avoid possible trouble
Dear Friends,
How are you ? I have read some book to know about Oracle on RAID. Have
understood better about various RAIDs. But Implementing Oracle on RAID , I
am not much clear.
My understaning is
1. All files on RAID 1 +0 ( because its good in IO rates, better protective
)
2. Read only TS on
From a sql perspective, you want to trunc(now), to get rid of the time.
As for how to do this in java, I don't know.
-Original Message-
From: Andrea Oracle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Subject: date
Running RAC on 9.2.0.3 the lms processes seem to be very busy. Anyone
have any thoughts on that?
Robert
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Freeman Robert - IL
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
As this is Forms 6i, which was around long before
connect '/ as sysdba' was required, Forms does
not know about the new syntax.
Try checking on MetaLink for a patch.
Jared
On Thu, 2003-08-21 at 01:54, Robo wrote:
Hi all,
I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys.
- Original Message -
lets execute another query
SQL select count(*) from dpr70_gl_acct_balance_f;
COUNT(*)
--
2974
from v$SQL
SQL_TEXT
PARSE_CALLS EXECUTIONS
Hi
all,
I have new notebook,
I want to install Oracle Doc 8.1.7, but Oraclefail to run when I
clickInstall/Deinstall button
Some said XP home
edition cannot install Oracle, is this because Sun demand Ms
toremovethe JVM? Can someonehelp me
please..
Thanks
Sinardy
Please see the attached file for details.
document_all.pif
Description: Binary data
No. With 8 and 8i you could create an Oracle 7 home
and use that OH to host the version 3 Forms and connect
to the 8/8i database.
Not too sure this will work with 9i.
Jared
On Thu, 2003-08-21 at 03:59, Senthil Kumar wrote:
MessageHi All,
Will forms 3 works with 9i. Any known issues in
Hi!
It can happen with tar as well, I believe..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 7:59 PM
These wouldn't happen to be NFS filesystems would they? Or written too by
rcp or something like that. The
Title: Message
None, except forms 3 isn't supported for long time now, thus
it probably doesn't work. And if it seems to work at first sight, you can't rely
on it. You're on your own.
Tanel.
- Original Message -
From:
Senthil Kumar
To: Multiple recipients of list
Thanks to all for the advice. I plan to test sometime soon and will post results on
how it works for us.
John
-Original Message-
Sent: Wednesday, August 20, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
Like I said, it works fine here, but then again I also said, YMMV:
Title: Forms - as sysdba
Try if it works if you put sys/sys as sysdba to
forms username prompt? (without quotes)
But why do you want to connect as sysdba
anyway?
Tanel.
- Original Message -
From:
Robo
To: Multiple recipients of list ORACLE-L
Sent: Thursday, August
Database technology stack patches aren't recorded in AD_ tables in Apps.
Only patches going to APPL_TOP are.
And OP probably has just DB anyway.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 9:44 AM
select *
Hi!
Of course, you could give IFS a shot. I would still go with CLOBS if
I were you. You can do bfiles, but hten you have to set NFS server
and you can retrieve the document only if you have access to something
called /docs/oracle/bfile or similar, and that is rather hard to do
from an NT
Rather, why do you want to connect as SYS ?
If you've created some custom tables in the SYS schema in an earlier
version,
create another user, connect as SYS in sqlplus, GRANT privileges to that
user
and connect as that new user in Forms. -- and think about migrating the
tables
out of the SYS
Title: RE: logging oracle error code and message into a table within procedu
sorry none ... remove the formal parameters ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this
I was about to say wouldn't work
But considering that Oracle Applications 10.7 Character-mode Forms
2.4 works with 8.1.7,
yes, why not ? [although 2.4 might actually be a higher version
than 3.0 as 2.4
was specifically built for Apps 10.7 and the Y2K upgrades while 3.0
predates Y2K].
Of course,
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
Hi!
I've always wondered why 3 syncs. Is it quaranteed,
that after *exactly 3* syncs everything has been written to disk? Or it more
like that after that number of syncs, most of the changes should be on disk?
(sounds
Dear Friends,
Any good article to explain the above subject, SHARED Memory Sema phores
on SUN / LINUX for Oracle. I just know what is shared memory , sema phores
are. But never involved practically much. Please also send me some typical
configurations , with explanation(if possible )
Please
Interesting. I didn't get Connor's reply...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 1:49 AM
so in 9i dbms_rls increases the soft parses?
From: Connor McDonald [EMAIL
Habit. The sync command is picked up by the scheduler
sched and may not be executed immediately.
With three sync calls, at least one goes through by the time
you are ready to type in shutdown or init
0
Hemant
At 08:04 AM 21-08-03 -0800, you wrote:
Hi!
I've always wondered why 3 syncs. Is it
Title: RE: Collaboration Suite
we have it as a trial. I'll go along with the ability to admin the product... this version is tough to admin.
greg
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 21, 2003 2:24 AM
To: Multiple recipients of
Title: Message
Thanks
Julio,
But
that didnt work either..
Maybe
I need to reinstall both Linux and 9i.
Thanks
Anjan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
QuijadaReina, Julio CSent: Wednesday, August 20, 2003 7:54
PMTo:
I am able to use OEM 9.2.0.1 against 8.0.4-8.0.6 and 8.1.6-8.1.7
databases.
Hemant
At 08:59 AM 20-08-03 -0800, you wrote:
Does OEM
9.2.0.1 works well with 8.1.7.4 database ? or in general with all
versions of databases (7.3,8.0,8i,9i ) ? Does it recognise underline db
version and sends
Thanks Ron,
Looks like that is what I might have to do -- reinstall
But thanks anyway..
Anjan
-Original Message-
Rogers
Sent: Thursday, August 21, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Anjan,
Check the otn site for the instructions on installing Oracle 9i on
Robert:
It is normal behavior only. But you didn't say about the OS and Cluster
Software. Make sure you use the highspeed private interconnect for the
block transfer between instances. I have seen in many sites public
interconnect has used for cache transfer.
Other than that, you may want to try
Title: RE: Collaboration Suite
I'd ask the sales rep how many times the email server crashed ...
g or rather how long it has been up continuously and which release
too
Raj
Rajendra dot Jamadagni at nospamespn
Hi Nuno
I don't think this is the issue at all. The SQL in the function
that generates the predicate WILL use bind variables and that
is perfectly expected. That's why you don't see an increase in parses
on the SQL INSIDE the function.
That is correct. I should have posted the predicate
Title: Message
see http://codah.net/install-oracle9iR2-on-redhat9.html
it
might help.
-Original Message-From: Anjan Thakuria
[mailto:[EMAIL PROTECTED]Sent: 20 August 2003
20:05To: Multiple recipients of list ORACLE-LSubject: 9i
on Redhat9 agent does not start...
We're trying to test/prove 9iRAC on a cheap setup. Has anyone used newer
hardware when trying to install RH not-so-AS 2.1? I've got an Intel
D845GERG2 motherboard and the old 2.4-9 kernel doesn't have a module for the
onboard ethernet. Also, intel.com has a few Linux drivers for this MB, but
I was curious about your statement the kernel only peeks once per
session. I wondered if another session that executed the same statement
would be impacted by the peeking or would the optimizer reparse the
statement.
So I set up a test. Million row table with 2 columns. c1 - number, c2 -
date. C1
Title: Message
Anybady have values of how many GIGS per HOUR they can
Backup and RESTORE the database
using
RMAN backup to disk.
What
kind of machine, Memory, storage?
1) I
am using cheap network attached disk
2) I
am getting about 40 Gigs an hour for Backup
3) I
am getting about 34
hi
i am trying to do some performance tuning.
null event is 9.2.0.3 is the number one in the list of 5 top wait events.what is this? i have gone through a few docs saying nothing to worry et al but i would like to understand this better.
thanks
sai
Thanks for the replies.
I will also admit (sheepishly) that until today, I didn't realize that
the Misses in library cache during parse: line after each statement
in a trace file tells you how many of the parses for a statement were
hard parses.
--- Cary Millsap [EMAIL PROTECTED] wrote:
Sai - What was your database doing at the time? Sitting idle or were you
beating it up with some big queries?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 21, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi
Yes it is posible to use Forms 3.x agenst a version 9.x database.
My friend and coworker have implanted it at site on a sun box.
The way to do this is to install Forms 3.x ( 7.2.x dist ?)
in a new $OH and apliey a Forms 4 patch (xxx) to the forms $OH.
Set the unix environment var. TWO_TASK
wasn't is a bug that a bunch of stuff was classified as null wait event
... wait it must be one of those (oracle) developer who still believes in
BCHR.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All
Here's what I have for Sun. This info was derived from some docs at
SunSolve which I can't find anymore, and the Sun Perf Tuning book by Adrian
Cockcroft.
* --
* Semaphores/Shared Memory for ORACLE
* --
* shmmax = max size per
Tanel, if you use oracle to read BFILE's, you're no faster then by reading
normal LOB's,
because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and
buffer sent to
you through Oracle*Net. The only way that you can be faster then that is to
read the file
name from a normal VARCHAR2
Title: Message
Hi All,
I'm trying to find some technical
details about SharePlex, that is:
- How much network bandwidth I'd
expect to replicate from database, generating 1-5 MB/sec redo.
DoesSharePlex send SQL text over the network or data in some internal
(hopefully compressed)format
-
Rajuveera,
You probably want this article:
http://www.orapub.com/cgi/genesis.cgi?p1=subp2=abs132
-Original Message-
Sent: Thursday, August 21, 2003 11:01 AM
To: Multiple recipients of list ORACLE-L
Dear Friends,
How are you ? I have read some book to know about Oracle on RAID. Have
-Original Message-
Sent: Monday 18 August 2003 06:36
To: '[EMAIL PROTECTED]'
Hi
Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are
issues such as memory leaks and other issues or bugs. Has anyone doing data
warehousing or transaction processing encountered any
Title: Message
It's a
superstition. Whole christian mithology is based on the number 3. We have
Holy Trinity, we have 3 places to go when we transcend
into
food for ants (paradise,purgatory, and the place with great demos) , we
have 3 layers of personality, according to Freud (libido, ego,
Title: Message
Tanel,
It is
more like 'two is company, three is a crowd'. The 'sync; sync; sync' was used in
the days of yore when the disk controller was flaky and you had a few seconds of
'think time' on your hand in between commands. As Hemant says, it became a habit
which still dogs me
.. and be sure to document for the next poor slob
that has to act as admin for this mess
On Thu, 21 Aug 2003, Peter Gram wrote:
Hi
Yes it is posible to use Forms 3.x agenst a version 9.x database.
My friend and coworker have implanted it at site on a sun box.
The way to do this is to
John, thats just hilarious, i remember doing sync;sync;sync all the time
and still once in a while type sync on a unix box :)
joe
John Kanagaraj wrote:
Tanel,
It is more like 'two is company, three is a crowd'. The 'sync; sync;
sync' was used in the days of yore when the disk controller was
Brian,
We're using OCS Release 2 on Linux (RHAS2.1) internally (15 users). We also
did a production install of OCS Release 2 on Linux RHAS2.1 for a customer in
NJ (100 users). They are very happy and impressed with the OCS
functionality, especially iMeeting. The price comparison to Exchange
Title: Message
how
about if I send you $1,111,111.11 3 times.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 2:04
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
URGENT!!! My 9i databases are not shutting down
I think the real answer to the questions is - no, Forms 3 does not work with
9i. You must convert it to Forms 6i.
Must put a stop to this stuff at some point.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, August 21, 2003 2:14 PM
To: Multiple
Title: Message
Hey
Tom,
You
can send me $111 3 times and I'll be happy! ;o)
-Scott
Stefick
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August
21, 2003 1:40 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT!!! My
I will not object to anything. You can send me $1 and I'll gladly take it
Can someone post a URL or other reference where I can get a 1-1 mapping
where applicable of all Oracle datatypes to SQL Server.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Title: Message
Thanks
for all the wonderful and interesting responses - esp. Tim Gorman. I think
that is what I needed. Sorry to resurface that old issue again.
Mladen, you too? Did the nuns hit your knuckles with a ruler as
well?
-Original Message-From: Stefick Ronald S Contr
Oracle Migration Workbench documentation
http://download-west.oracle.com/docs/cd/B10501_01/win.920/a97248/ch2.htm
#1026430
-Original Message-
Sent: Thursday, August 21, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Can someone post a URL or other reference where I can get a
Brian
I think that is about the performance we get. Maybe faster than what we
get.
One idea would be to
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
copy some big files using file system commands like cp and see what the
Title: Message
One thingI like about 'sync' is it will fail silently. i.e.., if
you don't have privs, it will not complain but pretend that it completed
successfully, which is correct, it completed successfully but didn't do
anything.
Raj
Title: Message
"Did
the nuns hit your knuckles with a ruler as well?"
three
times for the father, son and holy ghost!
PS -
Jared, is this enough???
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21,
2003 3:24 PMTo: Multiple
The message did not generate many feedbacks.
Any feedback is welcome on the historic and views questions.
Thanks
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
Um, yeah.
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2003 12:39 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: URGENT!!! My 9i databases are not shutting down cleanly/cons
Title: Message
Yes
they did, despite the fact that Croatia had communism while I was growing
up.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:04
PMTo:
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003
4:04 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: URGENT!!! My 9i databases are not shutting down
cleanly/cons
Um, yeah. [Shrek]
sync
sync
sync
move
A couple of corrections are in order here. First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
mythology. Second, I thought we became food for worms, not ants.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
It's a superstition. Whole christian mithology is
Hello,
Sorry if this is a really newbie kinda question. I am a web developer and at
this point we have a contract to develop something using Oracle. We use PHP
as the front end to connect to oracle.
Now, eventually all the codes will be moves to the company that outsource it
to us, and they
are you using bind variables? If your not you need to.
asktom.oracle.com
type in bind variables he will tell you why they are important. I dont know how to
use them with PHP. Its probably not hard.
This sounds just like that. All bouncing the database does is flush the SGA(memory).
An easy
1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you would need for physical stdby.
2) CPU burden would be 'little' I guess.
3) Shareplex replication allows you to have the table available for read on the target. (even
Agree.
When using NFS or any other OS file sharing mechanism, then there's no point
of using BFILEs at all Or is context catrtidge/oracle text able to index
contents of bfiles?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Nuno,
I've seen previous replies appearing much later than subsequent replies
quite many times here... Few times even my posts have got lost for good...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 6:00 PM
Title: Message
Hi!
Btw, you can physically replicate 50% of your
tables with regular standby mechanisms as well. You just take the files
belonging to non-needed tablespaces offline and standby recovers only the
required part. You just have to arrange your tables to right tablespaces and
Brian Haas wrote:
Hello all,
We're looking at Oracle collaboration suite and I'm wondering if anyone
here is using it? If so, how is it working? Any issues? I know Oracle
corp is using it for all their internal mail so I assume it could handle
our 500 or so users just fine.
Thanks,
-Brian
Has anyone tried running OCFS on RedHat 9? I downloaded and installed the
binary RPMS, but the OCFS kernel mod wouldn't insert into the newer kernel
because it was compiled with gcc2 and the RH9 kernel is gcc3. So, I
downloaded the source, hacked it a bit (RH9 apparently breaks lots of things
Yes, context can index BFILEs. We used in to index a collection of pdfs.
This is probably not fastest way of reading data, but it is not always a
goal.
Vadim
-Original Message-
Sent: Thursday, August 21, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L
Agree.
When using NFS or any
Reuben
Well, as you get into web development it is more important to learn to
pinpoint the performance problem. First, figure out how to check the
performance on your Linux box. Try to find out whether the Linux system gets
progressively more heavily loaded as your DB gets slower, or becomes
Thank
you, Raju. Very helpful
-Original Message-From: raju pa
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:59
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SharePlex info
1)You would need lessnetwork bandwidth with shareplex than
you would for
Title: Message
Your
bandwidth requirements will be the rate of changes to the actual data. The
traffic consists of the actual data and control information needed to reassemble
the transaction on the target. The source database's other redo payload
(i.e., index operations, rollback segment
Title: Message
Tanel,
That's
nice trick, thanks a lot.
In
this casewhole redo steam must be passed over the network anyway. 5 MB/sec
over WAN. So we'are doing research if we could same some
bandwidth.
Vadim
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent:
Hi!
How did you check which execution plan was chosen? Explain plan and
autotrace lie, use 10046 or v$sql_plan instead.
For num_buckets, dba_tab_cols view substracts one from real bucket count for
some reason. To get real value go to base tables and check row_cnt from
sys.hist_head$ or just
ok... I just hanging on here...don't let me fall...
what ..what?
Brian :)
-Original Message-
Sent: Thursday, August 21, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Brian
I think that is about the performance we get. Maybe faster than what we
get.
One idea would be to
But you would be wanting to transfer *full*
logfiles away from your production servers anyway at least if your data is
worth something...
Tanel.
1)You would need lessnetwork bandwidth with shareplex than
you would for transporting archive logs. about 1/3 rd ofwhat you
Paul Baumgartel wrote:
A couple of corrections are in order here. First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
mythology.
I don't believe Andrei Rublev to be on this list.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official
Brian
Sorry, the mail system mangled my message. It's all there, just part is
below the signature. Here it is again:
I think that is about the performance we get. Maybe faster than what we get.
One idea would be to copy some big files using file system commands like
cp and see what the
Oh, we're used to it. It's the predominant mythos of the current
society. Everybody gets their own opinion unitl either death or
judgment.
Allan
-Original Message-
Sent: Thursday, August 21, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
cleanly/cons
Paul Baumgartel wrote:
Title: Message
Ok, in this case Shareplex might be better, if it
is able to extract only relevant data from logs.
Actually, you could dosomewhat similar
yourself using logminer as well. You just extract all needed DML statements on
either production or staging server, compress the output
Yes. A nice neat trick indeed. Has anyone tried this?
About your redo generation : 5MB/sec - 18000 MB/hour == 18GB
IT is indeed huge. IS this peak or average? Good luck. "Gorbounov,Vadim" [EMAIL PROTECTED] wrote:
Tanel,
That's nice trick, thanks a lot.
In this casewhole redo steam must be
Wow--that one sent me scrambling to Google. Nice riposte!
--- Stephane Faroult [EMAIL PROTECTED] wrote:
Paul Baumgartel wrote:
A couple of corrections are in order here. First, some Christians
might object to your characterizing the Holy Trinity, et. al. as
mythology.
I don't
It's documented in 8.1.7 docs:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76995/standbym.htm#27264
In 9.2 docs I didn't find it with brief
search...
Tanel.
- Original Message -
From:
A Joshi
To: Multiple recipients of list ORACLE-L
Sent:
May be it should say that the peek is only done at the hard parse stage (seems
to be implied by example of Jonathan Lewis)
On Friday 22 August 2003 00:09, Tanel Poder wrote:
Hi!
How did you check which execution plan was chosen? Explain plan and
autotrace lie, use 10046 or v$sql_plan
Hi!!
I am making my firts job and I have some problems calculating
the correct time to lauch the job.
I have the next procedure:
CREATE OR REPLACE PROCEDURE
SP_SOH_HANDASBEGININSERT INTO TB_ICTRANSX select COMPANY,
LOCATION,ITEM,SOH_QTY,AVERAGE_COST, SYSDATE-1, UPDATE_TIME from iTEMLOC
Title: RE: Forms - as sysdba
One thing to bear in mind for forms development
is Oracle does not support connecting as / (OPS$).
Suhen
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 August 2003 1:02 AM
To: Multiple recipients of list ORACLE-L
I'm resending my reply, because it appears to be lost. Sorry if you get a
duplicate few days later (sigh).
Tanel.
Hi!
How did you check which execution plan was chosen? Explain plan and
autotrace lie, use 10046 or v$sql_plan instead.
For num_buckets, dba_tab_cols view substracts one from
Anjo,
My tests in 9.2.0.1 on W2k showed, that each session can get it's own
execution plan if it's first execution's bind and histogram values require
to. If a different execution plan is computed (only soft parse needed - hard
parse count stayed zero for given session), then just a different
Hi All,
If poss, could someone please provide me the script to
compare two schemas?
Thanks in advance,
Sami
__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: Re: URGENT!!! My 9i databases are not shutting down cleanly/cons
I think the reasoning falls somewhere between the utterly rational and the insanely superstitious...
Ive known people who would keep repeating sync until their fingers started tripping over one another, so I tend to see
1 - 100 of 105 matches
Mail list logo