This script will help you to move all objects from one tablespace to another, note that you will need downtime to move tables to other tablespace with this script, the operation can be done online using the dbms_redefinition package thought.
Zabbix is an open-source based enterprise level monitoring solution that aims for monitoring distributed network components and servers. It supports both polling and trapping based monitoring and provides an email-based alerting capability that can respond to virtually any event of the monitored system. A web portal is also provided for viewing metrics and monitoring behavior configuration.
At very high level, Zabbix monitoring solution is composed of the following core components:
Sometimes it is necessary to put on your uber-geek hat and start using cryptic bits of code to retrieve information from an Oracle database. Troubleshooting enqueue locking events in Oracle databases is one of the times some advanced SQL may be necessary.
Likely you have used SQL similar to the following when troubleshooting Oracle enqueue’s, probably in connection with row lock contention.
Well that went by quick, didn’t it? As I’m typing this blog post it’s already November 2016 and it’s time to look forward to our plans for 2017. With that in mind, I’m going to outline the goals I’m setting out for my clients in 2017. Same as our personal goals, some of them will happen, some won’t, but knowing where we want to go will help us progress regardless.
This part of the series is supposed to cover the results of I/O related tests performed on the Amazon RDS Oracle cloud instance.
As mentioned in the previous part of this series I've only used the "General Purpose SSD" storage type since the "Provisioned IOPS" storage was simply to expensive to me and it wasn't possible to get a trial license for that storage type.