Re: RE: pga_aggregate_target and a memory leak
where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 10:19 PM On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very courageous thing to do. I'm not sure that 10g will be stable enough for a big production database in 2 years. Experience with 9i tells us that nothing before 9.2.0.4 was not fit for a real production use. If I remember correctly, 9i is out for more then 2 years now. Have in mind that 10g is the first version that was written almost entirely outside of the US. I wouldn't rush into upgrading to 10g, if I were you. And the rumor is that 10g is so unstable that even with the standards lowered so much, Oracle doesn't want to release like that. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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: Views for a table
Experiment with dba_dependencies view. - Kirti --- Mauricio Vélez [EMAIL PROTECTED] wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: RE: pga_aggregate_target and a memory leak
Personal communication. On 01/24/2004 06:44:24 AM, Ryan wrote: where did you hear that oracle 10g was written almost entirely outside the US? what critical problems have you had with 9i? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 10:19 PM On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very courageous thing to do. I'm not sure that 10g will be stable enough for a big production database in 2 years. Experience with 9i tells us that nothing before 9.2.0.4 was not fit for a real production use. If I remember correctly, 9i is out for more then 2 years now. Have in mind that 10g is the first version that was written almost entirely outside of the US. I wouldn't rush into upgrading to 10g, if I were you. And the rumor is that 10g is so unstable that even with the standards lowered so much, Oracle doesn't want to release like that. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: [Q] create tablespace with different block size error???
It is NOT true. I did put db_16k_cache_size on init.ora file. I still work with ORACLE support engineer tried to find problem. --- Mladen Gogala [EMAIL PROTECTED] wrote: On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote: Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti He probably has left db_16k_cache_size parameter but the problem described here is with syntax, not the cache size. Parser stops looking or file attributes as soon as it encounters the first attribute that isn't a file attribute, like, for instance, block size. If he rearranges the statement, he'll get the right error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc 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: [Q] create tablespace with different block size error???
What amateur of Oracle support engineer are you working with? Mladen is right. Your syntax is wrong. Read the documentation (and suggest to the engineer he do the same): SQL create tablespace INDEX1 logging datafile '/u01/ORACLE/ora92/INDEX11.dbf' size 5m 2blocksize 16384 3autoextend on 4next 1280k 5maxsize unlimited 6extent management local 7segment space management auto 8uniform size 128k 9 / autoextend on * ERROR at line 3: ORA-02180: invalid option for CREATE TABLESPACE SQL SQL create tablespace INDEX1 logging datafile '/u01/ORACLE/ora92/INDEX11.dbf' size 5m 2autoextend on 3next 1280k 4maxsize unlimited 5blocksize 16384 6extent management local 7segment space management auto 8uniform size 128k 9 / Tablespace created. SQL At 04:49 PM 1/24/2004, you wrote: It is NOT true. I did put db_16k_cache_size on init.ora file. I still work with ORACLE support engineer tried to find problem. --- Mladen Gogala [EMAIL PROTECTED] wrote: On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote: Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti He probably has left db_16k_cache_size parameter but the problem described here is with syntax, not the cache size. Parser stops looking or file attributes as soon as it encounters the first attribute that isn't a file attribute, like, for instance, block size. If he rearranges the statement, he'll get the right error. -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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).