Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Snapshot refreshes are failing

Snapshot refreshes are failing

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 04 Mar 2003 09:04:45 -0800
Message-ID: <F001.0055FAAC.20030304090445@fatcity.com>

Any ideas or leads on where to look next?

BANNER



Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production PL/SQL Release 8.1.6.3.0 - Production
CORE 8.1.6.0.0 Production
TNS for 32-bit Windows: Version 8.1.6.3.0 - Production NLSRTL Version 3.4.1.0.0 - Production

On a Win2K box.

SELECT * FROM SYS.V_$SESSION_WAIT;

       SID       SEQ# EVENT
P1TEXT                                                                   P1
P1RAW P2TEXT
P2 P2RAW P3TEXT
P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
---------- ----------

----------------------------------------------------------------
---------------------------------------------------------------- ----------
-------- ---------------------------------------------------------------- ---------- --------
---------------------------------------------------------------- ----------
-------- ---------- --------------- ------------------- 1 2177 pmon timer duration 300 0000012C 0 00 0 00 0 282082 WAITING 2 52909 rdbms ipc message timeout 300
0000012C
0 00
0 00                0              83 WAITING
         3       3537 rdbms ipc message
timeout                                                                 300
0000012C
0 00
0 00                0              42 WAITING
         6        550 rdbms ipc message
timeout                                                               19800
00004D58
0 00
0 00                0              42 WAITING
         8          1 rdbms ipc message
timeout                                                                6000
00001770
0 00
0 00                0              42 WAITING
        27          1 rdbms ipc message
timeout                                                                6000
00001770
0 00
0 00                0              42 WAITING
        11          1 rdbms ipc message
timeout                                                                6000
00001770
0 00
0 00                0              42 WAITING
         7          1 rdbms ipc message
timeout                                                                6000
00001770
0 00
0 00                0              33 WAITING
         4      27282 rdbms ipc message
timeout                                                                 300
0000012C
0 00
0 00                0               0 WAITING
         5      20241 smon timer
sleep time                                                              300
0000012C failed
0 00
0 00                0             401 WAITING
        21        510 SQL*Net message to client
driver id                                                        1413697536
54435000 #bytes
1 00000001
0 00               -2               0 WAITED UNKNOWN TIME
         9         35 SQL*Net message from client
driver id                                                         675562835
28444553 #bytes
1 00000001
0 00                0             410 WAITING
        14       1383 SQL*Net message from client
driver id                                                         675562835
28444553 #bytes
1 00000001
0 00                0               9 WAITING
        23      19810 SQL*Net message from client
driver id                                                         675562835
28444553 #bytes
1 00000001
0 00                0            2485 WAITING
        16      43091 SQL*Net message from client
driver id                                                        1413697536
54435000 #bytes
1 00000001
0 00                0           73019 WAITING
        17      12779 SQL*Net message from client
driver id                                                         675562835
28444553 #bytes
1 00000001
0 00                0             684 WAITING
        18      42179 SQL*Net message from client
driver id                                                        1413697536
54435000 #bytes
1 00000001
0 00                0          380653 WAITING

17 rows selected.

Tue Mar 04

POOL        Memory Structure                          Bytes
----------- ------------------------------ ----------------
            fixed_sga                                70,620
            db_block_buffers                    245,760,000
            log_buffer                               66,560
shared pool free memory                           9,421,968
shared pool miscellaneous                        38,363,336
shared pool joxs heap init                            1,108
shared pool State objects                           268,056
shared pool KQLS heap                               562,552
shared pool transactions                            231,028
shared pool table columns                            18,760
shared pool DML locks                               120,176
shared pool KGK heap                                  9,800
shared pool db_files                                185,516
shared pool db_block_hash_buckets                   371,160
shared pool PLS non-lib hp                            2,096
shared pool long op statistics array                103,840
shared pool KGFF heap                                20,244
shared pool enqueue_resources                       112,896
shared pool trigger defini                            5,968
shared pool table definiti                            1,972
shared pool db_handles                              105,000
shared pool SYSTEM PARAMETERS                        62,576
shared pool dictionary cache                      3,758,100
shared pool PL/SQL DIANA                          1,130,864
shared pool PL/SQL MPCODE                         1,073,460
shared pool fixed allocation callback                   640
shared pool library cache                         8,558,760
shared pool sql area                             26,839,020
shared pool processes                               168,000
shared pool sessions                                503,152
shared pool trigger inform                            1,676
shared pool ktlbk state objects                     110,852
shared pool event statistics per sess               792,960
shared pool db_block_buffers                      2,040,000
shared pool message pool freequeue                  231,152
large pool  free memory                           6,144,000
java pool   free memory                          20,758,528
java pool   memory in use                           212,992
                                           ----------------
sum                                             368,189,388



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: tday6_at_csc.com

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: ListGuru_at_fatcity.com (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).
Received on Tue Mar 04 2003 - 11:04:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US