1 2 Previous Next 22 Replies Latest reply: May 1, 2014 3:39 AM by yoonas Go to original post RSS
      • 15. Re: Not able to see objects from apps schema in R12
        mksadmin

        Thanks for your great efforts Younas

         

        Yes the above note id 782224.1 belongs to 11gR1. But my DB version is 11gR2 (11.2.0.3). Could you please provide the note id respective to 11gR2.

         

        Can i run all the stats on non-working instance OR do i have to run stats on working instance in non-peak hours. As you know running stats degrades the performance till it finishes.

         

        Now weird got changed and and bit meaningfull to handle. Lol

         

        Thanks & Regs

        Mazher Khan

        • 16. Re: Not able to see objects from apps schema in R12
          yoonas

          Mazher,

           

          Glad to see you with a proper name, addressing you is easy now

          That's just a search away , If the given note is for 11g1 just enter "Interoperability Notes Oracle E-Business Suite Release 12 with 11gR2" in the MOS global search , search yields many notes, pick the one for your database. I am sure you will  be able to get it yourself else of course i have it with me

           

          If you think that way run it on non peak hours (Given whitepaper has very much in detail, i guess)

          This is handy too

          Troubleshooting Oracle Applications Performance Issues (Doc ID 169935.1)

          • 17. Re: Not able to see objects from apps schema in R12
            mksadmin

            Hi Younas,

             

            As per given note ids, have execute the below statement. But still query is hung.

             

            EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

            EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

             

            EXEC DBMS_STATS.GATHER_SCHEMA_STATS ('SYS');

            Exec FND_STATS.gather_schema_statistics('schema_name');

             

            Thanks

            • 19. Re: Not able to see objects from apps schema in R12
              mksadmin

              Hi Yoonas,

               

              as per above given blog, have fetch the explain plan and tkrpof for trace.

               

              *---- trace output----*

               

              TKPROF: Release 11.2.0.3.0 - Development on Thu May 1 10:35:41 2014

               

               

              Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

               

               

              Trace file: CRP_ora_4206.trc

              Sort options: default

               

               

              ********************************************************************************

              count    = number of times OCI procedure was executed

              cpu      = cpu time in seconds executing

              elapsed  = elapsed time in seconds executing

              disk     = number of physical reads of buffers from disk

              query    = number of buffers gotten for consistent read

              current  = number of buffers gotten in current mode (usually for update)

              rows     = number of rows processed by the fetch or execute call

               

               

               

               

               

               

              ********************************************************************************

               

               

              OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

               

               

              call     count       cpu    elapsed       disk      query    current        rows

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

              Parse        4      2.04       2.00          0          0          0           0

              Execute      5      0.01       0.00          0          0          0           0

              Fetch        2    651.41     651.41          1   31735264          0           0

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

              total       11    653.46     653.42          1   31735264          0           0

               

              Misses in library cache during parse: 3

              Misses in library cache during execute: 1

               

               

               

               

              OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

               

               

              call     count       cpu    elapsed       disk      query    current        rows

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

              Parse       48      0.01       0.01          0          0          0           0

              Execute     96      0.07       0.08          0          0          0           0

              Fetch      201      0.02       0.05          6        353          0         142

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

              total      345      0.10       0.15          6        353          0         142

               

               

              Misses in library cache during parse: 3

              Misses in library cache during execute: 3

               

               

                  5  user  SQL statements in session.

                 25  internal SQL statements in session.

                 30  SQL statements in session.

              ********************************************************************************

              Trace file: CRP_ora_4206.trc

              Trace file compatibility: 11.1.0.7

              Sort options: default

               

               

                     1  session in tracefile.

                     5  user  SQL statements in trace file.

                    25  internal SQL statements in trace file.

                    30  SQL statements in trace file.

                    27  unique SQL statements in trace file.

                  1301  lines in trace file.

                   766  elapsed seconds in trace file.

               

              *---End of Trace---*

               

              Shall i paste the explain plan output as it seems to be large OR is there any alternate option as support does not allow attachment cause of security.

               

              Thanx

              • 20. Re: Not able to see objects from apps schema in R12
                yoonas

                Mazher,

                 

                You better close this thread and open a new thread for this one on Data base general Questions so that you will have more audience with more expertise in performance

                 

                Regards

                Yoonas

                • 21. Re: Not able to see objects from apps schema in R12
                  mksadmin

                  Ok

                   

                  Thanks for your assistance.

                  • 22. Re: Not able to see objects from apps schema in R12
                    yoonas

                    You are welcome, glad to have been of assistance

                    1 2 Previous Next