From daemon Tue Feb 20 00:47:20 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA26561; Tue, 20 Feb 1996 00:47:16 -0500 Message-Id: <9602200547.AA26561@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 8568; Tue, 20 Feb 96 00:35:49 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4581; Tue, 20 Feb 1996 00:35:47 -0500 Date: Tue, 20 Feb 1996 11:45:34 +0530 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Avnish Rastogi DTA Subject: Oracle Snapshot Refresh (very urgent) X-To: ORACLE-L@CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L Hi Oracle Snapshots are not refreshing automatically. Once a snapshot is refreshed manually, after that it refreshed automaticall. anybody can tell, why it is happening create statement is create snapshot .. refresh fast start with sysdate next sysdate+1 as select * from .. init.ora parameters are SNAPSHOT_REFRESH_PROCESSES=1 snapshot_refresh_interval=60 snapshot_refresh_keep_connections=FALSE job_queue_interval=60 job_queue_keep_connections=FALSE job_queue_processes=1