Unkillable Background process SHUTDOWN ABORT LEAVES UNKILLABLE PROCESSES
Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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 or mssql
That was exactly my point. It is NOT 6 of one , half dozen of the other. You commit 1000's of times for each rollback. So the data you read is incorrect while you read it with enormous odds that the changes will be committed. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 8:09 PM But Yechiel, what is better? Getting data that has not been committed by the application, or data that has been updated by an application without a commit being issued? In the mssql option, do you really want to return data as valid, taking the chance that the person who updated the record may issue a rollback? I think it's 6 of one, half a dozen of the other. At least with Oracle, it's logical and under the applications control. If the user issues a commit, then the new data is available for query. If the application needs the data commited more frequently, then issuing commits more often is certainly available. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 30, 2002 11:55 AM To: Multiple recipients of list ORACLE-L I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, 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- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- 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). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City
RE: Fw: Oracle Internals course
Stephane Faroult wrote: No John, the author of DUL is Bernard van forgot-his-name. Van Damme? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: What do you think about multiples schemas versus 1 schema
Stephane, Just thinking of a few potential issues (I've worked in a warehouse set up that way): CONS 1) Duplicate objects (same name, different schema) - can be accidentally created and cause a lot of confusion 2) Need to prefix objects with schema or create synonyms to get data from one schema to the next 3) May hit a few errors regarding permissions across schemas - all can be worked around though PROS 1) Provides logical separation between objects 2) May make it easier to provide objects for adhoc reporting, etc (users connected to dw cannot see stage tables) 3) In a complex environment it can help enforce good standards - like a dw processing job should be able to read from stage but not update it (this depends on the application design though) I would recommend having a strong naming convention, even if using multiple schema's, so that the purpose of each table is understood without knowing which schema it is in - this helps fix con#1. I think the logical separation and ability to restrict access to end users are good reasons for choosing multiple schema's though. I think schema's are a little like folders in a filesystem. Therefore your question is similar to should I put all of my documents in a single folder or should I create folders for design, construction and testing. However I do understand the issue is slightly more complex than that. Regards, Mark. paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: What do you think about multiples schemas versus 1 schema [EMAIL PROTECTED] 01/11/2002 07:09 Please respond to ORACLE-L Hi, What do you think about multiples schemas versus 1 schema, pros and cons. For example, having the schemas: stage, dw, metadata or only dw. I have my ideas but I want to check if do not missed anything. 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?paquette=20stephane?= 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 --
Re: RE: oracle or mssql
Any database engine that offers dirty-reads as an option is doing so because it hasn't perfected the ability to avoid them. The dust settled on this issue over a decade ago. Check out Gray and Reuter Transaction Processing: Concepts and Techniques (ISBN: 1558601902 - it'll be in any college library) and read the section on the ACID properties, especially the sections on C for consistency and I for isolation... Oracle is doing the best thing. It supplies statement-level read-consistency by default. The ACID properties advise transaction-level read-consistency and Oracle offers that option, but it is not advisable to use it unless you are using a transaction-processing monitor besides... Thousand-to-one odds are awful. You can run across the exception millions of times per day. 90% of all coding is created to deal with 10% or less of the possible situations... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:54 AM I would like to point out that what you call dirty reads are mostly the correct reads. Oracle method IS the dirty read. I am sure that your users does at least 1000 commits to every rollback. So when oracle gives you the data it already knows that this data is wrong. If you do the query again a minute later you will get new results that were available when you did the original query but were committed later. So you get a 1000/1 chance to get incorrect data. The dirty read method, on the other hand, gives you the current values, believing that they will be committed in a moment. So you get 1/1000 chance to get wrong data. Which odds will you bet on? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:18 PM List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, 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- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- 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). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: ORA-1078 During a 9iR2 Install
I've never been able to get into the DB yet to open it. -Scott At 03:48 PM 10/31/02 -0800, you wrote: Was your database in mount,nomount,open or IDLE state? -Original Message- Sent: Thursday, October 31, 2002 3:30 PM To: Multiple recipients of list ORACLE-L I'm really new to 9i and I vaguely heard about the spfile, so I looked in the Oracle9i New Features book (thanks RF!) to read up on the spfile. I noticed that it said that if an spfile was not created, it would default to look for the initSID.ora file. Well, I opened a SQLPLUS session and tried to use the syntax in the book to create an spfile anyway and I got the following message: --snip--- SQL CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora' FROM PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora'; CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora' * ERROR at line 1: ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS ORA-27037: unable to obtain file status HP-UX Error: 14 Bad address Additional information: 1 SQL --snip--- I think my whole problem is that the DBCA is supposed to create one for you and it never got to that point. I got the ORA-01078 error before it was ever created. Thanks so much, -Scott At 07:03 AM 10/31/02 -0800, you wrote: You should recreate your spfile. Oracle9i starts from an spfile, if it exists and some installations do put a ghost one in $ORACLE_HOME/dbs. -Original Message- From: Scott Stefick [mailto:sstefick;harper.cc.il.us] Sent: Wednesday, October 30, 2002 5:04 PM To: Multiple recipients of list ORACLE-L Subject: ORA-1078 During a 9iR2 Install Hi Gurus, Hardware: HP rp5470 OS: HP-UX 11i (11.11) Oracle Version: Enterprise Edition 9.2.0.1.0 I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is trying to create and start the database, I'm getting an ORA-1078: failure in processing system parameters error. Then when I tried startup nomount I got that error again along with LRM-00109: could not open parameter file '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message. I opened up a TAR with Oracle and so far they just made sure that my ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set correctly. they said they would get back to me on this one. Has anyone here encountered anything like this during a 9iR2 install, or does anyone have any suggestions that I could try? Thanks in advance! -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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: Gogala, Mladen 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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
RE: ORA-1078 During a 9iR2 Install
try to startup the database in nomount and then do it. -Original Message- Sent: Thursday, October 31, 2002 4:14 PM To: Multiple recipients of list ORACLE-L I've never been able to get into the DB yet to open it. -Scott At 03:48 PM 10/31/02 -0800, you wrote: Was your database in mount,nomount,open or IDLE state? -Original Message- Sent: Thursday, October 31, 2002 3:30 PM To: Multiple recipients of list ORACLE-L I'm really new to 9i and I vaguely heard about the spfile, so I looked in the Oracle9i New Features book (thanks RF!) to read up on the spfile. I noticed that it said that if an spfile was not created, it would default to look for the initSID.ora file. Well, I opened a SQLPLUS session and tried to use the syntax in the book to create an spfile anyway and I got the following message: --snip--- SQL CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora' FROM PFILE='/u01/app/oracle/admin/REGENTDB/pfile/initREGENTDB.ora'; CREATE SPFILE='/u01/app/oracle/admin/REGENTDB/pfile/spfileREGENTDB.ora' * ERROR at line 1: ORA-01078: FAILURE IN PROCESSING SYSTEM PARAMETERS ORA-27037: unable to obtain file status HP-UX Error: 14 Bad address Additional information: 1 SQL --snip--- I think my whole problem is that the DBCA is supposed to create one for you and it never got to that point. I got the ORA-01078 error before it was ever created. Thanks so much, -Scott At 07:03 AM 10/31/02 -0800, you wrote: You should recreate your spfile. Oracle9i starts from an spfile, if it exists and some installations do put a ghost one in $ORACLE_HOME/dbs. -Original Message- From: Scott Stefick [mailto:sstefick;harper.cc.il.us] Sent: Wednesday, October 30, 2002 5:04 PM To: Multiple recipients of list ORACLE-L Subject: ORA-1078 During a 9iR2 Install Hi Gurus, Hardware: HP rp5470 OS: HP-UX 11i (11.11) Oracle Version: Enterprise Edition 9.2.0.1.0 I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is trying to create and start the database, I'm getting an ORA-1078: failure in processing system parameters error. Then when I tried startup nomount I got that error again along with LRM-00109: could not open parameter file '/u01/app/oracle/product/9201/dbs/initREGENTDB.ora' error message. I opened up a TAR with Oracle and so far they just made sure that my ORACLE_HOME, ORACLE_BASE, ORACLE_SID and PATH were set correctly. they said they would get back to me on this one. Has anyone here encountered anything like this during a 9iR2 install, or does anyone have any suggestions that I could try? Thanks in advance! -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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: Gogala, Mladen 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). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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:
Re: Re Raid 5+
On Thu, 31 Oct 2002 00:33:43 -0800, John Hallas wrote: We are certainly going to be performing extensive testing to ensure performance of our applications under Raid5+ is acceptable. That means it is as good if not better than that experienced under Raid1 I once threw my redo logs onto a RAID 5 array just for grins (while doing some preproduction testing before going live with a new database). The sysadmin and I saw a huge increase in disk activity, but that increase didn't translate into a negative impact on application performance. Who cares whether the poor disks are thrashing, so long as they are keeping up, right? Even so, we couldn't bring ourselves to leave the redo on RAID 5, so we moved it into RAID 0+1 before going live. My point here is that you just might find performance to be acceptable. Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * mailto:jonathan;gennick.com * 906.387.1698 -- 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).
Fwd: Re: Reporting - Casting about for ideas
Thanks, David. What I'm looking for is actually a solution to build the infrastructrue for this. And like sqlplus, Oracle Reports can't be used for reporting on SAP systems. Thanks for the idea though. I didn't know about the report caching, and they may come in handy on another project. Jared On Thursday 31 October 2002 16:28, [EMAIL PROTECTED] wrote: We don't use the Oracle Reports Server, but I seem to remember it offers report caching. I did a quick search on Metalink and found this: Note:118223.1 TOLERANCE PARAMETER 3. Creating a backup using the Reports Server One of the parameters of the Reports Server, is the Tolerance parameter. This parameter specifies a certain period in which a report which is ran again will use the cached output iso actually running the report again. Just add the tolerance parameter to the run report command, run the report to file, run the report again, but now to the printer. When you run the report to the printer, the cached output will be used. So if the print fails, you still have the backup of the report printed to a file. And if the tolerance period has not been expired, you even have an extra copy in the cache and can issue the print command again. 4. Example In this example we will first print a report to file and then to the printer. To do this the Reports Command Line Interface is used, but the same can be done from the other run options (see chapter 2). Step 1, print the report to file: RWCLI60 report name connectstring SERVER=repserver DESTYPE=file DESNAME=filename TOLERANCE=#min eg. RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i DESTYPE=file DESNAME=emp TOLERANCE=5 Step 2, print the report to the printer using the cached output from step 1: RWCLI60 report name connectstring SERVER=repserver DESTYPE=printer DESNAME=printername TOLERANCE=#min eg. RWCLI60 emp scott/tiger@orcl SERVER=repsrv6i DESTYPE=printer DESNAME=las4d TOLERANCE=5 Make sure to specify the tolerance parameter in both calls, otherwise the cached output will not be used. In the example a tolerance of 5 minutes is specified, make sure to activate step 2 within 5 minutes of step one, otherwise the cached output will not be used. -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Thursday, October 31, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Subject: Reporting - Casting about for ideas Dear List, First, a little background. A coworker and I have been charged with developing and implementing a 'short term' 'Reporting Solution'. Glossary: short term: low cast, fast to implement, throw it away late next year Reporting Solution: Some method to make it easy for users to see oft run reports without re-running them on the production SAP ( and other apps also ) systems. The goal of the 'Reporting Solution' is perceived performance. Only 1 or 2 of these reports have any detrimental performance impact on the servers. The goal is to allow users to view current and historic reports ( up to 90 days ) without being required to wait on reports to run on the application/database servers. This is partly political, partly user friendly. The political part is that we want to do *something* for users so that it looks like we're taking their requirements to heart, even though we don't have the resources to do much right now. The user friendly part is that we want to do *something* for users so that we can make their jobs a little easier, even though we don't have the resources to do much right now. One idea we have is to have an ABAPer ( SAP programmer ) setup the most requested reports to run in batch mode with a specified range of dates and whatever parameters are needed. This would be done periodically, the report output put on a network filer or database or something accessible via browser ( no shared drive type solution, access is to iffy ), and a web page that would allow simple navigation to reports by Category/Date. Click on the report, view your data. One thing that this is *not*, is a data warehouse and/or data marts. This is to be a low cost solution. Some software OK, a server is Ok if necessary. The key is fairly easy and quick implementation. I'm open to any and all ideas you may have for this, experiences doing similar projects, etc. If it uses Oracle software, that's cool, if not, that's cool too. Oracle is involved in any solution: at the very least, that's where all our source data is stored. Thanks for reading this long winded message. Jared -- 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