 | | | Oracle List | | Curiosum - try
SQL > UPSERT XYZ
You get a real ORA- error as it is a valid SQL command in SQL*Plus 's
opinion but the server doesn 't think so.
SQL > UPZERT XYZ
gives a sqlplus error just liMy guess is that it 's an Oracle kernel error that 's printing an unsigned
integer using a signed format in a printf somewhere. A question you
might ask yourself is "How much time did this event realIs the data plain text? If so then you don 't need to use the external listener.
Ian MacGregor
Stanford Linear Accelerator Center
ian@(protected)
-----Original Message-----
From Josh
I guess the first step is to decide what your definition of "SKEW " is.
Maybe it 's defined as the most common value is x% more common than the
least common value? Then you can adjust x tYour database does not start from init.ora file after certain version.
Any change you do there is purely for your own enjoyment.
On 03/11/2004 09 00 03 AM David Boyd wrote
> Hi List
>
> I si know how to do a top n query. I started a new thread with a better worded question.
>
> From "Juan Cachito Reyes Pacheco " <jreyes@(protected) >
> Date 2004/03/11 Thu AM 08 15 14 EST
> ToSID and SERIAL# are not guarenteed unique across instances. INST_ID is the
last part of that implied primary key for all GV$ views. Look at
V$FIXED_VIEW_DEFINITION
The data for each instance I saw there was some in here but didn 't downloaded
http //www.oug-ottawa.org/
I hope this help
----- Original Message -----
From "Seema Singh " <oracledbam@(protected) >
To <oracle-l@(protected)List
I am about ready to install 10g on my test box (RedHat 2.1AS Oracle
8.1.7.4) and I was wondering what the method those of you using 10g
used. Did you MIGRATE or EXPORT/IMPORT? Are there anOn 03/11/2004 10 54 30 AM Huascar Espinoza wrote
> I have another question about Oracle performance... I want to import MS
> Access to Oracle (Delphi as programming tool). But all the mechanisms
In version 8 I said that OAS can go in one direction only for the better
but 9i proved me wrong. I 'd be eager to find out about other people 's experience
with OAS because I am no longer inclined Hi folks
Got another trace file question. This is a snippet
from a 10046 level 8 trace. I 'm trying to interpret
it and these are my conclusions
cursor #1 execs procedure in a package (dep On 03/11/2004 01 53 43 PM rstevenson@(protected) wrote
> A Hotsos symposium in the NorthEast would be excellent!
Norwalk CT would be an ideal place in the NorthEast for an
event like thatOracle Version Number will determine the answer - see Tom Kyte 's website.
http //asktom.oracle.com/pls/ask/f?pI50 8 NO F4950_P8_DISPLAYID F4950_P8_CRITERIA 439329623515
or
http //tinyurl.We have upgraded our databases from 8174 to 9203.
We have started encountering ORA-04031 's on processes that are using MTS. Once we switch that process to use a dedicated connection then the proRight right after the run { in the run block. At least that is what I was
told and what I have done. Especially since 9i if you don 't tell rman when
you want to go back to he will just blithelThe "set current_schema " option was not for security reasons but to eliminate the need for the creation of all those synonyms.
-----Original Message-----
April Wells
no I don 't think that wiWhat would suspending a session actually mean? There is no such session state
as "suspended ".
On 03/11/2004 09 15 34 AM Database Admin wrote
> Hi Mladen
> thanks man I knw that but I am unablHas anyone experimented with SGA_MAX_SIZE? Does Oracle request that amount
of memory on startup? If memory of the components like SHARED_POOL_SIZE and
DB_CACHE_SIZE are smaller than SGA_MAX_SIZE doSeema
For $15 U.S. you can get scripts from noted Oracle author Mike Ault.
http //www.dba-oracle.com/bp/bp_elec_backup.htm
There is a repository of backup scripts at
http //www.orafaq.com/scriIt was supposed to be humour.
> -----Original Message-----
> Tim Johnston
>
> Jacques Kilchoer wrote
>
> >The execution plan with the smallest total cost will also be
> the execution plan th
On 03/11/2004 08 05 27 PM Tim Johnston wrote
> Hi Mladen...
>
> However if his original post was "What 's the most resource intensive
> SQL in my entire system " then a 10046 would not be tOn 03/11/2004 10 01 42 AM Bricklen Anderson wrote
> Juan Cachito Reyes Pacheco wrote
> Really? That 's an interesting rule. Any metrics to support that
> statement or does that kinda fall inthi
you should use svmon -p to show the detailed information.
Regards
Zhu Chao
----- Original Message -----
From <k.sriramkumar@(protected) >
To <oracle-l@(protected) >
Sent ThursI 'll wager that what is happening is the following
1) Your long SELECT starts and the system notes that the system change number (SCN) is x
2) Another transaction comes along aThanks JARED DAVID LISA JANUSZ
For your replies.I myself have worked on Veritas before and dont like CA products
they I dont know why doesnt seem to like me unlike Veritas.But you know the CTO 's whGood afternoon
I got
ORA-04031 unable to allocate 27160 bytes of shared memory ( "shared
pool " "unknown object " "sga heap(1 0) " "session param values ")
on the produciton database and no nHow about creating it as an Object.
create type address_type as object
(street varchar2(50)
city varchar2(25)
state char(2)
zip number)
-----Original Message-----
FrJuan
What version of oracle are you on?
I believe bulk fetch into a composite array is 9i and higher.
this works on 9i
declare
type array is table of emp%rowtype index by binary_inteThank you
Yes but create an object for every specific select that gathers specific
columns you
will have lot and lot of objects.
----- Original Message -----
From "Kevin Lange " <klange@(protected) |
|
|
