Query on Dual

Hi all, Can anyone tell me the performance issues related to the excessive usage of the DUAL table in pl/sql procedures? I remember reading an article about this ( I dont remember if it was in ASKTOM site ) wherein it was told that excessive usage of DUAL comes with a cost and there was a

RE: dbms_stats via dbms_job - syntax question

Thanks for the try Igor but that doesn't work either ERROR at line 1: ORA-06550: line 2, column 24: PLS-00201: identifier 'CASCADE' must be declared ORA-06550: line 1, column 99: Wolfgang's suggestion doesn't work and I have tried every permutation of quotes (including none at all) around the

RE: Deleting Statspack tables.

Tim Gorman has produced an excellent package sppurpkg.sql which certainly does the business for me It can be found at http://www.evdbt.com/sppurpkg.sql John -Original Message- Sent: 11 June 2003 00:35 To: Multiple recipients of list ORACLE-L Version : 8.1.7.3. I am not sure how it is

RE: dbms_stats via dbms_job - syntax question SOLVED

Thanks for all the help. The problem was not with my coding but the syntax. In my worked example I had CASCADE=TRUE whereas it should have been CASCADE=TRUE. A subtle difference but one that caused me (and fellow listers) no end of hassle. So all the answers that I said were incorrect were

RE: Deleting Statspack tables.

Hi John, Tim Gorman's site has been moved to http://www.sagelogix.com. So one can find all the UNIX and SQL scripts in sagelogix.com rather than evbdt.com. Regards, Ranganath -Original Message- Sent: Wednesday, June 11, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Tim

Re: Query on Dual

Find it as attachmentWith Regards,Manoj Kumar JhaC-56 , Phase-2NOIDA -201305, UP(INDIA)Tata Consultancy ServicesPh No: (+91-120) 4461001 ext : 1037 (Off.)Mobile No : 9810090974A

Upgradation Question on APPS 11i

Dear Group, One of our customer is using apps 11.5.4 on WIN2K. For a demo, they wanted to upgrade to 11.5.5, then 11.5.8. How do I do that in a short way. In the metalink doc's they are giving a big procedure. Any help??? TIA Senthil -Original Message- Gogala Sent: Saturday, May

Re: Re: Rule Based Optimizer

what did oracle use before the RBO? From: Mogens Nørgaard [EMAIL PROTECTED] Date: 2003/06/11 Wed AM 12:39:20 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Rule Based Optimizer Yep. Here's the official statement from Oracle about RBO in 10i: The RBO is

Re: Rule Based Optimizer

Paper and pen? On Wednesday 11 of June 2003 13:39, you wrote: what did oracle use before the RBO? From: Mogens Nørgaard [EMAIL PROTECTED] Date: 2003/06/11 Wed AM 12:39:20 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Rule Based Optimizer Yep. Here's the

RE: How to pass string with a ' to PL/SQL

Title: RE: How to pass string with a ' to PL/SQL Exactly ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an

RE: How to pass string with a ' to PL/SQL

Lizz, Remove the 'execute' from your PL/SQL block. it is not needed - in fact - it is causing the error. "Execute" is only needed within sqlplus when not using a PL/SQL block. You are using an anonymous PL/SQL block to call your procedure. Good Luck! Tom Mercadante Oracle Certified

Re: Re: Rule Based Optimizer

Perhaps MBO (Mood Based Optimizer)! - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 11, 2003 7:39 AM Subject: Re: Re: Rule Based Optimizer what did oracle use before the RBO? From: Mogens

RE: dbms_stats via dbms_job - syntax question

John, My code doesn't work probably because CASCADE = TRUE should actually be: CASCADE = TRUE. So, this should work: declare l_job number; begin dbms_job.submit (l_job,'begin dbms_stats.gather_schema_stats(ownname =' || CHR(39) || 'RPT_2G_MASTER' || CHR(39) || ', estimate_percent = 10,

Fragmentation ?

Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE = UNIFORM OVER dba_tablespaces.ALLOCATION_TYPE = USER ? With ALLOCATION_TYPE = UNIFORM , NEXT_EXTENT Size of the Object can NOT be Manually defined in the Table Creation Script storage (NEXT Value) which is allowed when having

RE: Named Pipes Protocol Adapter

And you would really allow your pipes to go nameless? I have both names and nicknames for the integral parts of my plumbing. Leaky Jack and wet Jill are my favorites. Windoze has no concept of SYSV IPC, in particular it doesn't know what shared memory is. Oracle on Windoze is not running

RE: dbms_stats via dbms_job - syntax question SOLVED

But one thing I proved was that you can mix and match positional and naming parameters Hmm, I'd still rather use one OR another: you never know if mixing them would work in the next version... Why trying your luck?-:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas,

RE: Database Auditing

Beware that user SYS is not AUDITable in 8i... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 1:14

RE: dbms_stats via dbms_job - syntax question SOLVED

John Then be sure to set the init.ora parameter _do_what_I_mean=true It solved most of my problems. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 4:35 AM To: Multiple recipients of list ORACLE-L

RE: Re: Rule Based Optimizer

No it was just BO - and it stunk -Original Message- Sent: 11 June 2003 14:20 To: Multiple recipients of list ORACLE-L Perhaps MBO (Mood Based Optimizer)! - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, June 11, 2003

Urgent: Need Oradim.exe for version 8.1.6

I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen -Original Message- From: Mark Richard [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 9:15 AM To: Multiple recipients of list ORACLE-L Subject: Re:

RE: Deleting Statspack tables.

Tim's script is not much of different except deleting from the stats$sqltext from original SPPURGE.sql . But if you see my mail below I do have a lot of other tables which needs to be purged periodically. Thank You, Madhu Reddy -Original Message- Sent: Tuesday, June 10, 2003 9:50 PM

RE: Fragmentation ?

Vivek Make sure you've read How to Stop Defragmenting and Start Living http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 The authors point out that uniform extents stop fragmentation at the tablespace level. However they point out that there are other forms of fragmentation. Dennis

New Oracle security tool?

Anyone know what the forthcoming security tools are called? Part of OEM IV??? http://www.eweek.com/article2/0,3959,1121278,00.asp Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the

RE: How to pass string with a ' to PL/SQL - Solved -Thanks.

Everyone: Yes this worked. This is what I originally ... originally had !!! The problem seem to be with my code. Pointed out by Jacques. My orderby clause was where the whereclause statement should be.. Thanks for the code review and feed back everyone. Learned a lot with this exercise.

Re: Named Pipes Protocol Adapter

Mladen, I think what is being referred to here is that named pipes can be set up as a protocol in the listener on Windoze. As to why one would want to do that, I don't have an answer. Jared On Wednesday 11 June 2003 07:00, Gogala, Mladen wrote: And you would really allow your pipes to go

RE: Urgent: Need Oradim.exe for version 8.1.6

O/S ? 32 bit or 64 bit?? John -Original Message- Sent: 11 June 2003 15:25 To: Multiple recipients of list ORACLE-L I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen -Original Message- From: Mark

RE: How to pass string with a ' to PL/SQL

You rock !!! Should have reviews my code closer!! Thanks.Jacques Kilchoer [EMAIL PROTECTED] wrote: Sorry about that. Looking at your example more closely it seems like you maybe doing it right.In your package body I see this:IF ( in_whereclause IS NOT NULL ) THEN v_sqlbeg := v_sqlbeg ||

Re: Query on Dual

Kesh, I have some information on my website (http://www.optimaldba.com/internals/oraint_dual.html). It is a pretty terse discussion of the topic. I know that Cary Millsap has tested and written a paper on this as well. IIRC, there is mention of DUAL in his paper on reducing Logical I/Os. You

Hash Tables and PL/SQL (Ora 9.2)

I've been trying to create a hash table using PL/SQL but I seem to be running into some trouble. Hoping someone can point me in the right direction. I've been using PL/SQL Users Guide and Reference Ch 5 as a guide. I have the following piece of code: declare cursor c1_cur is select *

Re: Hash Tables and PL/SQL (Ora 9.2)

Ok, I found the bug. Just re-read ch 5 page 5-4 Understanding Associative Arrays (Index-By Tables). The problem was here: if rdt_type.exists(c1_rec.rdt) then null; else rdt_type(ctr) := c1_rec.rdt; end if; This should have been: if

RE: Rule Based Optimizer

I remember CBO in 7.1.6 on AIX... RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/10/2003 6:45 PM I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :) Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL

[no subject]

SET ORACLE-L NOMAIL -- - Software Engineering Vattmannstraße 7, 33100 Paderborn Phone: (+49) 52 51 / 30 1 6333 Fax: (+49) 52 51 / 30 16 399 eMail: [EMAIL PROTECTED] http://www.unitrade.com

Performance Problems Solaris Vs Windows

Hi Gurus, I'm facing a weird problem. I'm running a same query on windows as well as on Solaris both having Oracle 8.0.5 database using CBO optimizer. The Query runs fine on Windows (takes 20-30 Secs) while the same hangs on Solaris and takes 4-6 hrs to return the results. Both the databases

RE: Named Pipes Protocol Adapter

Jared, I use to use Named Pipes MANY years ago before TCP/IP became the major player in networking. It runs on top of NBP or NetBeui. While one can use it with WinDoze that's about all. None of the Unix vendors that I know of support it. I believe that even MicroSlop has deprecated

RE: New Oracle security tool?

Oracle Security Auditing Tool for Analyzing Networks Does anybody have any good suggestions for abbreviations?Mladen GogalaOracle DBAPhone:(203) 459-6855Email:[EMAIL PROTECTED]-Original Message-From: Jesse, Rich [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 11, 2003 11:20 AMTo:

RE: Sun to Linux on Dell

Title: Message I'd go Windows on the Dell box. There are some quite nice tools like perfmon that can give you a lot of info about what is going on. My preferred Windows box though would be the Proliant, it's earned it's reputation over time for performance andreliability. Problem with a

RE: Deleting Statspack tables.

I'm having difficulty following all of the referential integrity on perfstat tables, but there are several on delete cascade constraints on the tables. It looks to me like all of my perfstat tables are being cleaned up. I've been accumulating data on 1 database for more than 1 year every hour

RE: Upgradation Question on APPS 11i

It is a Big Procedure ;) Sorry ... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Senthil Kumar D Sent: Wednesday,

RE: Rule Based Optimizer

Tom, I think you meant 'RBO' in 5.x and 6.0 rather than CBO... There were the 15 rules. John -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Rule Based Optimizer

RE: Rule Based Optimizer

I know that the CBO existed on Oracle 7.0.15 for HP-UX. I remember it well because we would frequently get incorrect and inconsistent results. Installing the 7.0.16 patch _mostly_ fixed these issues. We still had a large number of queries that we hinted to use the RBO as we couldn't get the

RE: Rule Based Optimizer

Title: RE: Rule Based Optimizer Tom, I thought the rules of precedence were for RBO (the R in RBO). Whereas CBO was _intelligent_ enough to choose a path based on information available on hand. Raj Rajendra

selectivity of predicates with LIKE - diff between 8i and 9i

Dear List, Is there any difference between 8i and 9i in how selectivity of the predicates with LIKE are estimated by CBO? We are migrating some apps running on 8.1.7.4 on HP-UX 11.0 into 9.2.0.3 on the same box and some queries choose completely different execution plans - HJ with FTS vs original

RE: Rule Based Optimizer

well beat me with a stick and call me black and blue. of *course* I meant RBO! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 11, 2003 12:30 PM To: Multiple recipients of list ORACLE-L CBO was what I learned on in late version of 5.x and 6.0.

RE: Rule Based Optimizer

Same here. Hopefully 10i's CBO has matured. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 11, 2003 1:16 PM To: Multiple recipients of list ORACLE-L I know that the CBO existed on Oracle 7.0.15 for HP-UX. I remember it well because we

OT: uuencode and mail

Hi all, Platform: AIX 4.3.3 I realize this off topic but it is somewhat related. Each morning a cron job creates an SQL*Plus output in csv format which gets e-mailed out as an attachment: $ uuencode somefile.csv somefile.csv |mail -s Here is your file [EMAIL PROTECTED] I still want to continue

RE: selectivity of predicates with LIKE - diff between 8i and 9i

By any chance are you using CURSOR_SHARING parameter in your 8i version? I think the default selectivity of 5% is used while costing the like operator and with the binds (and with an underscore parameter which I think defaults TRUE) it is treated as equality . If not you can set the underscore

wait event puzzler

Good day all, We have a bunch of queries in our data warehouse environment that are taking a long time to complete. I did a select on v$session_wait on one of the queries when it is running and it shows the wait event to be 'db file sequential read', which means it is scanning index blocks,

Re: RE: Rule Based Optimizer

did oracle always use the RBO? or did it have some extremely simplified optimizer prior to 6.0? i know some of you haev been around a while... hopefully this doesnt make you feel old. no real need to know. just curious how the technology has progressed over time. From: Mercadante, Thomas F

RE: wait event puzzler

Dennis: THe event 'db file sequential read' is NOT always an INDEX Scan. It is just a single block read which TYPICALLY happens during an INDEX scan. The word 'TYPICALLY' is the key here. Best Regards, K Gopalakrishnan -Original Message- Meng, Dennis Sent: Wednesday, June 11, 2003

RE: selectivity of predicates with LIKE - diff between 8i and 9i

Thanks, KG No, CURSOR_SHARING is not set (meaning it defaults to EXACT on both 8i and 9i) No bind variables. The query given with ... LIKE 'LOVE%' is the real one Yes, I can try setting _LIKE_WITH_BIND_AS_EQUALITY. One additional piece of info - we don't have OPTIMIZER_INDEX_* parameter set on

RE: wait event puzzler

It's reads the block using the *ROWID*...that would explain his concerns... Regis -Original Message- Sent: Wednesday, June 11, 2003 7:19 PM To: Multiple recipients of list ORACLE-L Dennis: THe event 'db file sequential read' is NOT always an INDEX Scan. It is just a single block read

RE: wait event puzzler

A SINGLE block? I was convinced that it was = DB_FILE_MULTIBLOCK_READ_COUNT blocks. Are you sure? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Dennis: THe event

RE: wait event puzzler

The db file sequential read means that oracle is trying to read a sequence of consecutive blocks, shorter then DB_FILE_MULTIBLOCK_READ_COUNT. That usually happens when reading indexes, but it's not inconceivable to happen during table access as well. Mladen Gogala Oracle DBA Phone:(203) 459-6855

RE: How to put a TOP 1 in a select

I run the next instruction: select a.item, a.location, a.trans_date, b.can_vta from ( select item, location, trans_date, rank() over (partition by item, location order by quantity) the_rank from ictrans a where company = 2000 and trans_date between (current_date-14) and current_date and

more on Oracle/PeopleSoft

From SearchDatabase.com today Despite Craig Conway's indignation over Larry Ellison's $5.1 billion hostile takeover bid, the PeopleSoft chief executive officer had approached Oracle just one year ago to discuss a possible deal between the two firms. The two companies went as far as signing a

Re: wait event puzzler

db file sequential read means single block read, which can be either from an index or from a table. Likewise, db file scattered read means multiblock read, which again can be either from a table or from an index. At 10:01 AM 6/11/2003 -0800, you wrote: Good day all, We have a bunch of queries

RE: uuencode and mail

Just append the file to the bottom of the message you want to send. S...: echo This is my message about this report testmsg uuencode somefile.csv somefile.csv testmsg mail -s Candygram! [EMAIL PROTECTED] testmsg Something like that. Matt -- Matthew Zito GridApp Systems Email: [EMAIL

RE: Performance Problems Solaris Vs Windows

Do u analyze both sets of tables on the different platforms at the same regular intervals? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Munish BajajSent: Wednesday, June 11, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: RE: Rule Based Optimizer

RBO was the optimizer as far back as I can remember and that was V3. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, June 11, 2003 2:10 PM To: Multiple recipients of list ORACLE-L did oracle always use the RBO? or did it have some extremely

RE: Query on Dual

http://www.ixora.com.au/scripts/cache.htm replace_dual.sql In some cases the data block for SYS.DUAL can be a hot block in cache. This script replaces the SYS.DUAL table with a view onto X$DUAL, thereby eliminating the cache access entirely. Please note: This is not a normal, supported

[Q] RMAN and backup tool?

We are thinking about use RMAN to backup our databases. The database is ORACLE 9ir2. My questions are: 1. due to we will use Veritas netbackup with RMAN, but UNIX server is Netbackup client (server is win 2K). Can RMAN understand and control the remote tape driver? 2. any other software I

RE: How to put a TOP 1 in a select

Title: Message That's always going to happen with something like a rank (or min/max). You'll need to add some additional criteria to tell Oracle which of the multiple records that you want to see returned. And that will depend on the business needs. For example, you might want the earlier

Preparing for Performance test

Tru64 5.1A 8.1.7.3 I have a very short window of time tomorrow to try and determine why the runtime of one 2-table join takes ~4 time as long on a (SAN/Snapshot) database copy as the same statement on the source database. All other test selects have similar runtimes on each database. Both

RE: uuencode and mail

Hey that worked. Thanks! Saira -Original Message- Matthew Zito Sent: June 11, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Just append the file to the bottom of the message you want to send. S...: echo This is my message about this report testmsg uuencode somefile.csv

RE: Preparing for Performance test

Title: RE: Preparing for Performance test after you are done wint 10046^8, you may want to try with event 10053^1 ... and if you are looking for information to interpret the output look no further than http://www.centrexcc.com/papers.html Raj

RE: more on Oracle/PeopleSoft

This is getting to be entertaining. I started re-reading The New Art of War by Sun Bin last night... Patrice. -Original Message- Sent: Wednesday, June 11, 2003 3:55 PM To: Multiple recipients of list ORACLE-L From SearchDatabase.com today Despite Craig Conway's indignation over Larry

RE: Performance Problems Solaris Vs Windows

Do you have anything set in the configuration that would (hints, multiblock read count...) that would favor a different execution path? -Original Message-From: Ishwar Tewari [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 11, 2003 3:00 PMTo: Multiple recipients of list

Is this thing on?

Title: Is this thing on? Testing... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were

Re: selectivity of predicates with LIKE - diff between 8i and

So far I have not observed a difference in selectivity of predicates between 8i and 9i. Is there something special about the table or index? I tried to create a mock table with your statistics and the 9i optimizer came up with the same cardinality and cost estimates as 8i. Can you post (or

Re: Rule Based Optimizer

Dick I personally think the CBO is a great optimizer even if the first versions 7.0.x,7.1.x, and 7.2 was a bit shaky When somebody say that the CBO has to get better/mature then they typically have worked with the RBO and forgot that humans has this fantastic skill of adapting to known

Re: Database Auditing

That's correct. The poster didn't specify which version. If it's 9i the options available are plenty. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:19 AM Beware that user SYS is not AUDITable in 8i...

RE: wait event puzzler

Yes, 'db file sequential read' is always a single block read. It is 'db file scattered read' which is = DB_FILE_MULTIBLOCK_READ_COUNT At 10:35 AM 6/11/2003 -0800, you wrote: A SINGLE block? I was convinced that it was = DB_FILE_MULTIBLOCK_READ_COUNT blocks. Are you sure? Mladen Gogala Oracle DBA

RE: selectivity of predicates with LIKE - diff between 8i and 9i

Aha, just come accross note 94051.1 explaining _LIKE_WITH_BIND_AS_EQUALITY... but it's probably not relevant in my case as my query doesn't make use of bind variables. And yes I tried it (at the session level) just for kicks with no effect on the execution plan Thanks anyway, Boris Dali.

RE: Named Pipes Protocol Adapter

I remember asking on the Metalink SQL*Net forum a couple of years ago why one would use Named Pipes vs. TCP/IP. The Oracle support person on Metalink answered Hardly anybody uses Named Pipes. You should use TCP/IP. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] I

RE: Rule Based Optimizer

Peter, OK, It seems you got my message wrong. Truly the CBO has made matters a whole lot better, especially for someone like Me who has a lot of semi educated users creating ad-hoc queries into the database. On the other hand, CBO has on occasion done some pretty dumb things that

Re: World premier performance of the BAARF party logo

Our storage team won't even respond to me anymore when I ask for the manufacturer's rating for non-cached I/Os per second number of controllers, RAID level, striping, etc... All I get is 'why do you want to know that' and 'what application is this for'... BARRF will stop the debilitating

OT: question about DynaLoader::dl_load_file from perl profiler output

Hi: I am using this command to profile a perl program on our unix box /tools/bin/perl -d:DProf my_program.pl. and then dprofpp -u to get the following: Total Elapsed Time = 0.477847 Seconds User Time = 0.319582 Seconds Exclusive Times %Time ExclSec CumulS #Calls sec/call Csec/c Name

RE: World premier performance of the BAARF party logo

I quit talking about RAID over a year ago. I just put the data on the disks the Unix folks present to the server. If there are performance problems that we can identify to the storage system then we pass them along for an explanation. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA

high cpu

OS :hp-ux oracle rdbms 8.1.7.4 there are certain processes taking lot of cpu ( some thing went wrong with stastics last nite). which is causing almost a halt in production database.these processes are killed from oracle but i can still see them on OS .Cpu is still high . I though after

RE: question about DynaLoader::dl_load_file from perl profiler output

IIRC, DynaLoader::dl_load_file looks for and physically loads an object that the perl program is dynamically linked against or calling in some fashion. Then the dl_ calls you see at the bottom handle symbol resolution, etc. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL

java.sql.SQLException: ORA-21243896

DBA's, Has anyone ever seen this: 15:37:19 06/11 [DBUG] [ConnectionPoolC] SvcsConnectionFinished Reading properties horizon 15:37:20 06/11 [EROR] [ConnectionPoolC] SvcsConnection SQLException occured while while creating pool for horizon 15:37:20 06/11 [EROR] [ConnectionPoolC]

Re: high cpu

Rebounce the database... After shutting down database , check for any oracle process is still alive by using ipcs -mb If it is still their kill those process by yourself (using ipcem -m ) or by Unix admin. Sometime it does not go and then you have to reboot. If shutdown immediate takes

RE: high cpu

Ak - Were the processes you killed doing updates? If so the work is probably rolling back changes. Then it won't make much difference whether the process rolls it back or smon does. You could take a look at the wait statistics to get an idea of what is going on. Dennis Williams DBA, 80%OCP,

RMAN FILESPERSET

I'm a bit confused by the default for filesperset. I ran the following yesterday run { allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=2048M PARMS=SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so, ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);

Re: high cpu

I don't think they were updates . buth they were long queries .which went crazy due to some statistics changes last nite. I did got one temp tablespace shortage error as well. -ak - Original Message - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 2:25 PM

applying transactions

I've got a project where I get daily log files with inserts and deletes to keep a table current. I've set up an external table which contains the logs and a stored procedure reads from it and inserts or deletes from the table accordingly. Note one insert or delete per iteration. They're not

RE: How to put a TOP 1 in a select

That's a good approach to dealing with duplicates - wrap it up in another query with a group by clause to remove the duplicates. It looks like we've got your query down from never to around 30 seconds. Also since the analytical function is doing a window sort and you will then be doing another

RE: question about DynaLoader::dl_load_file from perl profiler output

Does this mean that there is nothing I can do for that part in terms of code optimization? My objective is to find which part the perl code I could try to optimize for speed. Guang On Wed, 11 Jun 2003, Matthew Zito wrote: IIRC, DynaLoader::dl_load_file looks for and physically loads an

Re: OT: question about DynaLoader::dl_load_file from perl profiler output

First off, you really need to join a Perl and/or DBI users list, found at lists.perl.org. DynaLoader is used to load modules at runtime. It's part of Perl, you don't need to be too concerned with it unless it's taking a lot of time. Jared gmei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: Urgent: Need Oradim.exe for version 8.1.6

Here si oradim for 8.1..6.3 if you still need it. Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Urgent: Need

RE: question about DynaLoader::dl_load_file from perl profiler output

Sure you could link Perl statically. Probably not a good idea. I suggest you move this to Perl mailing list. Jared Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: How to put a TOP 1 in a select

Yes,rank return duplicates, that why I have some items with two or more line per item. [EMAIL PROTECTED] 06/11/03 05:39PM That's a good approach to dealing with duplicates - wrap it up in anotherquery with a group by clause to remove the duplicates. It looks like we'vegot your query down

Re: Urgent: Need Oradim.exe for version 8.1.6

Oops, here it is again, zipped this time. I realized after sending the last one your email may filter out exe files. And then I realized I sent it to the list instead of you. Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L

Re: applying transactions

If you're on 8i+ you can use bulk loading. It could save you a lot of time on large loads such as this. Jared David Turner [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: Rule Based Optimizer

Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :) To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you

Re: Urgent: Need Oradim.exe for version 8.1.6

Crud! Sorry, replied twice to the list when I shouldn't have. D'oh! Jared Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

Re: applying transactions

Thx Jared, But I don't see how I could use loader to perform a delete. Sad to say but this isn't the typical load that I'm used to.. The load files contain inserts and deletes. I could set up a temporary table to load into which has a trigger fire on delete to remove rows from the destination

Re: applying transactions

Sorry, guess I wasn't clear. Bulk loading is done with PL/SQL, not sql loader. I should have referred to 'bulk binds'. Here are some URL's that may help. http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg10pck.htm#37506

Re: RMAN FILESPERSET

How did you join to get BS_KEY and FILE# together? I don't believe the BS_KEY from a backup database relate directly to a FILE# from the rc_views. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 12, 2003 10:25 AM I'm a bit confused

Re: applying transactions

Depending on the volume of the changes it may be worthwhile to drop and then recreate indexes on the destination table. Indexes are going to slow the transaction rate down considerably. One way to partly achieve this goal would be to perform all inserts into a temporary table which has no

  1   2   >