Pour connaître les infos des stats dans la base Oracle. SET LINESIZE 250 COLUMN autostats_target FORMAT A20 COLUMN cascade FORMAT A25 COLUMN degree FORMAT A10 COLUMN estimate_percent FORMAT A30 COLUMN. read more…
Merci aux dev sql qui m’ont bien aidé sur ce forum : https://www.developpez.net/forums/d2021961/bases-donnees/langage-sql/insert-into-long-s-executer-optimiser/#post11229277
The Solution To resolve this error, you must increase the values for INBOUND_ CONNECT_ TIMEOUT on both the listener side and the server side. If you are getting ORA-609 because. read more…
http://www.runningoracle.com/product_info.php?products_id=435 Summary You can create an SQL TUNING TASK manually ad hoc with the following simple steps. ALTER SESSION SET NLS_LANGUAGE=’AMERICAN’; 0. Find the sql_id of the oracle session you. read more…
Pour afficher les stats sur les tables : set pages 200 col index_owner form a10col TABLE_NAME for a40col table_owner form a10col owner form a10 spool checkstat.lst PROMPT Regular Tables select. read more…
–Check the parameter is enabled or disable for Auditselect name || ‘=’ || value PARAMETER from sys.v_$parameter where name like ‘%audit%’;–Statement Audits Enabled on this Databasecolumn user_name format a10column audit_option. read more…
Voir si les stats Oracle sont calculées sur mon schéma : set lines 150set pages 3000col TABLE_NAME for a30col INDEX_NAME for a30col COLUMN_NAME for a30 define schema=&schema spool stats_&schema. read more…
Migrate database from One RMAN catalog to another RMAN catalog http://www.nazmulhuda.info/migrate-database-from-one-rman-catalog-to-another-rman-catalog Migrate database from One RMAN catalog to another RMAN catalog In that scenario we will move catalog from. read more…
Catégorie : Oracle12C,19C
Créer sql profile à partir du sql id
create_sql_profile.txt
Récupérer les infos de stats en base
Pour connaître les infos des stats dans la base Oracle. SET LINESIZE 250 COLUMN autostats_target FORMAT A20 COLUMN cascade FORMAT A25 COLUMN degree FORMAT A10 COLUMN estimate_percent FORMAT A30 COLUMN. read more…
Problème de compilation de trigger RMAN après montée de version en 12.2
alter trigger RMAN.VPC_CONTEXT_TRG disable; => marche pas 🙁 lancer : @?/rdbms/admin/dbmsrmanvpc.sql -vpd rman puis UPGRADE CATALOG ; source
Merci aux dev SQL
Merci aux dev sql qui m’ont bien aidé sur ce forum : https://www.developpez.net/forums/d2021961/bases-donnees/langage-sql/insert-into-long-s-executer-optimiser/#post11229277
ORA-609: opiodr aborting process unknown ospid
The Solution To resolve this error, you must increase the values for INBOUND_ CONNECT_ TIMEOUT on both the listener side and the server side. If you are getting ORA-609 because. read more…
Tuning SQL ID
http://www.runningoracle.com/product_info.php?products_id=435 Summary You can create an SQL TUNING TASK manually ad hoc with the following simple steps. ALTER SESSION SET NLS_LANGUAGE=’AMERICAN’; 0. Find the sql_id of the oracle session you. read more…
Stats missing
Pour afficher les stats sur les tables : set pages 200 col index_owner form a10col TABLE_NAME for a40col table_owner form a10col owner form a10 spool checkstat.lst PROMPT Regular Tables select. read more…
Script for check all the enabled auditing on Database
–Check the parameter is enabled or disable for Auditselect name || ‘=’ || value PARAMETER from sys.v_$parameter where name like ‘%audit%’;–Statement Audits Enabled on this Databasecolumn user_name format a10column audit_option. read more…
Stats Oracle SYSTEME et schema
Voir si les stats Oracle sont calculées sur mon schéma : set lines 150set pages 3000col TABLE_NAME for a30col INDEX_NAME for a30col COLUMN_NAME for a30 define schema=&schema spool stats_&schema. read more…
Migrate database from One RMAN catalog to another RMAN catalog
Migrate database from One RMAN catalog to another RMAN catalog http://www.nazmulhuda.info/migrate-database-from-one-rman-catalog-to-another-rman-catalog Migrate database from One RMAN catalog to another RMAN catalog In that scenario we will move catalog from. read more…