I use it for emails with attachments and running OS commands within
database;
Look at akadia.com for javamail and here it explains how it is used.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 5:03 AM
I use it for email.
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what machine the SQL statement was
fired.
thx
Sam
name--- Reardon, Bruce (CALBBAY)
[EMAIL PROTECTED] wrote:
Have a look at v$session
In particular the
Title: 9iAS - Error WTE-03503
During the installation of 9iAS on my system, with Origin DB residing on the same machine as the APP Server (as this is a trial installation, will shift to the appropriate arrangement once its all oktested), I am facing a problem in installing the Database
Helmut
We run both on the same box, but only in dev. If my memory serves me
correctly, there's a metalink note about it which recommends NOT using
64-bit oracle unless you need the increased memory addressing. We needed to
increase the size of the shared pool above what we would use in 32-bit
no application server involved.
thx
Sameer
--
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what machine the SQL statement was
fired.
thx
Sam
name--- Reardon, Bruce
Sam,
It looks like you have read Bruce's answer a little too fast. You might also like
to RTFM the SQL Reference book, section 'functions', entry SYS_CONTEXT - although if
you also want the SQL text, as Mladen said you must any way join V$SESSION and
V$SQLAREA - or V$SQLTEXT if your
Title: RE: Textfile into oracle
save
as txt first
-Original Message-From: Clinton Naude
[mailto:[EMAIL PROTECTED]]Sent: 06 June 2002 22:28To:
Multiple recipients of list ORACLE-LSubject: RE: Textfile into
oracle
Yes, use Sqlloader...
-Original Message- From:
Position: Oracle Applications Side DBA
Location: Columbus, Ohio area (Lancaster)
Industry: Manufacturing
Salary Range: Mid 70s Base Salary -depends on experience
A relocation package is available.
This company is an industry leader in its field of products.
Growing,profitable, well
Walter,
It may help to see where and why the problem occurs:
set the following event in the init.ora
60 trace name errorstack level 10
This will show where in the code oracle gets the deadlock and may help to
diagnose your problem.
Anjo.
Walter K wrote:
We have an application that is
Hi Gurus
any one have idea of any tool which can be used for migrating from forms 3
to forms 6.
Help needed in this is very much appreciated
Ayap
This communication contains information, which is confidential and may
Hi ,
I am configuring TAF on oracle 8.1.7 (solaris). I was just wondering if
anyone on the list has had experience on this and can give me any advice-
more specifically on the the method- preconnect and basic. Are there any
significant benefits of having the preconnect setting set?
Any input
If you were advertising this in a decent country,
you'd now be sued for discrimination. Unfortunately,
here you can get away with this sort of rubbish...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
DO NOT send your resume unless you have a stable work history.
Hi,
you could try migrator.
See www.logis.cz
Robert
---Original Message--
Date: Fri, 07 Jun 2002 03:13:37 -0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
From: [EMAIL
Hi,
you could try migrator.
See www.logis.cz
Robert
---Original Message--
Date: Fri, 07 Jun 2002 03:13:37 -0800
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
From: [EMAIL
Anyone who wants to know WHO this is, feel free to email me.
Also, mid 70's for oracle apps DBA, what a joke.
joe
OraStaff wrote:
Position: Oracle Applications Side DBA
Location: Columbus, Ohio area (Lancaster)
Industry: Manufacturing
Salary Range: Mid 70s Base Salary -depends on
Dear list
Can someone give me info about Oracle manufacturing and dba responsibilities
for the same. I will appreaciate the detailed feedback or any attachment to
me directely. TIA
Best Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench
Tried
it, but after 5 minutes - still there. Interestingly, is that if do
shutdown immediate, the thread is still there!!!
[EMAIL PROTECTED] 6/6/02 7:21:57 PM
Jeffrey,As an idea - does orakill let you kill the
thread off?This may let you "workaround" the issue without restarting the
Depends on what you mean by decent; quite a few silly laws have been
enacted in many countries because of someone's idea of decency. In the
US, the forms of discrimination that are legally prohibited involve race,
gender, age, sexual orientation, ethnicity/national-origin, and a couple
other
Problem is that can not reproduce on demand. Yesterday, we were doing
the wrap up for PO G patches, i.e. generate messagess, flexfields, etc.
Experienced the problem, tried redoing the same tasks and worked.
Then after bringin up concurrent manager, lots of compile flexfield
requests
Fawzia,
PRECONNECT establishes the second/failover database connection along with
the first/primary, so your client-server database connection is really
client-server1/server2. Should the first/primary connection fail, then you
failover to the second.
BASIC establishes only the first/primary
Yes.
Cool tool for diagram of db architecture.
(but I never used tools like Rational Rose)
I don't use auto generated scripts (Vim is the winner :-) etc.
But for the thing like to create schema picture is it great.
JP
On Thursday 06 June 2002 23:07, you wrote:
Anyone used CaseStudio from:
Something for the internals
folks.
Last
week we had a situation where the production system froze and we had to reboot
to
get
everything working again. Working with Oracle Support, we determained that
we had
encountered bug 2230693. The workaround was to
set the event listed above.
I've a script that until last Friday had been taking approximately 1 hour to
take an Offline disk-to-disk backup of one of our databases. Now it's
taking 2.5 hours. We've ruled our virus scanning software as a potential
culprit.
Basic Config is is a Compaq server W2K SP1 connected to a Compaq
I use it to keep me up.
:-)
On Friday 07 June 2002 04:03, you wrote:
I use it for email.
Jared
On Thursday 06 June 2002 14:07, Jesse, Rich wrote:
So, we've finally taken the jump and are using JSPs (erm...Java Stored
Procedures, not Java Server Pages) on 8.1.7.2.0.
Informal Poll:
Hi Anjo,
Tried uploading a statspack report to ORAPERF and the reply I get only goes
down to BREAK DOWN OF CPU TIME and than finishes.
Should I not be uploading level 10 statspack reportt?
Sorry for sending this through this list but figured this was the quickest
way
TIA
Jack
I have a client that is purchasing additional Oracle db product. The
company that the client has worked with for several years turns out to be a
not authorized reseller. This is the first that I have heard of not
authorized Oracle software resellers.
Are there any reasons why one would
Hi all ,
I have 2 TEMPORARY tablespaces which I want to drop and recreate with better
storage options. My worries:
1)If I connect as sysdba, what TEMP talespace will sysdba's session be using
given that a select from dba_users shows SYS SYSTEM users having TEMP as
their TEMPORARY tablespace.
Thanks to all for your answers,
I think that the NFS solution is the one.
Tks.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 1:18 PM
Metalink has a note on best practices on this.
The best method of these in my
Go to www.kumaran.com. Good people, know what their doing. We had a VERY good
experience with them when we left forms 3 behind.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 6/7/2002 3:13 AM
Hi Gurus
any one have idea of any tool
Simon,
You only use the TEMP tablespace when performing a GROUP BY or a sort.
In your case, this will not be happening to the SYS account during the drop
and recreate of the tablespace.
PS - change your drop tablespace command to:
SQLDROP tablespace TEMP
3and DATAFILES;
There are no
Hi all,
We have a bunch of TEMP tables in our 8161 databases. They are actually
permenant tables but have temporary data in them. Some of these are small
(less than a meg) to few large ones (100M or more). I truncate these tables
once a week.
Until now these used to reside with other regular
Title: RE: using a lot of temporary tablespace with large sort area size
Guys,
Have 20Gb and 16CPUS available on host. Need to do large full-table scans/joins to create materialized view. Since I have to do the full-table scans of large tables - decided to use parallel query option.
Don,
If I were you, I'd either stay out if this, or recomend that they speak with
Oracle about this.
If your client gets screwed later, you don't want to be on the blame end of
things. They could literally come after YOU for a bad recommendation.
Tom Mercadante
Oracle Certified Professional
Jan,
Did you try it's 'versioning' feature (comparing versions)? That's what
caught my attention.
I downloaded demo, and it crashes with Access violation..., when I'm
trying to create new model (NT4, SP6). Did you have similar problems?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original
Paula,
With so much data, Oralce (or Oracle, if you prefer)
might be hash joining your tables and writing temp
hash segments.
What is your hash_area_size?
jack silvey
--- [EMAIL PROTECTED] wrote:
Guys,
Have 20Gb and 16CPUS available on host. Need to do
large full-table
scans/joins to
Resellers can lose their authorization because of some irregularity, such
as failure to comply with the terms of the reseller agreement, poor
recordkeeping, accounting foulups, or even outright embezzlement or criminal
behavior. Oracle can refuse to do business with anyone it chooses, pretty
Title: RE: using a lot of temporary tablespace with large sort area size
What
about hash_area_size?
Paul x3704
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002
10:58 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
No, I didn't.
I never had a problem like Access ... used NT4 too.
JP
On Friday 07 June 2002 17:29, you wrote:
Jan,
Did you try it's 'versioning' feature (comparing versions)? That's what
caught my attention.
I downloaded demo, and it crashes with Access violation..., when I'm
trying to
Title: Newline char in oracle files
Hi everybody,
I have a very odd problem I hope someone can help me with. I've installed Oracle, OEM and OWB on a couple of NT 4.0 servers in the UK. The text files that Oracle generates during the install - the .config, .ora and the .ctl files from OWB
Bruce already mentioned using v$session.
Have you tried it? If you try it, you will find it.
Jared
On Friday 07 June 2002 00:13, sam d wrote:
We can definitely find the user ,
but considering my scenario 'all the people are logged
in with the same oracle user' ,
I want to know:From what
Interesting.
I know Bill is only passing on salary information that his clients
provide, but 70k is really lowball for someone that has this kind
of experience.
When the market picks up, people that take these positions
are going to bolt at the first chance.
Jared
On Friday 07 June 2002
I did an 8.0.4.3 to 8.1.7.2 upgrade back in January. My main nightmare with
that particular upgrade is not likely to affect you (we had a disk failure
while backing up the database prior to upgrade and the server didn't switch
to the mirrored disk until after we rebooted - ended up delaying the
I think it is not a problem of regional setting.
It's the difference between UN*X versus MS platform.
You can convert it to DOS format or use some better editor which can handle
UN*X text files.
JP
On Friday 07 June 2002 17:38, you wrote:
Hi everybody,
I have a very odd problem I hope
Title: Message
Tom,
Consider it done! Thanks for the advice. I hadn't tried
wordpad and prefer notepad, but its definitely a step up from Word which was
what I have been using.
Beth
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, June
set lines 250
set pages 30
set pause off
set feed off
clear break
clear col
col osuser format a12
col usernameformat a10
this is it!
col program format a60
col sid format 9
col sql_testformat a100
break on osuser-
on sid dupl -
Title: Newline char in oracle files
Beth,
Use
WordPad - it interprets and opens the files just fine.
Most
of newer Oracle *.sql files have the same issue - if you use WordPad, they open
fine.
This
bit of advice just cost you a virtual glassof Tetley Tea. Please
submit ASAP!
thank
you!
Title: RE: using a lot of temporary tablespace with large sort area size
I would think that this is the most efficient way to join the data. BTW, Version is 8.1.7.2 of Oracle. The hash_area_size is
hash_area_size integer 8388608
Also, never see from top session more than 4 GB memory
Title: RE: using a lot of temporary tablespace with large sort area size
Guys,
Note:
Oracle does not recommend using the HASH_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by
This query will help to see type of sortfor 8i above
select user,segtype,extents from v$sort_usage;
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 07 Jun 2002 07:38:26 -0800
Paula,
With so much data, Oralce (or Oracle, if
Jack,
It should work, please send me the file to [EMAIL PROTECTED] and I will have a
look why it fails.
Anjo.
Jack van Zanen wrote:
Hi Anjo,
Tried uploading a statspack report to ORAPERF and the reply I get only goes
down to BREAK DOWN OF CPU TIME and than finishes.
Should I not be
Columbus, Ohio is not a real big market.I'm not sure what market rates
are there but I would assume that they are not top of the line.
Cherie Machler
With in-laws that live in Columbus
Jared, i agree totally and have further info on that position/company, etc.
joe
Jared Still wrote:
Interesting.
I know Bill is only passing on salary information that his clients
provide, but 70k is really lowball for someone that has this kind
of experience.
When the market picks up,
Hi List,
What's the diffrent between unique constrint unique index, when we have to
use which, I think both are the same.
Any Idea?
And what about normal index reverse index? when we have to use normal and
when reverse index, I think Reverse index normaly using for FK index, Is it
right or not?
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppossedly fixed in 8.1.7.2 Will test with my 8.1.7.3 version.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: EXPORT BUG: oncorrect storage parameters being produced RESOLVED new bug
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppoesedly fised in 8.1.7.2
-Original Message-
From: Patricia Karla Cordeiro [EMAIL PROTECTED]@SUNGARD
Sent:
Are there any scripts
table_access_paths.sql
from www.ixora.com.au
will suggest number of freelists for a table
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Anyone used this yet? Does it run better than Oracle's RDA (haven't had a
successful run of that yet!)?
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=189489.1blackfr
ame=0
And, Jared, you'll be happy that it appears to be written in Perl. :)
Rich Jesse
Title: RE: using a lot of temporary tablespace with large sort area size
Man
significantly improved perf. by setting hash_area_size for session. Okay
so guyshave read in metalink says hash_area_size is 2* sort_area_size by
default - is this not true? Most be the case that it isn't
true.
I am trying to find out how to connect as SYSDBA using ADO in Visual Basic.
Did not see any mention of sysdba in the doc.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
No, don't use reverse index for FKs, on certain versions they caused havoc
by allowing parent key to be deleted (Metastink has an alert on this one).
Reverse indexes are preferred in OPS environment AFAIK.
Raj
__
Rajendra Jamadagni
Thanks
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
rtfm
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 3:46 PM
Hi List,
What's the diffrent between unique constrint unique index, when we have
to
use which, I think both are the
What about PK, which one should be, normal or Reverse, I can see in one of
my database, Erwin generate all PK as normal/reverse ?
-Original Message-
Sent: Friday, June 07, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
No, don't use reverse index for FKs, on certain versions
Igore,
rtfm is a very complex answer, please reply clearly!!
-Original Message-
Sent: Friday, June 07, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
rtfm
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
I try to use table_access_path.sql but got stoped at @save_sqlplus_setting
and couldn't find it, do I have to save my sqlplus setting manualy or some
thing else, If any body run this script can you give me a hint for running
it.
Thanks
-Original Message-
Sent: Friday, June 07, 2002 1:33
An example on my understanding of Reverse Key Indices:
Say you have a table EMP with a column EMPNO, and an index on this
field.This number is incremented sequentially for every new employee that
joins in. And as employees retire, say, the records are deleted. This
would generally mean
Here is an excerpt from the actual document:
OPatch can be invoked directly as:
perl opatch command [command_options] [ -h[elp] ] [ -n[o_op] ]
or you can use the wrapper script that will use the version of perl
installed in $ORACLE_HOME and invoke it as:
opatch command
Either comment out the save_sqlplus_setting script or download it from
from www.ixora.com.au. Do the same for script
restore_sqlplus_settings. Both scripts just save/restore your current
SQL*Plus settings should another script modify them.
Hamid Alavi wrote:
I try to use
Greetings,
One of our developers came to me with a fairly simple query that runs much
faster when she uses the RBO. I looked at the execution plans generated by
both the RBO and CBO and the CBO's plan is horrible. I was able to get a
reasonable plan from the CBO using a USE_NL hint.
Do any of
Hamid,
Which part of RTFM you didn't understand?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 5:28 PM
Igore,
rtfm is a very complex answer, please reply clearly!!
-Original
read the fine manual
you might, by doing a bit of research, get the answers on your own.
It's definitely a way to learn more
--- Hamid Alavi [EMAIL PROTECTED] wrote:
Igore,
rtfm is a very complex answer, please reply clearly!!
-Original Message-
Sent: Friday, June 07, 2002 1:18
Read The Frigging Manual
-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Index Constraint
Igore,
rtfm is a very complex answer, please reply clearly!!
-Original
has anyone actually found these utilities?
Oracle claims they are with 9iR2, but I can't find them.
Jared
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/07/2002 02:43 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Running To Find Mama.
Just kidding around,
JoJo
-Original Message-
Sent: Friday, June 07, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
Igore,
rtfm is a very complex answer, please reply clearly!!
-Original Message-
Sent: Friday, June 07, 2002 1:18 PM
To: Multiple
Hi,
Currently I have only one database running on a single host. Supposedly, I need to create multiple databases on the same host. My question is can I open two databases at the same time? I have not done it before, so just wanted to make sure that I can work on two databases all at once.
Thanks
Igore,
The RTFM part !
-Original Message-
Sent: Friday, June 07, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Hamid,
Which part of RTFM you didn't understand?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L
When were statistics last generated?
Any significant DML since then?
Jared
Stahlke, Mark [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/07/2002 02:51 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Thanks for the quick responses.
I analyzed both tables immediately before I started testing.
The USE_MERGE hint gives me the same execution plan I get without hints.
Mark Stahlke
Oracle DuhBA
Denver Newspaper Agency
-Original Message-
From: [EMAIL PROTECTED]
Mark,
Do any of you SQL tuning gurus have any suggestions? I've
listed all the
gory details below.
I am not a SQL tuning guru, but it looks like this is an ideal example where
Hash joins would be of immense help. You could set a largish value for
HASH_AREA_SIZE (defaults to twice
Yes, just make sure your ORACLE_SID is set correctly when creating or
starting the new database. You can even have multiple databases each
using a diff version of Oracle.
Meomeo Nguyen wrote:
Hi,
Currently I have only one database running on a single host.
Supposedly, I need to create
On my dev box I have following databases running
oraclei@orion ps -ef | grep
pmonoraclei 13487 1 1
21:23:53 ? 2:27 ora_pmon_INTDEV
oraclei 13529 1 1 21:23:57
? 2:18 ora_pmon_INTSTAGE
oraclef 1846 1 1
00:26:03 ? 0:14 ora_pmon_FINTEST
oraclei 25861 1 1 07:41:40
? 1:18
I've used RDA for Solaris just recently. It's pretty slick. Somebody put a
lot of thought into this tool. The html pages it generates are a pretty
good snapshot of your environment. It makes use of frames which makes it
easy to navigate through the information.
Gerardo
-Original
Jared,
Now that you mention it ... couldn't find it on Windoz NT and AIX 5
installations ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
Thanks ALL, Specialy Igore.
-Original Message-
Sent: Friday, June 07, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
Read The Frigging Manual
-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 5:28 PM
To: Multiple
If you
are on Unix make sure your ORACLE_SID environment
variable is set to the database you want to
use.
-Original Message-From: Meomeo Nguyen
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 3:28
PMTo: Multiple recipients of list ORACLE-LSubject:
Simple Oracle
Igore,
I didn't expect even in this group you can find such low class people If
you want to use these sort of words please keep it for yourself.
-Original Message-
Sent: Friday, June 07, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
rtfm
Igor Neyman, OCP DBA
[EMAIL
I'm going along with John. Try the hash join.
CBO was less mature in v7, so it may need a little 'help'
to get the plan you want. Such as a 'hash' hint, or the use_nl
hint if you don't use the hash.
Jared
Stahlke, Mark [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/07/2002 03:43 PM
Thanks for the tips.
The hash join looks like the best bet. Someday we'll upgrade to 8.1.7.
Someday...
Here is the plan and stats using /*+ USE_HASH(c p) */
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=104706
Exactly that is what my benchmarks have also noticed.
Couple of other points...
1. Since the PRECONNECT always maintains a connection with the secondary
instance, there is a 2% overhead compared to the BASIC option.
2. I don't and did not see the need for a PRECONNECT option. Off course like
7.3.4? You're brave...
Try to analyze with the following syntax:
ANALYZE TABLE tname COMPUTE STATISTICS FOR ALL INDEXED COLUMNS;
There was a funny with CBO that it ignored index stats completely
even in some very simple joins. With 7.3.4. Usually this fixed
the problem. Can't remember which
I currently have 4 databases running and am in the process of creating
a 5th one. thisis on a solaris box. It is possible to run as many
instances as disk space and memory will allow. It might not be good for
performance but you can run more than one on the box.
--- Meomeo Nguyen [EMAIL
rtfm can be read as read the fine manual
exactly what sort of language are you accusing Igor (and it would be
nice if you managed to spell his name correctly) of using?
you have spent a good deal of time asking people on this list for help
for things that you could easily find in the manuals, if
RDA was written (or at least managed) by Anita Bardeen who used to
spend a good deal of time on this list...she'll be happy to know you
like it!
Rachel
--- Molina, Gerardo [EMAIL PROTECTED] wrote:
I've used RDA for Solaris just recently. It's pretty slick.
Somebody put a
lot of thought
I'm sure Winston Churchill or someone equally clever had something relevant
to say on the topic. At the moment, the only quote I can remember is
Churchill's democracy is the absolute worst form of government, except of
course for all the others...
Ferenc Mantfeld :
Churchill, amongst all his
Hello All,
It looks as if I've hit a brick wall and I'd very much
appreciate if you can help. I've got a query that has
to get some names and tie them to members. Name table
is the main table with and member table is child
table.
desc Names
FIRST_INIT NOT NULL CHAR(4)
SECOND_INIT NOT
Hello All,
It looks as if I've hit a brick wall and I'd very much
appreciate if you can help.
desc Names
FIRST_INIT NOT NULL CHAR(4)
SECOND_INIT NOT NULL CHAR(1)
INIT_SEQUENCE NOT NULL NUMBER
LAST_NAMEVARCHAR2(30)
FIRST_NAME VARCHAR2(20)
FLAG
I try to use table_access_path.sql but got
stoped at @save_sqlplus_setting
On the page where you downloaded the script, click on and read
Prerequisites.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network
If your Duplicates are large in number then the
following method
works fine..
1.
create table TMP as select distinct ( set of columns
) from ORIGINAL_TABLE
2. truncate table ORIGINAL_TABLE
3. insert into ORIGINAL_TABLE select * from TMP/use
SQL Loader after taking a dump from TMP.
Bhulu
Are you looking for something trivial like:
select n.first_name, 'E.' middle_initial,n.last_name,m.mem_init_sequence
from names n, member m
where n.first_init=m.mem_first_init and
n.second_init=m.mem_second_init
order by 1 desc, 2 asc;
On 2002.06.08 01:33 Viktor wrote:
Hello All,
99 matches
Mail list logo