PinnedDaniel T. A.Hello!Welcome! This is the “Daniel T. A.” blog/website. I am an IT professional work together with Databases technology for a long time. Thru…Dec 20, 2022Dec 20, 2022
Daniel T. A.The Best SQL Command to Terminate Blocking Lock Database Sessions in OracleIntroduction: In an Oracle database, encountering blocking lock sessions can be a common occurrence, leading to performance issues and…May 31, 2023May 31, 2023
Daniel T. A.The Best SQL Command to Calculate the Overall Size of an Oracle DatabaseWhen it comes to managing an Oracle database, understanding its overall size is crucial for capacity planning, performance optimization…May 23, 2023May 23, 2023
Daniel T. A.Oracle Table and Indexes SizeAs Oracle DBAs many times we need a way to quickly get information about a particular table, its size (including LOB columns) and all…Mar 17, 2023Mar 17, 2023
Daniel T. A.Elasticsearch 7.x “java.io.FilePermission” errorRecently I have noticed this error message below in one Elasticsearch 7.x environment during Elasticsearch node startup. It causes…Jan 18, 2023Jan 18, 2023
Daniel T. A.Elasticsearch Query for SQL UsersElasticsearch is a search engine based on Lucene library. It provides a distributed, multitenant-capable full-text search engine with an…Dec 28, 2022Dec 28, 2022
Daniel T. A.Monitor Standby Archive Apply Gap on Oracle DataGuardIn the DataGuard environment is quite common DBA to monitor the amount of archives that need to be applied in order to sync up primary and…Dec 23, 2022Dec 23, 2022
Daniel T. A.Monitor Oracle database object grow using AWRIt is quite common DBAs to receive questions about table/index storage sizes on database, or more important some questions about how much…Dec 22, 2022Dec 22, 2022
Daniel T. A.Updating Oracle AWR RetentionThe AWR resource started from Oracle 10g version is one of most interesting and versatile tools available for the DBA. It is possible to…Dec 21, 2022Dec 21, 2022
Daniel T. A.How to find SPID on Oracle DatabaseMany time we want to know the SPID information of a specific Oracle database session. This information can be used to enabled trace on…Dec 20, 2022Dec 20, 2022