Thursday, February 19, 2015

Query to get Top 10 Big tables

SELECT * FROM ( SELECT OWNER, SEGMENT_NAME, BYTES/1024/1024/1024 SIZE_GB FROM DBA_SEGMENTS WHERE SEGMENT_TYPE = 'TABLE' ORDER BY BYTES/1024/1024 DESC ) WHERE ROWNUM <= 10;
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL executions based on AWR

SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...

  • Scripts required for 12.2.X custom
    1) For new table creations - after creating the table in custom schema execute below script to generate editoning view and synonym for it in...
  • Compile Forms and Reports in 11.5.10.2
    1) How to compile a form? A) Open the source code in the client PC using X-Server -------------------------------------------------------...
  • How to hold the concurrent requests
    List out the Jobs which were already on HOLD select request_id, phase_code, status_code from fnd_concurrent_requests where hold_flag = ...