摘要：
问题：临时表空间的 TEMPFILE(s) 变大后如何调整它们的大小？ 大型排序操作会导致临时表空间变得非常大，因此在此类操作之后可能需要“缩小”。在 Oracle 11g 之前，没有 SQL 命令来释放未使用的已分配临时空间。此问题的一种解决方法是创建一个较小的新空临时表空间，将这个新表空间分配给 阅读全文
摘要：
This is a script to get the tablespace utilization in Oracle Database 12c. You can use this script to get the tablespace utilization ALLOCATED(MB), US 阅读全文
摘要：
The post outlines the steps to resize an OCFS2 filesystem on Linux. The procedure should first be tested in test before being performed against a prod 阅读全文
摘要：
This post explains which initialization file can be used to start an instance, depending upon if a spfile or init.ora file exists. Before Oracle9i, Or 阅读全文
摘要：
This post summarizes the syntax used to set trace and debug events when the server uses the binary server-side parameter file (SPFILE). You need to se 阅读全文
摘要：
LogMiner is a tool that lets you use SQL statements to analyze events in the database log. With LogMiner, you can track transactions as they are proce 阅读全文
摘要：
This post provides the steps to resize the Undo tablespace.ie, to add space or shrink the current Undo tablespace. Shrinking Undo Tablespace Size Undo 阅读全文