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
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=TWO
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 stored
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
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.
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)
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
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
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
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
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
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
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 be
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'
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 obvious
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)
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 the
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:
ok
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
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:
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
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
No, we've turned into a kinder, gentler
listduring 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-LSubject:
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?
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
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
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 probably why it's in a VARCHAR.
Correct the data? What strange ideas you mortals have.
Burton,
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
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
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
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 'X' ELSE '
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
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)
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 boy those
I think its: OR YOU AND
IDIOT?
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec
911 Honolulu
- Hotsos Clinic 101, Jan
79 Knoxville
- Steve Adams's
Miracle Master Class, Jan 1315 Copenhagen
- 2003 Hotsos Symposium on
Oracle System
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
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
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:
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! pow
Lisa Koivu
Oracle Database Supermom to 4 Boys.
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
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
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
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
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
--
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
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
in
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
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
__
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
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/applmgr
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
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 space
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
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 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:
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
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
Tom,
Actually it returns 1 record.
Thanks
Rick
Mercadante,
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
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
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
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
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
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/dev/null
Bozo in Bozeman, Montana
-Original Message-
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
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,
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.
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
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
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
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
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
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
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.
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
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 posted
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 =
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 standby
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
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
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-
Sent: Friday,
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
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
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
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
88 matches
Mail list logo