HomeОбразованиеRelated VideosMore From: Oracle PL/SQL World

How to Monitor Session in SQL Developer | Oracle SQL Developer Tips and Tricks

4 ratings | 679 views
How to Monitor Session in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners, Oracle Database Tutorial for Beginners, Oracle SQL Developer Tips and Tricks, Oracle Tutorial for Beginners, Oracle Tutorial How to Monitor Session in SQL Developer, How to Monitor Session Using SQL Developer, How to Monitor Session in Oracle SQL Developer, How to Monitor Session Using Oracle SQL Developer, how to check number of connections in oracle, how to check active sessions in oracle, oracle sql developer real time sql monitoring, how to check active session in oracle 11g, sql developer monitor sessions table or view does not exist oracle monitor sql statements how to check query performance in oracle sql developer
Html code for embedding videos on your blog
Text Comments (3)
Kishan Kadam (4 months ago)
Sir how to calculate db size in Oracle
Oracle PL/SQL World (4 months ago)
Use the below Query and run through SYS user... U will get the existing tablespace Total Size and Availabe Free space... But one think you have to make sure ,, this query should be execute through SYS Schema
Oracle PL/SQL World (4 months ago)
SELECT B.TABLESPACE_NAME, TBS_SIZE SIZE_OF_TS_MB, A.FREE_SPACE FREE_SIZE_OF_TS_MB FROM (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES)/1024/1024 ,2) AS FREE_SPACE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) A, (SELECT TABLESPACE_NAME, SUM(BYTES)/1024/1024 AS TBS_SIZE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME ) B WHERE A.TABLESPACE_NAME(+)=B.TABLESPACE_NAME ORDER BY A.FREE_SPACE;

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.