Hot answers tagged

2

The installation of a PSU is not complete without the execution of the postinstall script. Opatch works at file level, it replaces/relinks files in the Oracle home. Changes inside the database are performed by running the postinstall script. Sometimes I see DBAs forget this step. The postinstall script maintains the SYS.REGISTRY$ table (on which the ...


2

Can nologging in certain tables boost the performance? Not for a normal transactional load. nologging only affects some very specific cases of DML (essentially direct-path inserts) and some DDL (see logging_clause). So essentially only for bulk data-loading scenarios. If that's not what your database is doing, it won't help at all. If it is what your ...


2

Archiving the Database Audit Trail Scheduling an Automatic Purge Job for the Audit Trail Manually Purging the Audit Trail Basically you copy the audit trail to another table, e.g: INSERT INTO table SELECT ... FROM SYS.AUD$ ...; INSERT INTO table SELECT ... FROM SYS.FGA_LOG$ ...; You can just export and drop these tables, then import them when you need ...


1

That's exactly the kind of thing that oracle AUDIT is created for. The basic view is DBA_AUDIT_TRAIL, though there are several others. By defalt, Oracle has some auditing already enabled, but you may want to review and modify. Also you want to use the dbms_audit_mgmt package to move the audit tables out of the SYSTEM tablespace into their own dedicated ...


1

I am using these two functions in my application: CREATE OR REPLACE FUNCTION Ip2Decimal(IP IN VARCHAR2) RETURN INTEGER DETERMINISTIC IS DecimalIp INTEGER; BEGIN SELECT SUM(REGEXP_SUBSTR(IP, '\d+', 1, LEVEL) * POWER(256, 4-LEVEL)) INTO DecimalIp FROM dual CONNECT BY LEVEL <= 4; RETURN DecimalIp; END Ip2Decimal; and CREATE OR ...


1

The initialization parameters are not supposed to change while bouncing the database except in one case, that is if the modification was only for currently running instance(SCOPE=MEMORY). The following are the steps to modify initialization parameters using Enterprise Manager. To modify initialization parameters for the currently running instance, and ...


1

Database SQL Language Reference There is no CREATE ASSERTION in Oracle. RDBMS products do not necessarily implement all features in the SQL standards. And to add to the above: Check Constraints Restrictions on Check Constraints The condition of a check constraint can refer to any column in the table, but it cannot refer to columns of other ...



Only top voted, non community-wiki answers of a minimum length are eligible