Catégorie : Oracle12C,19C

create_sql_profile.txt

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 […]

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 […]

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 […]

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 […]

–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 […]

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 […]