Re: PCTFREE and PCTUSED

2003-11-04 Thread Jared . Still
Your example block can be 60% full and not be on the free list. Once your block reaches 90% full, it is removed from the free list. It will not be put on the free list again until used space in the block falls below PCTUSED, which is 40% in your example. So, a block fills up, it is removed

Re: Question about datatypes

2003-11-03 Thread Jared Still
://www.orafaq.net -- Author: Jared Still 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

RE: Outsourcing's dirty secret

2003-11-03 Thread Jared . Still
This is not appropriate for this list. Please refrain in the future. Jared hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 05:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE:

RE: Win termin services alert

2003-11-03 Thread Jared . Still
Ok, what is LINDESK? I googled for it, but found nothing informative. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 04:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Win

Database Normalization

2003-11-03 Thread Jared . Still
List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and

10g new features

2003-11-03 Thread Jared . Still
Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared

Re: ** other oracle forums

2003-11-03 Thread Jared . Still
Regarding the posting of 'on topic only' messages: That is highly subjective. What I call on topic you may not agree with. Then there is the issue of time. I already spend way too much time on this list. Moderating to the degree that some may like is simply out of the question. Jared

Re: Oracle EE and SE on same box

2003-11-03 Thread Jared . Still
What is the actual concern with it? Installing both EE and SE on the same *nix or Win32 box is pretty straight forward, provided you aren't trying to do so with Version 7 on Win32. You don't do anything special, just install them, create your databases, edit tnsnames, etc. If your question

RE: Database Normalization

2003-11-03 Thread Jared . Still
Oh, I have *tons* of data modeling books/articles. Just needed a quick refresher for the purpose of offering explanations. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:14 AM Please respond to ORACLE-L To:Multiple recipients of list

RE: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-03 Thread Jared . Still
COALESCE would be a better option than REBUILD for Indexes on monotonically increasing sequences where older values are purged periodically. Unless you happen to be doing index_ffs on that particular index, in which case a rebuild *may* be in order. Rebuilding the index may cause insert

RE: Database Normalization

2003-11-03 Thread Jared . Still
More than enough. :) DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 12:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database Normalization Jared - Sounds fine. Do you feel

RE: Win termin services alert

2003-11-03 Thread Jared . Still
Thanks Ron. I currently use rdesktop for that: www.rdesktop.org It doesn't appear to be worthwhile ( at least to me) to compare them, as rdesktop works very well, and is GPL. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 10:54 AM Please respond to ORACLE-L

RE: Finding overlapping time periods - suggestions please

2003-11-03 Thread Jared . Still
Snodgrass is also the author of an excellent book on the subject, available at a bookstore near your browser. Henry Poras [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Oracle 9iR2 on NT sp6

2003-11-03 Thread Jared . Still
Has anyone run into any problems with this combination? The MetaLink note # 45997.1 says it should work fine, but it would be nice to hear from someone that has implemented 9iR2 on NT. Why NT? I need to put an app on a server that already has licensing for backup software etc. Beats spending

Re: redhat/oracle

2003-11-03 Thread Jared Still
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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: 10g new features

2003-11-03 Thread Jared Still
(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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: 10g new features

2003-11-03 Thread Jared Still
mytablespace rename datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words 'alter', 'tablespace' and 'rename' in there? You'll get it in the morning. ihomo sapien/i think better during the day. Yong --- Jared Still [EMAIL PROTECTED] wrote: Not sure I get it either

RE: Outsourcing's dirty secret

2003-11-02 Thread Jared Still
: Jared Still 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

RE: HELP HELP Trying to find this: PL/SQL MD4 and MD5 by Keith

2003-10-31 Thread Jared Still
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: UNIX OT: deleting file starting with --

2003-10-31 Thread Jared Still
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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: 9i on RHAS3

2003-10-31 Thread Jared . Still
If the question is 'Should I use an index with a small table, even \ one that fits in a single block, then the answer is very possibly yes. Best to test with your SQL, but for simple selects the use of an index makes the SQL much more scalable. Search the archives on 'run_stats', as that was

Re: dual

2003-10-30 Thread Jared . Still
You may find this interesting. Looks like a 'where rownum = 1' is always imposed on dual. Same results on 8.1.7.4 and 9.2.0.4 Don't try this on anything other than a trashable test database. Jared === 10:42:04 dv03@dt 10:42:05 dv03 10:42:05 dv03set echo

RE: Outsourcing's dirty secret

2003-10-30 Thread Jared . Still
The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared Jamadagni, Rajendra [EMAIL

RE: dual

2003-10-30 Thread Jared . Still
Didn't try no rows. I imagine all kinds of things would break. Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 11:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dual Do you

RE: dual

2003-10-30 Thread Jared . Still
I encountered the same problem once many years ago, for the same reason. Quite a pickle for a newbie - OWW bailed me out on that one. :) Jraed M Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 12:29 PM Please respond to ORACLE-L To:Multiple recipients of list

RE: alter system reset

2003-10-30 Thread Jared . Still
I've never used 'tput reset', but have always used 'stty sane', which sometimes clears things up, and sometimes doesn't. Next time it happens, I'll try 'tput reset'. Thanks, Jared Richard Ji [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 01:29 PM Please respond to ORACLE-L

Re: alter system reset

2003-10-30 Thread Jared . Still
True, but it's often easier to cat|more|less a file that is a couple hundred megs than try to load it into vi. Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: sqlplus prompt question in 9i

2003-10-29 Thread Jared . Still
You could just use login.sql instead, on a per user basis. If you don't want login.sql to be used, just edit or unset SQLPATH. Maybe other options available for this in 9i. A perusal of the sqlplus manual may prove useful. Jared Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: dbms_system.ksdwrt

2003-10-29 Thread Jared . Still
Yes, it works on 7.3.4, tested it just now. Jared Pete Finnigan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/29/2003 05:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:dbms_system.ksdwrt Hi

RE: How to drop a datafile ?

2003-10-29 Thread Jared . Still
That won't actually do what you're implying. Checking the docs would prove helpful. From the SQL ref: If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you

Re: RE: SQL and PL/SQL tuning template document required urgently

2003-10-29 Thread Jared . Still
Neither Tom Kyte's nor Cary Millsap's books are too advanced for beginners. In the case of Tom's book, they may have to ponder things a bit, and actually try the code for themselves to get a good understanding. So what? That's how you learn. Regarding Cary's book, what's so hard about it?

Re: 2G trace files

2003-10-29 Thread Jared . Still
Sounds like an OS limit. What OS is this on? Quintin, Richard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/29/2003 10:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:2G trace files I'm tracing a

Re: RE: SQL and PL/SQL tuning template document required urgently

2003-10-29 Thread Jared . Still
They really dont know anything and it REALLY is that hard for them. Hence the lies on their resumes. ;) OK, enought cynicism. For now. Maybe it is hard. I guess I just don't agree that they shouldn't just dive in and sink or swim. And yes, I've been doing this a while, but there are still

Re: Execution Plan is good but HIGH CPU

2003-10-28 Thread Jared Still
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: performance issue on select count(*)

2003-10-28 Thread Jared . Still
An unusually high BCHR could be an indicator that your database is running Connor McDonald's choose_a_hit_ratio procedure. http://www.oracledba.co.uk/tips/choose.htm Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/28/2003 09:09 AM Please respond to ORACLE-L

RE: dba interview questions

2003-10-28 Thread Jared . Still
Please kill this thread, as it no longer has anything to do with DBA interview questions. Schilling, Ben [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/28/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Execution Plan is good but HIGH CPU

2003-10-28 Thread Jared . Still
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: anyone have opinions on the future of the 'grid'?

2003-10-27 Thread Jared Still
') 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: Jared Still INET: [EMAIL

RE: VPN to database?

2003-10-27 Thread Jared Still
Yes: https://store.sans.org/store_item.php?item=80 On Mon, 2003-10-27 at 09:49, Paul Baumgartel wrote: Jared, Is that the book from sans.org? Thanks, Paul --- Jared Still [EMAIL PROTECTED] wrote: Yes, I will ditto the recommendation for Pete Finnigan's book. Jared

Re: ADMIN: Warning of potential list shut downs due to brush fires

2003-10-27 Thread Jared Still
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

OT: Ximian Evolution configuration

2003-10-27 Thread Jared Still
off list. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: anyone have opinions on the future of the 'grid'?

2003-10-27 Thread Jared Still
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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Refresh option for Materialized view , want to use it during

2003-10-25 Thread Jared Still
FAQ: http://www.orafaq.net -- Author: Jared Still 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

Re: Replication : ORA-04068: existing state of packages has been

2003-10-25 Thread Jared Still
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Replication : ORA-04068: existing state of packages has been

2003-10-25 Thread Jared Still
://www.orafaq.net -- Author: Jared Still 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

Re: Oracle 9.2.0.4 on Gentoo

2003-10-24 Thread Jared Still
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: UTL_RAW and slowness

2003-10-24 Thread Jared Still
. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Oracle pricing ain't going down

2003-10-24 Thread Jared Still
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: VPN to database?

2003-10-24 Thread Jared Still
: 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services

Re: how to specify tablespace in Designer

2003-10-24 Thread Jared Still
: http://www.orafaq.net -- Author: Jared Still 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

Re: VPN to database?

2003-10-24 Thread Jared Still
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: Jared Still INET: [EMAIL

RE: VPN to database?

2003-10-24 Thread Jared Still
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: Jared Still INET: [EMAIL PROTECTED] Fat City

RE: VPN to database?

2003-10-24 Thread Jared Still
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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: RMAN Incremental

2003-10-24 Thread Jared Still
://www.orafaq.net -- Author: Jared Still 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

Re: Cache a table

2003-10-23 Thread Jared . Still
Craig Shalahamer still refers to the cache as LRU/MRU. What has changed are the algorithms that determine the lifespan and placement of a buffer in the cache. www.orapub.com Jared Richard Foote [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/23/2003 08:34 AM Please respond to ORACLE-L

Re: OT: How to call unix shell scripts from 'C'?

2003-10-23 Thread Jared . Still
Ah, then what you really need to do this with is perl. Edit in place, make backup copies or not, all very simple. eg. change all instances of SQLServer to Oracle in the files in a directory perl -pi -e 's/SQLServer/Oracle/goi' * Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

Re: UTL_RAW and slowness

2003-10-23 Thread Jared . Still
Raj, I'll try to be tactful here, but that isn't encryption. It only looks like encryption, and is in fact very easy to break. Check out the article at http://www.cybcon.com/~jkstill/util/encryption/encryption.html There are PL/SQL implementations of RC4 and Blowfish there. RC4 is a stream

Re: Duplicated posts

2003-10-22 Thread Jared . Still
The only duplicate posts I have seen are from Michael. This from 2 different accounts that receive oracle-l. Jared Pete Finnigan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 04:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL

Re: Boolean dates...

2003-10-22 Thread Jared . Still
I think what your boss really means is 'julian' date. Does he also want his database in mauve? Try this: select to_date(bdate,'j') from paam; That said, the dates in your example are about 700 years into the future. Jared Jose Luis Delgado [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: Boolean dates...

2003-10-22 Thread Jared . Still
Actually, Oracle's implementation is a Julian date. The YYDDD format is most definitely not a Julian date, though many persist in calling it that. Oracle is using what is called a 'Modified Julian Date'. A Julian date actually begins at Noon on -4712, which is 4713 BC. That ordinal vs.

RE: Boolean dates...

2003-10-22 Thread Jared . Still
This may clear it up: select to_char(sysdate,'j') , to_char(to_date('06/05/2718','mm/dd/'),'j') , to_char(to_date(2713944,'j'),'mm/dd/ bc') , to_char(to_date(728464,'j'),'mm/dd/ bc') from dual; Jared Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003

RE: Shutdown takes 20+ minutes

2003-10-22 Thread Jared . Still
Uh-oh. I'm sure Jeremiah is digging up some old posts for cut and paste to avoid typing. Here, I'll save him the trouble. = There are unknowns with every feature. ABORT is a feature just as IMMEDIATE is. In version 7, I encountered a bug with IMMEDIATE that required

RE: questions regarding nologging

2003-10-22 Thread Jared . Still
A quick look at the docs for 'alter index' will reveal all. Roger Xu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 04:05 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: questions regarding

Re: db_block_lru_latches and servers with multiple instances

2003-10-21 Thread Jared . Still
As someone has pointed out to me, latch contention is a consumer of CPU. If you are familiar with Oracle's process of spinning on a latch, you will realize that while waiting for a latch, the CPU will 'spin', rather than go to the expense of doing a context switch and moving on to something

RE: WHERE 1 = 1 (any info on this)

2003-10-21 Thread Jared . Still
We looked at SQR in 1994. We chose Perl instead, it was much more flexible. The fact that Perl was free didn't have anything to do with the decision. Perl was just much more capable for data processing and reporting. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL

Re: Can I concatenate several rows without a procedure?

2003-10-21 Thread Jared . Still
Oh my, that *is* convoluted. :) Stephane Faroult [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/21/2003 02:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Can I concatenate several rows without a

RE: anyone have opinions on the future of the 'grid'?

2003-10-20 Thread Jared . Still
From what little I know about it, I would say that RAC is simply a piece of the Grid enabling infrastructure. Grid computing is much larger than just Oracle. There is no dearth of grid computing literature available on the www. Simply google for it and you will be inundated. Jared

Re: db_block_lru_latches and servers with multiple instances

2003-10-20 Thread Jared . Still
Interesting question. Some initial thoughts on that are that latches don't actually consume much CPU. In a poorly written app (or in the extremely rare event of a database bug, but probability of that is so low as to not be worth discussing) you may encounter latch contention that will cause

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-20 Thread Jared Still
: http://www.orafaq.net -- Author: Jared Still 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

RE: Data Transfer between two instances

2003-10-20 Thread Jared Still
: Jared Still 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

Re: passwords case sensitive

2003-10-19 Thread Jared Still
-- Author: Jared Still 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

RE: passwords case sensitive

2003-10-18 Thread Jared . Still
Already tried that - no go. Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/18/2003 07:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: passwords case sensitive BTW if you put in

Re: re Rebuilding Indexes in Oracle Apps -- Quoting an Apps

2003-10-17 Thread Jared . Still
Doesn't reuse leaf rows?! The myth is perpetuated. Try running these scripts. In a nutshell, a table is created with about 20k rows, with an incrementing id. There is a non-unique index created on the id column. An analyze is done on the table then index_stats is populated with 'analyze

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-17 Thread Jared . Still
My experience in contacting Oracle regarding modifying of notes on MetaLink has not been very satisfying. I did take the opportunity to voice my dissatisfaction by using the poll at the top of the article to indicate that I would not recommend this article to others. Jared Richard Foote

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

2003-10-17 Thread Jared . Still
The article states that leaf blocks are not reused, which is indeed incorrect, and has been for a very long time. Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 11:42 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL

Re: test

2003-10-17 Thread Jared . Still
Yes, the list was down for a few hours. The server software went down, the admin has out cold with cold medicine and didn't hear the pager. You could say we were hit with a virus - the rhino virus. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 12:04 PM

Re: passwords case sensitive

2003-10-17 Thread Jared . Still
see $ORACLE_HOME/rdbms/admin/utlpwdmg.sql Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 01:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:passwords case sensitive Is it possible

RE: passwords case sensitive

2003-10-17 Thread Jared . Still
Sorry, can't make it work in the case of 'ProperCase', at least not easily. I wasn't thinking it through when I replied. You could use it to enforce all lowercase, or init caps. Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 02:29 PM Please respond to

RE: sometimes pressure seems to get the best of us.

2003-10-17 Thread Jared . Still
Ah, the self-healing mailing list. Gotta love it. :) MaryAnn Atkinson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: sometimes pressure

RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-16 Thread Jared Still
Ah, my mistake. Last night I missed the fact that the first one *does* have LD_LIBRARY_PATH in it. Having both the 32 and 64 bit libs in the path could have been your problem. Jared On Wed, 2003-10-15 at 22:59, Jared Still wrote: This one is incorrect: export LD_LIBRARY_PATH=$ORACLE_HOME

Re: anyone have opinions on the future of the 'grid'?

2003-10-16 Thread Jared Still
, 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: Jared Still INET: [EMAIL PROTECTED] Fat

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Jared Still
FAQ: http://www.orafaq.net -- Author: Jared Still 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

Re: OT California

2003-10-16 Thread Jared . Still
OT list please Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 10:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OT California How, in the world, did a man with such a poor

Re: insert and commit 1000 records at a time

2003-10-16 Thread Jared . Still
That will work, slowly. You might like to try something like this insert into resource nologging select * from rqmt append; Read up on the 'append' and 'nologging' first. Jared Maryann Atkinson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 08:54 AM Please respond to

RE: Re: anyone have opinions on the future of the 'grid'?

2003-10-16 Thread Jared . Still
We had Sun's N1 architect here a few months ago to brief us on N1. ( grid) In a nutshell, all of your servers go in a pool, the administrative software doles out the resources as needed, simple as that. Of course, it is not that simple. Very interesting stuff, though I think the current buzz

Re: Solved: Find CPU clock speed on HP-UX 11

2003-10-16 Thread Jared . Still
I'm as much a Perl bigot as anyone Mladen, but really, what's the point of rewriting grep? grep -i HZ /var/log/syslog | head -1 Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 07:59 AM Please respond to ORACLE-L To:Multiple recipients of list

Re: insert and commit 1000 records at a time

2003-10-16 Thread Jared . Still
My bad. The SQL is not quite right: 'append' is a hint: alter table resource nologging; insert /*+ append */ into resource select * from rqmt; Read up on direct load insert in the concepts manual, along with nologging. Bypass the redo and undo - no need for commits. Just back it up when

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-16 Thread Jared . Still
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Passed Net8 OCP Exam

2003-10-16 Thread Jared . Still
Way to go Dennis! DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 12:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Passed Net8 OCP Exam I just passed the Net8 Administration OCP

RE: Opinions sought on possible TOAD replacement

2003-10-16 Thread Jared . Still
I forgot to include years of troubleshooting and debugging experience the techniques to go with it. :) Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/16/2003 01:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: SUPPRESS SQL STATEMENTS

2003-10-15 Thread Jared . Still
not a problem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Financials and APPS password

2003-10-15 Thread Jared . Still
SarbOx ( Sarbanes Oxley) will change this behavior. Users and developers will be more limited. There should be a way to limit DBA's and sysadmins as well. Data encryption at the db level is the only way I can think of to prevent that, short of locking out the admins. Jared Jay

Re: Opinions sought on possible TOAD replacement

2003-10-15 Thread Jared . Still
TORA, OraC, sqlplus, vi, perl and a linux box to run it on, though the database servers are mostly Win2k. Software $0.00 OS $0.0 HW $12k Jared Paul Vincent [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 08:59 AM Please respond to ORACLE-L To:Multiple recipients of

RE: Oracle on Sun vs Tru64

2003-10-15 Thread Jared . Still
Since you're migrating anyway, have you seriously considered Linux? Though I like Sun, it doesn't appear to be a good move lately. Sorry Daniel. :) Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 09:24 AM Please respond to ORACLE-L To:Multiple

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-15 Thread Jared . Still
Please explain why these indexes must be built. What benefits do you see from it? Are they quantifiable? Jared M Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 03:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: SUPPRESS SQL STATEMENTS

2003-10-15 Thread Jared . Still
what are the limitations? other than ps commands that can read past a 3k command line Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-15 Thread Jared Still
://www.orafaq.net -- Author: Jared Still 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

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

2003-10-15 Thread Jared Still
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Data Modelling Tools for a DBAs Job

2003-10-14 Thread Jared . Still
Oracle designer is a full fledged CASE tool, so it does quite a bit more than design a database. I've checked out other DB design tools, even bougth Embarcadero. None of them are nearly as capable as Oracle Designer for designing Oracle databases. None of them seem to be as good at separating

!! Please Read!! Oracle-L subscriptions, spam and viruses

2003-10-14 Thread Jared . Still
As all of you are quite aware, the past couple months have seen a huge influx of spam and viruses on the internet. This has had a huge impact on mail servers worldwide. I recently read of one university that was spending quite a bit of money to install new mail servers, all due to the increased

<    1   2   3   4   5   6   7   8   9   10   >