Oracle SYSAUX
-
Oracle SYSAUX表空间使用率过高的处理办法
目录1、维护需求2、通过SQL语句查询SYSAUX表空间占用3、直接查询出是哪些表分区占用SYSAUX表空间较高4、然后直接truncate这些表5、再次查看SYSAUX表空间使用量1、维护需求[详细]
2024-09-05 08:57 分类:数据库 Using a set of numbers inside a database without creating a temporary table
I have a set of numbers and a table in a database with the id (primary key) and text (not null) columns. I would like to create a query that returns all the numbers in the set and the associated text[详细]
2022-12-28 19:16 分类:问答