Evening_package运行时不一致
我们有晚间套餐，计划在晚上运行，通常在午夜之前完成。 我们最近将 Oracle ODA 迁移到 Exadata 云，并进行了容器化和 Oracle 修补。我们的数据库迁移后，它在第二天就停止了。然后，作为一个解决方案，我要求 DBA 团队收集过时的统计数据，第二天就成功了。之后的几天里，一切都运转良好。上周我们将 Oracle 升级到了可用的最新版本，第二天它再次停止，然后我要求 DBA 团队收集过时的统计信息，但它没有效果，现在它运行不一致，有一天它错误地指出临时表空间问题，我们的 DBA 团队增加了空间，之后第二天就完成了，但需要 12 小时才能完成，而不是 5 小时。它运行了两天，但在某一点上发生了错误，因此总结是有时它正在完成，有时它被击中不会出错。然后我们必须在晚上下一个会议开始之前终止罢工会议。
我与 DBA 团队进行了调查，他们没有发现任何问题。请让我知道造成这种缓慢和不一致行为的其他原因。
注意：包的定义没有发生变化。
非常感谢任何反馈或建议。
谢谢， 库什11
We have evening package that is scheduled to run during evening and usually completes by midnight.
We recently migrated our Oracle ODA's to Exadata cloud and did containerization and oracle patching. After our database migration it stopped the next day. Then as a solution I asked DBA team to gather stale stats and it worked the next day. After that it worked fine for rest of the days. Last week we did Oracle upgrade to latest version available, it again stopped the next day then I asked DBA team to gather stale stats, but it didn't effect, now it is running inconsistently, one day it errored out stating temp tablespace issue, our DBA team increased the space, after that it completed next day but taking 12 hours to complete instead of 5. For two days it ran but struck at one point without erroring out, therefore summary is sometimes it is completing and other times it gets struck without erroring out. Then we have to kill the struck session before next one starts in the evening.
I checked with DBA team to look into it, they don't see any issues from their end. Please let me know what else can be the reason for that slowness and inconsistent behavior.
Note: There was no change made in definition of the package.
Any feedback or recommendations are greatly appreciated.
Thanks,
Khush11
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论