Home| Progetto| Web| Faq| Acronimi | ||||||||||||||||||||||||||||||||||||||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Info:
Spazio su disco per motore Oracle 10g
Oracle...
Script:
Query per visualizzare percentuale di storage disponibile e ripartizione storage per datafile
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
Cursore implicito SQL
Oracle...
Tip:
V$RECOVER_FILE vista dinamica sullo stato dei datafile
Oracle...
Faq:
Which chars in table and column names?
Shell scripting...
Script:
Debug shell program
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
Php Funzione mail()
La J2EE (Java 2 Enterprise Edition) è dedicata a tutti coloro che desiderano aggiungere il supporto della versione Enterprise di Java (ad esempio a Tomcat) e quindi le funzionalità avanzate come Enterprise JavaBeans etc.
Un servizio Web XML è un'unità logica di applicazioni che fornisce dati e servizi ad altre applicazioni.
Le applicazioni accedono ai servizi Web XML tramite protocolli Web universali e formati di dati quali HTTP, XML e SOAP.
|
Oracle
Home >Oracle > Clean up audit tables
Some times may be necessary or useful clean up auditing logs from oracle tables. Audit_trail is set as DB or DB_EXTENDED.
-- audit settings in Oracle database 10g SQL> show parameter audit
-- audit views are full of logs and need clean up.
SQL> column object_schema format a10 SQL> column statement_type format a20 SQL> column db_user format a12 SQL> column os_user format a12 SQL> column terminal format a12 SQL> column extended_timestamp format a20 SQL> select object_schema, statement_type, db_user, os_user,terminal , extended_timestamp from dba_common_audit_trail where rownum < 4 order by extended_timestamp;
To remove all auditing records connect as sysdba and truncate the audit table AUD$.
-- clean audit tables. In production envirorment make sure you really want to remove all audit data or backup the data before.
$ sqlplus sys as sys dba SQL> truncate table aud$; Table truncated. -- to verify that audit records have been deleted; SQL> select object_schema, statement_type, db_user, os_user,terminal , extended_timestamp from dba_common_audit_trail ; no rows selected Same process to remove Fine Grained Auditing logs from fga tables. In this case the table is FGA_LOG$.
-- clean fga audit tables
SQL> truncate table fga_log$; Table truncated. Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Codici errore ![]() ![]() ![]() ![]() ![]() |
Cerca
Oracle...
Info:
Se non viene definite tablespace permanente e temporanea
Well-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Well-formedness is a new concept introduced by [XML]. Essentially this means that all elements must either have closing tags or be written in a special form (as described below), and that all the elements must nest properly.
Oracle...
Info:
Database buffer cache
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Scalar Subquery
Oracle...
Definizioni:
Area PGA
Shell scripting...
Script:
Pulire i file provenienti da ambieti dos/ windoes da caratteri sporchi
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |