Bad object ids in x$bh?
Anybody know what the blocks in x$bh are that don't map to rows in DBA_OBJECTS? I have 172 objects in x$bh that I can't account for. SQL SELECT count(obj), count(object_id) 2 FROM (SELECT DISTINCT bh.obj, ob.object_id 3FROM sys.x_$bh bh, 4 dba_objects ob 5WHERE bh.obj = ob.object_id(+)); COUNT(OBJ) COUNT(OBJECT_ID) -- 2243 2071 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA needed in Austin, TX
Did you leave off a :-)? I remember plenty of 100% (or at least high 90s') days back in Troy/Albany. When I moved to Seattle I had to explain what 100% humidity was or what the weather man meant by good sleeping weather. Don't miss the summers, but I do miss the foliage... ObOracle: Best tidbit from Connor's 9i Forgotten Features URL's for scripts SQL @http://script.repository/scripts/sessions.sql I'm sure there's something cool I could do with that but in order to be *REALLY* useful I'd want to be able to do this export SQLPATH=$HOME/sql:http//script.repository/scripts/ ...or something like that. The : in the http: is a problem. Of course I'd *never* point this out to somewhere out on the big, scary Internet! To easy for some script kiddy to hack. Still a Rensselaer county hillbilly at heart, S- On Thu, 25 Sep 2003, Mercadante, Thomas F wrote: ummm.. if it's 100% humidity, doesn't that mean it's raining .. or misting .. or something? I can't imagine it being 100degrees and raining. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFA myths was Re: BAARF
I'd like to get rid of the myth that OFA really states all that much about what goes in what tablespace etc. I've got a copy of the Cary's OFA paper entitled The OFA Standard - Oracle7 for Open Systems dated Sept 24, 1995. (Happy belated birthday OFA!) At the end of paper there's a summary of the requirements and the recommendations that make up OFA. The CLOSEST the OFA comes to specifying table/index separation are #7 Separate groups of segments with different lifespans, I/O request demands, and backup frequencies among different tablespaces. -or maybe- #11 *IF* [emphasis mine] you can afford enough hardware that: 1) You can guarantee that each disk drive will contain database files from exactly one application and 2) You can dedicate sufficiently many drives to each database to ensure that there will be no I/O bottleneck. The document itself says, The OFA Standard is a set of configuration guidelines that will give you faster, more reliable Oracle database that require less work to maintain. So every time I read that someone is putting redo here, index tablespaces here, and temp tablespaces there in order to be OFA compliant I kinda shrug. Obviously it's all a good idea to separate this stuff but it's not absolutely required for OFA-ness. Essentially, OFA is just a very good way of separating Oracle code from Oracle data to make administration *much* easier. I'm sure before OFA there were plenty of places that had everything under $ORACLE_HOME/dbs and no naming standard for datafiles. Ugh! Now if we could only find this Cary V. Millsap, Oracle Corporation character so he could explain himself. ;-) '95 was a loong time ago. S- On Thu, 25 Sep 2003, Thomas Day wrote: [snip] While we're at it could we blow up the OFA myth? Since you're tablespaces are on datafiles that are on logical volumns that are on physical devices which may contain one or many actual disks, does it really make sense to worry (from a performance standpoint) about separating tables and indexes into different tablespaces? [snip] Maybe we will never get rid of the OFA myth. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tablespace management.
recommended using LOCAL, UNIFORM, AUTO as the options for tablespace management. Does anyone have any bad experiences with these? AUTOALLOCATE seems to come up with extents that are much smaller than I want and MANUAL segment management requires the use of FREELISTs (and I know that there are problems with freelists freeing up space correctly, especially in a parallel environment). I can't find any basis for making a decision between UNDO and ROLLBACK SEGMENTS. Does anyone have any experience or recommendations about UNDO usage? The database will be a materialize view replication of a transaction master that is being used for decision support and has a 15 minute update/refresh cycle. Basically, people can run queries against the snapshot without impacting the master. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Some of you may find this useful
It looks like all of the SQL executed from the named packages. I found two references to the voodoo that is x$kglrd, both from the venerable Steve Adams' ixora.com.au: http://www.ixora.com.au/q+a/0110/31164749.htm http://www.ixora.com.au/scripts/library.htm#package_sql_executions S- On Fri, 10 Jan 2003, Chris Stephens wrote: what is it that i am looking at after running this query?? pardon the ignorance. chris -Original Message- Sent: Friday, January 10, 2003 9:20 AM To: Multiple recipients of list ORACLE-L That's pretty cool :) Thanks for sharing it, Stephane. - Kirti -Original Message- Sent: Friday, January 10, 2003 4:04 AM To: Multiple recipients of list ORACLE-L break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Queues - does anyone use them
I've used queues extensively and I've never had any reliability problems. Based on the user_jobs comment, I'd guess mkb is confusing DBMS_JOB with the DBMS_AQ functionality. AQs are very nice. I built an entire scheduling system on using queues since they have some nice properties (transactional safety, message delay/timeout/retry, user defined object transport) but I can't vouch for the java bindings having only used it via PL/SQL. They seem to be fairly light weight, but don't go nuts. I have a dev server that has the same product installed *LOTS* of times so it's got nearly 1000 queues on it so the QMON0 process gets a little CPU hoggy. On a normal server with 6 queues, it's negligible for low throughput applications. YMMV if you need the queues to handle sustained high throughput rates. ...oh yeah, we read the same recovery warning and threw the queues in their own TS. S- On Wed, 30 Oct 2002, mkb wrote: Bruce, We used to use queues in 8.1.6 on Solaris. Don't remember much about them except that they were, at that time, unreliable. We'd have push/pulls jobs that would run extract and transformation routines from multiple databases into a reporting DW. We finally switched over to Informatica because of the unreliabilty of the queues. As for seperate queue tables, don't remember. I believe the queues were owned by the application schema since I remember looking for stopped jobs in user_jobs as the application owner. mkb --- [EMAIL PROTECTED] wrote: Bruce, No we don't use advanced queuing here. Don't have the time to figure out how to make it work. Dick Goulet Reply Separator Author: Reardon; Bruce (CALBBAY) [EMAIL PROTECTED] Date: 10/29/2002 10:58 PM Hi, I've sent a couple of questions on queues and got no answers - that's fine and I understand we're all busy. What I'm wondering though is whether anyone is actually using Oracle queues at all? Any feedback would be appreciated. For anyone out there who does use Advanced queues: one of our developers read that Creating a queue table in a tablespace will disable that particular tablespace for point-in-time recovery. - Do you normally put your AQ tables in a separate tablespace (we're currently looking at doing just that)? - Who normally owns the queues and queue tables - system or the application schema. Thanks, Bruce Reardon mailto:bruce.reardon;comalco.riotinto.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RAC on the cheap
If I wanted to put together a cheap RAC for play purposes what sort of HW/SW would I need? I'm not talking about a production-level solution here, just taking some older-HW I might have laying around and turning it into a RAC with a minimal investment for sandbox purposes. Could I do it with 2+ Sun boxes w/ Solaris 8 (or 2+ Intel boxes w/ Linux), some sort of shared SCSI array (A1000 or JBOD) and standard 100 Mb ethernet? Is this enough or do I need to spend ? (gigabit ethernet, fibre channel SAN, Veritas, etc) S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Licensing - Concurrent users
Nuclear Plant? Don't say Larry didn't warn you: The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs. From Title and Copyright Information for Getting to Know 8i (8.1.6) S- On Wed, 20 Feb 2002, Kevin Lange wrote: For one last 2 cents worth . same for my last employer. Even though there were only 4 entry stations into the Radiation Protected Area of the Nuclear Plant, all employees who were eligible to enter that area was considered a user. Instead of 4, we had to have 1000 licenses. At least Oracle is consistent in their greed... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
newfs suggestions for Oracle filesystem
Any suggestions for newfs parameters for a file system that will be dedicated to Oracle data files? It will be a large file system with very few files of very large (2GB) size. I've been using the following with good results but I'm wondering if anyone has any suggestions. newfs -v -C 64 -c 229 -f 8192 -i 65536 -r 1 /dev/dsk/cWtXdYsZ tunefs -a 128 -e 1048576 -m 0 -o time /newfilesystem Details: Solaris 2.8 Oracle 8.1.7.1 EE 16k db block size 8k operating block size S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
64 bit vs 32 bit Oracle
!! Please do not post Off Topic to this List !! Is there any benefit of 64 bit versions over 32 bit versions of Oracle beyond allowing 2GB SGAs? (8.1.7/Solaris 2.8 in particular) The systems I'm working with are predominantly DSS queries against data sets that most of the servers have no hope of caching anywhere near the amount of data needed so huge SGAs are not that useful. Our C++ guys tell me that Sun reccommends that compiling 64 bit binaries for processes that might take advantage of the larger memory limit. The logic being that 64 bit pointers take up twice as much space as 32 bit pointers and the processor cache density is thus lower for 64 bit processes. Does anyone know if there is any additional trickery Oracle does on the 64-bit port that may provide performance benefits that would outweigh the potential for lower cache hit rates? Magic data structures? _make_sql_faster support? S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 64 bit vs 32 bit Oracle
!! Please do not post Off Topic to this List !! Where does this additional throughput come from? S- On Fri, 14 Sep 2001, Christopher Spence wrote: !! Please do not post Off Topic to this List !! Depends, 64bit can certainly give you more throughput, but it is very slow for being patched. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, September 14, 2001 3:50 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Is there any benefit of 64 bit versions over 32 bit versions of Oracle beyond allowing 2GB SGAs? (8.1.7/Solaris 2.8 in particular) The systems I'm working with are predominantly DSS queries against data sets that most of the servers have no hope of caching anywhere near the amount of data needed so huge SGAs are not that useful. Our C++ guys tell me that Sun reccommends that compiling 64 bit binaries for processes that might take advantage of the larger memory limit. The logic being that 64 bit pointers take up twice as much space as 32 bit pointers and the processor cache density is thus lower for 64 bit processes. Does anyone know if there is any additional trickery Oracle does on the 64-bit port that may provide performance benefits that would outweigh the potential for lower cache hit rates? Magic data structures? _make_sql_faster support? S- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
hash join order
Does anyone know how the operation below is performed? Which object has the hashtable built on it and which object performs the lookup against the hashtable once it's built? | Operation | Name | --- | 0SELECT STATEMENT|| | 1 0 HASH JOIN || | 2 1 TABLE ACCESS FULL |B_TAB | | 3 1 INDEX FAST FULL SCAN |PK_A_TAB| --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Rospo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).