RE: Multithreaded server question

2002-03-20 Thread Jeroen van Sluisdam
Hi, The only way to limit your connections is through the max_sessions parameter. As far as I know there is no queuing mechanism for this available. About the price, only thing we experienced is dramatic performance in certain batch applications which run through sqlnet. In these cases you shou

Oracle Certification Upgrade 8 to 8i

2002-03-20 Thread Manoj Jain
Dear all, I have Oracle8 DBA certification. To upgrade there is following exam. 1Z0-020 ORACLE 8I: NEW FEATURES FOR ADMINISTRATORS Oracle announced : Oracle8 OCP Track Retirement As of March 31, 2002 Do anyone of you know if they will also retire 1Z0-020 ORACLE 8I: NEW FEATURES FOR ADMINIS

RE:

2002-03-20 Thread אדר יחיאל
Hello Victor Try to add and your_date in (select max(your_date) from whatever) Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Viktor [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 19, 2002 11:53 PM > To: Multiple recipients of list ORACLE-L > Subje

RE: Oracle Gold Support

2002-03-20 Thread Mark Leith
I agree, 98 is a pile of ... The thread management in 98 leaves a *lot* to be desired, and as Oracle is a single (multi-threaded) process on win32 platforms, it usually helps to get an OS that can handle these multiple threads "correctly". Upgrade to Win2K Pro.. 192Mb RAM is more than enough, jus

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Connor McDonald
Some rudimentary testing on a laptop here (500Mhz, 512M RAM, typical single disk) a) visiting a single block via 4,000,000 logical IO's got me approx 35000 gets/sec b) repeated full table scans similar system got me approx 350 phys reads/sec After this extensive, thorough and exhaustive exercis

RE: Looking for a Web Application Development Suite???

2002-03-20 Thread Mark Leith
Does this mean that I can get a free spam to the list as well?? :> GD&RLH -Original Message- Baumgartel Sent: 19 March 2002 16:48 To: Multiple recipients of list ORACLE-L Jared? Can you please go beat up these spammers? --- Runner Technologies Human Resources <[EMAIL PROTECTED]> w

iFS ppt

2002-03-20 Thread Szecsy Tamas
Hi, Could someone please point me to some good iFS power point slides? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Disk is cheap?

2002-03-20 Thread Bjørn Engsig
No. I/O capacity is basically proportional to the number of spindles you can have working in parallel for you at any one time. Thanks, Bjørn. On Tuesday 19 March 2002 20:58, Jenkins, Michael - EDS wrote: > Doesn't "creative" striping solve this problem to some extent? > > -Original Messa

RE: Looking for a Web Application Development Suite???

2002-03-20 Thread Jack van Zanen
Hi Mark, Sure you do, just wear your crash helmet and bullet proof vest :-) Take care Jack "Mark Leith"

Re: what pl/sql construct can return multiple rows?

2002-03-20 Thread Bjørn Engsig
Oracle9i supports this directly - look for pipelined PL/SQL functions. Thanks, Bjørn. On Tuesday 19 March 2002 14:58, Magaliff, Bill wrote: > Hi, > > Is there a way to write a procedure to return multiple rows? I have some > nasty SQL that I'd like to convert to run server-side, but how do you

RE: Looking for a Web Application Development Suite???

2002-03-20 Thread Mark Leith
Hiya Jack Oh I've got them on already! ;P Now donning my flame retardant suit! M. P.S. Had some fun with Chris the other week! ;P -Original Message- Zanen Sent: 20 March 2002 10:33 To: Multiple recipients of list ORACLE-L Hi Mark, Sure you do, just wear your crash helmet and bull

Re: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Bjørn Engsig
Cary Milsap from hotsos has much data to confirm an approximate 1:100 ratio between LIO time and PIO time. Can we therefore conclude, that the buffer cache hit ratio should be 99%? :-) Rgds, Bjørn. On Wednesday 20 March 2002 10:48, Connor McDonald wrote: > Some rudimentary testing on a laptop

RE: Oracle Certification Upgrade 8 to 8i

2002-03-20 Thread Hallas John
Title: RE: Oracle Certification Upgrade 8 to 8i Manoj I am in the same situation and looking at the IZO-020 exam as well. It is 8 that is due to retire , IZO-020 is an 8i exam. You have plenty of time to take the exam. John -Original Message- From: Manoj Jain [mailto:[EMAIL PROTE

RE: Disk is cheap?

2002-03-20 Thread אדר יחיאל
Hello Kimberly I meant on the point that loads all the cost of the infrastructure on the first disk in the new controller. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 19, 2002 10:24 PM >

Re: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Mogens Nørgaard
I always thought 42 was a good number. Perhaps I was wrong. Bjørn Engsig wrote: Cary Milsap from hotsos has much data to confirm an approximate 1:100 ratio between LIO time and PIO time. Can we therefore conclude, that the buffer cache hit ratio should be 99%? :-)Rgds, Bjørn.On Wednesday 20

Re: Oracle Certification Upgrade 8 to 8i

2002-03-20 Thread Ora NT DBA
Hi Manoj, Only the oracle8 exams are being retired in March of 2002. You can bet that the8i exams will be retired but not when :-). Typically the announcement is made far in advance. The official place to see these announcements is: http:/www.oracle.com/education/certification Best regards

Re: Oracle Gold Support

2002-03-20 Thread Igor Neyman
JoJo, Did you check, if 9i is certified to run on Win98? I doubt it. (though still might work, even - not being certified for this platform). Also, you mentioned, installation "bombs" on db creation. Could be, because default memory settings in default init.ora parameter file for "starter" db (

RE: what pl/sql construct can return multiple rows?

2002-03-20 Thread Jesse, Rich
You don't say what version you're using, but you could look at reference cursors. Search Oracle docs (tahiti.oracle.com) for "REFCURSOR". HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA ---

RE: what pl/sql construct can return multiple rows?

2002-03-20 Thread Magaliff, Bill
Could not find any specific examples of this usage . . . 1) must it be inside a package? could it just be defined in a procedure? 2) why IN/OUT? What's being passed in? 3) why open with no fetch? what does that accomplish? thanks much bill -Original Message- Sent: Tue,

More info on sql query running slow

2002-03-20 Thread Rick_Cale
Hi All, Oracle 8.1.6 I have 2 tables which have been analyzed. The query takes about 30+ seconds to run. If I run it many times it is faster as data gets loaded into buffer cache. I want to optimize when that is not the case. All the fields in the query have a separate index created EXCEPT for

Re: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Gaja Krishna Vaidyanatha
My dear friend Mogens, I am so glad we share the same kind of "bedtime reading" in our own parts of the world. I totally agree with you, every cache hit ratio and performance metric within Oracle needs to be 42, for us to be in a sublime and happy state...;-). After all "42" does solve all of lif

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Whittle Jerome Contr NCI
Depends on the question. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]] > > I always thought 42 was a good number. Perhaps I was wrong. > -- Please see the official ORACLE-L FAQ

RE: Oracle Gold Support/ iTARs

2002-03-20 Thread Jesse, Rich
The problem I've had with TARs and Oracle Support in general is actually getting a hold of someone in Oracle Support who knows what they are talking about. I had a TAR that I needed to explain basic DBA knowledge to the support person. And we're paying how much for Silver Support (or whatever it

RE: Is Couchman book good for OCP SQL & PLSQL

2002-03-20 Thread Freeman, Robert
Dennis, And my apologies for the semi-flame... I was having a stress filled day yesterday. One event was that I discovered what I think was a very unfair review on bookpool.com about the 9i book, and I was just a tad upset about it. I think you got more than your fare share of the brunt of it. My

RE: Oracle Gold Support

2002-03-20 Thread Freeman, Robert
Much prefer that solution myself. I was suggesting DBCA because I assumed this was his first NT install and thats why he wanted to use DBCA. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread DENNIS WILLIAMS
Connor - Cary Millsap presented the results of 10 trace files in a Hotsos seminar I attended. The ratio ranged from a high of 108.57 down to a low of 0.79. The point is that the ratio is nowhere near the oft-quoted 10,000. This means that logical I/Os are not insignificant. Even if physical I/O we

RE: ORACLE TUNING

2002-03-20 Thread SRAJENDRAN
Yes they both are, only difference being the amount of data in Prod and DEV databases for this query. Prod has more. Srini -Original Message- Sent: Tuesday, March 19, 2002 9:43 PM To: Multiple recipients of list ORACLE-L Are the tables/indexes analyzed the same way, if you use CBO?

cannot create bitmap index "feature not enabled"

2002-03-20 Thread Rick_Cale
Hi All, Oracle 8.1.6 SE I tried to create a bitmap index and but get feature not enabled. This cannot be only available in EE. Is there some script I need to run to enable creation of bitmap indexes. I have searched MetaLink but see no restrictions. Thanks Rick -- Please see the official ORA

RE: storing wave files in database(Oracle)

2002-03-20 Thread DENNIS WILLIAMS
Shibu - One piece of advice I received was that unless you are manipulating the audio/video data inside Oracle, you may be better off storing them in external files. Oracle has some overhead in storing and retrieving the data that may be significantly higher than just using the operating system. A

Difference in number of records returned using same SQL statement and same

2002-03-20 Thread Cherie_Machler
List, There is a report that I tuned last November. It worked great for months. Then a couple of weeks ago we started moving some of our indexes to disks that had been logically striped with Veritas volume manager.I rebuilt all of the indexes for a couple of partitioned tables and reanaly

RE: More info on sql query running slow

2002-03-20 Thread Hallas John
Title: RE: More info on sql query running slow The query in itself seems quite well optimised in my opinion, although 30 seconds does seem quite long relative to what is possible. What I do not understand is why the query uses the PCON_CMPY_FK index on the PHY_CONTRACTS table when that field

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Deshpande, Kirti
Not quite !! 99.999% or 'the five nines' sounds much better ;-) With 64-bit computing we can address SGA sizes in the order of few TBs (if not PBs), why worry about disk I/Os except for two occasions ;-)) Then the 'five nines' can be 'nine nines'. Wow!! That sounds even better.. much much bette

Re: cannot create bitmap index "feature not enabled"

2002-03-20 Thread Rick_Cale
Ignore question I just found on MetaLink that bitmap index is not part of SE which in IMHO is bulls..t Thanks Rick Rick Cale

RE: Disk is cheap?

2002-03-20 Thread Orr, Steve
Stiping cannot overcome PHYSICAL disk contention between redo logs, archived logs, database files, etc. 3 objectives: buffer I/O via cache; spread I/O via striping; and reduce contention via file segregation onto separate PHYSICAL devices. I want it all: cache, striping, and enough drives to PHYSI

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Mark Leith
Ahh, but how can you be sure that "42" does not also *cause* all of life's problems? ;) Does this also mean that the "preferred" number of disks, tablespaces, and extents should also be 42? ;> -Original Message- Krishna Vaidyanatha Sent: 20 March 2002 14:03 To: Multiple recipients of lis

RE: More info on sql query running slow

2002-03-20 Thread אדר יחיאל
Hello Rick How many records satisfy the selection without referring to the hold_payment_flag? How many of those have the flag set to 'y'? Are your indexes bitmaps or regular? Of the top of my head I will build bitmap indexes for all the fields, including hold_payment_flag. Yechiel Adar, Mehish

RE: ORACLE TUNING

2002-03-20 Thread SRAJENDRAN
Thank you I will look into this option. Can tell me more on this if have already implemented this feature. Srini -Original Message- Sent: Wednesday, March 20, 2002 1:58 AM To: Multiple recipients of list ORACLE-L hi Srini, Why don;t you use stored outlines. -Original Message

RE: ORACLE TUNING

2002-03-20 Thread SRAJENDRAN
Thank you.. Buffer cache is smaller on DEV. What specific parameters are you refering you? Indexes are in the same order. -Original Message- Sent: Tuesday, March 19, 2002 5:52 PM To: Multiple recipients of list ORACLE-L buffer cache size the same ? init.ora parameters the same ? index

Re: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Anjo Kolk
Yapp, feel the new tuning force ;-) DENNIS WILLIAMS wrote: > Connor - Cary Millsap presented the results of 10 trace files in a Hotsos > seminar I attended. The ratio ranged from a high of 108.57 down to a low of > 0.79. The point is that the ratio is nowhere near the oft-quoted 10,000. > This m

RE: ORACLE TUNING

2002-03-20 Thread SRAJENDRAN
Both have current statistics. Data distribution is smaller on DEV. Both are using CBO. -Original Message- Sent: Tuesday, March 19, 2002 4:53 PM To: Multiple recipients of list ORACLE-L What about current statistics on both DBs? Is the distribution of the data reasonably the same? Are

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Farnsworth, Dave
And the "preferred" work week only be 42 hours!! -Original Message- Sent: Wednesday, March 20, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Ahh, but how can you be sure that "42" does not also *cause* all of life's problems? ;) Does this also mean that the "preferred" number o

RE: More info on sql query running slow

2002-03-20 Thread Stephane Faroult
Rick, Curious to know how this would perform : SELECT COUNT(a.phy_contract_id) FROM accrued_and_paid a, (select phy_contract_id from phy_contracts where company_id = 16 and contract_type = 'IC') b WHERE a.hold_payment_flag = 'Y' AND

RE: More info on sql query running slow

2002-03-20 Thread Rick_Cale
Hi Only 928 records satisfy flag set ot 'Y'. Unfortuneately they have standard edition which does not support bitmap indexes. I did create an index on hold_payment_flag in my test database and the cost went from 3347 to 413. Time went from 38 seconds to 1 second. I will have to see what

RE: cannot create bitmap index "feature not enabled"

2002-03-20 Thread Hallas John
Title: RE: cannot create bitmap index "feature not enabled" Try granting the query_rewrite and query_rewrite_enabled (check spelling first) privileges to the user -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March 2002 14:28 To: Multiple recipients o

Re: cannot create bitmap index "feature not enabled"

2002-03-20 Thread Joe Raube
It's only available in Enterprise Edition, see docs at http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76962/ch4.htm#52939 -Joe --- [EMAIL PROTECTED] wrote: > Hi All, > > Oracle 8.1.6 SE > > I tried to create a bitmap index and but get feature not enabled. > This

RE: Is Couchman book good for OCP SQL & PLSQL

2002-03-20 Thread DENNIS WILLIAMS
Robert - Not a problem. I feel that my email was too brusque, so I was asking for it. I need to work harder on smoothing out my emails. But I really appreciate first of all that people like you are willing to devote their time to writing books for the benefit of the rest of us. If I wanted to make

Houston, TX- Oracle DBA/Web Developer Needed

2002-03-20 Thread OraStaff
Houston Texas company needs an Oracle DBA/Web Developer to join its' I.T. team. PLEASE DO NOT send your resume for this position UNLESS you aalready live in the Houston area and have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history (no j

RE: cannot create bitmap index "feature not enabled"

2002-03-20 Thread Hallas John
Title: RE: cannot create bitmap index "feature not enabled" Forget my previous reply regarding query_rewrite privileges  - I misread it as a FBI question not a BMI one - enough of these TLA BFN! John -Original Message- From: Joe Raube [mailto:[EMAIL PROTECTED]] Sent: 20 March

PCTFREE and PCTUSED

2002-03-20 Thread Pablo ksksksk
How can I calculate the values I should set PCTFREE and PCTUSED for a table that has already been created. can I use the statistics for that? thank you. Pablo ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con t

A RMAN question

2002-03-20 Thread SARKAR, Samir
Hi All, Though I have been using RMAN for quite a while now, I would like to ask for a clarification here. We have a production database with partitioning options on server A. We copy over the files (including the control files) of the prod database each night to a server B. We will then be us

Oracle Exports and performance

2002-03-20 Thread Smith, Ron L.
This has probably been discussed before but I would like to know if a full database export could affect either Oracle or server performance. Also, does a consistent=y export only mean that each table is consistent or is the entire database consistent? Ron Smith DBA Kerr-McGee Corp -- Please

RE: More info on sql query running slow

2002-03-20 Thread Rick_Cale
Steve, That query took about 52 seconds to run. Thanks Rick "Stephane

OT -- 42 [RE: Fav. Urban Legend...Mem vs Disk]

2002-03-20 Thread Deshpande, Kirti
And 'preferred' rate : $42/hour? $42/minute? $42/42 seconds (That will solve some (42?) of my life's problems :) Gaja is finally back (after 42 weeks of disappearance;) Welcome Back :) I will now go back to packing my cube(in 42 boxes :) to move to a new small cube (42 SQ FT. And that's not

Oracle Financial Analyzer Question

2002-03-20 Thread Jamadagni, Rajendra
Hi all, just a basic question it was mentioned in a meeting that our OFA instance gets so much fragmented that it needs to be rebuilt every week. Is that true with everyone ?? BTW this is on NT (please don't ask me why). Are there any ways to get around this fragmentation? The DB size seems

Re: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Alan Davey
On 3/20/02, Mark Leith <[EMAIL PROTECTED]> wrote: >Ahh, but how can you be sure that "42" does not also *cause* all of >life's >problems? ;) Because, as Homer Simpson said, "Ahhh booze. The cause of and the solution to all of life's problems." ;^) -- Alan Davey [EMAIL PROTECTED] On 3/20/0

CPU usage for each oracle instance

2002-03-20 Thread Anne Yu
Hey list, In the system accounting report, I can get the total CPU usage for ORACLE. However, I have 7 instances on this box. How can I get the total CPU usage for each Oracle instance?Any ideas? Million thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

RE: cannot create bitmap index "feature not enabled"

2002-03-20 Thread DENNIS WILLIAMS
Rick - Hmmm. I'm looking at a document that says MS SQL doesn't have bitmap indexes. My dark suspicion is that may have something to do with that feature not being included in SE. But I'm pretty paranoid. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wedn

Use of Orastaff

2002-03-20 Thread Donald Bricker
I am assuming that since Orastaff continues to post positions on to this list that they are reputable. Is there anyone out there that is willing to share their experiences with this company. Did you get interviews? Did you obtain a position? etc   Thanks     Don BrickerDatabase Administrator

Re: PCTFREE and PCTUSED

2002-03-20 Thread Charlie Mengler
I have some PL/SQL code which looks for chained rows once a week and unchains them when the chained rows count exceeds 5% of the total number of rows. Inside this code for each table where the unchaining occurs I increase PCTFREE by 5 and decrease PCT used by 5. The goal is to achieve equilibrium

Re: PCTFREE and PCTUSED

2002-03-20 Thread Pablo ksksksk
I see, Charlie. Thanks for answering. I'm not trying to avoid chained rows, I think that Buffer busy waits may be ocurring in the header of this segment because the gap between the PCTUSED and PCTFREE might be too small. What I want is to check this and all tables as well and set this GAP corre

db_block_buffers

2002-03-20 Thread Holgado Martin Jose Carlos
Hi, How can i estimate the correct number of db_block_buffers?. I have read that it shold be approximately 1% or 2% of the total database size. Thanks José Carlos - -- Please see the official ORACLE-L FAQ: http://www.oraf

Re: Houston, TX- Oracle DBA/Web Developer Needed

2002-03-20 Thread mitchell
> PLEASE DO NOT send your resume for this position UNLESS you aalready live in > the > Houston area and have the skills outlined below for this position. PLEASE DO NOT sent your mail for this purpose UNLESS you want to hire the guy where ever they are. joke for a day. Mitchell - Original M

Re: Oracle Exports and performance

2002-03-20 Thread Diego Cutrone
Hi Ron: Comments inline HTH greetings Diego Cutrone - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 1:18 PM > This has probably been discussed before but I would like to know if a full > database > export could affec

Re: Use of Orastaff

2002-03-20 Thread bill thater
[EMAIL PROTECTED] wrote: > I am assuming that since Orastaff continues to post positions on to this > list that they are reputable. Is there anyone out there that is willing > to share their experiences with this company. Did you get interviews? > Did you obtain a position? etc i have sent m

Big news regarding Oracle licensing...

2002-03-20 Thread Jim Hawkins
Please read the following article and try not to choke... http://investor.cnet.com/investor/news/newsitem/0-9900-1028-9407413-0.html?tag=ltnc Pricing change irks Oracle customers By: Alorie Gilbert 3/19/02 5:25 PM Source: News.com A pricing disagreement between Oracle and some of its databas

RE: Oracle Gold Support

2002-03-20 Thread JoJo Al-Zawawi
Hi Igor, Yes, 9i "Personal Edition" is certified to run in Win 98. I've love to upgrade to Win2K but it's just not feasible at the moment. I have so much crap on there, configured, DSL here, VPN there, InterDev that, and so on and so on (crappola for work) -- it would be a massive pain that I j

Oracle replication

2002-03-20 Thread Farnsworth, Dave
I am beginning to read on Oracle replication. I will need to eventually replicate from Oracle to a DB2 database. Has anyone done this and if so, was it a total pain to set up? Also, besides TFM and some docs on metalink, does anyone have any good links to any papers or articles on Oracle rep

Re: PCTFREE and PCTUSED

2002-03-20 Thread Anjo Kolk
Bad things will happen, it just a question of how expensive these waits are. I have a feeling that they don't contribute much to the overall performance problem. Besides that pcfree/pctused will determine when blocks are put on the freelist and when not. So probably what you want is multiple freel

Failover

2002-03-20 Thread David Turner
I set up two independent readonly databases and a tns alias that would allow failover in the event that one of the databases or listeners goes down and thought I would have no downtime only to find this isn't the case. If one of the boxes has a severe load put on it and connections begin to time

Re: Use of Orastaff

2002-03-20 Thread Brian_P_MacLean
I have tried 4 times to contact them over the last several years. All for jobs, skill sets, and locations that matched my personal profile. I have never even received a "we received you email" reply. Looks like a good quality organization to meNOT Brian P. MacLean Oracle DBA, OCP8i

Re: Use of Orastaff

2002-03-20 Thread Joe Raube
I have sent my resume to them, and called them on the phone - no one ever responded to me. -Joe --- bill thater <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > I am assuming that since Orastaff continues to post positions on > to this > > list that they are reputable. Is there anyo

Re: Use of Orastaff

2002-03-20 Thread Gene Sais
I 2nd that. >>> [EMAIL PROTECTED] 03/20/02 01:21PM >>> I have tried 4 times to contact them over the last several years. All for jobs, skill sets, and locations that matched my personal profile. I have never even received a "we received you email" reply. Looks like a good quality organization

RE: Use of Orastaff

2002-03-20 Thread Gogala, Mladen
I used them to test the program called "mailfilter" which can be found on freshmeat. I'm happy to report that the program works very, very well. Many thanks to OraStaff and OraKnowledge! You just need to put something like DENY=^From:.*ora(staff|knowledge) in $HOME/.mailfilterrc and you w

RE: Oracle Gold Support/ iTARs

2002-03-20 Thread John Kanagaraj
Ian and the list, iTARs are part and parcel of the Oracle Apps world - you wouldn't believe the number of iTARs that needed to get opened, especially during testing/implementation of new versions. I have seen upto 10 - 15 TARs being opened per day during such times, esp. with 11i installations...

RE: Use of Orastaff

2002-03-20 Thread Lyuda Hoska
One thing I've noticed.. their positions always for local candidates only.. no relocation assistance.. -Original Message- Sent: Wednesday, March 20, 2002 1:21 PM To: Multiple recipients of list ORACLE-L I have tried 4 times to contact them over the last several years. All for jobs, sk

RE: Multithreaded server question

2002-03-20 Thread Jeremiah Wilton
You can also limit the number of connections per dispatcher with the (CONNECTIONS=) attribute of the MTS_DISPATCHERS initialization parameter. This also does not queue incoming connections, but causes incoming connections to hang, then time out. It sounds like what Andrey needs is a function of

Re: Use of Orastaff

2002-03-20 Thread Ron Rogers
You must not be holding your mouth right. I sent my resume to orastaff and have had 1 in-person interview (out of state, local person selected) and 1 telephone interview(out of state, no relo offered). My dealings with their organization have been very professional and courteous. It does take a w

strange tkprof output for SQLs - II

2002-03-20 Thread Danisment Gazi Unal (Unal Bilisim)
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for SQL. Here are the steps: SQL > alter session flush shared_pool; SQL > alter session set sql_trace=true; SQL > insert into test select * from test; SQL > alter session set sql_trace=false; FROM DICTIONARY: SVRMGR> select

strange tkprof output for PL/SQLs

2002-03-20 Thread Danisment Gazi Unal (Unal Bilisim)
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for PL/SQL. I've enabled sql_trace from another session by DBMS_SYSTEM.SET_EV(). Here are my observations and questions: - The caller PL/SQL package are seen at the end of the raw file as below: PARSING IN CURSOR #1 len=19 d

RE: A RMAN question

2002-03-20 Thread DENNIS WILLIAMS
Samir - We have found that each Oracle database has an internal ID. This ID doesn't change when you clone it as you describe. RMAN uses this ID, and will become confused if it sees two databases that are identical. One way around this is to run two RMAN catalogs. I have not considered it an advant

Re: PL/SQL Question

2002-03-20 Thread Big Planet
create a function getSoftwares(p_licence_id ) which returns varchar2 string of softwares and then simply run query on licence table select licence_id , getSoftware(licenceid) from licence ; I hope you know what to write in getSoftwares . -ak - Original Message - To: "Multiple recipi

RE: Use of Orastaff

2002-03-20 Thread Koivu, Lisa
I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really got his attention was "No relocation reimbursement required, we are moving to Flori

Re: PCTFREE and PCTUSED

2002-03-20 Thread Pablo ksksksk
Thanks for the answer ANJO, "Besides that pcfree/pctused will determine when blocks are put on the freelist and when not. So probably what you want is multiple freelists to take care of single freelist contention." Let me ask you something about this. The problem of having a small gap between P

RE: Oracle Exports and performance

2002-03-20 Thread Ball, Terry
Just one comment. Back on O7, some testing was done by one of the DBAs where I used to work. He determined that the consistency was within a schema, not the whole export. SO if you had cross references between schemas, you could experience problems on imports. I don't know if this "functional

RE: Use of Orastaff

2002-03-20 Thread Farnsworth, Dave
Lisa, You have been missed on the off-topic list!! -Original Message- Sent: Wednesday, March 20, 2002 1:25 PM To: Multiple recipients of list ORACLE-L I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a posit

Re: Use of Orastaff

2002-03-20 Thread Ruth Gramolini
Lisa, Your're back! How are things going? You need to come back to the OT list! Rutj - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 2:25 PM > I got a response from them once, when I first moved down here. The market

Re: More info on sql query running slow

2002-03-20 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: > > Steve, > > That query took about 52 seconds to run. > > Thanks > Rick > > > "Stephane > Faroult" To: Multiple recipients of list >ORACLE-L <[EMAIL PROTECTED]> > eco

RE: Length of LONG datatype - ANSWER !!!

2002-03-20 Thread Rusnak, George A.
DECLARE my_long_var LONG; len_long_var VARCHAR2(10); CURSOR get_rec IS SELECT key_column, long_column FROM table_name ORDER BY key_column; BEGIN FOR x_rec IN get_rec LOOP my_

RE: Oracle Gold Support/ iTARs

2002-03-20 Thread Kimberly Smith
There is another level of support that you can get were an analyst is dedicated to your site. He may not be on site but he gets 4 or 5 accounts that are his and its all he (or she) does. We were looking into it and decided it really was not necessary in our case. -Original Message- Sent

RE: Oracle Gold Support

2002-03-20 Thread Kimberly Smith
Actually personal Oracle is certified on 98 -Original Message- Sent: Wednesday, March 20, 2002 5:33 AM To: Multiple recipients of list ORACLE-L JoJo, Did you check, if 9i is certified to run on Win98? I doubt it. (though still might work, even - not being certified for this platform).

RE: Is Couchman book good for OCP SQL & PLSQL

2002-03-20 Thread Kimberly Smith
ok, enough of the love fest :-) -Original Message- WILLIAMS Sent: Wednesday, March 20, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Robert - Not a problem. I feel that my email was too brusque, so I was asking for it. I need to work harder on smoothing out my emails. But I re

RE: Oracle Gold Support

2002-03-20 Thread Kimberly Smith
No man, your life will be so much easier on 2000 even with all the crap you mentioned. First off, I have done quite a few upgrades of 98 and all were well. But even if you did a fresh install it would be no more then half a day for years of piece and quite. -Original Message- Al-Zawawi

RE: A rollback segment question on minextents

2002-03-20 Thread kumanan . balasundaram
OK, Thanks to all of you for the input. Only if we can can have a big storage to put all the Oracle internals into our brains :) There is a nice article in Metalink : Note 62005.1 Cheers Kumanan > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: 15 March 2

Re: Use of Orastaff

2002-03-20 Thread Bill Conner
i have never received any kind of response from them ever and always made sure that i was qualified for the posting before responding. At 10:21 AM 3/20/2002 -0800, you wrote: >I have sent my resume to them, and called them on the phone - no one >ever responded to me. > >-Joe > >--- bill thater <

Rebuilding Index Organised Tables (IOTs)

2002-03-20 Thread kumanan . balasundaram
Is that possible? Thanks Kumanan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: Use of Orastaff

2002-03-20 Thread Ron Rogers
Lisa. Welcome back. Ron ROR mô¿ôm >>> [EMAIL PROTECTED] 03/20/02 02:25PM >>> I got a response from them once, when I first moved down here. The market was frantic at that point and I had already accepted a position. I even spoke to Bill Law himself for a brief moment. I think what really

Re: Use of Orastaff

2002-03-20 Thread sdlockhart
Ruth, What is the procedure to subscribe to the OT list, please? TIA, Scott Lockhart -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public In

Re:RE: Use of Orastaff

2002-03-20 Thread dgoulet
First, Lisa, welcome back on line. I regret to say that I did not notice until someone mentioned it in a previous reply at which time I had to remove the baseball bat from the face! :-) Second as to OraStaff. I replied to one of their posts only to have Bill reply that it was really a SQL*Serve

Re:Rebuilding Index Organised Tables (IOTs)

2002-03-20 Thread dgoulet
Kumanan, If you mean via the "alter index rebuild" command, NO. Via other methods, YES. Exp/Imp works. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 3/20/2002 12:50 PM Is that possible? Thanks Kumanan -- Please see the officia

RE: Fav. Urban Legend...Mem vs Disk

2002-03-20 Thread Connor McDonald
I think you may have missed my sarcasm - I've been on the anti-cache hit ratio bandwagon for a long time... Cheers Connor --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Connor - Cary Millsap presented the results of 10 > trace files in a Hotsos > seminar I attended. The ratio ranged from a hi

  1   2   >