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. read more…
Josselin Joly
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…
Modèle gratuit de status pour EURL
https://www.wonder.legal/fr/creation-modele/statuts-eurl
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. 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…
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. 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…
Translate »