2019年9月24日
change user default tablespace and move table,index to new tablespace
摘要： Here I present a simple query to use when we want to move the tables and indexes of several users at once. To make it one by one: ALTER TABLE xxxxxx M 阅读全文
posted @ 2019-09-24 17:54 兜儿~ 阅读(320) 评论(0) 推荐(0)
oracle resize redo logfile and standby logfile on both primary and physical standby database
摘要： Oracle更改redo log大小和standby log大小（1）redo log的大小可以影响 DBWR 和 checkpoint ； （2）arger redo log files provide better performance. Undersized logfiles increas 阅读全文
posted @ 2019-09-24 15:40 兜儿~ 阅读(392) 评论(0) 推荐(0)