On these tutorial we create some graphs for view oracle performance problems and IO .First step is install oracle docker on Oracle Linux - 6 or 7. My case i going to study hard to get OCP on linux, and now we use Oracle Linux 7.2, please follow:https://blogs.oracle.com/linux/entry/ahoy_cast_off_with_dockerInstallationTo install Docker on Oracle Linux 6:Enable the ol6_addons channel in /etc/yum.repos.d/public-yum-ol6.repoRun:# yum install docker To install Docker on Oracle Linux 7:Enable the ol7_addons channel in /etc/yum.repos.d/public-yum-ol7.repoRun:# yum install docker Enable btrfs supportDocker uses device-mapper devices as the default storage engine. To switch to using btrfs as the storage engine, ensure that /var/lib/docker is mounted on a btrfs filesystem. Check Chapter 5 of the Oracle Linux Administrator's Solutions Guide for more details on how to create and mount btrfs filesystems.To enable btrfs support for Docker on Oracle Linux:Ensure that /var/lib/docker is on a btrfs filesystemEdit /etc/sysconfig/docker and add "-s btrfs" to the other_args fields.Restart the Docker daemon:# service docker restartEnabling and starting DockerTo enable the Docker daemon on system boot and start Docker on OL6:# chkconfig docker on# service docker startTo enable the Docker daemon on system boot and start Docker on OL7:# systemctl enable docker.service# systemctl start docker.serviceChecking Docker statusTo check that Docker is up and running on OL6:# service docker statusTo check that Docker is up and running on OL7:# systemctl status docker.serviceYou can also get more information from Docker itself:# docker info# docker versionOnce you have Docker up and running, follow the upstream Docker documentation to get started. Next step is to get my docker on next post! Com a consulta abaixo conseguimos ter acesso as recomendacoes do Segment advisor.SELECT 'Segment Advice --------------------------'|| chr(10) || 'TABLESPACE_NAME : ' || tablespace_name || chr(10) || 'SEGMENT_OWNER : ' || segment_owner || chr(10) || 'SEGMENT_NAME : ' || segment_name || chr(10) || 'ALLOCATED_SPACE : ' || allocated_space || chr(10) || 'RECLAIMABLE_SPACE: ' || reclaimable_space || chr(10) || 'RECOMMENDATIONS : ' || recommendations || chr(10) || 'SOLUTION 1 : ' || c1 || chr(10) || 'SOLUTION 2 : ' || c2 || chr(10) || 'SOLUTION 3 : ' || c3 AdviceFROM TABLE(dbms_space.asa_recommendations('FALSE', 'FALSE', 'FALSE')); Particionamento de tabelas OracleO particionamento de tabelas e de indices auxilia no tratamento e na selecao destes dados. Os dados sao armazenados em segmentos, e estes segmentos que estao armazenados nessas particoes podem sofrer manutencoes diretamente.Para isso temos as seguintes tipos de particoes:Range - E a mais comum e pelo nome ja diz baseada em cima de um range da chave.Hash - A partir de um algoritmo os dados sao armazenados nas particoes a partir de uma chave de particionamento.List - Os dados sao mapeados as particoes a partir de listas.Interval - Os dados sao mapeados as particoes a partir de intervalos que sao automaticamente criados de acordo com o intervalo.System - Os dados sao mapeados as particoes de forma arbitraria - via o programa que os esta tratando.Podemos ainda ter uma subparticao, para que possamos ter uma opcao de aproveitar ainda mais aquela particao ja existente.Range top level: Range-Range Range-Hash Range-List List top level: List-Range List-Hash List-List Interval top level: Interval-Range