anyone use pipelined functions?

2003-12-31 Thread ryan_oracle
I read the little blurb in the 9i new features on it. The example there doesnt seem very useful. What have people used it for? any good articles with good examples on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]

Bug with automatic undo management?

2003-12-31 Thread ryan_oracle
I have a TAR open on this and Im arguing with the Oracle tech support guy. Here is what happened. We upgraded an instance to 9i. Switched to automatic undo management. Set our undo parameters to point to a newly created undo tablespace. 1. took our old rollback tablespace(with rollback

is it possible to force different 'types' of index scans?

2003-12-30 Thread ryan_oracle
I know you can hint a fast full scan. I have run into cases lately where depending on circumstances Oracle will use an index, but use a sub-optimal type of index scan with dramatic differences in performances. This is on 9.2. Any hints for forcing an 'index range scan'. Anything stronger than

Re: RE: large pl/sql table sucking up all memory on a server

2003-12-30 Thread ryan_oracle
i know about the limit clause. I just want to keep someone else from bringing down an instance. I think Ill get a taser and fry the next person who does it. :) From: zhu chao [EMAIL PROTECTED] Date: 2003/12/29 Mon PM 10:34:24 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
I have a very strict SLA and I posted a question on asktom about the best way to get the 'estimate' of rows and return it to the user. Im getting 'no data found'. anyone have ideas? Im on 9.2, tables are analyzed, and Im in a DBA account. my question is at the bottom.

Re: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
im concerned about hitting the v$views in production. we have 30,000 users. its either that or do counts. Its a requirement from the users. not sure what to do. doesnt tom kyte do this on asktom? From: Wolfgang Breitling [EMAIL PROTECTED] Date: 2003/12/30 Tue PM 12:09:33 EST To: Multiple

Re: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
anyone have a better way to do this? im going to post what you said wolfgang on asktom and see what he has to say. From: Wolfgang Breitling [EMAIL PROTECTED] Date: 2003/12/30 Tue PM 12:09:33 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: help with estimate row

RE: Re: help with estimate row count from asktom

2003-12-30 Thread ryan_oracle
i could have swarn i read in multiple places that in a high transaction system hitting v$views repeatedly kills performance? causes excessive latching? ill have to test it to see if this is better than a count. Gonna be ugly either way. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date:

Re: DBA Unemployment

2003-12-29 Thread ryan_oracle
that isnt a reliable statistic. doesnt track people forced to take low paying temp jobs either. besides, anyone can tell you that the job market is bad, by just putting out a job ad. when you get 100-150 resumes for 1 job... its a tight labor market. From: DENNIS WILLIAMS [EMAIL PROTECTED]

large pl/sql table sucking up all memory on a server

2003-12-29 Thread ryan_oracle
One of our guys used a very large bulk collect into with a forall update. It sucked up all the swap space on our solaris box and noone could connect to it. So we had to bounce the server. I was under the impression that pl/sql tables go into the buffer cache and cannot go large than its size?

Re: A performance problem

2003-12-29 Thread ryan_oracle
the sqlnet is a network issue. talk to your SAs. is the other database on a different server? work from there. your big one is your read. could mean your SGA is too small. is anything else running at this time? are you sure there is an equivalent amount of work to do? are you sure there isnt

ref cursors and parsing

2003-12-29 Thread ryan_oracle
do ref cursors always do a hard parse? or can i get them to always do a soft parse? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RE: large pl/sql table sucking up all memory on a server

2003-12-29 Thread ryan_oracle
we dont have that level of granularity. everyone developers out of the same DBA account(not my call). any parameter settings to limit the size of pl/sql tables? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/12/29 Mon PM 12:14:24 EST To: Multiple recipients of list ORACLE-L [EMAIL

Re: RE: large pl/sql table sucking up all memory on a server

2003-12-29 Thread ryan_oracle
3 million records in a forall statement. we are bringing on temps and you know how that goes... Im hoping I can set a parameter somewhere to keep anyone from bringing down a server. such as 'memory for pl/sql table area limit hit' errors out what he is doing. i guess not :( From: Khedr,

Re: RE: large pl/sql table sucking up all memory on a server

2003-12-29 Thread ryan_oracle
it filled up the pga and then used 'swap' space on the hard drive. this filled up. didnt realize this was a feature. yeah, I know i can 'tell' them to do it. I was hoping to disallow it though. From: Bobak, Mark [EMAIL PROTECTED] Date: 2003/12/29 Mon PM 01:24:25 EST To: Multiple recipients

Re: RE: A performance problem

2003-12-29 Thread ryan_oracle
you mean a dbms_job? execute immediate 'turn trace on' inside what ever is being called. then check it. or just run it manually. From: Potluri, Venu (CT Appl Suppt) [EMAIL PROTECTED] Date: 2003/12/29 Mon PM 01:09:29 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

Re: RE: A performance problem

2003-12-29 Thread ryan_oracle
go to metalink and get 'trace analyzer' read the install instructions. It will extract wait events from your output. if your in 9i and up wait events are in the tkprof. i think you have to do a 10046 trace to get the wait events? not just a sql_trace. From: Potluri, Venu (CT Appl Suppt)

getting estimate of result set from v$sql_plan

2003-12-29 Thread ryan_oracle
can someone send me the query I use to hit v$sql_plan to get my estimated cardinality for a query? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: Re: getting estimate of result set from v$sql_plan

2003-12-29 Thread ryan_oracle
i need to return the cardinality estimate to the user as a number. how do i do that? From: Stephane Faroult [EMAIL PROTECTED] Date: 2003/12/29 Mon PM 04:29:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: getting estimate of result set from v$sql_plan [EMAIL

Re: RE: Database Instance

2003-12-26 Thread ryan_oracle
i believe tom kyte recommends putting them in one or a few instances and using VPD to handle security. He claims it scales better. I believe its in his second book and on his website. However, Thomas is right. You really dont want 13 instances together for maintenance reasons. Some may need

please help with materialized view question

2003-12-26 Thread ryan_oracle
Im sure its a privilege issue. 1. I have 3 tables with two different owners 2. I want to create a materialized join view of these tables in a 3rd user account. 3. I altered the session to enable query rewrite and query_rewrite_integrity=trusted 4. I granted query rewrite enabled to every owner

Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
I figured it out. I have another problem. I create my materialized view. I now want to write a query that joins it to a transactional table. I want to use query rewrite. Problem is the join is not on the primary key of either table. Is it possible to enable query rewrite without that? I have

Re: Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
I figured it out. I need some help with query re-write. Im not sure its possible. My materialized view joins 3 tables on the primary key/foreign key. I have a query that would join that materialized view to a third transactional table, but that join is not on any primary key or foreign key. I

Re: Re: please help with materialized view question

2003-12-26 Thread ryan_oracle
my bad on the explanation. I have 4 tables. 3 are non-transactional. These are joined in a primary key/foreign key relationship. These are going in the materialized view. I want to join my 4th table to my materialized view. 1. The application current has code that joins all 4 tables. I dont

Re: RE: Hit Ratio

2003-12-23 Thread ryan_oracle
are there really that many people who use hit ratio? From: Cary Millsap [EMAIL PROTECTED] Date: 2003/12/23 Tue AM 11:49:33 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Hit Ratio Yong, Connor's script is not a joke, it's a proof by counterexample that the

does CPU usage matter when scaling?

2003-12-23 Thread ryan_oracle
The softwrae engineers are measuring CPU usage. I usually ignore this and dont care about that value. I dont have any docs on it. anyone have any docs on this? or am I wrong? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED]

Re: RE: does CPU usage matter when scaling?

2003-12-23 Thread ryan_oracle
the cpu right now is high because they are not-using bind variables. Which is being fixed. So I was ignoring CPU usage. Ive read that article. I dont remember any CPU material in there. I just focused on LIOs and didnt realize I needed to monitor CPU. However, high LIOs will lead to high CPU

ASM question

2003-12-22 Thread ryan_oracle
I decided to play around with ASMs and use the statspack tablespace as my trial balloons(lots of inserts and deletes and I dont care about fragmentation). anyway I just ran SPCREATE. Wierd thing is that there is no data in any of my statspack tables, but their segments sizes vary from 1m to

Re: ASM question

2003-12-22 Thread ryan_oracle
hmmm... odd there is no setting for pct_used on tables, but different settings for percent free. Different settings for initial extent to between tables. anyone have more info on how this 'intelligent' algorithm works? I heard kyte speak last week and he assured us that the algorithm is good

Re: ASM question

2003-12-22 Thread ryan_oracle
ignore spcreate.sql actually puts pctfree,pctused, and really bad initial and next extent settings on the tables. its an antiquated script that hasnt been updated. my bad. From: [EMAIL PROTECTED] Date: 2003/12/22 Mon AM 09:09:26 EST To: Multiple recipients of list ORACLE-L [EMAIL

Re: Exporting a partition with transport tablespace

2003-12-22 Thread ryan_oracle
transportable tablespaces need to be totally self-contained. everything that is being transported has to be in that tablespace. it doesnt matter if its a different datafile. you probably have your partitions in seperate tablespaces? or am i wrong? From: NGUYEN Philippe (Cetelem) [EMAIL

Re: Exporting a partition with transport tablespace

2003-12-22 Thread ryan_oracle
wait or are you just trying to transport 1 partition? i think you have to do regular export and import. From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED] Date: 2003/12/22 Mon AM 10:34:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Exporting a partition with

Re: RE: Hit Ratio

2003-12-22 Thread ryan_oracle
i dont think many people are using bchr anymore. I think its been talked down to death. only place I hear about it is offshore. people still using the old niemic book. his new took all that stuff out. or am i wrong? From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/12/22 Mon PM 02:14:26 EST

stress tests for a scale to 30,000 users

2003-12-22 Thread ryan_oracle
My estimate right now is about a 500GB instance(but could grow). There are several complexities. 1. high transaction system, but also will have alot of long running queries 2. We deliver data daily and rebuild large parts of the database nightly with loads. Im not certain I have the window to

10g new features question for beta testers

2003-12-19 Thread ryan_oracle
I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs

Re: RE: 10g new features question for beta testers

2003-12-19 Thread ryan_oracle
no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you

RE: RE: Career Advice

2003-12-19 Thread ryan_oracle
the last two projects I have been on we are using client server with .Net. Tons of .net people, verify few database people. oracle is pushing jdeveloper hard. You need skilled java people to use that. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:44:25 EST To:

what is business intelligence?

2003-12-19 Thread ryan_oracle
I see this alot when people look for data warehouse people. any idea what is meant by this? Not look for the obvious oxymoronic joke. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services--

Re: RE: 10g new features question for beta testers

2003-12-19 Thread ryan_oracle
SAME is stripe and mirror everything. There is a doc on otn by that name. ASMs will do that for you, 'in theory'. kyte is the technical face of oracle. This is why they pay him so much money. presentation would have been better if people didnt play 'stump the dba'. It seems like people were

Re: Re: Any known problems using NOT IN ?

2003-12-18 Thread ryan_oracle
btw, a straight not in without a hash_aj, tends to get hideous bench marks. From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/12/18 Thu AM 09:14:24 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Any known problems using NOT IN ? Actually, because relational

Re: Re: Any known problems using NOT IN ?

2003-12-18 Thread ryan_oracle
uhh... thats not exactly true. oracle is a bastardization of set theory. there are alot of cases where 'not exists' and 'not in'(if doing a hash anti-join' are much superior to minus. here are some generalizations. 1. not in with a hash_aj is the best if -- your sub-query is significantly

Re: RE: Career Advice

2003-12-18 Thread ryan_oracle
your goals should tie into the job market. you might absolutely love Pascal programming, but I dont recommend studying it. Right now(and I dont know how it will fluctuate), there is far, far, far more demand for Software Engineers who specialize in Java or .Net. Far, far, far, more than people

RE: RE: Career Advice

2003-12-18 Thread ryan_oracle
my biggest concern is the model for development has been changed. The model now is do most development with software engineers and have only a small number of database people. this means less pure oracle jobs. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/12/18 Thu PM 02:59:26 EST To:

Re: Re: Career Advice

2003-12-17 Thread ryan_oracle
learn java and object oriented programming. go to sun.com and start reading the java docs. go to www.bruceeckel.com and read his java book. do a search on any job sites. a ton more work for java than oracle. people who can do both are in demand. From: Mladen Gogala [EMAIL PROTECTED]

RE: Re: Who are certified Oracle Masters?

2003-12-17 Thread ryan_oracle
DC area is insanely expensive. you can spend $300,000 for a condo. Traffic is very bad also and getting worse. it doesnt get 'affordable' until you get up to frederick or in virginia near manassas or west of leesburg. with all the government money and the private sector IT stuff in free

Re: Good news from Oracle

2003-12-16 Thread ryan_oracle
the question for technical people is where the sales are located. are they in the US? or somewhere else From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/12/16 Tue AM 08:59:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Good news from Oracle Oracle is

connection pooling from an application server to oracle

2003-12-15 Thread ryan_oracle
The software engineers here are using an application server with connection pooling to connect to our oracle instances. They are doing it with a dedicated connection to Oracle. No MTS. they compartmentalize stuff here, so Im having trouble figuring out exactly how this affects the database and

Re: RE: connection pooling from an application server to oracle

2003-12-15 Thread ryan_oracle
doesnt this force you to commit after every single DML statement? From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/12/15 Mon AM 08:36:09 EST To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: connection pooling from an application server

Re: RE: connection pooling from an application server to oracle

2003-12-15 Thread ryan_oracle
so if user A has 10 DML statements to do in one transaction. The application server will be smart enough to to only allow user 'A' to use that connection until a 'commit' is issued? how does application level connection pooling compare to MTS? From: Rachel Carmichael [EMAIL PROTECTED]

permanently changing the 'optimal' setting

2003-12-12 Thread ryan_oracle
I change it with an alter rollback segment, but when i bounce the instance, it goes back to the default of 1m. is there a way to make the change permanent? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network

Re: Re: Who are certified Oracle Masters?

2003-12-12 Thread ryan_oracle
how many people are actually OCMs? and those of you that are, has it helped you in getting work? From: Richard Foote [EMAIL PROTECTED] Date: 2003/12/12 Fri AM 07:54:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Who are certified Oracle Masters? Hi

Re: OT: More Advances in Netwotking to Support the Grid

2003-12-12 Thread ryan_oracle
how do you move over to the academic database world? it seems like the most interesting stuff is going on there? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/12 Fri AM 11:29:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: More Advances in

Re: Little competition

2003-12-11 Thread ryan_oracle
i meant automatic segment management has fragmentation issues. From: Richard Foote [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 06:39:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Little competition Little competition for you all :) It's a two part question:

Re: Little competition

2003-12-11 Thread ryan_oracle
who wrote that? automatic undo management has fragmentation issues. Niall Litchfield posted a test case a couple of months ago. From: Richard Foote [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 06:39:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Little

Re: Little competition

2003-12-11 Thread ryan_oracle
hopefully i wont sound like a complete idiot, but what is wrong with wanting to be able to handle your own pctfree and pctused. Ok oracle handles the next and initial extent sizes...(which causes fragmentation). I use transportable tablespaces and in order to increase the time it takes to copy

Re: Re: Little competition

2003-12-11 Thread ryan_oracle
Ive been working on 'large' distributed databases lately and its not as high as alot of arrogant people make it out to be. Its just different. Im not sure tuning a database with alot of data and fewer transactions like in a datawarehouse necessarily 'harder' than tuning a higher transaction

Re: Re: Little competition

2003-12-11 Thread ryan_oracle
yeah typical burleson carelessness then. anyone can make that mistake, but if your going to publish you should be more careful. should have known. From: Tim Gorman [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 08:34:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

Re: Re: Little competition

2003-12-11 Thread ryan_oracle
#1. these instances are still on 8i. We are supposed to go to 9i, but its not my call #2. its read only for the users. We do batch loads at night and I did not notice any slow down in the loads. I run statspack regularly. no problem. Just gotta do an alter table move periodically when we get

Re: Re: Strange behavior with dbms_stats...

2003-12-11 Thread ryan_oracle
put it into a a dbms_output to see what is passed as variables then wrap it in execute immediate. your doing dynamic pl/sql. i think that will work. From: anu [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 11:54:35 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:

Re: RE: Little competition

2003-12-11 Thread ryan_oracle
oracle literature is really lacking in entry level docs anyway. The concepts document is way too large to be digestable by someone new to the topic. What we really need is: simple SQL book for newbies simple PL/SQL book for newbies Architecture book automatic features Beginning Oracle

Re: 3rd Party Oracle Licenses

2003-12-11 Thread ryan_oracle
you need to contact oracle sales to make certain. The obligation is on your company double check. i doubt what they are saying is true. please post what you find out. From: Jay Hostetter [EMAIL PROTECTED] Date: 2003/12/11 Thu AM 09:14:26 EST To: Multiple recipients of list ORACLE-L [EMAIL

Re: Performance tuning in complex environment

2003-12-11 Thread ryan_oracle
DBAs should never 'guess' about performance. If they are guessing you need new DBAs. They should be running statspacks, sql trace, and looking at timing data. Its too much to explain in an email. Fire your DBAs and find people who dont 'guess'. How much are you paying these guys? From:

tuning for throughput vs. tuning for response time

2003-12-10 Thread ryan_oracle
Has anyone else notice that these two can be somewhat different? In a high transaction system, I typiucal try to reduce LIOs when I write queries. For last 6-8 months, Ive been doing alot of ETL and nightly batch data loads. Ive found that there are times when I can improve response time by

Re: 24 x 7 x 365

2003-12-10 Thread ryan_oracle
i was at an oracle group meeting and one of the RAC specialists at oracle was talking. he said that that kind of thing 'can' be done, but is incredibly expensive. you need redundancy and fail safes like crazy. any time you do an upgrade, bad things may happen. From: Tracy Rahmlow [EMAIL

OS calls with java stored procedures

2003-12-09 Thread ryan_oracle
Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that

Re: RE: PERL?

2003-12-08 Thread ryan_oracle
what do you mean by sophisticated I/O? From: Cary Millsap [EMAIL PROTECTED] Date: 2003/12/07 Sun PM 11:59:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: PERL? You'll get much more comprehensive answers than mine, but a few huge motives for me are.

Re: Database management techniques and frameworks

2003-12-05 Thread ryan_oracle
We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when

Re: RE: java package to run OS command

2003-12-04 Thread ryan_oracle
expert one on one. check asktom.oracle.com might be on there also. From: John Dunn [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 09:44:29 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: java package to run OS command Which book is that? -Original

Re: Varray Problem

2003-12-04 Thread ryan_oracle
cost is irrelevant. ignore it. it doesnt matter. its internal for oracle. what docs are you using that say to use cost? none from oracle. they dont exist. have your Logical I/Os gone up? Has your response time gone up? I can guess as to why its more 'costly'? By accessing the varray do you do

RMAN questions

2003-12-04 Thread ryan_oracle
We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i. I'm looking at using RMAN for our backup and recovery. We have many instances but essentially 2 types. 1. Production instances that have both OLAP and OLTP. These must be in archive log mode. 2. We have

Re: RE: RMAN questions

2003-12-04 Thread ryan_oracle
i must have misread the docs. i thought it was either catalog or control file. didnt know you could do both thanks. From: [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 11:04:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RMAN questions I suppose just how

wait events that indicate lack of bind variables

2003-12-04 Thread ryan_oracle
Which wait events are indications that your missing bind variables? btw, if you want to implement bind variables through a c/c++ middle tier its best to use 'prepared statements'. correct? bind arrays can be issued as prepared statements right? This is when you need to do alot of inserts

Re: RE: partitioning option licensing

2003-12-03 Thread ryan_oracle
never pay retail with oracle licensing. who pays the full $10k? If your buying other stuff you should be able to knock off alot. Never pay the full amount. From: David Wagoner [EMAIL PROTECTED] Date: 2003/12/03 Wed AM 09:24:38 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

what is the difference between shared nothing and shared everything?

2003-12-03 Thread ryan_oracle
this has to do with RAC right? oracle uses shared everything and ibm uses shared nothing right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

what happened to baarf.net?

2003-12-03 Thread ryan_oracle
anyone got the articles about why raid 5 is bad for databases? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING

2003-12-03 Thread ryan_oracle
are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING

running both shared server and dedicated mode on the same instance

2003-12-02 Thread ryan_oracle
i think this is possible. any docs on how to set this up with suggested methods? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Re: running both shared server and dedicated mode on the same instance

2003-12-02 Thread ryan_oracle
what if you have a web based architecture? is there a way to have 9iAS decide which connection to use? From: Tanel Poder [EMAIL PROTECTED] Date: 2003/12/02 Tue AM 07:34:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: running both shared server and dedicated

Re: Re: SESSION_CACHED_CURSORS -- RE: Parse Vs Execute

2003-12-02 Thread ryan_oracle
what causes memory fragmentation errors? should oracle be able to go to the LRU and start kicking stuff out of memory if there isnt enough space? From: Tanel Poder [EMAIL PROTECTED] Date: 2003/12/02 Tue PM 12:39:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:

Re: Re: Anyone run into this strange ORA-00904 error ??

2003-12-02 Thread ryan_oracle
i believe column privileges are only for dml. views are supposed to filter out columns for selects. i could be wrong. From: Krishna Kakatur [EMAIL PROTECTED] Date: 2003/12/02 Tue PM 12:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Anyone run into this

Re: Software Engineer/DBA needed in Southwest Ohio

2003-12-01 Thread ryan_oracle
im assuming this means you want a software engineer who knows a little oracle right? you cnat be an expert in both. Ive seen more and more jobs like this and less and less oracle specialist positions. Its troubling. From: Dave Phillips [EMAIL PROTECTED] Date: 2003/12/01 Mon AM 08:59:25 EST

Re: Semi-OT...dbazine

2003-11-28 Thread ryan_oracle
maybe its running on sql server? From: Connor McDonald [EMAIL PROTECTED] Date: 2003/11/28 Fri AM 08:34:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Semi-OT...dbazine Anyone noticed www.dbazine.com... This domain has temporarily been disabled. To restore

when do you use v$statname?

2003-11-26 Thread ryan_oracle
This view seems to be a smaller subset of v$sysstat? When is it useful? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Re: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
both store that info SQL desc v$statname Name Null?Type - STATISTIC# NUMBER NAME

Re: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
v$sysstat has the NAME column also? From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 08:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: when do you use v$statname? v$statname is a lookup table for the statistic# that appears in

RE: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
right, then why do we have v$statname? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 08:44:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: when do you use v$statname? but only v$sysstat has the value column ... Raj

Re: ORA-1000 and pl/sql cursor cache

2003-11-26 Thread ryan_oracle
are you looking for the init.ora max_open_cursors(dont think i typed it exactly right). even if the cursors are cached, they should not be counted as open. they doesnt make sense from an oracle design standpoint. From: Lord David [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 10:34:34 EST To:

Re: RE: Parse Vs Execute

2003-11-26 Thread ryan_oracle
i remember in tom kytes new book there is a 'softer parse' he was referring to using dbms_sql instead of execute immediate. Im not referring to using dbms_sql when you have to loop and use the same cursor repeatedly so you eliminate all parsing. he didnt go into great detail on this just gave

Re: Beginning of a global unravelling?

2003-11-25 Thread ryan_oracle
i heard it was just the corporate call centers coming back? not the private call centers? dell tech support isnt any good no matter where it is. its just an entry level position. The guys who get good move up or on to other things. gateway is bad too. From: Bellow, Bambi [EMAIL PROTECTED]

what is oracle rdb?

2003-11-24 Thread ryan_oracle
I see it referred to on metalink alot. I know its seperate from the rdbms. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

Re: RE: Development vs. Production DBA

2003-11-21 Thread ryan_oracle
the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows

RE: RE: Development vs. Production DBA

2003-11-21 Thread ryan_oracle
i was on a project last year where the lead didnt let us make stored code. she thought it 'cluttered the database'. what can you do? lots of incompetence out there. worst when its the boss. From: April Wells [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 09:54:33 EST To: Multiple recipients of

Re: RE: Any articles/books that take relational theory and make it

2003-11-20 Thread ryan_oracle
how does dimensional modelling used by datawarehousing fit into relational theory? From: Daniel Hanks [EMAIL PROTECTED] Date: 2003/11/19 Wed PM 04:35:03 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Any articles/books that take relational theory and make it

orbitz fiasco

2003-11-20 Thread ryan_oracle
I was at an Oracle usergroup meeting last week and a guy at Oracle said the following happened. Can anyone confirm? Just curious. 1. Orbitz did an upgrade to some software other than Oracle. I think it was firmware. They did NOT test it first. Did it directly in production. 2. This corrupted a

Re: Re: Any articles/books that take relational theory and make it

2003-11-20 Thread ryan_oracle
there are used copies for sale right on there. From: KENNETH JANUSZ [EMAIL PROTECTED] Date: 2003/11/20 Thu AM 11:20:15 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Any articles/books that take relational theory and make it Unfortunately according to

RE: RE: orbitz fiasco

2003-11-20 Thread ryan_oracle
the guy who spoke from oracle said that 9.2 is much better than 9.0.1 RAC. anyone use it? From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/11/20 Thu PM 12:19:59 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: orbitz fiasco The only thing high about 9.0.1

Re: RE: Any articles/books that take relational theory and make it

2003-11-20 Thread ryan_oracle
which noted O-O author said that about DBs? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/20 Thu PM 02:59:58 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Any articles/books that take relational theory and make it Paula - It may get worse. A noted

RE: RE: orbitz fiasco

2003-11-20 Thread ryan_oracle
what is TAF? From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/11/20 Thu PM 02:45:19 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: orbitz fiasco Yes. We have a 9.2.0.4 test system based on the How to Build a $1000 RAC whitepaper

Any articles/books that take relational theory and make it english?

2003-11-19 Thread ryan_oracle
I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand.

Re: Database Health Template-OT

2003-11-19 Thread ryan_oracle
these are bogus. its just about giving your boss some BS, so he goes away. Been there, done that. the only useful stuff to send him would be polling the alert log for 'ORA' errors, checking for chained rows as a percentage of total rows, and check to see how much free space is in each

  1   2   >