-
Put the Database in ARCHIVE mode and enable flashback mode
SQL> select banner from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod PL/SQL Release 10.2.0.1.0 – Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 – Production NLSRTL Version 10.2.0.1.0 – Production SQL> select flashback_on from v$database; FLASHBACK_ON —————— NO SQL> select log_mode from v$database; LOG_MODE ———— NOARCHIVELOG SQL> alter…
-
Read the file
A Master piece from http://laurentschneider.com An excellent piece of code handy for DBA`s SQL> SELECT s.sid, 2 s.serial#, 3 pa.value || ‘\’ || LOWER(SYS_CONTEXT(‘userenv’,’instance_name’)) || 4 ‘_ora_’ || p.spid || ‘.trc’ AS trace_file 5 FROM v$session s, 6 v$process p, 7 v$parameter pa 8 WHERE pa.name = ‘user_dump_dest’ 9 AND s.paddr = p.addr 10 AND…
-
Handy Package DBMS_UTILITY
Really Its great handy package for Oracle People! We can use this in so many different scenarios. SQL> DECLARE 2 parnam VARCHAR2(256); 3 intval BINARY_INTEGER; 4 strval VARCHAR2(256); 5 partyp BINARY_INTEGER; 6 BEGIN 7 partyp := dbms_utility.get_parameter_value(‘max_dump_file_size’, 8 intval, strval); 9 dbms_output.put(‘parameter value is: ‘); 10 IF partyp = 1 THEN 11 dbms_output.put_line(strval); 12 ELSE…
-
Get the trace file name and read it
SQL> COL trace_file FOR A75 SQL> col VALUE format a50 SQL> col name format a20 SQL> select name,value 2 from v$parameter 3 where name=’user_dump_dest’; NAME VALUE ——————– ————————————————– user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\SRIRAM_TEST\UDUMP SQL> SELECT s.sid, s.serial#, …
Sriram Sanka
Databases | Cloud | Infrastructure | Security |
Sriram Sanka 