by S-Square | Aug 2, 2021 | Blogs
Introduction: Sessions which are running longer in oracle database can be viewed from v$session_longops view provided by Oracle. For RAC, make sure to use gv$session_longops instead of v$. In this blog, will see how to find long running sessions or long operations in...
by S-Square | Jul 5, 2021 | Blogs
Introduction: In this blog, will see how to identify the objects which are consuming more space in an Oracle database and options to reclaim the space. Description: In an OLTP database environments, the objects can grow large and sometimes the fragmentation can happen...
by S-Square | May 31, 2021 | Blogs
Introduction: Rubrik Cloud Data Management (CDM) for Oracle databases provides enterprise-grade data protection and DevOps-centric automation. It targets enterprises that use hybrid cloud environments and offers data management services such as backup and recovery....
by S-Square | May 3, 2021 | Blogs
Introduction: A Materialized view (also referred to as a snapshot) is a logical structure whose data is physically stored in the database. Since data is accessed from a direct physical location, data retrieval is quicker with a materialized view than with a standard...
by S-Square | Mar 31, 2021 | Blogs
Introduction: If you are observing fast growth in SYSAUX tablespace and your database version is 12c, then you need to check for the sysaux occupants to find the root cause. In case if you find the top occupant name as AUDIT_TABLES , there could be some purging issue...
