Josselin Joly

ORACLE DATABASE LOAD TESTING TOOLS – OVERVIEW   Benchmarking Oracle I/O Performance with Orion by Alex Gorbachev Miladin Modrakovic’s Blog: Oraclue Measuring Storage Performance For Oracle Systems  

Tout est dans le titre !

Big Data : http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html Developer : http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html Vms Template oracle 12c: http://www.oracle.com/technetwork/server-storage/vm/database-templates-12c-11gr2-1972804.html

    ICI

Coalesce will just do a reorganization on the existing data, in place and leave any fully free blocks it created belonging to the index – it does not release it,. read more…

Pour récupérer l’espace libre d’une table, on peut utiliser : TRUNCATE table_toto DROP STORAGEou ALTER TABLE table_toto DEALLOCATE UNUSED   Avant tout il faut connaitre quel table contient des trous. read more…

Cette méthode est celle utilisée par Percona : 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCKNote – this command may take a while to complete if you. read more…

$ psql -qAt -d mydatabase -c « SELECT ‘ALTER TABLE ‘||schemaname||’.’||tablename||’ OWNER TO new_owner;’ FROM pg_tables WHERE schemaname = ‘myschema' » > data.txt   $ psql < data.txt -d mydatabase   source. read more…

Installer pgbouncer , configurer le .ini : cat /etc/pgbouncer/pgbouncer.ini   [databases]<aliasBDD> = dbname=test user=pg_test port=5433 pool_size=48 [pgbouncer]logfile = /var/log/pgbouncer/pgbouncer.logpidfile = /var/run/pgbouncer/pgbouncer.pidauth_file = /etc/pgbouncer/userlist.txtlisten_addr = <hostname>-pgblisten_port = 5432auth_type = trustadmin_users =. read more…

A quoi ça sert de faire un explain sur une requete lente?   Alors pour info dans une requête quand tu ne mets pas les simples quotes sur les types. read more…