Hi All
I have stored a user defined function as Varchar field in a table.
How do I execute this function.
Here is the table where the function is stored.
SQL> select * from func;
FUNCTION_NAME
-
Calc_radius(5)
This procedure contains the following Code
um joe, I sent it to you as part of the article I compiled... check
your 9i account
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> The 9i new features msg i posted on Self managing undo features. I'm
> compiling the info to put on the oracle-dba.com website and for some
> reason i didnt get that on
I talked to a friend on the selection committee, she said late November
so Joe's probably got it right :)
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Original message said, 4th week(thnkagiving week in the US) in Nov.
>
> joe
> John Kanagaraj wrote:
> >
> > Hi,
> >
> > Does anyone know when IO
Title: RE: providing 24*7 database ---
Thanks
all for the input.
hi
tony ,
Quick
question ... when you exchange partititons with non partitioned table data , all
indexes on non partitioned tables become unusable status
right.
do
have to rebuild them after every exchnage...
naren
-
to everyone who sent me a copy, nice to know people are filing them
away:)
joe
--
Joe Testa
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
--
Please see the official ORACLE-L
Original message said, 4th week(thnkagiving week in the US) in Nov.
joe
John Kanagaraj wrote:
>
> Hi,
>
> Does anyone know when IOUG-A will complete the selections for the upcoming
> April 2002 conference? The website wasn't very helpful, and the submissions
> closed more than a month back...
>
The 9i new features msg i posted on Self managing undo features. I'm
compiling the info to put on the oracle-dba.com website and for some
reason i didnt get that one at home(or more than likely deleted it w/o
filing it first).
I attempted to get it off the fatcity.com website but its a beast to
Hi,
Does anyone know when IOUG-A will complete the selections for the upcoming
April 2002 conference? The website wasn't very helpful, and the submissions
closed more than a month back...
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Listen to great commercial-free christi
Anand,
Just curious : Is there some test or other observation that you can share
with the list about dbms_stats using 10% as a boundary for staleness?
John Kanagaraj
Which version of Oracle are you using. In 8i you can set 'monitoring on' for
the tables and use dbms_stats to analyze stale
Hi Greg,
I had already covered the part of getting down to the
SQL earlier in my response.
Gaja
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> > so long as you look at the wait events, you will
> > be looking at your database's bottlenecks, and in
> the
> > world of Oracle Performance Tuning, that
Which version of Oracle are you using. In 8i you can
set 'monitoring on' for the tables and use dbms_stats to analyze stale. (Though,
I am getting error while using dbms_stats for the partitioned tables. So I have
made a home made version to analyze stale). As per my calculations, package
db
Hello everyone,
Env: 8i and 8.0
I've been digging around the rman manuals and metalink but can't seem
to find anything decent on this so thought I'd try this forum...
Firstly, what functionality do you loose when you don't use a catalog?
2ndly, how does one delete old backups? I'm backing up t
Title: RE: ADO.NET and Oracle 8.1.6
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> We're getting ORA-12154: TNS:could not resolve service name
>
> I've checked the TNSNAMES.ORA and SQLNET.ORA and they seem OK.
>
> WIN2K. Using the MS Oracle ODBC drive
Hi Seema, I use this script. I have added comments so
it should not be difficult to understand. Let me know
if you need any clarification:
the usage is --> exec_restore.ksh -d [SID] -f
[rman_cmdfile]
Deepak
PS: i have not included command file as i think
probably need only the wrapper.
#!/us
Some reasons for the difference:
a) A single disk read could get more than 1 block
b) queries may already find blocks in the cache and
thus not need a disk read
c) a query may revisit the same block over and over
without ever going back to disk
The reason we look at both is 'disk_reads' tell us
Eric,
here's a high level from my understanding on this
issue:
Buffer gets {also called Logical IO's}
These happen as oracle scans blocks of data in the
buffercache(in-mem scans). Many people believe that
since these are memory reads, they are inexpensive. I
have seen the contrary in many cases
run {
allocate channel t1 type 'SBT_TAPE';
backup
incremental level 0
skip inaccessible
tag hot_fdm1_bk_level0
filesperset 2
format 'bk_%s_%p_%t'
(database);
sql 'alter system archive log current';
backup
filesperset 20
format 'al_%s_%p_%t'
(archivelog all
delete in
Hi
Can some one send me automated RMAN backup scripts please?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Se
I am trying to identify the most harmful statements in an application. From
the Oracle Performance and Tuning Tips and Techniques book, I found two
statements. Both are looking at the statements contained in the v$sqlarea.
The first looks at statements with a high number of buffer gets and the
ot
Hi List,
I have a question regarding design & data modelling If any of you have any
Idea or similar experience It would be nice to respond, Thanks in advance
all of you.
This is my question, I am in the middle of designning a database and want
to know if any tools or some methodology for testing
i would probably first use v$sqlarea instead of v$sql
to be able to identify the hash values for bad
ones(high lio's) and then probe v$sql using the same.
Deepak
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> > so long as you look at the wait events, you will
> > be looking at your database's bottle
Statistics become old after a single change is made to the object.
Granted adding a single row to a 1 Million row table isn't going to effect
much. But adding 100,000 rows will. So where do you draw the line?
I really don't know. But 5%-10% is generally a good measure.
Sometimes more sometim
If he is preparing a presentation, it is definitly one I won't
want to miss.
Stephen Andert>>>
[EMAIL PROTECTED] 10/23/01 02:40AM >>>I think Joe's just doing
it to be helpfuland as a way of learning the 9i stuff... he has to play
with it to beable to write about it--- Larry Elkins
<[EMAIL
> so long as you look at the wait events, you will
> be looking at your database's bottlenecks, and in the
> world of Oracle Performance Tuning, that is all that
> counts.
What about v$sql?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROT
We have a data-warehouse that is a combination of Snapshots and table-builds
based on the snapshots.
The table builds run at 4:30 am, scripts are setup to start the snapshots at
7:00am and end
at 9:00pm. At 6:30 am a script performs an analyze on ALL (except sys and
system) tables in
the databa
Well, I'd suggest setting 'global_name = true' in your init.ora files. Then the
database names in global_names have to be unique.
Dick Goulet
Reply Separator
Author: "Marin Dimitrov" <[EMAIL PROTECTED]>
Date: 10/23/2001 8:10 AM
- Original Mess
Thanks a lot !
Does anyone have such a script , please !
Thanks !
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 22, 2001 10:40 PM
To: Multiple recipients of list ORACLE-L
A broad process overview:
Process:
1. Notification co
Hi All,
Oracle uses direct I/O on W2K so the O/S block size is an irrelevance.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all
-Original Message--
We're getting ORA-12154: TNS:could not resolve service name
I've checked the TNSNAMES.ORA and SQLNET.ORA and they seem OK.
WIN2K. Using the MS Oracle ODBC driver (the Oracle ODBC driver is a no
go).
Anyone have any experience with this?
TIA
--
Please see the official ORACLE-L FAQ: http://ww
Marin,
If you don't like SYS_GUID() returning RAW, you can use
rawtohex(SYS_GUID()), it will return character string, containing hex
representation.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[E
WHOA, No that is not a performance problem. The Oracle block size needs to
always be a multiple of the OS block size. Most operating systems today, W2K
being no exception, do not simply read the number of OS blocks that you request.
They always 'read ahead' in the anticipation that you'll want
Marin,
Not sure I understand the question. Each database needs a unique sid on
that machine. You can use the same sid on different computers, but not on the
same one. According to MetaLink DBID is not a unique indicator.
Dick Goulet
Reply Separator
- Original Message -
To: "Marin Dimitrov" <[EMAIL PROTECTED]>; "Multiple recipients of list
ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 23, 2001 17:48
> Marin,
>
> Not sure I understand the question. Each database needs a unique sid
on
> that machine. You can use the same
Tony,
According to my understanding of this, which may or may not be absolutely
true, it depends on the way that connections are established.
In a standard dedicated server connection method, a user originally connects
to the listener on port 1521 or whatever else you've selected. Once
Hi,
what is the best way to uniquely identify a database?
A. grant access to the user to v$database and use DBID?
(how unique is the DBID?)
B.generate a unique ID somehow
(some PL/SQL package to use?)
thanx,
Marin
"...what you brought from your past, is of no use in your present
Hi
I'd say yes. For every Oracle block read the OS has to read two block which
causes overhead.
Jack
[EMAIL PROTECTED]@fatcity.com on 23-10-2001 16:05:21
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Thanks, Anita and Simon!! Your suggestion to do a custom install worked. I
had to install it piece by piece. It is not the way I would want all
installations to go but it worked and the client PC can connect to the
database.
Thanks,
Dave
-Original Message-
Sent: Monday, October 22,
How does oracle assign ports to connections? I know the listener is
assigned to a port - does all connections use this port for communication?
I was looking into using connection manager to limit the number of ports
that are assigned to user sessions, but it seems that all my connections are
usin
hi all
we have an oracle block size of 8k and i believe our W2K server has a
default
os block size of 4k.
Is this a problem with the performance ?
thanks
g.g. kor
rdw ict groningen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat C
Tony - All Net8 connections must use the port you assign the listener in
listener.ora, or they won't connect. Are you using other Oracle products
such as Application Server? I'm not familiar with how those work.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sen
How to find SQL statement in SQL area
try this:
select t.sql_text,
t.piece,
a.hash_value
fromv$sqltext t,
v$sqlarea a,
v$session s
where s.sql_address=t.address
and s.sql_address=a.address
order by a.address, t.piece
hth,
Mar
Helmut,
To get the full text of the statement you will need to do a join with
v$sqltext. An example:
select s.sid
a.address,
a.buffer_gets,
a.executions,
t.piece,
t.sql_text
from v$sqlarea a,
v$sqltext t,
v$session s
where a
Hi Jack,
I am a bit out of my depth here. I configured the listener so that it can
use
the INSO filter by setting the
ENVS=LD_LIBRARY_PATH=/usr/local/oracle/8.1.7/ctx/lib
in the listener.ora.
We r using Intermedia text on 8.1.7.0 on SunOS.
When I tried to check the listener by executing the co
Title: How to find SQL statement in SQL area
Hi!
How do I find the ENTIRE SQL statement that is dogging my box?
select sql_text from v$sqlarea where hash_value=123456
gives me the first part of the SQL statement; but since the statement is pretty long, the sql_text column d
I need to get the adue_cd and group by the sum of the adue_amt- amtpd based
on the decoded code ??
SELECT DECODE(adue_cd,'DS','STM','IS','INS','MS','OUI',
'PA','OD1','PN','OD2','PP','OD1')
,SUM(adue_amt - amt_pd)
FROM BSADUE
WHERE la_no = v_la_no
AND adue_cd IN ('DS','IS','M
Roland,
Your qry is making a HASH join and eating up the temp tablespace. The solution is to
increase the parameter HASH_MULTIBLOCK_IO_COUNT in init.ora and bounce the db once. By
default this parameter is '0'. So increase the next extent parameter for the temp
tablespace.
alter tablespace tem
I think Joe's just doing it to be helpful
and as a way of learning the 9i stuff... he has to play with it to be
able to write about it
--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> As always Joe, we appreciate these updates. And if it is never
> ending,
> that's fine by me. The way you have tak
I agree.
If you're really tight on space, you may need to
consider drop/create, otherwise rebuilds generally are
the way to go.
hth
connor
--- Jacques Kilchoer <[EMAIL PROTECTED]>
wrote: > > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >
> > What are the
When tablespace 3 is your temp tablespace
Look into possibility of extending that one eg:
autoextend, add another datafile
Hth,
Jeroen
>-Oorspronkelijk bericht-
>Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Verzonden: dinsdag 23 oktober 2001 10:10
>Aan: Multiple recipients of lis
Hi Roland, check if your temp tablespace is getting filled up (look at dba_free_space,
v$sort_segment, v$sort_usage). Are you getting any other messages with this one ?
Mandar.
[EMAIL PROTECTED] wrote:
Hallo
I run this select statement and get this errormessage. What should I do to
Seek and ye shall find
oracle@tyne:/usr/oracle >oerr ora 3232
03232, 0, "unable to allocate an extent of %s blocks from tablespace %s"
// *Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value
// that is greater than the tablespace's NEXT value
// *Action: Increase
Hallo
I run this select statement and get this errormessage. What should I do to solve it? I
have a databaselink from the actual schema to another schema.
SELECT RIK2.VARE.EAN_NR,
> RIK2.VARE.LEVNR,
> RIK2.ART_HIERARKI_CALC.VGR,
> RIK2.VARE.SORTIMENT,
>
52 matches
Mail list logo