Oracle: Track TEMP size

 SELECT sysdate,a.username, a.sid, a.serial#, a.osuser, 
(b.blocks*d.block_size)/1048576 MB_used, c.sql_text
FROM v$session a, v$tempseg_usage b, v$sqlarea c,
     (select block_size from dba_tablespaces where tablespace_name='TEMP02') d
    WHERE b.tablespace = 'TEMP02'
    and a.saddr = b.session_addr
    AND c.address= a.sql_address
    AND c.hash_value = a.sql_hash_value
    AND (b.blocks*d.block_size)/1048576 > 1024
    ORDER BY b.tablespace, 6 desc;

Comments

Post a Comment

Popular posts from this blog

Postgres: To list table owners

SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename; ---- SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname <> tableowner AND  schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename;
Read more

PeopleSoft: Clean Up PUM

  Manual Cleanup steps for WINDOWS Before carrying out the advanced steps in this section: Run the command:  psft-dpk-setup.bat --cleanup. If you deployed the environment using the use_alternate_puppet_install option, use this command:   psft-dpk-setup.bat --cleanup --use_alternate_puppet_install If the script displays a FAILED message, run it again. If it succeeds, check the BASE_DIR folders to be sure everything has been deleted. If the BASE_DIR folders are not clear, or if a subsequent deployment is not successful, carry out the steps below. For the  ADVANCED CLEAN UP PROCESS  on Microsoft Windows, please see the following steps. NOTE: These should be performed by someone familiar with modifying the Microsoft Windows registry. Depending upon where the cleanup process failed, some of the items mentioned in these steps may have already been removed. The user should remove whatever remains in this order: Start the Microsoft Windows Services utilit...
Read more

Postgres: To check the locale / Character set settings

  To check the locale settings in PostgreSQL, you can use the following SQL query: SHOW lc_collate; SHOW lc_ctype; SHOW lc_messages; SHOW lc_monetary; SHOW lc_numeric; SHOW lc_time; Explanation: lc_collate : Defines the collation order (sorting rules) for strings. lc_ctype : Specifies the character classification (e.g., upper/lower case). lc_messages : Determines the language for system messages. lc_monetary : Sets the locale for monetary formatting. lc_numeric : Configures the locale for numeric formatting. lc_time : Specifies the locale for date and time formatting. You can run these commands in your PostgreSQL client (e.g., psql ) to view the current locale settings. If you need to change them, you can configure them in the postgresql.conf file or during database initialization.
Read more