Auteur/autrice : admin
-
Calcul des charges sociales d’une EURL
Le taux des charges sociales d’une EURL sur la rémunération du gérant associé unique dépend de plusieurs données. Il s’agit : Des allocations familiales ; De l’assurance maladie maternité ; De l’assurance vieillesse […]
-
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 […]
-
eurl compte pro qonto
https://qonto.eu/fr/freelancers/compte-professionnel-eurl https://qonto.eu/fr/pricing Prendre le pack solo créateur d’entreprise.
-
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 […]
-
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 […]
-
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 […]
-
Cursor environment mismatch V$SQL_SHARED_CURSOR
SELECTSS1.SQL_TEXT,SS1.SQL_ID,SS1.CHILD_NUMBER,SS2.CHILD_NUMBER,SS1.SQLTYPE,SS2.SQLTYPE,SS1.PARSING_SCHEMA_NAME,SS2.PARSING_SCHEMA_NAMEFROMV$SQL SS1,V$SQL SS2WHERESS1.SQL_ID=SS2.SQL_IDAND SS1.SQLTYPE < SS2.SQLTYPEORDER BYSS1.SQL_TEXT,SS1.CHILD_NUMBER,SS2.CHILD_NUMBER; SELECTSSC.*FROMV$SQL S,V$SQL_SHARED_CURSOR SSCWHERES.SQL_ID=’xxxxxxxxxxxxx’AND S.SQL_ID=SSC.SQL_IDAND S.CHILD_ADDRESS=SSC.CHILD_ADDRESSORDER BYSSC.CHILD_NUMBER; SELECT S.CHILD_NUMBER, SBM.POSITION, SBM.DATATYPE, SBM.MAX_LENGTH, SBM.BIND_NAME FROM V$SQL S, V$SQL_BIND_METADATA […]
-
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 […]
-
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 […]