Arvind Toorpu

A profile is a named set of the following password and resource limits: a.. Password aging and expirationb.. Password historyc.. Password complexity verificationd.. Account lockinge.. CPU timef.. Input/output (I/O) operationsg.. Idle timeh.. Connect timei.. Memory space (private SQL area for Shared Server only)j.. Concurrent sessions After a profile has been created, the database administrator can…

 exporting schema excluding some tables: To exclude table from EXPDP Backup. Let’s take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp exclude=table:”in\(‘EMP’\,’DEPT’\)” parameter is best for DBA . Make sure you provide table…

When ever you try to insert an ambersand ‘&’ into database, database tries to intract and get the values values from screen. in that case we can follow below steps create table test (name varchar2(35)); insert into test values (‘hello&world’); I tried the escape character ‘\’ but the system asks for a value of the…

Auditing changes within the database are becoming more and more important. As well as auditing changes to data, auditing DDL changes can be just as critical. This allows the DBA to not only know what changes have been made but also what haven’t. Being able to see what changes have been made to the database…

Find accounts unused for days                                                 Summary Here’s a script that shows accounts and number of days since last use. It assumes session auditing is enabled. SELECT RPAD(da.username, 12) “Username”, TRUNC(SYSDATE – MAX(da.TIMESTAMP)) “Days Inactive”, LPAD(du.account_status, 16) “Status”, LPAD(TO_CHAR(MAX(da.TIMESTAMP), ‘DD-MON-YYYY’), 16) “Last Login”FROM dba_users du, dba_audit_session da WHERE da.action_name LIKE ‘LOG%’– AND da.username NOT IN (‘SYS’,’SYSTEM’)…