Tablespace Utilisation in Oracle SQL

How to Check the Table space usage in Oracle database   An Oracle database consists of one or more logical storage units called TableSpaces, which collectively store all of the database's data. Each TableSpaces in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating … Continue reading Tablespace Utilisation in Oracle SQL

Advertisements

GC Time Using jstat

  GARBAGE COLLECTION TIME - (using JSTAT)   Login to your Linux/Unix Server Enter the below command to get the JAVA PID running on the server.                           ps –ef|grep –i java From the output take the application JAVA PID. Using jstat command with … Continue reading GC Time Using jstat