Re: Purging Managed Standby Database Archive Logs
Title: RE: Purging Managed Standby Database Archive Logs Hello Steve If you are on 9.2 you can use utl_file.fremove directly from the sql. Yechiel AdarMehish - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Thursday, December 12, 2002 9:48 PM Subject: RE: Purging Managed Standby Database Archive Logs Hi John, Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn't been applied and then having to go through the hassle of finding in on tape. (We use RMAN on production server and "archivelog all delete input" every night.) A lot of logs could be zapped if the standby got hosed just before a 3-4 day weekend. I want to avoid having to rebuild the standby but I don't want to keep multiple days worth of logs around either. I just want to remove the logs that are no longer needed and the archive info is in the data dictionary views so why not use it? Well after waiting on the list a while nobody did my job for me so I got busy and rolled my own... :-) -- #!/usr/bin/ksh # File: sb_log_maint.sh ... Steve Orr, 12/12/2002 # Purpose: Purge standby database archive logs which have been applied. ORAUBIN="/u01/app/oracle/bin" SEQ_FILE="$ORAUBIN/last_purged_seqno.txt" LAST_PURGED_SEQ=`cat ${SEQ_FILE}` getAppliedLogs() { sqlplus -s "/ as sysdba" @$ORAUBIN/login.sql < set feed off pages 0 echo off wra off select sequence#, trim(name) from v\$archived_log where sequence# > $LAST_PURGED_SEQ and archived='YES' order by sequence# ; exit EOSQL } getAppliedLogs | while read SEQNO FNAME do echo "Removing file $FNAME" echo $SEQNO > $SEQ_FILE if [ -f $FNAME ]; then rm $FNAME fi done -- ...it seems to work and I wasn't in a PERLescent mood. Steve Orr Bozeman, Montana -Original Message- From: John Carlson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: Purging Managed Standby Database Archive Logs Keep it simple. If you are on unix put this in your crontab. 30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc" -mtime +0 -exec rm -f {} \; This will run every hour on the half hour and purge everything over 24 hours old. Modify as you like. (-mtime +1 gives you 48 hours) Yes, I know this could delete files that haven't been applied but I figure if your standby is 24 hours behind, it will need to be re-established anyway. HTH, John >>> [EMAIL PROTECTED] 12/12/02 08:04AM >>> Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database? I figure it needs to: 1. Query v$archived_log and v$log_history to get a list of the archive logs (v$archived_log.name) where sequence# > [the max number you purged the last time]; 2. Cycle through the above list and remove the files; 3. Record the max(sequence#) from v$log_history for the next purge. Any other ideas/suggestions? AtDhVaAnNkCsE!!! Steve Orr Standing by in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Carlson INET: [EMAIL PROTECTED]
OT: about the future of Borland's tools
If you use tools from Borland like Delphi, C++ Builder or Kylix http://delphi.about.com/library/weekly/aa112902a.htm JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
Oracle 8i (8.1.7) for Windows XP Home Edition
Quick question, has anyone managed to sucessfully install 8.1.7 on Windows XP Home Edition. I have read on metalink that this is not officially supported by Oracle, but wanted to know if anyone has managed to install it for test purposes on their home/work PC's tia Zabair -- 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).
OT - change in Oracle's marketing strategy
The article below has produced more feedback than any of the others I have written, so I thought I'd share it with Oracle-L http://www.jlcomp.demon.co.uk/tar.html Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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).
OCS install problem, featuring TaskMaster
Disclaimer: I'm a messaging & security guy. What I don't know about Oracle would fill an entire row of bookshelves. Nonetheless, I¹m trying to install OCS 9.0.2.0 on Red Hat Advanced Server 2.1. When I install the OCS infrastructure components, the install completes normally, then OUI fires off a set of configuration assistants. The specific problem I¹m having is that the Single Sign-On Config Assistant (ssoca) is crapping out, apparently because Enterprise Manager can¹t hook up to TaskMaster (whatever that is): NLS_LANG param = AMERICAN_AMERICA.WE8MSWIN1252 Portal SMI: Initialised plugin: GlobalPlugin Portal SMI: Initialised plugin: DADPlugin Portal SMI: Initialised plugin: WebDAVPlugin Portal SMI: Initialised plugin: CachePlugin Portal SMI: ERROR: Oracle home: /usr/oracle/OraHome could not be created because: oracle.ias.sysmgmt.exception.TaskException: TaskMaster initialization failed. Root Cause: Subscription request timed out after 3 millseconds ERROR : Exception while configing SSO DAD : TaskMaster initialization failed. Root Cause: Subscription request timed out after 3 millseconds Portal SMI: Terminating. Portal SMI: Terminated in: 0 milliseconds. /usr/oracle/OraHome/jdk/bin/java -jar /usr/oracle/OraHome/jlib/emConfigInstall.jar targets /usr/oracle/OraHome/sso/sso_server_target2add.xml I¹ve verified that I have the right set of kernel parameters; other than that, I don¹t know what else to check for. Any suggestions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Robichaux 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 8.1.7 on Red Hat Linux 8.0 Personal Edition
I had to download and install the following packages to get the installer running. compat_glibc-6.2-2.1.3.2.i386.rpm compat_libs-6.2 compat_egcs-6.2 to get the installer running. Thanks Sumathy -Original Message- Sent: Thursday, December 12, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Has any body got Oracle 817 working on Red Hat Linux 8.0 Personal Edition? If yes, it would be great if you would let me know whether you had to install the glibc 6.2 Thanks Sumathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Panicker, Thankam S. 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: Panicker, Thankam S. 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: OT - change in Oracle's marketing strategy
Title: RE: OT - change in Oracle's marketing strategy ROTFL ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 7:24 AM To: Multiple recipients of list ORACLE-L Subject: OT - change in Oracle's marketing strategy The article below has produced more feedback than any of the others I have written, so I thought I'd share it with Oracle-L http://www.jlcomp.demon.co.uk/tar.html Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: about the future of Borland's tools
I remember in OS/2 magazine years ago, they were talking about the uneasy relationship between Borland and Microsoft. Philippe Kahn and Bill Gates were not chummy, to say the least. I haven't worked with Delphi, but Turbo Pascal for Windows seemed incredible to me, they had an object-oriented version of Pascal that could use the foundation classes. This is about ten years ago, the Borland programmers were really good. Regards, Pat. -Original Message- Sent: Monday, December 16, 2002 7:24 AM To: Multiple recipients of list ORACLE-L If you use tools from Borland like Delphi, C++ Builder or Kylix http://delphi.about.com/library/weekly/aa112902a.htm JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Boivin, Patrice J 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: OT - change in Oracle's marketing strategy
LOL!!! Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 7:23 AM > > The article below has produced more feedback > than any of the others I have written, so I thought > I'd share it with Oracle-L > > > > http://www.jlcomp.demon.co.uk/tar.html > > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Coming soon a new one-day tutorial: > Cost Based Optimisation > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > England__January 21/23 > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jonathan Lewis > 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: Igor Neyman 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).
Locally Partitioned Index
Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? Base Table being RANGE Partitioned -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: OEM email problems (unix)
More info needed. But see if you can ping the mail server. Make sure you are actually using the mail server you think you are and not solaris's sendmail. Try putting MS exchange host and IP in /etc/hosts On Sun, 15 Dec 2002, Don wrote: > we are stumped. > > We have installed OEM 9.2, the console, the OMS, and 9.2 repository on a > solaris 5.9 box. > > So far, we are not able to send any email from the console, no matter what > we try. The messages generally indicated that the email SMPT host (a MS > exchange server) can not be found. > > We found some info on Metalink that led us through some command line tests, > which were all successful. > > The Unix admin, the network folks, the Exchange people, and even a > consultant that wondered by, have all given up. > > any ideas? > > Don > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don > 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: Alex 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: Locally Partitioned Index
Title: RE: Locally Partitioned Index Like this? CREATE INDEX vegas_mart_date_of_sale_idx ON vegas_mart (date_of_sale, julian_run_date) local tablespace lrg_index_a / base table partitions reside in 3 different tablespaces. Lisa Koivu Oracle Databonehead Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Subject: Locally Partitioned Index Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? Base Table being RANGE Partitioned -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: Locally Partitioned Index
Vivek - I don't think that should be a problem. Just specify the desired tablespace in your CREATE INDEX statement. Here is a good article on creating partitioned indexes. http://www.oracle-base.com/Articles/8i/PartitionedTablesAndIndexes.asp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 16, 2002 7:59 AM To: Multiple recipients of list ORACLE-L Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? Base Table being RANGE Partitioned -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: DENNIS WILLIAMS 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: Locally Partitioned Index
Specify the TABLESPACE clause for the index globally (i.e. outside all partition clauses) or individually for each partition. This can be done for all partitioning methods (i.e. RANGE, HASH, or LIST) and composites (i.e. RANGE-HASH and RANGE-LIST)... > > > Is it possible to Create a Locally partitioned Index in a > Tablespace Different from the Base Table Tablespace ? Base > Table being RANGE Partitioned -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com -- > Author: VIVEK_SHARMA > 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).
RE: Locally Partitioned Index
Yes. Check the complete syntax options for CREATE INDEX command. - Kirti -Original Message- Sent: Monday, December 16, 2002 7:59 AM To: Multiple recipients of list ORACLE-L Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? Base Table being RANGE Partitioned -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: 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).
RE: SQL question avoiding 2 views and not in
Thanks for the where clause and to all who respond, I'll check into fine grained access control (dbms_rls). --- "Khedr, Waleed" <[EMAIL PROTECTED]> a écrit : > Add this to where clause: > > group <> decode(user,'typical',380,-100) > > Instead of -100 use any number not used by the > groups. > > Also read about contexts and grain level security. > > Waleed > > -Original Message- > Sent: Friday, December 13, 2002 2:59 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > We have a lot of views. Now the users have a new > requirement, only the user 'admin' can see all the > data from the views. The user 'typical' must see all > data except the one from group 380. > > A basic solution is to create 2 sets of views with > one > set having a group number <> 380. > > I'm looking for a solution to have only one set of > views. It's friday afternoon and I have no > inspiration > :-( > > TIA > > > = > Stéphane Paquette > DBA Oracle et DB2, consultant entrepôt de données > Oracle and DB2 DBA, datawarehouse consultant > [EMAIL PROTECTED] > > __ > Lèche-vitrine ou lèche-écran ? > magasinage.yahoo.ca > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Stephane=20Paquette?= > 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: Khedr, Waleed > 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). > = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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: OT - change in Oracle's marketing strategy
The following was an actual bug in Oracle's "bug" database; doesn't seem searchable anymore and has likely been archived recently, for some reason. Please note that the bug has been open for over 8 years and that all lines preceded with "@" are intended to be censored for viewing by Oracle Development personnel only, so please consider this info to be confidential... :-) **( Source: BUGREP ) BugDB see No Base Bug Related Bugs : Customer: GREAT MODELING AGENCY Created: 17-NOV-94 Component: RDBMSComp Ver: 7.0.16.4 Rel St: P Updated: 04-MAR-02 Sub Comp: RDBMSRDBMS Ver: 7.0.16.4 By: AOLGREN Status: 92,Closed, Not a Bug Sup Pri: 4,Minor Error, No Loss of ServiceFixed In Ver: O/S: 1 Digital VAX OpenVMS PL Group: DEC Gen/Port: G Error #: ORA-600 Pub: N ** Hdr: 250845 7.0.16.4 RDBMS 7.0.16.4 RDBMS PRODID-5 PORTID-1 ORA-600 Abstract: RECEIVED THE SPORT JACKET FROM ORACLEWEAR AND IT HAS A HOLE IN THE BACK *** VKHACHAD 11/17/94 08:46 am *** @ part number is: ora-3 @ tried fixing it myself, but I poked my finger with the needle. I need someone @ experienced to help me with this. @ Size of sweater: Medium @ Color: Red @ I will be happy with any workaround as long as it has the Oracle name on it. @ The sweater is in bug$ @ I'm cold without it, so please hurry. *** VKHACHAD 11/17/94 09:09 am *** (CHG: Sta->92) @ Closed. *** VKHACHAD 11/17/94 09:30 am *** (CHG: Pri->4) *** MRAMACHE 11/17/94 09:42 am *** @ c generic (white) patch has been provided, please open another bug to have it @ ported to red. *** MRAMACHE 11/17/94 10:09 am *** @Note that without the proper use of mothballs, we can't guarantee this @won't happen again. *** CELSBERN 11/17/94 02:13 pm *** (CHG: Sta->11) @ Reopening bug. The generic white patch will not work with my RS/6000. Please @ port to IBM blue. *** MRAMACHE 11/17/94 02:45 pm *** (CHG: Sta->92) *** WDSOUZA 11/17/94 03:35 pm *** @ can not reproduce the GREATEST OracleWear with the LATEST OracleWear. So @ Update the wear *** SSHAMBAR 11/21/94 07:43 pm *** (CHG: Sta->11) @ Client received patch, client does not know how to stitch a crosshatch @ (as indicated in README). Could development please provide iron-on. *** EKAARTO 11/21/94 10:23 pm *** @ Question -- @ Is Oracle-WARE, HardWARE, firmWARE, softWARE, or underWARE ?? @ depending on where the hole is in the product, the patch will either be stiched @ or ironed on patch. *** PGREENWA 11/22/94 10:32 am *** (CHG: Sta->32) *** PGREENWA 11/22/94 10:32 am *** @ Sorry, iron-on is currently not a supported feature. Please file an @ enhancement request. *** VKHACHAD 11/28/94 09:58 am *** (CHG: Sta->92) *** SPILLAI 12/01/94 10:45 am *** @Since no one can "close" this bug @ This is not a bug but a feature. It was used in the wrong "environment". It is @ to be used in summer when it would let the air in and keep your body cool. *** BUG 05/01/95 10:56 am *** (CHG: Prod->510) *** BUG 05/01/95 01:51 pm *** (CHG: Prod->5) *** DSHELLIT 12/23/97 02:07 pm *** @ This can not be backported. Only applicable to current releases. *** DHAYTER 06/11/99 07:40 am *** @ Surely this bug was filed under the wrong port. @ JACKET was only ever available on Alpha - along with TIE and VEST @ (check it out!) *** GHAYDEN 06/11/99 08:03 am *** @ To add a cautionary note... if ironed on patch does become supported, @ remember to REMORACLEWARE prior to applying patch. *** HBERGH 07/02/99 03:12 pm *** (CHG: Sta->30) *** HBERGH 07/02/99 03:12 pm *** (CHG: Confirmed Flag->N) *** HBERGH 07/02/99 03:12 pm *** @Are there any traces of a file on the jacket? If there are, then this is most @likely caused by incorrect installation of the jacket. Do not open the package @using a nail file. User error. @If no file traces are found, then this should be changed to a documentation @bug. *** AMOHAMED 08/16/99 09:19 am *** @ Is it possible for customer to obtain a plug-in to solve the current problem? @ The theory being that a plug-in would make the jacket compatible with use @ during winter time and removing the plug-in would make the jacket compatible @ during summer time. @ A possible plug-in would be dependent on the size of the problem whereby a @ range of options starting from 1st finger upto whole fist could be used. @ Hope this helps towards fixing the bug. *** ETLEWIS 08/25/99 03:20 pm *** @After many hours of research and testing, I think this bug can be closed. The @documentation does not state there should be a "hole" in the back. The @documentation does not address holes at all. Turns out what the client was @referring to was the "Hole" where the head goes Seems client (who was an @Oracle Consultant) tried to patch that hole because he was getting wet when it @rained. @. @Some people don't know enough to come in out of the r
Parallel degree on tables and indexes
List, Is there a 'magic' number for num_rows that you use in order to set the parallel degree on tables and/or indexes? We were told to use parallel degree of 4 for tables having more than 100,000 rows. Some of the on-line queries are running in parallel mode thus making batch jobs to go serial for lack of parallel slaves. Upon a closer look, we see tables/indexes having millions of rows having parallel degree set at 1 and tables/indexes having fewer than 100,000 rows are having parallel degree set at 4 etc., Is there a number for num_rows that you have been very successful to determine the parallel degree? Some of the indexes were re-built using parallel degree of 3 to reduce the 'create index' time but were not changed back to 'noparallel' recently and I need to answer these questions. TIA. Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: <[EMAIL PROTECTED] 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: New course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10&p_org_id=1001&lang=US Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: New course for 9i - Dumps/Crashes from Oracle University LOL Search Results For: D12856GC10 No items found. "Jamadagni, Rajendra" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> gni Subject: New course for 9i - Dumps/Crashes from Oracle University @espn.com> Sent by: root 12/13/2002 01:59 PM Please respond to ORACLE-L http://education.oracle.com and search for D12856GC10 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! << Attachment Removed : ESPN_Disclaimer.txt >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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 ---
alert log suppression
Title: alert log suppression Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA
Re: Locally Partitioned Index
Vivek, Yes. There is no restriction whatsoever in the tablespace where an index or its partitions can be created and there is no relationship to the tablespace of the base table. Just as you could create an index in a tablespace different from that of the table, you could create any index partition in any tablespace, different from the table's tablespaces. In fact that is recommended for performance and reliability reasons. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 8:58 AM > > > Is it possible to Create a Locally partitioned Index in a Tablespace Different from the Base Table Tablespace ? > Base Table being RANGE Partitioned > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > 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: Arup Nanda 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).
Sun Solaris
List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: DUAL
Title: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) > -Original Message- > From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: DUAL > > > Thanks for the great suggestion! > I will remember to use that one when > those developers start getting too lippy ;-) > > Babette > -Original Message- > Richard > Sent: Thursday, December 12, 2002 4:14 PM > To: Multiple recipients of list ORACLE-L > > > Howdy, > > I believe that truncating DUAL has also been known to leave developers > scratching their head. Of course I could never recommend > that anyone try > it though. > > > > > "Farnsworth, Dave" > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > iture.com> cc: > Sent by: Subject: DUAL > [EMAIL PROTECTED] > > > 13/12/2002 05:14 > Please respond to > ORACLE-L > > > > > > > Hallo, > > Problems with dual, please read link > > http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 > 497,00.html > > TIA, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > 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). > > > > > << > >> > > Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly > notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not > consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<>>> > >> > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Richard > 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: Babette Turner-Underwood > 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: Sun Solaris
Title: RE: Sun Solaris sunhelp.org for general. sunmanagers.org for critical. requires summary post and is more restrictive. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Sun Solaris List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: New course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University Nowhere in particular ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Sun Solaris
Go to this page and join the SOLARIS-L list. http://www.openitx.com/nav/t.asp?t=507&p=607&h1=507&h2=571&h3=607 This page has a bunch of other OS lists as well. -Original Message- Sent: Monday, December 16, 2002 9:59 AM To: Multiple recipients of list ORACLE-L List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: Kevin Lange 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: Sun Solaris
Try this: http://unix.ittoolbox.com/ Gillian "Ehresmann, David" <[EMAIL PROTECTED]> wrote: List,Does anybody know a Sun Solaris e-mail list/forum that's useful like thisone is for Oracle?thanks, David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ehresmann, DavidINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: Oracle 8i (8.1.7) for Windows XP Home Edition
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition Didn't try 8.1.7, but 9i went in just fine. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 16, 2002 3:54 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 8i (8.1.7) for Windows XP Home Edition > > > Quick question, has anyone managed to sucessfully install > 8.1.7 on Windows XP > Home Edition. I have read on metalink that this is not > officially supported by > Oracle, but wanted to know if anyone has managed to install > it for test > purposes on their home/work PC's > > tia > > Zabair > > -- > 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). >
RE: Sun Solaris
> >List, > >Does anybody know a Sun Solaris e-mail list/forum that's >useful like this >one is for Oracle? > Try http://www.sunhelp.org/mailman/listinfo/sunhelp Eddie Watkins The Moray Council email: [EMAIL PROTECTED] tel: 01343 563247 The Moray Council: Internet E-mail Notice The contents of this e-mail and any attachments ('this e-mail') are confidential and intended solely for the addressee. If this e-mail has been sent to you by mistake, please notify [EMAIL PROTECTED] as soon as possible; you should then delete this e-mail from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eddie Watkins 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: alert log suppression
The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ > tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: New course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University There will probably be others in the series... Looks like one of the 8i Internals seminars has made it to 9i! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10&p_org_id=1001&lang=US Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! also send the HELP command for other information (like subscribing).
RE: Parallel degree on tables and indexes
Title: RE: Parallel degree on tables and indexes Govind, a statement like 'use parallel = 4 for tables over 100,000 rows' is like saying drive to Iowa, go that way. The parallel degree should at least take into account the resources on your box. It can be larger than the number of CPU's on your box as long as it doesn't start thrashing and swapping. Partitioned objects are usually good candidates for a parallel degree > 1. Also a bit of knowledge as to when the tables/indexes are used and for what purpose helps. The answer to this question may be different for different times of the day - for example, daily user interaction and night batch execution. Sorry, seems to me there's no quick and easy answer. Tuning is an ongoing process that isn't completed overnight. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: Parallel degree on tables and indexes List, Is there a 'magic' number for num_rows that you use in order to set the parallel degree on tables and/or indexes? We were told to use parallel degree of 4 for tables having more than 100,000 rows. Some of the on-line queries are running in parallel mode thus making batch jobs to go serial for lack of parallel slaves. Upon a closer look, we see tables/indexes having millions of rows having parallel degree set at 1 and tables/indexes having fewer than 100,000 rows are having parallel degree set at 4 etc., Is there a number for num_rows that you have been very successful to determine the parallel degree? Some of the indexes were re-built using parallel degree of 3 to reduce the 'create index' time but were not changed back to 'noparallel' recently and I need to answer these questions. TIA. Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: <[EMAIL PROTECTED] 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: Sun Solaris
SunHelp. Oddly enough, when I asked _them_ for a list just like theirs, but for Oracle, they directed me to Oracle-L.. http://www.sunhelp.org/lists.php Also useful for the knowledge of all things geeky are Recsue and Geeks, same page. ~brian -Original Message- Sent: Monday, December 16, 2002 9:59 AM To: Multiple recipients of list ORACLE-L List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: Brian Dunbar 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: Sun Solaris
David, http://www.sunmanagers.org/ HTH Barry -Original Message- Sent: 16 December 2002 15:59 To: Multiple recipients of list ORACLE-L List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: Barry Deevey 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: Sun Solaris
This one is good: http://www.sunmanagers.org/mailman/listinfo/sunmanagers. -bill At 07:58 AM 12/16/2002 -0800, you wrote: List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: Bill CONNER 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: Parallel degree on tables and indexes
Ah, yes...the magic number. For all questions requiring a magic number, that number is 42. ;) -Original Message- Sent: Monday, December 16, 2002 8:39 AM To: Multiple recipients of list ORACLE-L List, Is there a 'magic' number for num_rows that you use in order to set the parallel degree on tables and/or indexes? We were told to use parallel degree of 4 for tables having more than 100,000 rows. Some of the on-line queries are running in parallel mode thus making batch jobs to go serial for lack of parallel slaves. Upon a closer look, we see tables/indexes having millions of rows having parallel degree set at 1 and tables/indexes having fewer than 100,000 rows are having parallel degree set at 4 etc., Is there a number for num_rows that you have been very successful to determine the parallel degree? Some of the indexes were re-built using parallel degree of 3 to reduce the 'create index' time but were not changed back to 'noparallel' recently and I need to answer these questions. TIA. Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: <[EMAIL PROTECTED] 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: Fink, Dan 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: alert log suppression
Title: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: RE: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: RE: alert log suppression Coalescing LMTs is unnecessary ! - Kirti -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: Message Thanks for the info Igor. In addition to this I am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: RE: alert log suppression If it is LMT, coalescing is ignored. -Original Message-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: alert log suppression Coalescing LMTs is unnecessary ! - Kirti -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 8i (8.1.7) for Windows XP Home Edition
Title: RE: Oracle 8i (8.1.7) for Windows XP Home Edition i was able to install 8.1.5 sometime back.. but it made my xp terribly slow.. some jdk issues, i guess.. babu - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 11:49 AM Subject: RE: Oracle 8i (8.1.7) for Windows XP Home Edition Didn't try 8.1.7, but 9i went in just fine. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 16, 2002 3:54 AM > To: Multiple recipients of list ORACLE-L > Subject: Oracle 8i (8.1.7) for Windows XP Home Edition > > > Quick question, has anyone managed to sucessfully install > 8.1.7 on Windows XP > Home Edition. I have read on metalink that this is not > officially supported by > Oracle, but wanted to know if anyone has managed to install > it for test > purposes on their home/work PC's > > tia > > Zabair > > -- > 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). >
Re: alert log suppression
Title: Message Richard, I have here versions 8.1.5 and 9.2. Both show allocation type "UNIFORM" for LMTs with uniform extent size (except LM SYSTEM and UNDO tablespaces in 9.2 , for which "SYSTEM" allocation type is shown), and allocation type "USER" for dictionary managed tablespaces. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 2:09 PM Subject: RE: alert log suppression Thanks for the info Igor. In addition to this I am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: OCS install problem, featuring TaskMaster
Bad form to follow up to my own post, but so what. It turns out that this particular problem was caused by (get ready) not having an /etc/hosts entry for localhost. Once I fixed that, I was able to rerun ssoca and the other config assistants that failed, and I now (appear to) have a functional 9iAS install. Props go to Dennis Thayer of Warnock Tanner & Associates for the answer. > -Original Message- > From: Paul E. Robichaux > Sent: Monday, December 16, 2002 7:50 AM > To: [EMAIL PROTECTED] > Subject: OCS install problem, featuring TaskMaster > > > Disclaimer: I'm a messaging & security guy. What I don't know > about Oracle would fill an entire row of bookshelves. > > Nonetheless, I¹m trying to install OCS 9.0.2.0 on Red Hat > Advanced Server 2.1. When I install the OCS infrastructure > components, the install completes normally, then OUI fires > off a set of configuration assistants. The specific problem > I¹m having is that the Single Sign-On Config Assistant > (ssoca) is crapping out, apparently because Enterprise > Manager can¹t hook up to TaskMaster (whatever that is): > > > > NLS_LANG param = AMERICAN_AMERICA.WE8MSWIN1252 > > Portal SMI: Initialised plugin: GlobalPlugin > > Portal SMI: Initialised plugin: DADPlugin > > Portal SMI: Initialised plugin: WebDAVPlugin > > Portal SMI: Initialised plugin: CachePlugin > > Portal SMI: ERROR: Oracle home: /usr/oracle/OraHome could not > be created > because: oracle.ias.sysmgmt.exception.TaskException: > TaskMaster initialization failed. > > Root Cause: Subscription request timed out after 3 millseconds > > ERROR : Exception while configing SSO DAD : > > TaskMaster initialization failed. > > Root Cause: Subscription request timed out after 3 millseconds > > Portal SMI: Terminating. > > Portal SMI: Terminated in: 0 milliseconds. > > /usr/oracle/OraHome/jdk/bin/java -jar > /usr/oracle/OraHome/jlib/emConfigInstall.jar targets > /usr/oracle/OraHome/sso/sso_server_target2add.xml > > > I¹ve verified that I have the right set of kernel parameters; > other than that, I don¹t know what else to check for. Any suggestions? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul E. Robichaux 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: New course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University Oracle Corporation is conducting these 3 highly technical seminars. Each one of them is a full day class at a cost of $500 per class. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12856GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12858GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12860GC10 -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University There will probably be others in the series... Looks like one of the 8i Internals seminars has made it to 9i! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10&p_org_id=1001&lang=US Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! also send the HELP command for other information (like subscribing).
Re: RMAN datafile allocation to channels
My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are used for the next. This is empiracal thought, what I have observed. I have 2 channels going to one disk. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, December 15, 2002 1:38 PM > Does anyone know how RMAN decides which data files get backed up by which > channels. I'm backing up to disk and have 4 channels, each to a separate > disk drive. The data files seem to get assigned to channels at random. Also, > this is a version 8.0.5 database (U). > > Keith > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. If the reader of this message is not the intended recipient, > you are hereby notified that your access is unauthorized, and any review, > dissemination, distribution or copying of this message including any > attachments is strictly prohibited. If you are not the intended > recipient, please contact the sender and delete the material from any > computer. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).
Cross version SNAPSHOT/MATERIALIZED VIEW replication
Our current master is 8.1.6.3 as is our Snapshot database. However, at some time in the future our master database will be upgraded to 8.1.7.4. Our options are to stay with 8.1.6.3, upgrade to 8.1.7.4, or upgrade to 9.1.2. We can do this either before or after the master's upgrade. So our possible configurations are: MASTERSLAVE 8.1.6.3 8.1.7.4 8.1.6.3 9.1.2 8.1.7.4 8.1.6.3 8.1.7.4 8.1.7.4 8.1.7.4 9.1.2 These will be upgrades in place. Also, our customers are using a variety of methods to access the snapshot database including SQLNet and ODBC. I don't think that the OS environments are an issue but the master is on a DEC/Alpha UNIX box and the snapshot is on a Win2K box. Has anybody done this (upgrades in place for any of the master/slave pairs) and, if so, did you run into any issues? Any input will be gratefully accepted in the spirit in which it is offered. We are RTing the FMs for all they're worth but the upgrade in place is treated as a non-issue (which I suspect is not the case) and I'd rather hear from someone who has actually done it. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Leading spaces in dbms_output.put_line
Good afternoon, Some time ago there was a response to the question of how to get leading spaces to display when using dbms_output.put_line. I have tried - dbms_output.put_line(' '||tabrec.table_name); but do not get the leading spaces. When someone mentioned how to do this I said "of course" but naturally have forgotten the technique. Can some one share? Thanks folks... = Steve Haas Opus Consultants, LLC 860.408.1512 (office/fax) 860.651.9475 (home) [EMAIL PROTECTED] [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Haas 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: alert log suppression
Title: Message Rich, You just gave the answer yourself, allocation_type in dba_tablespaces should show UNIFORM for uniform extent allocation. For non-uniform allocation, it will show SYSTEM in that field. If you want to know what is the size of the uniform extent, look for INITIAL_EXTENT and NEXT_EXTENT; they should be same. HTH. Arup - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 2:09 PM Subject: RE: alert log suppression Thanks for the info Igor. In addition to this I am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: RMAN Reporting?
Add them together! Or are we so in need of a technical solution that we forget the pencil and paper? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 2:30 PM > Yes. The completion_time is available for the backup > piece (BP) and the backup set (BS) but not for the > entire backup. That would be fine if there was a way > of relating the "pieces" or "sets" to a single backup > but I see no way of doing this. > > > --- Original Message --- > To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> > > >Did you try running a query against rman.bp. It has > a column called > >completion_time. > > > >Ruth > >- Original Message - > >To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]> > >Sent: Wednesday, December 11, 2002 1:11 PM > > > > > >> Is there no way to produce a report from the RMAN > >> views/tables that lists the date and duration of the > >> backups for each database? I have pored through the > RC > >> views and can produce such a report at the backup > set > >> level but not at the database level. > >> > >> Am I missing something? Any suggestions? > >> > >> Thanks. > >> -w > >> > >> -- > >> Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >> -- > >> Author: Walter K > >> 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: Ruth Gramolini > > 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: Walter K > 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: Ruth Gramolini 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: alert log suppression
Title: Message ok good thats what I had expected, I found that the particular TS was created differently in another instance. Thanks for your time. -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, I have here versions 8.1.5 and 9.2. Both show allocation type "UNIFORM" for LMTs with uniform extent size (except LM SYSTEM and UNDO tablespaces in 9.2 , for which "SYSTEM" allocation type is shown), and allocation type "USER" for dictionary managed tablespaces. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 2:09 PM Subject: RE: alert log suppression Thanks for the info Igor. In addition to this I am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option), you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE > 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Is it possible to suppress successful DDL within the > alter log? > For example, I have a cron job that coalesces 300+ tablespaces > which creates a couple line entry for each. I would > like to > get feedback only if the DDL has actually failed. > > TIA > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: New course for 9i - Dumps/Crashes from Oracle University
Title: RE: New course for 9i - Dumps/Crashes from Oracle University I took this seminar set last year for Oracle 8i. It's really very good, but only a little was able to really soak in. I'm trying to convince manglement to let us go again. I had a professor in college who's first lesson was that he - despite speaking 8 languages, having 2 or 3 doctoral degrees in languages and such, and having many years of teaching experience - was more ignorant than we students. His lesson was "The more you know, the more you know you don't know". I am now more ignorant of Oracle than I was a year ago, and I think I could learn more this time. So far, it's not flying, but I haven't given up! Cheers, Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University Oracle Corporation is conducting these 3 highly technical seminars. Each one of them is a full day class at a cost of $500 per class. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12856GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12858GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12860GC10 -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University There will probably be others in the series... Looks like one of the 8i Internals seminars has made it to 9i! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University What is the world coming to? -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: New course for 9i - Dumps/Crashes from Oracle University hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10&p_org_id=1001&lang=US Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! also send the HELP command for other information (like subscribing).
RE: RMAN datafile allocation to channels
Keith - We were using 2 channels writing to disk and RMAN was putting almost an equal amount of data to each channel. For space purposes we needed to put more data to one disk. The only way I found to do this was to create 2 channels to the disk I needed to write the most data. That works fine, but seems a little crude. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 16, 2002 1:49 PM To: Multiple recipients of list ORACLE-L My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are used for the next. This is empiracal thought, what I have observed. I have 2 channels going to one disk. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, December 15, 2002 1:38 PM > Does anyone know how RMAN decides which data files get backed up by which > channels. I'm backing up to disk and have 4 channels, each to a separate > disk drive. The data files seem to get assigned to channels at random. Also, > this is a version 8.0.5 database (U). > > Keith > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. If the reader of this message is not the intended recipient, > you are hereby notified that your access is unauthorized, and any review, > dissemination, distribution or copying of this message including any > attachments is strictly prohibited. If you are not the intended > recipient, please contact the sender and delete the material from any > computer. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: DENNIS WILLIAMS 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: Leading spaces in dbms_output.put_line
Steve, Have a look at Metalink Doc ID: Note:108091.1 For those without Metalink access this suggests: 1) Use "format wrapped" at the end of your "Set Serveroutput" command. This works with SQL Plus version 3.3 or above. This will keep leading spaces and double spacing 2) If you're on an older database, you can use CHR(10) and CHR(9) to produce blank lines and leading spaces respectively I have also found that 3) chr(0) works as well (found in http://www.quest-pipelines.com/Pipelines/PLSQL/archives/search.sql) Cheers, Bruce Reardon -Original Message- Sent: Tuesday, 17 December 2002 7:14 AM Good afternoon, Some time ago there was a response to the question of how to get leading spaces to display when using dbms_output.put_line. I have tried - dbms_output.put_line(' '||tabrec.table_name); but do not get the leading spaces. When someone mentioned how to do this I said "of course" but naturally have forgotten the technique. Can some one share? Thanks folks... Steve Haas Opus Consultants, LLC 860.408.1512 (office/fax) 860.651.9475 (home) [EMAIL PROTECTED] [EMAIL PROTECTED] -- 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).
RE: warehouse builder's dependance on oem job system.
Title: RE: warehouse builder's dependance on oem job system. Chris, if its a plsql job then tcl wrapper script in oem would be same. but your runtime parameters could be diff. As others have mentioned, u could just run package.main, just verify that the package has been configured with the right runtime parameters in OWB. btw when use the method (forgot that name for passing parameters ) "=>" u need now worry about parameter position. -Mandar -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: warehouse builder's dependance on oem job system. wow. thank you. i will be testing this in the afternoon but before i do, i have one more question. we have ~50 jobs we would like to cron instead of submit to oem. so my question is, are these tcl arguments in the same order and of the same # for every job? or is there some way to determine the order and position they should be when executing the package? thank you so much for your help. -Original Message- From: Mandar A. Ghosalkar [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: warehouse builder's dependance on oem job system. Chris, the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parList_i]] set p_num_errors [lindex $parList [incr parList_i]] set p_commit_frequency [lindex $parList [incr parList_i]] set p_bulk_size [lindex $parList [incr parList_i]] set p_purge_group [lindex $parList [incr parList_i]] set p_percentage [lindex $parList [incr parList_i]] and then the package.main is called try the following. i would recommend testing this on the test server before putting it on prod :-) sql>exec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode => 3, p_audit_level => 2, p_max_errors => 50, p_commit_frequency => 1000, p_bulk_size => 50, p_job => 'wb'); -Mandar Original Message- Sent: Thursday, December 12, 2002 1:09 PM To: Multiple recipients of list ORACLE-L here is the tcl that was generated: "-r" "3,2,50,1000,50,wb,10" "-c" "WE8MSWIN1252" the package that is generated is quite long. i have absolutely no idea how to read the tcl. if you could point me somewhere, i could try and figure it out myself. any help is appreciated. attached is the package code if you are willing to take a look... (for some reason my computer associates .pls extensions with real audio) -Original Message- Sent: Tuesday, December 10, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message- Sent: Tuesday, December 10, 2002 9:31 AM To: Multiple recipients of list ORACLE-L ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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:
RE: Parallel degree on tables and indexes
Yes, but what was the question? "Fink, Dan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/16/2002 10:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Parallel degree on tables and indexes Ah, yes...the magic number. For all questions requiring a magic number, that number is 42. ;) -Original Message- Sent: Monday, December 16, 2002 8:39 AM To: Multiple recipients of list ORACLE-L List, Is there a 'magic' number for num_rows that you use in order to set the parallel degree on tables and/or indexes? We were told to use parallel degree of 4 for tables having more than 100,000 rows. Some of the on-line queries are running in parallel mode thus making batch jobs to go serial for lack of parallel slaves. Upon a closer look, we see tables/indexes having millions of rows having parallel degree set at 1 and tables/indexes having fewer than 100,000 rows are having parallel degree set at 4 etc., Is there a number for num_rows that you have been very successful to determine the parallel degree? Some of the indexes were re-built using parallel degree of 3 to reduce the 'create index' time but were not changed back to 'noparallel' recently and I need to answer these questions. TIA. Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: <[EMAIL PROTECTED] 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: Fink, Dan 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).
Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question
Happy Holidays Everyone! I have been hacking around the MetalLink site looking for how to move from using a TNSNAMES.ORA file to Active Directory. We use a mixed environment of HP-UX, Solaris, and Windows, with versions of Oracle from 7.3.4 (really!) to 9iR2. All the notes and docs I can find seem to be only for a Windows environment. Any pointers to docs or tips would be appreciated. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).
OCM
Hi there! Wondering if it is worth becoming Oracle Certified Master, considering the investment for Oracle University courses and Fee for the Practicum. I estimate 2*$1500 for courses and $2000 for practicum totaling to $5000. Any opinions? Also, I have two questions: (1) There are pre-requisite courses for the Advanced DBA courses - For example, if we want to take "Oracle 9i: Security", we should have attended "Oracle 9i DBA Fundamentals I" and "Oracle 9i DBA Fundamentals II". But, when I called Oracle Support, and they have told that these are not mandatory. Did I understand correctly? (2) Do you know of any discounts available for Oracle University courses (for OTN members, or otherwise) Any help is highly appreciated. HTH, Krishna
Capacity Planning -- Expecting the DB growth !!!
Title: Blank Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like "thanks giving" , "holiday season" and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu <>
export porblem ???
guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING". But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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: Capacity Planning -- Expecting the DB growth !!!
Title: Blank so how r u gonna do it? 1 business object = n number of rows in m different tables + indexes if regular day then x number of business objects are created if holiday then y number of business objects are created and are u going to considering the historical growth of database objects during regular and holidays? do u hv tablespace space consumption for the last couple of yrs to get a good graph and extrapolate (?) it. -Mandar -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 6:19 PMTo: Multiple recipients of list ORACLE-LSubject: Capacity Planning -- Expecting the DB growth !!! Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like "thanks giving" , "holiday season" and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu
Re: Purging Managed Standby Database Archive Logs
Title: RE: Purging Managed Standby Database Archive Logs For pre 9i release2 there is following Note on metalink Doc ID: Note:190311.1 Subject: ** How to delete an Operating System file from PL/SQL This uses a java stored procedure HTH Shaleen - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 12:38 AM Subject: Re: Purging Managed Standby Database Archive Logs Hello Steve If you are on 9.2 you can use utl_file.fremove directly from the sql. Yechiel AdarMehish - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Thursday, December 12, 2002 9:48 PM Subject: RE: Purging Managed Standby Database Archive Logs Hi John, Keeping things simple sometimes complicates things when they go haywire. I thought about the simple shotgun approach but wanted something a little more robust and I didn't want to risk deleting an archive log that hadn't been applied and then having to go through the hassle of finding in on tape. (We use RMAN on production server and "archivelog all delete input" every night.) A lot of logs could be zapped if the standby got hosed just before a 3-4 day weekend. I want to avoid having to rebuild the standby but I don't want to keep multiple days worth of logs around either. I just want to remove the logs that are no longer needed and the archive info is in the data dictionary views so why not use it? Well after waiting on the list a while nobody did my job for me so I got busy and rolled my own... :-) -- #!/usr/bin/ksh # File: sb_log_maint.sh ... Steve Orr, 12/12/2002 # Purpose: Purge standby database archive logs which have been applied. ORAUBIN="/u01/app/oracle/bin" SEQ_FILE="$ORAUBIN/last_purged_seqno.txt" LAST_PURGED_SEQ=`cat ${SEQ_FILE}` getAppliedLogs() { sqlplus -s "/ as sysdba" @$ORAUBIN/login.sql < set feed off pages 0 echo off wra off select sequence#, trim(name) from v\$archived_log where sequence# > $LAST_PURGED_SEQ and archived='YES' order by sequence# ; exit EOSQL } getAppliedLogs | while read SEQNO FNAME do echo "Removing file $FNAME" echo $SEQNO > $SEQ_FILE if [ -f $FNAME ]; then rm $FNAME fi done -- ...it seems to work and I wasn't in a PERLescent mood. Steve Orr Bozeman, Montana -Original Message- From: John Carlson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Subject: Re: Purging Managed Standby Database Archive Logs Keep it simple. If you are on unix put this in your crontab. 30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc" -mtime +0 -exec rm -f {} \; This will run every hour on the half hour and purge everything over 24 hours old. Modify as you like. (-mtime +1 gives you 48 hours) Yes, I know this could delete files that haven't been applied but I figure if your standby is 24 hours behind, it will need to be re-established anyway. HTH, John >>> [EMAIL PROTECTED] 12/12/02 08:04AM >>> Any one have a ready-made routine to purge the unneeded archives which have been automagically applied to a managed standby database? I figure it needs to: 1. Query v$archived_log and v$log_history to get a list of the archive logs (v$archived_log.name) where sequence# > [the max number you purged the last time]; 2. Cycle through the above list and remove the files; 3. Record the max(sequence#) from v$log_history for the next purge. Any other ideas/suggestions? AtDhVaAnNkCsE!!! Steve Orr Standing by in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Carlson INET: [EMAIL PROTECTED]
Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question
Vergara, Michael (TEM), I think what you need is the names server, though it is seldom used . Regards zhu chao [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-12-16 16:08:00 ,you wrote£º=== >Happy Holidays Everyone! > >I have been hacking around the MetalLink site looking for how to >move from using a TNSNAMES.ORA file to Active Directory. We use a >mixed environment of HP-UX, Solaris, and Windows, with versions >of Oracle from 7.3.4 (really!) to 9iR2. > >All the notes and docs I can find seem to be only for a Windows >environment. Any pointers to docs or tips would be appreciated. > >Thanks, >Mike > >--- >=== >Michael P. Vergara >Oracle DBA >Guidant Corporation > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Vergara, Michael (TEM) > 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: chao_ping 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: export porblem ???
Are you importing indexes? How many indexes there are on table #17? Is the DB in archive log mode? Is the archiver getting stuck? - Kirti -Original Message- Sent: Monday, December 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L guys, i am exporting a DB of size 10G. it totally has 33 tables. everything completes succesfully and even the log file says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING". But while importing it,only 17 tables are imported. after that the cursor stands still and the import does not process further.the remaining 16 tables are not imported at all. why is it so ? have any of you come across such situation ? will datafiles of size greater than 2G cause such problem ? the DB is on oracle 8.1.6/Win2k. kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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: 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).
RE: Capacity Planning -- Expecting the DB growth !!!
Title: Blank Craig Shallahamer has a good training class on this topic : http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=cp_course - Kirti -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 8:19 PMTo: Multiple recipients of list ORACLE-LSubject: Capacity Planning -- Expecting the DB growth !!! Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like "thanks giving" , "holiday season" and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu
Locally Partitioned Index
> Is it possible to Create a Locally partitioned Index in a Tablespace Different from >the Base Table Tablespace ? > Base Table being RANGE Partitioned > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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).
password
how can a dba see the password of a user.The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad 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).
Problem with SQL query
Hi all, I have the following query which is running slow and doing full table scan on DIENSTLEISTUNGSOBJEKT and FZGBRIEF tables. I have created all the neccessary indexes on these two tables apart from other tables. In this regard I request you to help me in tuning the below query so that the full table scan is avoided and the response time is less. > > > > > select > ZPAA.AUFTRAGSPOSITION.POSITIONSNUMMER, > ZPAA.AUFTRAGSPOSITION.ZAHLUNGSART, > ZPAA.AUFTRAGSPOSITION.ZAHLUNGSARTTYP, > ZPAA.AUFTRAGSPOSITION.VORGANGSNUMMER, > to_char( AUFTRAG.AUFTRAGERTEILTDATUM, 'DD-MM-'), > ZPAA.AUFTRAG.AUFTRAGSNUMMER, > ZPAA.FAHRZEUG.AMTLICHESKENNZEICHEN, > ZPAA.FAHRZEUG.FZGHALTERNAME, > ZPAA.FZGBRIEF.FAHRZEUGARTTEXT, > ZPAA.RECHNUNG.PREISGRUPPE, > NULL BETRAG, > NULL QUITTUNGSNR, > ZPAA.PLAKETTENERGEBNIS.PLAKETTENLAUFZEITSTR, > ZPAA.PLAKETTENERGEBNIS.PLAKETTENZUTEILUNG, > ZPAA.AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID, > S.MATERIALNUMMER, > S.ERZEUGNISNR, > ZPAA.AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE, > PARTNER_PRUEFORT.PARTNERNUMMER, > PARTNER_MHS.PARTNERNUMMER, > PARTNER_AG.PARTNERNUMMER, > PARTNER_AG.NAME, > PARTNER_SV.PARTNERNUMMER, > S.SVDIENSTLEISTUNGOID, > to_char(S.ERZEUGNISDATUM, 'DD-MM-'), > S.ERGEBNIS, > S.SPERGEBNIS, > S.SPPLAKETTE, > ZPAA.AUFTRAGSPOSITION.DIENSTLEISTUNGSGRUPPE, > ZPAA.AUFTRAGSPOSITION.DIENSTLEISTUNGSBEZEICHNUNG, > NULL BETRAGOFFEN, > NULL PARTNERNUMMER, > NULL ENDEZEIT, > NULL TAGESABSCHLUSSNUMMER > from > ZPAA.FAHRZEUG, > ZPAA.AUFTRAG, > ZPAA.AUFTRAGSPOSITION, > ZPAA.FZGBRIEF, > ZPAA.PLAKETTENERGEBNIS, > ZPAA.AUFTRAGSPOSPOSITIONSSTATUS, > ZPAA.DIENSTLEISTUNGSOBJEKT D, > ZPAA.RECHNUNG, > ZPAA.SVDIENSTLEISTUNG S, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_PRUEFORT, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_MHS, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_AG, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_SV > where > > ZPAA.AUFTRAGSPOSITION.TAGESABSCHLUSSNUMMER = :TAGESABSCHLUSSNUMMER > > AND AUFTRAG.VORGANGSNUMMER = AUFTRAGSPOSITION.VORGANGSNUMMER > > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID = S.AUFTRAGSPOSITIONOID > > AND S.SVDIENSTLEISTUNGOID = D.SVDIENSTLEISTUNGOID > AND D.DIENSTLEISTUNGSOBJEKTOID > FAHRZEUG.DIENSTLEISTUNGSOBJEKTOID > AND D.SEQNO = (SELECT E.SEQNO FROM > ZPAA.DIENSTLEISTUNGSOBJEKT E ,ZPAA.SVDIENSTLEISTUNG S1 > WHERE S1.SVDIENSTLEISTUNGOID = E.SVDIENSTLEISTUNGOID > AND S1.SVDIENSTLEISTUNGOID = S.SVDIENSTLEISTUNGOID > AND ROWNUM < 2) > AND FAHRZEUG.FAHRZEUGOID = FZGBRIEF.FAHRZEUGOID > AND S.ERGEBNIS = PLAKETTENERGEBNIS.PLAKETTENERGEBNISOID(+) > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > RECHNUNG.AUFTRAGSPOSITIONOID > AND AUFTRAGSPOSITION.AKTUELLERSTATUS > AUFTRAGSPOSPOSITIONSSTATUS.AUFTRAGSPOSITIONSSTATUSOID > AND (AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE = '6' > OR AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE = '8') > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_PRUEFORT.AUFTRAGSPOSITIONOID(+) > AND PARTNER_PRUEFORT.ROLLENTYP(+) = 'ZP' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_MHS.AUFTRAGSPOSITIONOID(+) > AND PARTNER_MHS.ROLLENTYP(+) = 'MHS' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_AG.AUFTRAGSPOSITIONOID(+) > AND PARTNER_AG.ROLLENTYP(+) = 'AG' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_SV.AUFTRAGSPOSITIONOID(+) > AND PARTNER_SV.ROLLENTYP(+) = 'ZT' > Operation Object Name RowsBytes CostTQ In/Out > PStart PStop > > SELECT STATEMENT Hint=HINT: RULE > > NESTED LOOPS > > NESTED LOOPS > > NESTED LOOPS > > NESTED LOOPS > >
Re: Capacity Planning -- Expecting the DB growth !!!
Title: Blank Load 5-10% of the stuff and see how much it takes . From this you can calculate. No formula will give you accurate results, mainly because actual field length vary so much that approximation is useless. (based on a lot of years checking this) Yechiel AdarMehish - Original Message - From: Reddy, Madhusudana To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 17, 2002 4:18 AM Subject: Capacity Planning -- Expecting the DB growth !!! Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size , even by considering events like "thanks giving" , "holiday season" and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would you help me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu
RE: Locally Partitioned Index
Hi Vivek, Yes, one can specify the breakout of the index partitions and define the location for storing them. Here is an example: CREATE INDEX pt_projects on projects(month_num) LOCAL( PARTITION imonth1 TABLESPACE idx1, PARTITION imonth1 TABLESPACE idx1, PARTITION imonth1 TABLESPACE idx1, PARTITION imonth1 TABLESPACE idx1, PARTITION imonth1 TABLESPACE idx1, PARTITION imonth1 TABLESPACE idx1, > -Original Message- > From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 9:44 AM > To: Multiple recipients of list ORACLE-L > Subject: Locally Partitioned Index > > > > > Is it possible to Create a Locally partitioned Index in a Tablespace > Different from the Base Table Tablespace ? > > Base Table being RANGE Partitioned > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > 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). WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishnaswamy, Ranganath 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: DUAL
Title: RE: DUAL So listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel AdarMehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) > -Original Message- > From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: DUAL > > > Thanks for the great suggestion! > I will remember to use that one when > those developers start getting too lippy ;-) > > Babette > -Original Message- > Richard > Sent: Thursday, December 12, 2002 4:14 PM > To: Multiple recipients of list ORACLE-L > > > Howdy, > > I believe that truncating DUAL has also been known to leave developers > scratching their head. Of course I could never recommend > that anyone try > it though. > > > > > "Farnsworth, Dave" > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > iture.com> cc: > Sent by: Subject: DUAL > [EMAIL PROTECTED] > > > 13/12/2002 05:14 > Please respond to > ORACLE-L > > > > > > > Hallo, > > Problems with dual, please read link > > http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 > 497,00.html > > TIA, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > 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). > > > > > << > >> > > Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly > notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not > consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<>>> > >> > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Richard > 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: Babette Turner-Underwood > 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: password
Walk over to their desk and look for post-it notes attached to the monitor. Failing that you probably have to ask them. As I understand it, you cannot "reverse-engineer" a password from within Oracle. The common workaround scripts available store the encrypted password in a temporary table, change the password, let you connect and then copy the encrypted password back when complete. This might be ok depending on what you need to do. But why would you need their password anyway? "faisal ahmad" tmail.com> cc: Sent by:Subject: password [EMAIL PROTECTED] 17/12/2002 15:09 Please respond to ORACLE-L how can a dba see the password of a user. The new MSN 8: smart spam protection and 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: faisal ahmad 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). <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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: export porblem ???
Hello After building a table the import builds constraint and indexes. If you got a big table that can take awhile. Check with task/performance monitor if the instance is idle or working. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 4:28 AM > guys, > > i am exporting a DB of size 10G. > it totally has 33 tables. > everything completes succesfully and even the log file > says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING". > > But while importing it,only 17 tables are imported. > after that the cursor stands still and the import does > not process further.the remaining 16 tables are not imported > at all. > > why is it so ? have any of you come across such situation ? > > will datafiles of size greater than 2G cause such problem ? > > the DB is on oracle 8.1.6/Win2k. > > kindly let me know guys. > > TIA. > Jp. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: oraora oraora > 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: Yechiel Adar 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: Problem with SQL query
In the explain plan's first line SELECT STATEMENT Hint=HINT: RULE But i don't see any rule hint in the SQL statement you have sent. Analyze the tables/indexes, use a choose hint and run the SQL plan again. What version you are on? what is the value of optimizer_mode, optimizer_goal Regards Naveen -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hi all, I have the following query which is running slow and doing full table scan on DIENSTLEISTUNGSOBJEKT and FZGBRIEF tables. I have created all the neccessary indexes on these two tables apart from other tables. In this regard I request you to help me in tuning the below query so that the full table scan is avoided and the response time is less. > > > > > select > ZPAA.AUFTRAGSPOSITION.POSITIONSNUMMER, > ZPAA.AUFTRAGSPOSITION.ZAHLUNGSART, > ZPAA.AUFTRAGSPOSITION.ZAHLUNGSARTTYP, > ZPAA.AUFTRAGSPOSITION.VORGANGSNUMMER, > to_char( AUFTRAG.AUFTRAGERTEILTDATUM, 'DD-MM-'), > ZPAA.AUFTRAG.AUFTRAGSNUMMER, > ZPAA.FAHRZEUG.AMTLICHESKENNZEICHEN, > ZPAA.FAHRZEUG.FZGHALTERNAME, > ZPAA.FZGBRIEF.FAHRZEUGARTTEXT, > ZPAA.RECHNUNG.PREISGRUPPE, > NULL BETRAG, > NULL QUITTUNGSNR, > ZPAA.PLAKETTENERGEBNIS.PLAKETTENLAUFZEITSTR, > ZPAA.PLAKETTENERGEBNIS.PLAKETTENZUTEILUNG, > ZPAA.AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID, > S.MATERIALNUMMER, > S.ERZEUGNISNR, > ZPAA.AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE, > PARTNER_PRUEFORT.PARTNERNUMMER, > PARTNER_MHS.PARTNERNUMMER, > PARTNER_AG.PARTNERNUMMER, > PARTNER_AG.NAME, > PARTNER_SV.PARTNERNUMMER, > S.SVDIENSTLEISTUNGOID, > to_char(S.ERZEUGNISDATUM, 'DD-MM-'), > S.ERGEBNIS, > S.SPERGEBNIS, > S.SPPLAKETTE, > ZPAA.AUFTRAGSPOSITION.DIENSTLEISTUNGSGRUPPE, > ZPAA.AUFTRAGSPOSITION.DIENSTLEISTUNGSBEZEICHNUNG, > NULL BETRAGOFFEN, > NULL PARTNERNUMMER, > NULL ENDEZEIT, > NULL TAGESABSCHLUSSNUMMER > from > ZPAA.FAHRZEUG, > ZPAA.AUFTRAG, > ZPAA.AUFTRAGSPOSITION, > ZPAA.FZGBRIEF, > ZPAA.PLAKETTENERGEBNIS, > ZPAA.AUFTRAGSPOSPOSITIONSSTATUS, > ZPAA.DIENSTLEISTUNGSOBJEKT D, > ZPAA.RECHNUNG, > ZPAA.SVDIENSTLEISTUNG S, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_PRUEFORT, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_MHS, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_AG, > ZPAA.AUFTRAGSPOSITIONSPARTNER PARTNER_SV > where > > ZPAA.AUFTRAGSPOSITION.TAGESABSCHLUSSNUMMER = :TAGESABSCHLUSSNUMMER > > AND AUFTRAG.VORGANGSNUMMER = AUFTRAGSPOSITION.VORGANGSNUMMER > > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID = S.AUFTRAGSPOSITIONOID > > AND S.SVDIENSTLEISTUNGOID = D.SVDIENSTLEISTUNGOID > AND D.DIENSTLEISTUNGSOBJEKTOID > FAHRZEUG.DIENSTLEISTUNGSOBJEKTOID > AND D.SEQNO = (SELECT E.SEQNO FROM > ZPAA.DIENSTLEISTUNGSOBJEKT E ,ZPAA.SVDIENSTLEISTUNG S1 > WHERE S1.SVDIENSTLEISTUNGOID = E.SVDIENSTLEISTUNGOID > AND S1.SVDIENSTLEISTUNGOID = S.SVDIENSTLEISTUNGOID > AND ROWNUM < 2) > AND FAHRZEUG.FAHRZEUGOID = FZGBRIEF.FAHRZEUGOID > AND S.ERGEBNIS = PLAKETTENERGEBNIS.PLAKETTENERGEBNISOID(+) > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > RECHNUNG.AUFTRAGSPOSITIONOID > AND AUFTRAGSPOSITION.AKTUELLERSTATUS > AUFTRAGSPOSPOSITIONSSTATUS.AUFTRAGSPOSITIONSSTATUSOID > AND (AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE = '6' > OR AUFTRAGSPOSPOSITIONSSTATUS.STATUSCODE = '8') > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_PRUEFORT.AUFTRAGSPOSITIONOID(+) > AND PARTNER_PRUEFORT.ROLLENTYP(+) = 'ZP' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_MHS.AUFTRAGSPOSITIONOID(+) > AND PARTNER_MHS.ROLLENTYP(+) = 'MHS' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID > PARTNER_AG.AUFTRAGSPOSITIONOID(+) > AND PARTNER_AG.ROLLENTYP(+) = 'AG' > AND AUFTRAGSPOSITION.AUFTRAGSPOSITIONOID
Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question
I am currently busy with the same project. Junk tnsnames.ora for OID. I installed OID 9.2.0.1. I then converted the tnsnames.ora to OID entries with no problems. I then tried to access the OID from 8.1.6 client and got zilch, nada, gurnisht etc. . After Deborah from Oracle Israel came in she told me that I need to create the Oracle Context under an entry in the root and not in the OID root itself. After we did that 8.1.6 and 9.2.0.1 clients worked with OID version 9.2.0.1. Still testing on my machine. After we solve the problem of replication and Failover (two OID servers with the client automatically switching from one to the other in case of failure (not clustering)) I will think about moving it to the users. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 2:08 AM > Happy Holidays Everyone! > > I have been hacking around the MetalLink site looking for how to > move from using a TNSNAMES.ORA file to Active Directory. We use a > mixed environment of HP-UX, Solaris, and Windows, with versions > of Oracle from 7.3.4 (really!) to 9iR2. > > All the notes and docs I can find seem to be only for a Windows > environment. Any pointers to docs or tips would be appreciated. > > Thanks, > Mike > > --- > === > Michael P. Vergara > Oracle DBA > Guidant Corporation > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vergara, Michael (TEM) > 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: Yechiel Adar 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).