That is exactly what I was looking for. Thanks.
Adam
-Original Message-
Sent: Friday, December 06, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L
Adam, If you need keep the global_name the Create the
database link with "@" symbol.
The online documentation
http://download-west.o
Adam, If you need keep the global_name the Create the
database link with "@" symbol.
The online documentation
http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803
gives you some examples.
I am not sure if this is what you are looking for but
it may help.
Scott
On Friday 06 December 2002 08:29, Mercadante, Thomas F wrote:
>
> I think their theory was to keep the JD Edwards system totally RDBMS
> neutral - they could switch out any backend that they wanted to.
A patently ridiculous idea.
Jared
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> --
Ah, yes, I was bitten by one of those persistent myths some
weeks ago, involving this very subject.
Never stop learning...
Jraed
On Friday 06 December 2002 01:04, Connor McDonald wrote:
> A few nasties still exist with compression on indexes
> if they are going to be used as a unique or primary
Umm I dunno. Don't recall it.
Jared
On Friday 06 December 2002 12:33, DENNIS WILLIAMS wrote:
> Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was
> that you?
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Se
Jay,
Is the PMON method set to LOCK? See the output of the following SQL
select profile_option_value from applsys.Fnd_Profile_Option_Values
where Level_ID = 10001
And Level_Value = 0
And Application_ID = 0
And Profile_Option_ID = ( Select Profile_Option_Id
Thanks for the suggestions, all. I knew about these workarounds, but apparently the
answer to my original question is "no".
Adam
-Original Message-
Sent: Friday, December 06, 2002 5:39 PM
To: Multiple recipients of list ORACLE-L
There is: Alter database rename global_name
Waleed
I just started the databases up in the background.
Patrol keeps track of the databases but we have never
had a problem doing this. Had to write a custom
dbstart script though. Works fine but is unsupported
by Oracle.
--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> Problem: How to keep a standb
There is: Alter database rename global_name
Waleed
-Original Message-
Sent: Friday, December 06, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L
You can update the global_name by using sqlplus or svrmgrl (internal or "/
as
sysdba" or sys):
update global_name
set global_name =
You can update the global_name by using sqlplus or svrmgrl (internal or "/ as
sysdba" or sys):
update global_name
set global_name = newname;
commit;
I do this every time I clone a database. If you don't change it, then the
database links won't work.
DENNIS WILLIAMS wrote:
> Adam - Someone post
My developers (I'm the hapless sys-admin) challanged me with this. I've
searched metalink and googled .. perhaps I'm not feeding Oracle-ese into the
search terms?
"There is a timeout warning (on $HOST running Discoverer 4i Plus) that
occurs ~ 1 minute before the session timeout. Can this warning
Is it possible to change the global name for one of them?
-Original Message-
Sent: Friday, December 06, 2002 3:34 PM
To: Multiple recipients of list ORACLE-L
Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was
that you?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
Hi All,
What value does an indicator variable in a pro*c program assume when the fetch
column value is NOT NULL. Is is 0 or something other that -1.
I would appreciate your help.
Thanks,
Rajesh
-Original Message-
Sent: Friday, December 06, 2002 12:34 PM
To: Multiple recipients of li
How badly do you want the space back? I believe you will indeed need to touch each row.
You could update each row with something like (update set column-1=column-1)
Good luck!
Barb
"Miller, Jay" <[EMAIL PROTECTED]> wrote:
But will this solve my problem in the near term? My understanding is t
I remember reading that when a free block fails the space requirements for
an insert it gets flagged 'unlink' and either it gets unlinked or it may
require to fail five times before it gets unlinked.
Waleed
-Original Message-
Sent: Friday, December 06, 2002 2:34 PM
To: Multiple recipient
That was exactly what I said, :)
Saludos,
Veronica Levin Enriquez
Compañía Cervecera de Nicaragua
-Mensaje original-
De: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, December 04, 2002 7:34 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Import Table from Ful
nothing is "wrong" - it works fine and I'm already implementing it . . . was
just looking for alternatives - I like to look at all the options available
bill
-Original Message-
Sent: Friday, December 06, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L
The pl/sql block gets submitt
They had one new piece of information. That is the unpublished note on
Bug#450349 which states that if Oracle doesn't have enough space to insert
in the first 5 blocks it tries then it will request a new block.
So even if most of the blocks are available if there happen to be 5 in a row
near the t
Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was
that you?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 06, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
I was afraid that'd be the only way.
The pl/sql block gets submitted for execution only after the variables get
replaced with their values.
So for different values you are submitting different code.
What is wrong in moving the different actions to inside the if/then/else
clause?
Waleed
-Original Message-
Sent: Friday, Dece
Okay, now that I've read this over it makes sense (and thanks again to Kirti
who supplied the same note albeit without the quote from the unpublished
section on bug 450349. Apparently Oracle will check a maximum of 5 blocks
on freelist for sufficient free space for an insert before grabbing a new
> I would go one more paranoid step further and redirect stderr too.
"program >& file &" DOES redirect BOTH stdout and stderr. Or use
"program &> file &" for Bourne/bash... sigh.
socially_challenged_standing_in_the_background.sh/dev/null &
Bozo in Bozeman, Montana
-Original Message-
One row/insert. One commit every 1-6 inserts (rows).
Column values are passed to pl/sql procedure which does the insert (i.e,.
passed in variables).
Maximum row length: I assume you mean the largest row in the table? Does
anyone have an easy way to get this? Other than applying formulas to eac
What Oracle said is not different than what I sent before (see below).
The problem is that the statistics of the table indicates that the average
free space in the free blocks is almost 100% and this contradicts with the
idea below.
At least there will be room for one row if the space in the block
On Friday 06 December 2002 18:29, Orr, Steve wrote:
[...]
> So then I tried nohup:
> --
> $ nohup sqlplus "/ as sysdba" @managed_recov.sql &
> [1] 23412
> $ nohup: appending output to 'nohup.out'
> [1]+ Exit 127 nohup sqlplus "/ as sysdba"
Currently we have installed
Installed Patch List:2664929 [ Base Bug(s): 2629652 2320407 2599613
2461455 2590120 2157903 2534430 2515844 2598124 2557893 ]2682180 [
Base Bug(s): 2652771 ]
and two more are in the pipeline ... maybe early Jan.
Raj
___
It's surprising you could do this since, as far as I know, if you start a
background process in ksh then try to exit the shell, you get prompted that
you have running jobs; if you type exit again, the jobs are killed.
Two things I do are:
Instead of running nohup directly, run
sh -c "/bin/nohu
Tom,
Actually it returns 1 record.
Thanks
Rick
"Mercadante,
Quit whining =8-)
The behaviour is the same for any process that inherits it's stdin/stdout
and stderr from the parent. Once the parent (your shell) goes
away, the file handles are closed and the child has nothing to
talk to. You only half-solved the problem with the nohup. You
did the right thin
Title: RE: sql tuning help
bad
news for me I guess - doing a Production Install right now!
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
11:29 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: sql tuning help
That is v
I was afraid that'd be the only way. Thanks.
Adam
-Original Message-
Sent: Friday, December 06, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L
Hi
Set global_names = false in init.ora file and try again
-Original Message-
Sent: vrijdag 6 december 2002 17:41
To: Multip
Problem: How to keep a standby database in continuous managed recovery
without having to maintain an open terminal session. (Version 8.1.7.2)
When you execute the following...
--
SQL> RECOVER MANAGED STANDBY DATABASE;
---
I'm curious, we have a database with a canned app that isn't using bind variables.
Periodically we flush the shared pool when the cache fills up with these statements.
But I've noticed it takes much longer to fill up after a shutdown than it does a
flush. What's the difference? We aren't pinning a
This is what Oracle came up with just now:
Hi Jay,
Based on my research:
1/From note: <1029850.6> Freelist and Freelist Groups:
"It is advised that the space calculated as (100% - (PCTFREE + PCTUSED)) be
greater than the maximum size of a table row. "
Based on the above formula, the leftover sp
Hi
Set global_names = false in init.ora file and try again
-Original Message-
Sent: vrijdag 6 december 2002 17:41
To: Multiple recipients of list ORACLE-L
Don't ask how we got into this situation, but I have two instances with the
same global_name and need to be able to create a link b
Here is the output from the query:
Sid/Ser# DB/OSUser StartTime Mins Rbs NameBlks Status
-- --- -- -- -
14/106 APPS/applmgr12/06/02 01:29:32 518 RBS2 1 ACTIVE
33/537 APPS/applmgr12/06
Title: RE: DB corruption question
This is more of a theoretical question, rather than an actual problem that happened. Let's assume the files were not copied, and there is no security at the site or on the disks themselves.
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTEC
Title: RE: Can I use "GOTO" with variables in PL/SQL?
you can do this (called as indirect referencing) within pl/sql using dynamic sql.
some info at http://www.pinnaclepublishing.com/OP/OPmag.nsf/0/8196D5C00E2B1E7C852568DB004FFBA4 ...
Raj
_
Rick,m
PS - I would bet that the FTS is from the last join - where:
and (b.description not like 'AMERICAN ASSOCIATION OF PHYSICIAN SPECIALIST%'
and
b.description not like 'AMERICAN BOARD OF ANESTHESIOLOGY%' and
b.description not like 'AMERICAN BOARD OF EMERGENCY MEDICINE%' and
etc etc
I expand that rule slightly:
no changes to production on the day before I will be absent from the
office.
Makes for so many fewer "emergency" phone calls on my day off
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> That is very wise advice. Don't touch production on Fridays has been
> a rule
>
Don't ask how we got into this situation, but I have two instances with the same
global_name and need to be able to create a link between them. Is this doable?
Adam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Donahue, Adam
INET: [EMAIL PROTECTED]
Fat City Netwo
Within the create database statement there is:
MAXLOGHISTORY. Does this apply only to Oracle Parallel Server (OPS) like
the docs say? So If I am not running OPS I can set this to 1 (one) safely?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
OK so I've opened an Enhancement Request on this . . . and in the meantime I
discovered that I CAN use SQL*Plus substition variables!
The following DOES work:
**
accept i_label prompt 'Enter CR '
declare
v_cr number := &&i_label;
v_crlabel varch
It's obvious they are using Oracle as a glorified fileing system.
JD Edwards does the same thing. They create tables with columns with things
like Number(38). they store the number with no decimal points. the "middle
layer" has the definition of the column. so all applications have to call
t
How is the insert being used?
Is it one row per insert?
Is the column values hardcoded or passed in variables?
What is the maximum row length?
-Original Message-
Sent: Friday, December 06, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Very interesting!
I was out sick yesterda
Title: RE: sql tuning help
That is very wise advice. Don't touch production on Fridays has been a rule in previous shops I worked at. Happy Friday all!
Lisa Koivu
Oracle Database Supermom to 4 Boys.
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-
Bill,
Sadly, I don't think this is possible. The PL/SQL compiler is just not that
dynamic.
Pretty cooleo idea, though.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 06, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
Good day, all:
I'
Rick,
does this return *any* records at all? the only reason that I ask is that
in the 'where' clause, it is saying:
where p.phy_id = board_aaps.phy_id (+)
and p.phy_id = board_aba.phy_id (+)
and p.phy_id = board_abem.phy_id (+)
and p.phy_id = board_abfp.phy_id (+)
and p.phy_id
Take a look at this article : http://www.jlcomp.demon.co.uk/faq/find_dist.html and the
link in there to Tom Kyte's article.
- Kirti
-Original Message-
Sent: Friday, December 06, 2002 9:34 AM
To: Multiple recipients of list ORACLE-L
That's right. How can I find out which transaction i
I think it’s: “OR YOU AND
IDIOT?”
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- Hotsos Clinic 101, Jan
7–9 Knoxville
- Steve Adams's
Miracle Master Class, Jan 13–15 Copenhagen
- 2003 Hotsos Symposium on
Oracle® Syst
Thanks, Raj.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote: > Boris,
>
> the example I gave you is 9012 RAC and I have 5
> other production systems
> that are 9202 RAC. BTW remember if you have
> cluster_database is true, then
> no matter how many instances, you will see GC
> traffic and
I think the problem (without really getting into how they coded this) is the
nested-nested loops.
try this hint:
/*+ no_merge use_hash(board_aaps) use_hash(board_aba) use_hash(board_abem)
use_hash(board_abfp) use_hash(board_abim) use_hash(board_abp)
use_hash(board_abr) use_hash(board_aobem) use_
Good day, all:
I'm writing a script where the user can specify at run-time if they want to
run the entire script or just one numbered piece. One way I thought of
implementing this is pasted below, but the line "goto v_crlabel" is not
recognized - evidently the PL/SQL engine is not substituting in
Title: RE: sql tuning help
Something like this might help ...
SELECT p.phy_id
,CASE WHEN (b.description LIKE 'AMERICAN ASSOCIATION OF PHYSICIAN SPECIALIST%' AND cnt > 0 ) THEN 'X' ELSE ' ' END
,CASE WHEN (b.description LIKE 'AMERICAN BOARD OF ANESTHESIOLOGY%' AND cnt > 0 ) THEN
Very interesting!
I was out sick yesterday so I'm just getting caught up on the email today.
There are currently 898334 rows and 2654300 blocks in the table (the number
of rows will grow over the next 2 months before the next big delete which is
done quarterly). But this does seem to imply that
Thanks for the reply but I only see 1 FTS for the last inline view.
Some of the info was truncated from previous post. I am resending output
Plan Table
| Operation | Name| Rows | Bytes| Cost |
I use OEM only to start my jobs on the servers. I do not use backup
manager, the gui interface to rman. I have used it but there is not
advantage to it. I like letting the servers run the jobs.
Just my $.02 ,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL
That's probably why it's in a VARCHAR.
"Correct the data"? What strange ideas you mortals have.
"Burton,
Hmmm - this is a Friday afternoon, you know. My suggestion is to forget
it until Monday - don't spoil your weekend
peter
edinburgh
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2002 12:54
> To: Multiple recipients of list ORACLE-L
That's right. How can I find out which transaction is distributed and which
isn't? And how do I kill it?
The scenario would be:
1. I log on to the db with the DBA account.
2. Query on v$transaction to get the list of transactions and find out who
is running these from v$session. (What would be th
Thanks a lot, Tim. Enjoyable reading. Much
appreciated.
Just to clarify what data modeling vendor might mean
by "RAC-aware" model:
In one of the draft suggestions they had "activity"
class tables that would record all major steps in the
system like registration, signing a contract,
inventory repl
No, it's "OR"
IDIOT.
NAND?
XOR???
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
8:49 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
ok
I'll play
ARE
YOU AND IDIOT?
-O
No, we've turned into a kinder, gentler
list during the Holidays . . .
(must control my typing fingers of Death..)
-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
9:19 AMTo: Multiple recipients of list ORACLE-LSu
Title: OEM 9.2 and TNS_ADMIN
Hi list,
today I've installed OEM 9.2.0.2 on W2K client. When I start my OEM he recognizes path of TNS_ADMIN variable, which I've set in registry, but OEM doesn't revognize my services. If I delete TNS_ADMIN from registry and copy TNSNAMES.ORA to $ORACLE_HOME\Net
My first thought would be that the plan shows a full table scan for
phy_boards for each in-line view. This is almost certainly due to the
'pb.expiration_Date is null' condition in the where clause of each
in-line view. Since Oracle does not store NULLs in an index (except for
bitmaps), that condi
ALTER SESSION SET ORACLE-L NO MAIL
;o)
-Original Message-
Sent: 06 December 2002 14:19
To: Multiple recipients of list ORACLE-L
uh-oh.. here they come..
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 06, 2002 8:35 AM
To: Mul
Title: RE: Online Index Rebuild Tuning
Uh oh ... read this yesterday on Metalink the version part I don't remember, but in that case if your PK is compressed, Oracle wouldn't return ORA-1 error ... that's scary.
Raj
__
Rajendra Jamadagni
you are lucky, it's Friday, so may be Jared will allow you to
play :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Friday, December 06, 2002 9:49
AM
Subject: RE:
Title: RE: To_Number
Thanks for the email!! I did not know about Dump so I learned something new. The record I thought I had a problem with was ok and that is why I did not see anything amiss. However the record after this one was $20041-94. Corrected that and got $145.34 EA. I just told
ok
I'll play
ARE
YOU AND IDIOT?
-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
9:04 AMTo: Multiple recipients of list ORACLE-LSubject:
RE:
HELP
-Original Message-From: NGUYEN Philippe (Cetelem
I always ask the obvious questions... because the answer is usually
"oops we screwed up" and it fixes the problem
I STILL think "because" is an unacceptable answer to "why did you make
a number field varchar?"
--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Oh sure. you had to ask the ob
A simple 'select' (non-DML) from a remote database is also treated as a transaction by
the source database (run a simple test to count from v$transaction (on source) after
issuing a 'select' that refers a remote object). One can either exit the session or
issue a commit/rollback, after 'select'
Well i'm of the concept you can never depend on having the gui
version.
so CLI is my choice, if you can do recovery by doing CLI then by all means
use GUI if available, just dont be dependent on GUI as your only method of
recovery.
Take for example:
Does the OEM gui give you option to b
HELP
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
7:35 AMTo: Multiple recipients of list ORACLE-LSubject:
SET ORACLE-L NOMAIL
uh-oh.. here they come..
Tom Mercadante Oracle Certified Professional
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
8:35 AMTo: Multiple recipients of list ORACLE-LSubject:
SET ORACLE-L NOMAIL
HELP
-Original Message-From: NGUYEN Philippe (Cetelem)
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002
7:35 AMTo: Multiple recipients of list ORACLE-LSubject:
SET ORACLE-L NOMAIL
When somebody complains that, when they do an "order by" and get that 100 is
less than 2, now you know what to tell them "Because". (As you might
guess, you're not the first to see this.)
-Original Message-
Sent: Thursday, December 05, 2002 7:29 PM
To: Multiple recipients of list OR
SET ORACLE-L NOMAIL
Is it possible that the data files from the first database were copied to
the second, but the control files did not get copied?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 05, 2002 5:05 PM
> To: Multiple recipients of list ORACLE-L
Apart from potential ease of use, are there any "compelling" reasons to use
RMAN via some form of GUI interface over CLI?.
I believe RMAN can be managed! via OEM. Does anyone know if there is an
associated financial cost to implement this and once implemented what
advantages does it provide compa
Hi,
Oracle 8.1.6 NT 4.0
I have a rather complex query a developer gave to me to try to improve
performance.
There are 3 tables used. All relevant columns used are indexed. The tables
have been analyzed
SQLWKS> select count(*) from physicians;
COUNT(*)
--
340043
1 row selected.
SQLWKS
Oh sure. you had to ask the obvious question and start a holy war!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, December 05, 2002 4:50 PM
To: Multiple recipients of list ORACLE-L
Am I the only one wondering why an obviously numeric field
(unit_cost??
Dear Listers,
Oracle 8.1.7 on HP-UX11
We have three databases, one master and two slaves. On the slaves resides a
view which queries data from master using a database link.
While querying from the view, we often get the error 'ORA-02042: too many
distributed transactions'.
We are pretty sure th
Hello to everyone
I want to write national characters
(Central European) to ASCII file, by using utl_file.
UTL_FILE is called within unix script,
and afterwards ascii file (after applying "unix2dos") is sent as an attachment
(by using "uuenview"). Both NLS_CHARACTERSET (EE8ISO8859P2) para
Look at NLS_NUMERIC_CHARACTERS " ,. "
-Message d'origine-
De: Jared Still [mailto:[EMAIL PROTECTED]]
Date: vendredi 6 décembre 2002 09:59
À: Multiple recipients of list ORACLE-L
Objet: Re: To_Number
No, she isn't.
A few nasties still exist with compression on indexes
if they are going to be used as a unique or primary
key - you'll have to come to my session at UKOUG if
you want to see why :-)
But also jumping back to Mark's point about rebuilding
the index because it contains ever increasing values -
this i
No, she isn't.
On Thursday 05 December 2002 14:19, Fink, Dan wrote:
> Yes, yes you are.
>
> -Original Message-
> Sent: Thursday, December 05, 2002 2:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Am I the only one wondering why an obviously numeric field
> (unit_cost???) is being
have two instnaces on some machines as well. normally I've ORACLE_SID set to a first
instance, lets asume ONE. typing at the command line
sqlplus "/ as sysdba"
or
sqlplus "sys/passphrase as sysdba"
or
sqlplus "sys/passphrase@ONE as sysdba"
are the same.
now either you choose to set
ORACLE_SID=
On Thursday 05 December 2002 13:35, Mark Richard wrote:
> Also, I have heard about compressing indexes, but it is something I have
> never used before. Can anyone shed some light on the topic? Are there any
> drawbacks (ie: reduced IO but increased processing)?
>
To obtain optimal results with a
89 matches
Mail list logo