1 2 Previous Next 19 Replies Latest reply on Apr 24, 2017 9:52 AM by User258546 Go to original post
      • 15. Re: UCM Search is not working , i'm getting error while perform search
        User258546

        output of srdc_text_hc.sql
        <pre>

        +----------------------------------------------------+
        | Diagnostic-Name: Text_Health_Check
        | Timestamp:       2017-04-21 10:18:18 -04:00
        | Machine:         eojsacovnd04
        | Version:         11.2.0.3.0
        | DBName:          VZIMUTA
        | Instance:        VZIMUTA1
        +----------------------------------------------------+
        </pre>
        Oracle Text Health Check Tool 04-21-2017 10:18:18
        .
        **********************************************************************
        Database:
        **********************************************************************
        --> name:                    VZIMUTA
        --> version:                 11.2.0.3.0
        .
        **********************************************************************
        Database Components:
        **********************************************************************
        --> OLAP Catalog                        11.2.0.3.0   VALID
        --> Oracle Application Express          3.2.1.00.1   VALID
        --> OLAP Analytic Workspace             11.2.0.3.0   VALID
        --> Oracle Database Catalog Views       11.2.0.3.0   VALID
        --> Oracle Database Java Packages       11.2.0.3.0   VALID
        --> Oracle Database Packages and Types  11.2.0.3.0   VALID
        --> Oracle Text                         11.2.0.3.0   VALID
        --> Oracle Enterprise Manager           11.2.0.3.0   VALID
        --> Oracle Expression Filter            11.2.0.3.0   VALID
        --> JServer JAVA Virtual Machine        11.2.0.3.0   VALID
        --> Oracle Multimedia                   11.2.0.3.0   VALID
        --> OWB                                 11.2.0.3.0   VALID
        --> Oracle Workspace Manager            11.2.0.3.0   VALID
        --> Oracle Real Application Clusters    11.2.0.3.0   VALID
        --> Oracle Rules Manager                11.2.0.3.0   VALID
        --> Spatial                             11.2.0.3.0   VALID
        --> Oracle XML Database                 11.2.0.3.0   VALID
        --> Oracle XDK                          11.2.0.3.0   VALID
        --> Oracle OLAP API                     11.2.0.3.0   VALID
        .
        **********************************************************************
        Oracle Text Status and Version:
        **********************************************************************
        .. CTXSYS data dictionary version (Ver Dict) : 11.2.0.3.0
        .. Linked-in code version (Ver Code) : 11.2.0.3.0
        .. DRI Version : 11.2.0.3.0
        .
        **********************************************************************
        Invalid Objects in CTXSYS Schema:
        **********************************************************************
        There are no invalid objects in the CTXSYS schema
        .
        **********************************************************************
        Possible Text-related Objects under the SYS schema:
        **********************************************************************
        .. SYS.DRISGP -  PACKAGE BODY -  INVALID

        If objects are listed above, review the following notes:
          Note 1313273.1 - Invalid SYS-Owned Text Objects / How To Remove
              Text Objects From The SYS Schema When Text Is Installed/In Use?
          Note 558894.1  - Invalid Oracle Text Object Under User SYS Even
              When Oracle Text is not Installed
        If Oracle Text is invalid, open a Service Request.
          Support, see INTERNAL Note.746970.1.
        .
        **********************************************************************
        Compilation errors of invalid Text-related objects under
        CTXSYS and SYS schemas:
        **********************************************************************
        .. PACKAGE BODY SYS.DRISGP
        .... at Line/Col: 1/14
        .... PLS-00201: identifier 'DRISGP' must be declared
        .. PACKAGE BODY SYS.DRISGP
        .... at Line/Col: 1/14
        .... PLS-00304: cannot compile body of 'DRISGP' without its specification
        .. PACKAGE BODY SYS.DRISGP
        .... at Line/Col: 0/0
        .... PL/SQL: Compilation unit analysis terminated
        .
        **********************************************************************
        Summary count of CTXSYS schema objects:
        **********************************************************************
        .. FUNCTION           2
        .. INDEX             63
        .. INDEXTYPE          4
        .. LIBRARY            1
        .. LOB                2
        .. OPERATOR           6
        .. PACKAGE           74
        .. PACKAGE BODY      63
        .. PROCEDURE          3
        .. SEQUENCE           3
        .. TABLE             50
        .. TYPE              35
        .. TYPE BODY          6
        .. VIEW              77
        .
        **********************************************************************
        Text Indexes:
        **********************************************************************
        .. VZHIST_OCS.FT_IDCTEXT1 is VALID
        .... Table: VZHIST_OCS.IDCTEXT1, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZHIST_OCS.FT_IDCTEXT2 is VALID
        .... Table: VZHIST_OCS.IDCTEXT2, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZHROPT_OCS.FT_IDCTEXT1 is VALID
        .... Table: VZHROPT_OCS.IDCTEXT1, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZHROPT_OCS.FT_IDCTEXT2 is VALID
        .... Table: VZHROPT_OCS.IDCTEXT2, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZLABORRELA_OCS.FT_IDCTEXT1 is VALID
        .... Table: VZLABORRELA_OCS.IDCTEXT1, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZLABORRELA_OCS.FT_IDCTEXT2 is VALID
        .... Table: VZLABORRELA_OCS.IDCTEXT2, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZPAY_OCS.FT_IDCTEXT1 is VALID
        .... Table: VZPAY_OCS.IDCTEXT1, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZPAY_OCS.FT_IDCTEXT2 is VALID
        .... Table: VZPAY_OCS.IDCTEXT2, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZPROD_OCS.FT_IDCTEXT1 is VALID
        .... Table: VZPROD_OCS.IDCTEXT1, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .. VZPROD_OCS.FT_IDCTEXT2 is VALID
        .... Table: VZPROD_OCS.IDCTEXT2, Indexed Column: DDOCNAME
        .... Index Type: CONTEXT
        .
        **********************************************************************
        Ten (10) most recent text index errors (ctx_index_errors):
        **********************************************************************
        There are no errors logged in CTX_INDEX_ERRORS
        .
        **********************************************************************
        Testing Text Index Creation:
        **********************************************************************
        ..Creating user TEXT_HEALTHCHECK
        ....User TEXT_HEALTHCHECK created successfully
        ..Testing creation of Text index type CONTEXT
        ....Creating table TEXT_HC_TAB
        ....Inserting test data
        ....Creating text index TEXT_HC_IDX
        ....Text index TEXT_HC_IDX created successfully

        ..Dropping user TEXT_HEALTHCHECK
        ....User TEXT_HEALTHCHECK dropped successfully

        Text Index Creation Test complete
        .
        **********************************************************************
        Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
        With the Partitioning, Real Application Clusters, OLAP, Data Mining
        and Real Application Testing options

        • 16. Re: UCM Search is not working , i'm getting error while perform search
          User258546

          VZIMUTA> select * from  VZPROD_OCS.OUTPUT;

           

          RESULT

          -------------------------------------------------------------------------------

          ===========================================================================

                         
          STATISTICS FOR "VZPROD_OCS"."FT_IDCTEXT2"

          ===========================================================================

           

          indexed
          documents:                                            
          1,681,108

          allocated
          docids:                                             
          1,684,504

          $I
          rows:                                                      
          4,394,306

           

          ---------------------------------------------------------------------------

                                     
          TOKEN STATISTICS

          ---------------------------------------------------------------------------

           

          unique
          tokens:                                                
          4,138,714

          average $I rows per
          token:                                         
          1.06

          tokens with most $I rows:

            IDCNULL
          (0:TEXT)                                               
          17,610

            XIPM_APP_1_26 (2:ZONE
          SEC)                                      
          4,159

            XIPM_APP_2_11 (2:ZONE
          SEC)                                      
          4,142

            IPM
          (0:TEXT)                                                    
          3,959

            XIPM_APP_2_9 (2:ZONE
          SEC)                                       
          3,799

            1
          (0:TEXT)                    
                                            3,302

            XIPM_APP_1_17 (2:ZONE
          SEC)                                      
          2,760

            XIPM_APP_2_13 (2:ZONE
          SEC)                                      
          2,679

            AGENTSERVICEUSER
          (0:TEXT)                                       
          2,600

            TIF
          (0:TEXT)                                                    
          2,579

            ZDSECURITYGROUP (2:ZONE
          SEC)                                    
          1,985

            XVZ_AMS_MEDICALNOTES
          (2:ZONE
          SEC)                               
          1,979

            DPUBLISHTYPE (2:ZONE SEC)
                                                  1,977

            DDOCOWNER (2:ZONE
          SEC)                                          
          1,974

            DORIGINALNAME (2:ZONE
          SEC)                                      
          1,966

            XIDCPROFILE (2:ZONE
          SEC)                                  
                1,955

            XWEBFLAG (2:ZONE
          SEC)                                           
          1,945

            XCOMMENTS (2:ZONE
          SEC)                                          
          1,939

            XVZ_AMS_ADMINNOTES
          (2:ZONE
          SEC)                                 
          1,871

            FFOLDERNAME (2:ZONE
          SEC)                                        
          1,871

            XIPM_APP_10_12 (2:ZONE
          SEC)                                     
          1,867

            DFULLTEXTFORMAT (2:ZONE
          SEC)                                    
          1,864

            XIPMSYS_APP_ID (2:ZONE
          SEC)                         
                      1,860

            XIPM_APP_10_17 (2:ZONE
          SEC)                                     
          1,856

            DGIF (2:ZONE
          SEC)                                               
          1,844

            XPARTITIONID (2:ZONE
          SEC)                                       
          1,841

            DOCUMENT
          (0:TEXT)                                               
          1,836

            XIPM_APP_2_10 (2:ZONE
          SEC)                                      
          1,834

            XIPM_APP_10_0 (2:ZONE
          SEC)                                      
          1,824

            XIPM_APP_2_14 (2:ZONE SEC)                    
                            1,821

            XIPM_APP_10_1 (2:ZONE
          SEC)                                      
          1,818

            DREVLABEL (2:ZONE
          SEC)                                          
          1,815

            XIPM_APP_1_10 (2:ZONE
          SEC)                                      
          1,813

            XIPM_APP_1_11 (2:ZONE
          SEC)                                      
          1,810

            DDOCCREATOR (2:ZONE
          SEC)                                        
          1,805

            XIPM_APP_1_12 (2:ZONE
          SEC)                                      
          1,800

            XIPM_APP_10_5 (2:ZONE
          SEC)    
                                            1,797

            DWEBEXTENSION (2:ZONE
          SEC)                                      
          1,795

            XIPM_APP_10_20 (2:ZONE
          SEC)                                     
          1,793

            XIPM_APP_1_16 (2:ZONE
          SEC)                                      
          1,787

            XSTORAGERULE (2:ZONE
          SEC)                                       
          1,774

            XVZSSNLASTFOUR (2:ZONE
          SEC)                                     
          1,773

            XIPM_APP_2_8 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_2_7 (2:ZONE SEC)
                                                  1,773

            XIPM_APP_2_4 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_2_3 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_2_2 (2:ZONE
          SEC)                                 
                1,773

            XIPM_APP_2_1 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_2_0 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_9 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_8 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_7 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_6 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_5 (2:ZONE
          SEC)                           
                      1,773

            XIPM_APP_1_4 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_3 (2:ZONE
          SEC)                                       
          1,773

            XIPM_APP_1_29 (2:ZONE
          SEC)

           

          • 17. Re: UCM Search is not working , i'm getting error while perform search
            User258546

            SQL ordered by Cluster Wait Time

            • %Total - Cluster Time  as a percentage of Total Cluster Wait Time
            • %Clu   - Cluster Time  as a percentage of Elapsed Time
            • %CPU   - CPU Time      as a percentage of Elapsed Time
            • %IO    - User I/O Time as a percentage of Elapsed Time
            • Only SQL with Cluster Wait Time > .005 seconds is reported
            • Total Cluster Wait Time (s):              90
            • Captured SQL account for   92.3% of Total
            Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO   SQL IdSQL ModuleSQL Text
            39.9825244.54210.8218.9616.6157.581mb78bgcmq5svJDBC Thin Client BEGIN CTX_DDL.SYNC_INDEX(:1 , ...
            37.0622,46041.29179.5420.647.4766.37bwf9gntjkmzzwJDBC Thin Client insert into "VZPROD_OCS"."DR$F...
            34.3040538.21204.9516.738.5268.2991w2tnsqf3s00JDBC Thin Client INSERT INTO IdcText1(dDocName,...
            3.0023.3431.469.533.5683.170muw7xuyp0a4rJDBC Thin Client SELECT Revisions.dRevClassID F...
            1.563,0821.742.5760.909.5126.484kmcppy281g0nJDBC Thin Client insert into "VZPROD_OCS"."DR$F...
            1.366,1861.5114.509.3620.8363.418kgwmjvvr90qyJDBC Thin Client SELECT/*+ USE_NL (Revisions Do...
            1.3526,1861.516.0222.5134.490.01715tk4xc0tjxcJDBC Thin Client UPDATE RevClasses SET dRevClas...
            1.1821.324.9923.6732.4530.006ajkhukk78nsr  begin prvt_hdm.auto_execute( :...
            1.1441.277.3815.4022.1842.220xr4t2tfn3m79SQL*Plus select /*NORULE */ 'DATAPOINT ...
            0.8520.951.5355.6630.7621.306wm3n4d7bnddg  SELECT source, (case when tim...
            0.50320.566.447.7833.4245.766gvch1xu9ca3g  DECLARE job BINARY_INTEGER := ...
            0.5040.568.555.8316.7042.321jkqtvuahshwrSQL*Plus insert into P$CANTEXTFILE(file...
            0.4840.545.189.3418.2151.626uvzftsujw5s6SQL*Plus select /*NORULE */ 'DATA:'||A....
            0.2950.320.8035.8239.062.769dhn1b8d88dpf  select OBJOID, CLSOID, RUNTIME...
            0.1720,0000.196.692.5241.6325.748df8rv6sxsadaJDBC Thin Client UPDATE/*+ INDEX (Revisions dRe...
            0.166,5870.1873.610.221.2494.7508435bgs3279dJDBC Thin Client SELECT * FROM FileStorage WHER...
            0.1110,0000.122.923.8146.959.56agcqsqs3p2wp6JDBC Thin Client UPDATE/*+ INDEX (Revisions PK_...
            0.076,3020.080.818.5678.711.7319x1189chq3xd  SELECT LOCKID FROM DBMS_LOCK_A...
            0.0610,0000.072.232.9047.1917.682jfugh3kmfcr2JDBC Thin Client UPDATE RevClasses SET dIndexed...
            0.0610.073.441.711.8695.24ajymgnp1qnruw  select o.name, o.owner# from o...
            0.061720.060.3317.5819.6348.5118naypzfmabd6  INSERT INTO MGMT_SYSTEM_PERFOR...
            0.0697,8520.0617.840.3133.250.787avk1qcda3sgyRecognitionServer.exe SELECT "ECCOMMENT" FROM ECBATC...
            0.0480.050.924.5651.5831.63ffd74jm9nb9hqJDBC Thin Client SELECT NULL AS table_cat, o.ow...
            0.0497,4920.0425.830.1423.750.43a42sj2ts1munqImportServer.exe UPDATE ECBATCHES SET "ECNAME" ...
            0.0397,4930.0316.730.1839.360.7752dphyx10q6pzImportServer.exe UPDATE ECBATCHES SET "ECCOMMIT...
            0.0240.020.464.8811.400.93a0hysrqc16zsaSQL*Plus declare cursor c_tempTbspData ...
            0.0240.022.001.004.600.0041ma32pk3awpdSQL*Plus declare v_bytes NUMBER; v_incr...
            0.0240.020.394.898.120.00dvmgtd5ad3xcmSQL*Plus SELECT TABLESPACE_NAME, SUM(FR...
            0.0248,8680.0215.290.1324.660.13aahazjq6km6wuRecognitionServer.exe INSERT INTO ECBATCHLOCKS( "ECF...
            0.0140.010.0267.2542.860.005gkuw9zf0wqptSQL*Plus select /*NORULE */ 'DATAPOINT'...
            0.011600.010.442.4125.7141.08a5xywkfbpw8q9JDBC Thin Client SELECT * FROM ScheduledJobs WH...
            0.0140.012.550.302.661.006p1159fwkdnvbSQL*Plus insert into P$AUTOEXTTS select...
            0.01640.010.106.5585.930.004gjq0xf0rw497SEVERITY EVALUATION SELECT /*+ cardinality(d 20) *...
            0.01410.010.0512.9831.3752.381nx1518vff191  UPDATE MGMT_COLLECTION_TASKS S...
            0.016,1860.012.240.2938.690.07gaz3df6czs8rnJDBC Thin Client SELECT/*+ USE_NL (Revisions Do...
            0.01890.010.0510.9733.9345.21davq1msn9b8kd  UPDATE MGMT_POLICY_ASSOC_EVAL_...
            0.0130.010.212.521.9587.92d2zat51t1fac0JDBC Thin Client SELECT/*+ USE_NL (WorkflowDocu...

            Back to SQL Statistics
            Back to Top

            Complete List of SQL Text

            SQL IdSQL Text
            045brvnnytxvtSELECT DISTINCT child.xIPM_APP_2_4 FROM DOCMETA child ORDER BY child.xIPM_APP_2_4 ASC
            04b2278hf0hr9SELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84972
            06pmyvpq0a589SELECT "ECINDEXES" FROM ECBATCHPAGES WHERE ROWID = :1
            08435bgs3279dSELECT * FROM FileStorage WHERE dID=:"SYS_B_0" AND dRenditionId=:"SYS_B_1"
            0b8swzadycg2pSELECT ecFileCabinets.*,  ecFileCabinets."ROWID" FROM ecFileCabinets ORDER BY ecName
            0bp7g2ft797dqSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84920
            0h1gsvau4xm7aSELECT DISTINCT child.xIPM_APP_2_2 FROM DOCMETA child ORDER BY child.xIPM_APP_2_2 ASC
            0muw7xuyp0a4rSELECT Revisions.dRevClassID FROM Revisions,  RevClasses WHERE (dReleaseState not in (:"SYS_B_0",  :"SYS_B_1",  :"SYS_B_2",  :"SYS_B_3") OR dReleaseState = :"SYS_B_4" AND dIndexedID > :"SYS_B_5") AND (dStatus =:"SYS_B_6" OR dStatus =:"SYS_B_7" OR dStatus = :"SYS_B_8") AND (dIndexerState = :"SYS_B_9" OR dIndexerState is null) AND Revisions.dRevClassID = RevClasses.dRevClassID
            0xr4t2tfn3m79select /*NORULE */ 'DATAPOINT free_space ' bpb,  decode(min((a.BYTES_FREE / b.BYTES) * 100),  '',  'NULL',  min((a.BYTES_FREE / b.BYTES) * 100)) from (select /*NORULE */ tfs_b.name tablespace_name,  tfs_b.ts# ts#,  sum(nvl(tfs_a.bytes,  0)) bytes_free from dba_free_space tfs_a,  sys.ts$ tfs_b,  dba_tablespaces tfs_c where tfs_b.name = tfs_a.tablespace_name and tfs_b.name = tfs_c.tablespace_name and tfs_b.online$ != 3 and tfs_c.contents != 'UNDO' group by tfs_b.name,  tfs_b.ts# union all select p.name tablespace_name, p.ts# ts#,  (p.space_free + q.undo_free) bytes_free from (select /*NORULE */ s.name, s.ts# ts#, sum(nvl(r.bytes, 0)) space_free from dba_free_space r, sys.ts$ s, dba_tablespaces t where s.name = r.tablespace_name and s.name = t.tablespace_name and s.online$ != 3 and t.contents = 'UNDO' group by s.name, s.ts#) p,  (select /*NORULE */ tablespace_name, sum(nvl(bytes, 0)) undo_free from dba_undo_extents where status != 'ACTIVE' group by tablespace_name) q where p.name( +)=q.tablespace_name ) a,  (select /*NORULE */ e.tablespace_name,  sum(e.bytes) bytes from dba_data_files e,  (select /*NORULE */ tablespace_name from dba_data_files where autoextensible = 'YES') f where e.tablespace_name = f.tablespace_name(+) and f.tablespace_name is null and e.autoextensible = 'NO' group by e.tablespace_name) b,  DBA_TABLESPACES c,  (SELECT /*NORULE */ TS# FROM P$OBJ_EXCLUSION WHERE OBJECT_TYPE = 'TABLE' AND FILE# IS NULL AND BLOCK# IS NULL) d where a.TABLESPACE_NAME = b.TABLESPACE_NAME and b.TABLESPACE_NAME = c.TABLESPACE_NAME and c.CONTENTS != 'TEMPORARY' and c.status = 'ONLINE' and a.TS# = d.TS#(+) and d.TS# is NULL and c.TABLESPACE_NAME != 'SYSTEM'
            156paaha0gta5SELECT ecB.ecID,  ecB.ecName,  ecB.ecCommittedPageCount,  ecB.ecUnCommittedPageCount,  ecB.ecStatus,  ecB.ecPriority,  ecB.ecDateTime,  ecB.ecComment FROM ecBatches ecB WHERE ecB.ecFileCabinetID=006 AND ecB.ecID NOT IN (SELECT ecBatchID FROM ecBatchLocks WHERE ecBatchID=ecB.ecID)
            172czx648h1fvinsert into P$AUTOEXTENDEDLINKS values('temptblspc',  '/oradb/data100/VZIMUTA',  '/oradb/data100/VZIMUTA')
            18bs31ybn35m8SELECT "ECFILECABINETID" ,  "ECBATCHID" ,  "ECFILECABINET" ,  "ECBATCH" ,  "ECDATETIME" ,  "ECLOCKEDBYUSER" ,  "ECLOCKEDBYCOMPUTER" ,  "ECPROCESSID" ,  "ROWID" FROM ECBATCHLOCKS WHERE ROWID = :1
            18naypzfmabd6INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME,  TIME,  DURATION,  MODULE,  ACTION,  IS_TOTAL,  NAME,  VALUE,  CLIENT_DATA,  HOST_URL) VALUES (:B9 ,  SYSDATE,  :B8 ,  SUBSTR(:B7 ,  1,  512),  SUBSTR(:B6 , 1, 32),  :B5 ,  SUBSTR(:B4 , 1, 128),  SUBSTR(:B3 , 1, 128),  SUBSTR(:B2 , 1, 128),  SUBSTR(:B1 , 1, 256))
            19x1189chq3xdSELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE
            1akghbnj6v9hySELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84953
            1csadbh5yxg4uSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84952
            1jkqtvuahshwrinsert into P$CANTEXTFILE(file_id,  file_name,  tablespace_name,  file_inc_bytes,  file_avail) select a.file_id,  file_name,  a.tablespace_name,  nvl(c.max_free_bytes,  0),  -1 from DBA_DATA_FILES a,  P$AUTOEXTTS b,  (select file_id,  max(bytes) max_free_bytes from dba_free_space group by file_id )c,  SYS.FILEXT$ d where a.tablespace_name = b.tablespace_name and a.file_id = c.file_id and a.file_id = d.file#
            1mb78bgcmq5svBEGIN CTX_DDL.SYNC_INDEX(:1 ,  :2 ,  NULL,  :3 ,  :4 ); END;
            1nx1518vff191UPDATE MGMT_COLLECTION_TASKS SET TASK_TYPE=NVL(:B14 , TASK_TYPE),  PRIORITY=NVL(:B13 , PRIORITY),  NEXT_COLLECTION_TIMESTAMP=NVL(:B12 ,  NEXT_COLLECTION_TIMESTAMP),  LAST_COLLECTION_TIMESTAMP=NVL(:B11 ,  LAST_COLLECTION_TIMESTAMP),  ERROR_MESSAGE=:B10 ,  FAILURES=NVL(:B9 , FAILURES),  TOTAL_RUNS=NVL(:B8 , TOTAL_RUNS),  MIN_WAIT_TIME=NVL(:B7 , MIN_WAIT_TIME),  MAX_WAIT_TIME=NVL(:B6 , MAX_WAIT_TIME),  AVG_WAIT_TIME=NVL(:B5 , AVG_WAIT_TIME),  MIN_RUN_TIME=NVL(:B4 , MIN_RUN_TIME),  MAX_RUN_TIME=NVL(:B3 , MAX_RUN_TIME),  AVG_RUN_TIME=NVL(:B2 , AVG_RUN_TIME) WHERE TASK_ID = :B1 RETURNING FREQUENCY_CODE, PRIORITY, TASK_TYPE,  NEXT_COLLECTION_TIMESTAMP, TASK_CLASS INTO :O0 , :O1 , :O2 , :O3 , :O4
            1tgukkrqj3zhwSELECT OBJOID,  CLSOID,  (2*PRI + DECODE(BITAND(STATUS,  4),  0,  0,  DECODE(INST,  :1,  -1,  1))),  WT,  INST,  DECODE(BITAND(STATUS,  8388608),  0,  0,  1),  SCHLIM,  ISLW,  INST_ID FROM ( select a.obj# OBJOID,  a.class_oid CLSOID,  a.job_status STATUS,  a.flags FLAGS,  a.priority PRI,  a.job_weight WT,  decode(a.running_instance,  NULL,  0,  a.running_instance) INST,  a.schedule_id SCHOID,  a.last_start_date LSDATE,  a.last_enabled_time LETIME,  decode(a.schedule_limit,  NULL,  decode(bitand(a.flags,  4194304),  4194304,  b.schedule_limit,  NULL),  a.schedule_limit) SCHLIM,  0 ISLW,  a.instance_id INST_ID from sys.scheduler$_job a,  sys.scheduler$_program b,  v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#,  c.class_oid,  c.job_status,  c.flags,  d.priority,  d.job_weight,  decode(c.running_instance,  NULL,  0,  c.running_instance),  c.schedule_id,  c.last_start_ date,  c.last_enabled_time,  d.schedule_limit,  1,  c.instance_id from sys.scheduler$_lightweight_job c,  sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS,  4096) = 4096 AND BITAND(STATUS,  515) = 1 AND ((BITAND(FLAGS,  134217728 + 268435456) = 0) OR (BITAND(STATUS,  1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm,  sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags,  1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS,  16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND ((CLSOID IS NOT NULL AND INST_ID IS NULL AND CLSOID IN (select e.obj# from sys.scheduler$_class e where bitand(e.flags,  :8) <> 0 and lower(e.affinity) = lower(:9))) OR (INST_ID IS NOT NULL AND INST_ID = :10)) ORDER BY 2,  3,  4 DESC
            28mcpf42nd4kfSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84955
            2g0wsxgktu720SELECT RESULT_KEY_VALUE FROM MGMT_POLICY_ASSOC_EVAL_DETAILS WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1 AND RESULT_KEY_VALUE NOT IN (SELECT COLUMN_VALUE FROM TABLE(CAST(:B4 AS MGMT_MEDIUM_STRING_TABLE)))
            2gu0zk55w9xgxSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84951
            2j0fw19fph49jSELECT dbin.instance_number,  dbin.db_name,  dbin.instance_name,  dbin.host_name,  dbin.version,  CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce,  CAST(s1.end_interval_time AS DATE) as begin_time,  CAST(s2.end_interval_time AS DATE) as end_time,  ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs,  CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect,  round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed),  (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 ,  WRM$_DATABASE _INSTANCE dbin ,  WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time
            2jfugh3kmfcr2UPDATE RevClasses SET dIndexedID = :"SYS_B_0" WHERE dRevClassID = :"SYS_B_1"
            2vwp8qtnaf62hUPDATE ScheduledJobs SET dSjState=:"SYS_B_0",  dSjProgress=:"SYS_B_1",  dSjLastProcessedTs=TO_TIMESTAMP (:"SYS_B_2",  :"SYS_B_3"),  dSjLastProcessedStatus=:"SYS_B_4" WHERE dSjName=:"SYS_B_5"
            3c5bhfxp1s209SELECT DISTINCT child.xIPM_APP_1_3 FROM DOCMETA child ORDER BY child.xIPM_APP_1_3 ASC
            41ma32pk3awpddeclare v_bytes NUMBER; v_increment_by NUMBER; v_maxbytes NUMBER; v_os_avail NUMBER; cursor c_AutoextendData is select c.file_id,  b.bytes,  (nvl(a.inc,  0)*8192) increment_by,  (nvl(a.maxextend,  0)*8192) maxbytes,  c.file_avail from SYS.FILEXT$ a,  DBA_DATA_FILES b,  P$CANTEXTFILE c where c.file_id = b.file_id and c.file_id = a.file# (+); begin open c_AutoextendData; loop fetch c_AutoextendData into :v_file_id,  v_bytes,  v_increment_by,  v_maxbytes,  v_os_avail; if (v_os_avail = -1) then :v_file_can_extend := 9999999999999999; else if (v_increment_by > v_os_avail) then :v_file_can_extend := 0; else if (v_bytes + v_increment_by > v_maxbytes) then :v_file_can_extend := 0; else :v_file_can_extend := v_maxbytes - v_bytes; if (:v_file_can_extend > v_os_avail) then :v_file_can_extend := v_os_avail; end if; end if; end if; end if; update P$AUTOEXTEND set max_file_avail = :v_file_can_extend where file_id = :v_file_id; exit when c_AutoextendData%NOTFOUND; end loop; commit; close c_A utoextendData; end;
            447456gzjccb1select ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3360) and ecactionid in (10, 5) and ecdate < 20161025
            4gjq0xf0rw497SELECT /*+ cardinality(d 20) */ MAX(MGMT_GLOBAL.ADJUST_TZ(MARKER_TIMESTAMP,  T.TIMEZONE_REGION,  :B3 )) FROM MGMT_AVAILABILITY_MARKER M,  MGMT_TARGETS T,  TABLE(CAST(:B1 AS MGMT_METRIC_DETAILS_ARRAY)) D WHERE T.TARGET_GUID = M.TARGET_GUID AND T.TARGET_GUID = D.TARGET_GUID AND M.MARKER_AVAIL_STATUS = :B2
            4kmcppy281g0ninsert into "VZPROD_OCS"."DR$FT_IDCTEXT1$S" (sdata_id,  sdata_last,  sdata_data) values (:1,  :2,  :3)
            4xg6bys7cwf49SELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84949
            52dphyx10q6pzUPDATE ECBATCHES SET "ECCOMMITTEDPAGECOUNT" = :1,  "ECUNCOMMITTEDPAGECOUNT" = :2,  "ECSTATUS" = :3,  "ECPRIORITY" = :4,  "ECDATETIME" = :5 WHERE "ECFILECABINETID" = :6 AND "ECNAME" = :7 AND "ECID" = :8 AND "ECCOMMITTEDPAGECOUNT" = :9 AND "ECUNCOMMITTEDPAGECOUNT" = :10 AND "ECSTATUS" = :11 AND "ECPRIORITY" = :12 AND "ECDATETIME" = :13 AND "ROWID" = :14
            5gkuw9zf0wqptselect /*NORULE */ 'DATAPOINT',  nvl(min(freespace/1048576),  11) MINFREESPACE,  nvl(min(freespace/totalspace*100),  1111) MINFREESPACEPCT from p$temp_ts_spaceleft a,  (select /*NORULE */ object_name from p$obj_exclusion where object_type = 'TABLE' and file# is null and block# is null ) d where a.tablespace_name = d.object_name(+) and d.object_name is null
            5k813a9ukvg79delete from P$AUTOEXTENDEDLINKS where type = 'tblspc'
            60h8znkuw2v5sSELECT DISTINCT child.xIPM_APP_2_10 FROM DOCMETA child ORDER BY child.xIPM_APP_2_10 ASC
            6ajkhukk78nsrbegin prvt_hdm.auto_execute( :dbid,  :inst_num ,  :end_snap_id ); end;
            6gvch1xu9ca3gDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
            6j9ykx4sxkrvbSELECT DISTINCT child.xIPM_APP_1_0 FROM DOCMETA child ORDER BY child.xIPM_APP_1_0 ASC
            6p1159fwkdnvbinsert into P$AUTOEXTTS select /*NORULE */ distinct a.TABLESPACE_NAME,  ALLOCATION_TYPE from DBA_DATA_FILES a,  SYS.FILEXT$ b,  ( SELECT /*NORULE */ TABLESPACE_NAME,  ALLOCATION_TYPE FROM DBA_TABLESPACES WHERE STATUS = 'ONLINE' AND CONTENTS = 'PERMANENT' AND EXTENT_MANAGEMENT = 'LOCAL' OR EXTENT_MANAGEMENT = 'DICTIONARY' ) c where a.FILE_ID = b.file# and a.tablespace_name = c.tablespace_name group by a.TABLESPACE_NAME,  ALLOCATION_TYPE
            6pdrz7njcs447SELECT DISTINCT child.xIPM_APP_1_7 FROM DOCMETA child ORDER BY child.xIPM_APP_1_7 ASC
            6uvzftsujw5s6select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' || A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD from (SELECT /*NORULE */ TS#,  FILE#,  BLOCK#,  MAX(decode(1,  sign(trunc(blocks*8192 / (1048576*1024))),  67108864,  sign(trunc(blocks*8192 / (67108864))),  8388608,  sign(trunc(blocks*8192 / (1048576))),  1048576,  sign(trunc(blocks*8192 / (65536))),  65536))/8192 MAX_EXT_SIZE FROM SYS.SEG$ GROUP BY TS#,  FILE#,  BLOCK#) A,  (SELECT /*NORULE */ VB.NAME TABLESPACE_NAME,  VB.TS#,  MAX(nvl(VA.BLOCKS,  0)) MAX_BLOCKS_FREE FROM DBA_FREE_SPACE VA,  SYS.TS$ VB WHERE VB.NAME = VA.TABLESPACE_NAME AND VB.ONLINE$ != 3 GROUP BY VB.NAME,  VB.TS#) B,  (SELECT TS#,  FILE#,  BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NULL AND BLOCK# IS NULL) C,  (SELECT TS#,  FILE#,  BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NOT NULL AND BLOCK# IS NOT NULL) S,  (SELECT /*NORULE */ UA.TS# TS#,  UA.FILE# FILE#,  UA.BLOCK# BLOCK# FROM SYS.SEG$ UA,  P$OBJ_ EXCLUSION UB WHERE UB.USER# IS NOT NULL AND UA.USER# = UB.USER#) U,  (SELECT A.TS# TS#,  NULL FILE#,  NULL BLOCK# FROM SYS.FILE$ A,  SYS.FILEXT$ B WHERE A.FILE# = B.FILE#) D,  (SELECT /*NORULE */ TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = 'ONLINE' AND CONTENTS = 'PERMANENT' AND (EXTENT_MANAGEMENT = 'LOCAL' AND ALLOCATION_TYPE = 'SYSTEM')) E WHERE A.TS# = B.TS# AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE AND B.MAX_BLOCKS_FREE > 0 AND A.TS# = C.TS#(+) AND C.TS# IS NULL AND A.TS# = S.TS# AND A.FILE# = S.FILE# AND A.BLOCK# = S.BLOCK# AND S.TS# IS NULL AND S.FILE# IS NULL AND S.BLOCK# IS NULL AND A.TS# = U.TS# AND A.FILE# = U.FILE# AND A.BLOCK# = U.BLOCK# AND U.TS# IS NULL AND U.FILE# IS NULL AND U.BLOCK# IS NULL AND A.TS# = D.TS#(+) AND D.TS# IS NULL AND B.TABLESPACE_NAME = E.TABLESPACE_NAME
            6wm3n4d7bnddg SELECT source,  (case when time_secs < 1 then 1 else time_secs end) as time_secs,  operation FROM ( SELECT 1 as source,  trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs,  decode(ll.operation,  'OPEN',  0 ,  1 ) as operation,  ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll ,  ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,  DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN',  'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source,  trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs,  decode(l.operation,  'OPEN',  0 ,  1 ) as operation,  l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l ,  DBA_SCHEDULER_WINGR OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN',  'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source,  trunc((sysdate - et.etime) * 86400) as time_secs,  3 as operation,  0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source,  trunc((sysdate - bt.btime) * 86400) as time_secs,  2 as operation,  0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC,  time_secs DESC,  log_id ASC
            6xkgbbsxfv4swSELECT DISTINCT child.xIPM_APP_1_11 FROM DOCMETA child ORDER BY child.xIPM_APP_1_11 ASC
            704bzmpz2uufySELECT dSceSourceLocation from sceSourceLocation WHERE sceSourceLocation.dDocName like :"SYS_B_0"
            715tk4xc0tjxcUPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = :"SYS_B_0"
            77mmwbpt5g7c8SELECT DISTINCT child.xIPM_APP_1_5 FROM DOCMETA child ORDER BY child.xIPM_APP_1_5 ASC
            7avk1qcda3sgySELECT "ECCOMMENT" FROM ECBATCHES WHERE ROWID = :1 FOR UPDATE
            7c352srsqzmhfSELECT ecB.ecID,  ecB.ecName,  ecB.ecCommittedPageCount,  ecB.ecUnCommittedPageCount,  ecB.ecStatus,  ecB.ecPriority,  ecB.ecDateTime,  ecB.ecComment FROM ecBatches ecB WHERE ecB.ecFileCabinetID=005 AND ecB.ecID NOT IN (SELECT ecBatchID FROM ecBatchLocks WHERE ecBatchID=ecB.ecID)
            7jmxg1bv287dzUPDATE ECBATCHES SET "ECNAME" = :1 WHERE "ECFILECABINETID" = :2 AND "ECNAME" = :3 AND "ECID" = :4 AND "ECCOMMITTEDPAGECOUNT" = :5 AND "ECUNCOMMITTEDPAGECOUNT" = :6 AND "ECSTATUS" IS NULL AND "ECPRIORITY" = :7 AND "ECDATETIME" = :8 AND "ROWID" = :9
            7vjfqyrmkyhw9select ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3347) and ecactionid in (10, 5) and ecdate < 20161025
            89sdz401dc5ufselect program_oid,  schedule_expr,  schedule_id,  queue_owner,  queue_name,  queue_agent,  event_rule,  mxdur_msgid,  last_enabled_time,  class_oid,  next_run_date,  last_start_date,  last_end_date,  retry_count,  run_count,  failure_count,  running_instance,  running_slave,  flags,  job_status,  creator,  client_id,  guid,  char_env,  start_date,  end_date,  instance_id,  fw_name,  fw_oid,  destination,  credential_name,  credential_owner,  credential_oid,  dest_oid,  job_dest_id,  run_invoker,  program_action,  schedule_limit,  priority,  job_weight,  number_of_args,  max_runs,  max_failures,  max_run_duration,  comments,  user_callback,  user_callback_ctx,  nls_env,  source,  env,  database_role,  owner_udn,  dist_flags from sys.scheduler$_job where obj# = :1
            8c5fdm292vxd2select ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3364) and ecactionid in (10, 5) and ecdate < 20161025
            8df8rv6sxsadaUPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = :"SYS_B_0" WHERE dRevClassID = :"SYS_B_1" AND (dIndexerState in (:"SYS_B_2",  :"SYS_B_3") OR dIndexerState is null) AND (dID <= :"SYS_B_4" OR dStatus = :"SYS_B_5" OR dReleaseState in (:"SYS_B_6",  :"SYS_B_7",  :"SYS_B_8",  :"SYS_B_9"))
            8kgwmjvvr90qySELECT/*+ USE_NL (Revisions Documents DocMeta DocTypes RevClasses) LEADING(Revisions)INDEX (Revisions PK_Revisions)*/ Revisions.*,  Documents.*,  xComments, xIdcProfile, xPartitionId, xWebFlag, xStorageRule, xIPMSYS_APP_ID, xIPMSYS_BATCH_ID1, xIPMSYS_BATCH_SEQ, xIPM_APP_10_0, xIPM_APP_1_0, xIPM_APP_2_0, xIPM_APP_10_1, xIPM_APP_10_2, xIPM_APP_10_3, xIPM_APP_10_4, xIPM_APP_10_5, xIPM_APP_10_6, xVZDistributionDate, xIPM_APP_10_7, xIPM_APP_2_1, xIPM_APP_1_1, xIPM_APP_10_10, xIPM_APP_10_12, xIPM_APP_10_13, xIPM_APP_10_14, xIPM_APP_10_15, xIPM_APP_10_16, xIPM_APP_10_17, xIPM_APP_10_18, xIPM_APP_10_19, xIPM_APP_2_2, xIPM_APP_1_2, xIPM_APP_10_20, xIPM_APP_10_21, xIPM_APP_10_22, xIPM_APP_10_24, xIPM_APP_10_25, xIPM_APP_10_26, xIPM_APP_10_27, xIPM_APP_10_28, xIPM_APP_10_29, xIPM_APP_2_3, xIPM_APP_1_3, xIPM_APP_2_4, xIPM_APP_1_4, xIPM_APP_1_5, xIPM_APP_1_6, xIPM_APP_2_7, xIPM_APP_1_7, xIPM_APP_2_8, xIPM_APP_1_8, xIPM_APP_1_9, xIPM_APP_2_9, xVZSSNLastFour, xvz_AMS_MedicalNotes, xvz_AMS_AdminNotes, xIPM_APP_2_10, xIPM_APP_1_10, xIPM_APP_1_11, xIPM_APP_2_11, xIPM_APP_1_12, xIPM_APP_1_13, xIPM_APP_2_13, xIPM_APP_2_14, xIPM_APP_2_17, xIPM_APP_1_16, xIPM_APP_1_17, xIPM_APP_1_18, xIPM_APP_1_19, xIPM_APP_1_20, xIPM_APP_1_22, xIPM_APP_1_23, xIPM_APP_1_24, xIPM_APP_1_25, xIPM_APP_1_26, xIPM_APP_1_27, xIPM_APP_1_32, xIPM_APP_1_33,  DocTypes.dGif,  RevClasses.* FROM Revisions, Documents, DocMeta, DocTypes,  RevClasses WHERE Revisions.dID = :"SYS_B_0" AND Revisions.dID = Documents.dID AND Revisions.dID = DocMeta.dID AND Revisions.dRevClassID = RevClasses.dRevClassID AND DocTypes.dDocType = Revisions.dDocType AND Revisions.dIndexerState in (:"SYS_B_1",  :"SYS_B_2")
            8pusxc4hp8mr5insert into P$AUTOEXTENDEDLINKS values('tblspc',  '/oradb/data100/VZIMUTA',  '/oradb/data100/VZIMUTA')
            91w2tnsqf3s00INSERT INTO IdcText1(dDocName, dDocTitle, dDocType, dSecurityGroup, dInDate, xVZSSNLastFour, dDocLastModifiedDate, dRevClassID, AlternateFormat, dDocAuthor, xStorageRule, xIPM_APP_2_9, xIPM_APP_2_8, xIPM_APP_2_7, xIPM_APP_2_4, xIPM_APP_1_9, xIPM_APP_2_3, xIPM_APP_1_8, xIPM_APP_2_2, xIPM_APP_1_7, xIPM_APP_2_1, xIPM_APP_1_6, xIPM_APP_2_0, xIPM_APP_1_5, xIPM_APP_1_4, dDocFunction, xIPM_APP_1_3, xIPM_APP_1_2, xIPM_APP_1_1, xIPM_APP_1_0, dOutDate, xIPMSYS_BATCH_SEQ, dDocLastModifier, dFormat, dRendition2, xIPM_APP_1_33, dRendition1, xIPM_APP_1_32, xIPM_APP_1_27, xIPM_APP_1_26, xIPM_APP_1_25, xIPM_APP_1_24, xIPM_APP_1_23, xIPM_APP_1_22, xIPM_APP_1_20, dDocCreatedDate, dDocAccount, URL, xIPM_APP_10_29, xIPM_APP_10_28, dCreateDate, dID, xIPM_APP_10_27, xIPM_APP_10_26, xIPM_APP_10_25, xIPM_APP_10_24, xIPM_APP_1_19, dExtension, xIPM_APP_1_18, xIPM_APP_10_22, xIPM_APP_1_17, xIPM_APP_10_21, xIPM_APP_1_16, xIPM_APP_10_20, dWebExtension, xIPM_APP_10_7, xIPM_APP_10_6, xIPM_APP_1_13, xIPM_APP_10_5, xI PM_APP_1_12, xIPM_APP_10_4, xIPM_APP_2_17, dDocCreator, VaultFileSize, xIPM_APP_10_3, xIPM_APP_1_11, xIPM_APP_10_2, dRevLabel, xIPM_APP_1_10, xIPM_APP_10_1, xIPM_APP_2_14, xIPM_APP_10_0, xIPM_APP_2_13, xIPM_APP_2_11, xIPM_APP_2_10, xVZDistributionDate, xPartitionId, xIPM_APP_10_19, xIPM_APP_10_18, dGif, xIPM_APP_10_17, xIPM_APP_10_16, xIPMSYS_APP_ID, xIPM_APP_10_15, xIPM_APP_10_14, dFullTextFormat, xIPM_APP_10_13, xIPM_APP_10_12, xIPM_APP_10_10, xvz_AMS_AdminNotes, dRevisionID, WebFileSize, xComments, xWebFlag, xIPMSYS_BATCH_ID1, xIdcProfile, dOriginalName, dDocOwner, dPublishType, xvz_AMS_MedicalNotes, otsMeta, otsFormat, otsCharset, otsLanguage, otsContent) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , :41 , :42 , :43 , :44 , :45 , :46 , :47 , :48 , :49 , :50 , :51 , :52 , :53 , :54 , :55 , :56 , :57 , :58 , :59 , :60 , :61 , :62 , :63 , :64 , :65 , :66 , :67 , :68 , :69 , :70 , :71 , :72 , :73 , :74 , :75 , :76 , :77 , :78 , :79 , :80 , :81 , :82 , :83 , :84 , :85 , :86 , :87 , :88 , :89 , :90 , :91 , :92 , :93 , :94 , :95 , :96 , :97 , :98 , :99 , :100 , :101 , :102 , :103 , :104 , :105 , :106 , :107 , :108 , :109 , :110 , :111 , :112 , :113 , :114 , :115 )
            9czpmyvwswgrdSELECT DISTINCT child.xIPM_APP_1_2 FROM DOCMETA child ORDER BY child.xIPM_APP_1_2 ASC
            9dhn1b8d88dpfselect OBJOID,  CLSOID,  RUNTIME,  PRI,  JOBTYPE,  SCHLIM,  WT,  INST,  RUNNOW,  ENQ_SCHLIM from ( select a.obj# OBJOID,  a.class_oid CLSOID,  decode(bitand(a.flags,  16384),  0,  a.next_run_date,  a.last_enabled_time) RUNTIME,  (2*a.priority + decode(bitand(a.job_status,  4),  0,  0,  decode(a.running_instance,  :1,  -1,  1))) PRI,  1 JOBTYPE,  decode(a.schedule_limit,  NULL,  decode(bitand(a.flags,  4194304),  4194304,  p.schedule_limit,  NULL),  a.schedule_limit) SCHLIM,  a.job_weight WT,  decode(a.running_instance,  NULL,  0,  a.running_instance) INST,  decode(bitand(a.flags,  16384),  0,  0,  1) RUNNOW,  decode(bitand(a.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM from sys.scheduler$_job a,  sys.scheduler$_program p,  v$database v,  v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status,  515) = 1 and bitand(a.flags,  1048576) = 0 and ((bitand(a.flags,  134217728 + 268435456) = 0) or (bitand(a.job_status,  1024) <> 0)) and bitand(a.flags,  4096) = 0 and (a.nex t_run_date <= :2 or bitand(a.flags,  16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags,  17179869184) <> 0 ) union all select l.obj#,  l.class_oid,  decode(bitand(l.flags,  16384),  0,  l.next_run_date,  l.last_enabled_time),  (2*decode(bitand(l.flags,  8589934592),  0,  q.priority,  pj.priority) + decode(bitand(l.job_status,  4),  0,  0,  decode(l.running_instance,  :3,  -1,  1))),  1,  decode(bitand(l.flags,  8589934592),  0,  q.schedule_limit,  decode(pj.schedule_limit,  NULL,  q.schedule_limit,  pj.schedule_limit)),  decode(bitand(l.flags,  8589934592),  0,  q.job_weight,  pj.job_weight),  decode(l.running_instance,  NULL,  0,  l.running_instance),  decode(bitand(l.flags,  16384),  0,  0,  1), decode(bitand(l.job_status,  8388608),  0,  0,  1) from sys.scheduler$_lightweight_job l,  sys.scheduler$_program q,  (select sl.obj# obj#,  decode(bitand(sl.flags,  8589934592),  0,  sl.program_oid,  spj.program_oid) program_oid,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.priority) priority,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.job_weight) job_weight,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl,  scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj ,  v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status,  515) = 1 and ((bitand(l.flags,  134217728 + 268435456) = 0) or (bitand(l.job_status,  1024) <> 0)) and bitand(l.flags,  4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags,  16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags,  17179869184) <> 0 ) union all select c.obj#,  0,  c.next_start_date,  0,  2,  c.duration,  1,  0,  0,  0 from sys.scheduler$_window c ,  v$instance i where bitand(c.flags,  1) <> 0 and bitand(c.flags,  2) = 0 and bitand(c.flags,  64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#,  0,  d.next_start_date + d.duration,  0,  4,  numtodsinterval(0, 'minute'),  1,  0,  0,  0 from sys.scheduler$_window d ,  v$instance i where bitand(d.flags,  1) <> 0 and bitand(d.flags,  2) = 0 and bitand(d.flags,  64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#,  0,  e.attr_tstamp,  0,  decode(bitand(e.flags,  131072),  0,  2,  3),  e.attr_intv,  1,  0,  0,  0 from sys.scheduler$_global_attribute e,  sys.obj$ f,  sys.obj$ g,  v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#,  0,  h.attr_tstamp + h.attr_intv,  0,  decode(bitand(h.flags,  131072),  0,  4,  5),  numtodsinterval(0,  'minute'),  1,  0,  0,  0 from sys.scheduler$_global_attribute h,  sys.obj$ i,  sys.obj$ j,  v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME,  JOBTYPE,  CLSOID,  PRI,  WT DESC,  OBJOID
            9wu9gz6dydv0qSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84925
            9zu8xkckjhb1qSELECT "ECCONFIGURATION" FROM ECPICKLISTSOURCE WHERE ROWID = :1
            a0hysrqc16zsadeclare cursor c_tempTbspData is select tablespace_name,  sum(freespace_in_na) + sum(freespace_in_au) freespace,  sum(totalspace) totalspace from (select m.tablespace_name,  n.filesystem,  sum(m.freespace_in_file + m.freespace_in_sort_segment) freespace_in_na,  least(sum(m.max_file_can_extend),  nvl(n.osavail,  4194302*8192)) freespace_in_au,  sum(m.totalspace) + least(sum(m.max_file_can_extend),  nvl(n.osavail,  4194302*8192)) totalspace from (select a.file_id,  a.file_name,  a.tablespace_name tablespace_name,  nvl(b.bytes,  0) freespace_in_file,  nvl(c.freespace_in_sort_segment,  0) freespace_in_sort_segment,  decode(nvl(a.maxbytes,  0),  0,  0,  a.maxbytes - a.bytes) max_file_can_extend,  a.bytes totalspace from dba_data_files a,  (select file_id,  sum(bytes) bytes from dba_free_space group by file_id ) b,  (select segment_file,  free_blocks*8192 freespace_in_sort_segment from v$sort_segment ) c,  (select tablespace_name from dba_tablespaces where contents = 'TEMPORARY' and status = 'ONLINE' ) e where a.file_id = b.file_id(+) and a.file_id = c.segment_file(+) and a.tablespace_name = e.tablespace_name union select a.file_id,  a.file_name,  a.tablespace_name tablespace_name,  a.user_bytes - nvl(b.bytes_used,  0) freespace_in_file,  0 freespace_in_sort_segment,  decode(a.maxbytes,  0,  0,  a.maxbytes - a.bytes) max_file_can_extend,  a.bytes totalspace from dba_temp_files a,  (select file_id,  sum(bytes_used) bytes_used from v$temp_extent_pool group by file_id ) b where a.file_id = b.file_id(+) ) m,  p$temp_os_space n where substr(m.file_name,  1,  instr(m.file_name,  '/',  -1) -1) = n.filesystem group by m.tablespace_name,  n.filesystem,  n.osavail ) o group by tablespace_name; begin open c_tempTbspData; loop fetch c_tempTbspData into :v_tablespace_name,  :v_freespace,  :v_totalspace; exit when c_tempTbspData%NOTFOUND; insert into p$temp_ts_spaceleft(tablespace_name,  freespace,  totalspace) values(:v_tablespace_name,  :v_freespace,  :v_totalspace); end loop; close c_tempTbspData; commit; end;
            a0wz61fs5pahddelete from P$AUTOEXTENDEDLINKS where type = 'temptblspc'
            a42sj2ts1munqUPDATE ECBATCHES SET "ECNAME" = :1 WHERE "ECFILECABINETID" = :2 AND "ECNAME" = :3 AND "ECID" = :4 AND "ECCOMMITTEDPAGECOUNT" = :5 AND "ECUNCOMMITTEDPAGECOUNT" = :6 AND "ECSTATUS" = :7 AND "ECPRIORITY" = :8 AND "ECDATETIME" = :9 AND "ROWID" = :10
            a5xywkfbpw8q9SELECT * FROM ScheduledJobs WHERE dSjState in (:"SYS_B_0") AND dSjType=:"SYS_B_1" ORDER BY dSjPriority ASC
            aahazjq6km6wuINSERT INTO ECBATCHLOCKS( "ECFILECABINETID",  "ECBATCHID",  "ECFILECABINET",  "ECBATCH",  "ECDATETIME",  "ECLOCKEDBYUSER",  "ECLOCKEDBYCOMPUTER",  "ECPROCESSID") VALUES (:1, :2, :3, :4, :5, :6, :7, :8) RETURNING ROWID INTO :9
            afhm2upad07baUPDATE ECBATCHES SET "ECCOMMITTEDPAGECOUNT" = :1,  "ECUNCOMMITTEDPAGECOUNT" = :2,  "ECSTATUS" = :3,  "ECPRIORITY" = :4,  "ECDATETIME" = :5 WHERE "ECFILECABINETID" = :6 AND "ECNAME" = :7 AND "ECID" = :8 AND "ECCOMMITTEDPAGECOUNT" = :9 AND "ECUNCOMMITTEDPAGECOUNT" = :10 AND "ECSTATUS" IS NULL AND "ECPRIORITY" = :11 AND "ECDATETIME" = :12 AND "ROWID" = :13
            agcqsqs3p2wp6UPDATE/*+ INDEX (Revisions PK_Revisions)*/ Revisions SET dStatus = :"SYS_B_0",  dReleaseState = :"SYS_B_1",  dIndexerState = :"SYS_B_2" WHERE dID=:"SYS_B_3" AND dIndexerState = :"SYS_B_4"
            ajymgnp1qnruwselect o.name,  o.owner# from obj$ o,  type$ t where o.oid$ = t.tvoid and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
            ak5crjygnpk60UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2
            aktbxfjwnzgmuupdate WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
            aqrvw4bfbrkzfselect ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3362) and ecactionid in (10, 5) and ecdate < 20161025
            b1na79hpa7k3pselect 'DATAPOINT prf_current_trans' bpb,  count(*) from V$LOCK where TYPE = 'TX' and REQUEST = 6
            bn4b3vjw2mj3uSELECT OBJOID,  CLSOID,  DECODE(BITAND(FLAGS,  16384),  0,  RUNTIME,  LETIME),  (2*PRI + DECODE(BITAND(STATUS,  4),  0,  0,  decode(INST,  :1,  -1,  1))),  JOBTYPE,  SCHLIM,  WT,  INST,  RUNNOW,  ENQ_SCHLIM,  INST_ID FROM ( select a.obj# OBJOID,  a.class_oid CLSOID,  a.next_run_date RUNTIME,  a.last_enabled_time LETIME,  a.flags FLAGS,  a.job_status STATUS,  1 JOBTYPE,  a.priority PRI,  decode(a.schedule_limit,  NULL,  decode(bitand(a.flags,  4194304),  4194304,  b.schedule_limit,  NULL),  a.schedule_limit) SCHLIM,  a.job_weight WT,  decode(a.running_instance,  NULL,  0,  a.running_instance) INST,  decode(bitand(a.flags,  16384),  0,  0,  1) RUNNOW,  decode(bitand(a.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM,  a.instance_id INST_ID from sys.scheduler$_job a,  sys.scheduler$_program b,  v$database v ,  v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a .flags,  17179869184) <> 0 ) union all select c.obj#,  c.class_oid,  c.next_run_date,  c.last_enabled_time,  c.flags,  c.job_status,  1,  decode(bitand(c.flags,  8589934592),  0,  d.priority,  pj.priority),  decode(bitand(c.flags,  8589934592),  0,  d.schedule_limit,  decode(pj.schedule_limit,  NULL,  d.schedule_limit,  pj.schedule_limit)),  decode(bitand(c.flags,  8589934592),  0,  d.job_weight,  pj.job_weight),  decode(c.running_instance,  NULL,  0,  c.running_instance),  decode(bitand(c.flags,  16384),  0,  0,  1) RUNNOW,  decode(bitand(c.job_status,  8388608),  0,  0,  1) ENQ_SCHLIM,  c.instance_id INST_ID from sys.scheduler$_lightweight_job c,  sys.scheduler$_program d,  (select sl.obj# obj#,  decode(bitand(sl.flags,  8589934592),  0,  sl.program_oid,  spj.program_oid) program_oid,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.priority) priority,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.job_weight) job_weight,  decode(bitand(sl.flags,  8589934592),  0,  NULL,  spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl,  scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj,  v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags,  17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS,  515) = 1 AND BITAND(FLAGS,  1048576) = 0 AND ((BITAND(FLAGS,  134217728 + 268435456) = 0) OR (BITAND(STATUS,  1024) <> 0)) AND BITAND(FLAGS,  4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS,  16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags,  :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3,  2,  4,  7 DESC,  1
            bt2wq3508cm0hselect ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3359) and ecactionid in (10, 5) and ecdate < 20161025
            bvsh5dstfdwknselect /*+ DYNAMIC_SAMPLING(0) */ * from "VZPROD_OCS"."IDCTEXT1" where rowid = :rid
            bwf9gntjkmzzwinsert into "VZPROD_OCS"."DR$FT_IDCTEXT1$I" (token_text,  token_type,  token_first,  token_last,  token_count,  token_info) values (:token,  :ttype,  :first,  :last,  :count,  :data)
            bzvjvmn8a12ggSELECT DISTINCT child.xIPM_APP_1_1 FROM DOCMETA child ORDER BY child.xIPM_APP_1_1 ASC
            ckgqj1btjfp2kSELECT C.FILE_ID,  B.BYTES,  (NVL(A.INC,  0)*8192) INCREMENT_BY,  (NVL(A.MAXEXTEND,  0)*8192) MAXBYTES,  C.FILE_AVAIL FROM SYS.FILEXT$ A,  DBA_DATA_FILES B,  P$CANTEXTFILE C WHERE C.FILE_ID = B.FILE_ID AND C.FILE_ID = A.FILE#
            cnqtsas7dwcv4select ecbatchid from vzhropt_odc.ecaudit where ecbatchid IN (3361) and ecactionid in (10, 5) and ecdate < 20161025
            cu7f1b2g5ytu1SELECT DISTINCT child.xIPM_APP_2_3 FROM DOCMETA child ORDER BY child.xIPM_APP_2_3 ASC
            d2zat51t1fac0SELECT/*+ USE_NL (WorkflowDocuments Revisions) LEADING(WorkflowDocuments)INDEX (WorkflowDocuments dWfDocState)*/ DISTINCT Revisions.dRevClassID FROM WorkflowDocuments,  Revisions WHERE WorkflowDocuments.dDocName=Revisions.dDocName AND Revisions.dStatus<>:"SYS_B_0" AND WorkflowDocuments.dWfDocState=:"SYS_B_1"
            d595mj9tbntjnSELECT "ECCOMMENT" FROM ECBATCHES WHERE ROWID = :1
            davq1msn9b8kdUPDATE MGMT_POLICY_ASSOC_EVAL_DETAILS SET CRIT_COUNTER = NVL(:B9 , CRIT_COUNTER),  WARN_COUNTER = NVL(:B8 , WARN_COUNTER),  INFO_COUNTER = NVL(:B7 , INFO_COUNTER),  LAST_ERROR_MESSAGE = :B6 ,  LAST_EVALUATION_DATE = :B5 WHERE TARGET_GUID = :B4 AND POLICY_GUID = :B3 AND COLL_NAME = :B2 AND RESULT_KEY_VALUE = :B1
            dvmgtd5ad3xcmSELECT TABLESPACE_NAME,  SUM(FREESPACE_IN_NA) + SUM(FREESPACE_IN_AU) FREESPACE,  SUM(TOTALSPACE) TOTALSPACE FROM (SELECT M.TABLESPACE_NAME,  N.FILESYSTEM,  SUM(M.FREESPACE_IN_FILE + M.FREESPACE_IN_SORT_SEGMENT) FREESPACE_IN_NA,  LEAST(SUM(M.MAX_FILE_CAN_EXTEND),  NVL(N.OSAVAIL,  4194302*8192)) FREESPACE_IN_AU,  SUM(M.TOTALSPACE) + LEAST(SUM(M.MAX_FILE_CAN_EXTEND),  NVL(N.OSAVAIL,  4194302*8192)) TOTALSPACE FROM (SELECT A.FILE_ID,  A.FILE_NAME,  A.TABLESPACE_NAME TABLESPACE_NAME,  NVL(B.BYTES,  0) FREESPACE_IN_FILE,  NVL(C.FREESPACE_IN_SORT_SEGMENT,  0) FREESPACE_IN_SORT_SEGMENT,  DECODE(NVL(A.MAXBYTES,  0),  0,  0,  A.MAXBYTES - A.BYTES) MAX_FILE_CAN_EXTEND,  A.BYTES TOTALSPACE FROM DBA_DATA_FILES A,  (SELECT FILE_ID,  SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY FILE_ID ) B,  (SELECT SEGMENT_FILE,  FREE_BLOCKS*8192 FREESPACE_IN_SORT_SEGMENT FROM V$SORT_SEGMENT ) C,  (SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE CONTENTS = 'TEMPORARY' AND STATUS = 'ONLINE' ) E WHERE A.FILE_ID = B .FILE_ID(+) AND A.FILE_ID = C.SEGMENT_FILE(+) AND A.TABLESPACE_NAME = E.TABLESPACE_NAME UNION SELECT A.FILE_ID,  A.FILE_NAME,  A.TABLESPACE_NAME TABLESPACE_NAME,  A.USER_BYTES - NVL(B.BYTES_USED,  0) FREESPACE_IN_FILE,  0 FREESPACE_IN_SORT_SEGMENT,  DECODE(A.MAXBYTES,  0,  0,  A.MAXBYTES - A.BYTES) MAX_FILE_CAN_EXTEND,  A.BYTES TOTALSPACE FROM DBA_TEMP_FILES A,  (SELECT FILE_ID,  SUM(BYTES_USED) BYTES_USED FROM V$TEMP_EXTENT_POOL GROUP BY FILE_ID ) B WHERE A.FILE_ID = B.FILE_ID(+) ) M,  P$TEMP_OS_SPACE N WHERE SUBSTR(M.FILE_NAME,  1,  INSTR(M.FILE_NAME,  '/',  -1) -1) = N.FILESYSTEM GROUP BY M.TABLESPACE_NAME,  N.FILESYSTEM,  N.OSAVAIL ) O GROUP BY TABLESPACE_NAME
            dxfjgbw3g9d6gSELECT "ECSTATUSES" FROM ECFILECABINETS WHERE ROWID = :1
            f0s96up59sz63UPDATE ScheduledJobs SET dSjState=:"SYS_B_0",  dSjLastProcessedStatus=:"SYS_B_1",  dSjLastProcessedTs=TO_TIMESTAMP (:"SYS_B_2",  :"SYS_B_3"),  dSjProgress=:"SYS_B_4" WHERE dSjName=:"SYS_B_5"
            ffd74jm9nb9hqSELECT NULL AS table_cat,  o.owner AS table_schem,  o.object_name AS table_name,  o.object_type AS table_type,  NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE :"SYS_B_0" AND o.object_name LIKE :2 ESCAPE :"SYS_B_1" AND o.object_type IN (:"SYS_B_2",  :"SYS_B_3",  :"SYS_B_4") ORDER BY table_type,  table_schem,  table_name
            fxa24kfurmk0dinsert into P$AUTOEXTENDEDLINKS values('dest',  '/var/app/oracle/diag/rdbms/vzimuta/VZIMUTA1/cdump',  '/apps/eojvarapp/oracle/diag/rdbms/vzimuta/VZIMUTA1/cdump')
            g23ysr1dttg1hSELECT ecBatches.*,  ecBatches."ROWID" from ecBatches WHERE ecFileCabinetID=005 AND ecID=84954
            g39xf32ck0fpySELECT DISTINCT child.xIPM_APP_1_10 FROM DOCMETA child ORDER BY child.xIPM_APP_1_10 ASC
            gaz3df6czs8rnSELECT/*+ USE_NL (Revisions DocMeta RevClasses) LEADING(Revisions)INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions.*,  DocMeta.*,  RevClasses.* FROM Revisions,  DocMeta,  RevClasses WHERE Revisions.dRevClassID = :"SYS_B_0" AND Revisions.dID = DocMeta.dID AND Revisions.dRevClassID = RevClasses.dRevClassID AND dStatus in (:"SYS_B_1",  :"SYS_B_2",  :"SYS_B_3") AND dReleaseState in (:"SYS_B_4",  :"SYS_B_5",  :"SYS_B_6",  :"SYS_B_7") ORDER BY Revisions.dID DESC
            gz4dvxryub0gqSELECT DISTINCT child.xIPM_APP_1_6 FROM DOCMETA child ORDER BY child.xIPM_APP_1_6 ASC
            • 18. Re: UCM Search is not working , i'm getting error while perform search
              User258546

              SQL ordered by Executions

              • %CPU   - CPU Time      as a percentage of Elapsed Time
              • %IO    - User I/O Time as a percentage of Elapsed Time
              • Total Executions:       1,949,263
              • Captured SQL account for   78.4% of Total
              Executions Rows ProcessedRows per ExecElapsed  Time (s) %CPU  %IO   SQL IdSQL ModuleSQL Text
              599,545599,5451.0034.7030.5006pmyvpq0a589RecognitionServer.exe SELECT "ECINDEXES" FROM ECBATC...
              146,601146,6011.0010.2934.30d595mj9tbntjnCommitServer.exe SELECT "ECCOMMENT" FROM ECBATC...
              97,85297,8521.0017.8433.2.87avk1qcda3sgyRecognitionServer.exe SELECT "ECCOMMENT" FROM ECBATC...
              97,49397,4931.0016.7339.4.852dphyx10q6pzImportServer.exe UPDATE ECBATCHES SET "ECCOMMIT...
              97,49297,4921.0025.8323.8.4a42sj2ts1munqImportServer.exe UPDATE ECBATCHES SET "ECNAME" ...
              57,34057,3401.003.7733.509zu8xkckjhb1qRecognitionServer.exe SELECT "ECCONFIGURATION" FROM ...
              48,86848,8681.003.7834.1018bs31ybn35m8RecognitionServer.exe SELECT "ECFILECABINETID" , "EC...
              48,86848,8681.0015.2924.7.1aahazjq6km6wuRecognitionServer.exe INSERT INTO ECBATCHLOCKS( "ECF...
              38,27038,2701.002.7533.20dxfjgbw3g9d6gCommitServer.exe SELECT "ECSTATUSES" FROM ECFIL...
              26,18626,1861.006.0234.50715tk4xc0tjxcJDBC Thin Client UPDATE RevClasses SET dRevClas...
              22,460178,7357.96179.547.566.4bwf9gntjkmzzwJDBC Thin Client insert into "VZPROD_OCS"."DR$F...
              20,00020,0011.006.6941.625.78df8rv6sxsadaJDBC Thin Client UPDATE/*+ INDEX (Revisions dRe...
              • 19. Re: UCM Search is not working , i'm getting error while perform search
                User258546

                SQL ordered by User I/O Wait Time

                • Resources reported for PL/SQL code includes the resources used by all SQL     statements called by the code.
                • %Total - User I/O Time as a percentage of Total User I/O Wait time
                • %CPU   - CPU Time      as a percentage of Elapsed Time
                • %IO    - User I/O Time as a percentage of Elapsed Time
                • Captured SQL account for   93.0% of Total User I/O Wait Time (s):             697
                • Captured PL/SQL account for   18.1% of Total User I/O Wait Time (s):             697
                User I/O Time (s)Executions UIO per  Exec (s)%TotalElapsed  Time (s)%CPU%IO   SQL IdSQL ModuleSQL Text
                139.954050.3520.08204.958.5268.2991w2tnsqf3s00JDBC Thin Client INSERT INTO IdcText1(dDocName,...
                121.392520.4817.41210.8216.6157.581mb78bgcmq5svJDBC Thin Client BEGIN CTX_DDL.SYNC_INDEX(:1 , ...
                119.1622,4600.0117.09179.547.4766.37bwf9gntjkmzzwJDBC Thin Client insert into "VZPROD_OCS"."DR$F...
                69.746,5870.0110.0173.611.2494.7508435bgs3279dJDBC Thin Client SELECT * FROM FileStorage WHER...
                26.17213.083.7531.463.5683.170muw7xuyp0a4rJDBC Thin Client SELECT Revisions.dRevClassID F...
                26.10126.103.7427.261.2295.73bt2wq3508cm0hHRImagingMonitor.exe select ecbatchid from vzhropt_...
                25.07125.073.6026.321.7395.24cnqtsas7dwcv4HRImagingMonitor.exe select ecbatchid from vzhropt_...
                24.25124.253.4825.502.2695.10447456gzjccb1HRImagingMonitor.exe select ecbatchid from vzhropt_...
                21.34121.343.0622.502.0694.837vjfqyrmkyhw9HRImagingMonitor.exe select ecbatchid from vzhropt_...
                21.16121.163.0422.422.0394.41aqrvw4bfbrkzfHRImagingMonitor.exe select ecbatchid from vzhropt_...
                20.64120.642.9621.882.5694.358c5fdm292vxd2HRImagingMonitor.exe select ecbatchid from vzhropt_...
                17.0044.252.4438.8349.1643.79b1na79hpa7k3pSQL*Plus select 'DATAPOINT prf_current_...
                9.5319.531.3717.1831.5755.47g39xf32ck0fpyJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                9.4019.401.3517.1026.7154.96045brvnnytxvtJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                9.196,1860.001.3214.5020.8363.418kgwmjvvr90qyJDBC Thin Client SELECT/*+ USE_NL (Revisions Do...
                9.0819.081.3017.2031.2952.81gz4dvxryub0gqJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.9318.931.2818.2027.5849.056j9ykx4sxkrvbJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.3018.301.1916.2030.7951.2260h8znkuw2v5sJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.2518.251.1817.5030.9047.146pdrz7njcs447JDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.2018.201.1817.7730.6846.14bzvjvmn8a12ggJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.1518.151.1715.8630.6951.38cu7f1b2g5ytu1JDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                8.0318.031.1515.8129.1850.796xkgbbsxfv4swJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                7.8417.841.1217.1929.9945.589czpmyvwswgrdJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                7.7517.751.1116.1732.9847.950h1gsvau4xm7aJDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                7.5517.551.0815.7230.3948.0777mmwbpt5g7c8JDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                7.3417.341.0516.4836.8544.533c5bhfxp1s209JDBC Thin Client SELECT DISTINCT child.xIPM_APP...
                1 2 Previous Next