|
||||
|
Hello Thanks to my colleague (Satish) to share this. Here is the nice script to find the relative object name that is having block corruption, ofcourse the the v$database_block_corruption will populate only when you run the rman command. 1) RMAN> Backup validate check logical database; This will populate the v$data_block_corruption with rows about the blocks […] Tracing datapump is not straight forward, you can trace the datapump worker(dw00) or datapump master(DM00) with 10046 to get the sql etc or use the TRACE option in expdp/impdp Where in expdp has an option called trace where you can trace the session associated to datapump and then see what its waiting for or running […] Hello, When using parallel query, Oracle uses one of these methods of performing parallel queries or DML: Parallelize by block range Parallelize by partition Parallel processing using slave processes go and read on […] Hello, Until 10g when you want to export and import between releases (i.e 10g to 11g), For example you want to export from 11g database and import it into 10g. This is not possible until 10g, unless you use the higher version binaries(means expdp/impdp executables) in both databases. But from 11g R1 onwards you […] Hello, Sometimes we tend to miss some simple thing which I had similar in expdp and impdp. Normally when you want to export a schema and import into another schema we user fromuser and touser, before to that you have to create the user in target database where you are going to import. In expdp/impdp […] In 11gR2, Oracle has introduced a cache called flash cache which is a secondary cache of the buffer cache. This flash cache is resides in L2 Cache of the system (RAM) and can be very fast compare to the disk. The SSD disks which gives you the benefit of high speed disks , the same […] Here is the nice script for finding the row lock (hoping you will find the locked objects easily) select do.object_name , row_wait_obj# , row_wait_file# , row_wait_block# , row_wait_row# , dbms_rowid.rowid_create (1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW#) from v$session s , dba_objects do where sid=&sid and s.ROW_WAIT_OBJ# = o.OBJECT_ID ; select * from tablename where rowid=”; […] When transactions hit the database. Each transaction will be allocated one UNDO segment. The transaction will look for extents in the UNDO segment to place UNDO data. It will pick up segments as follows – (1) Pick up an UNDO segment, which has no ACTIVE extent, if none allocate a new segment. If space does […] Perhaps, you are also one of like me, difficult to understand about Oracle Licensing strategy with respect to CPU and Cores. You will need to know about two types for a processor based licensing, 1) Is your host/server is non-virtual based The Processor license for the Oracle Enterprise Edition is based on the number of […] One of my colleague struggling from two days for a Oracle client 11g 64 bit installation, where he is expecting a lib32 folder in Oracle_HOME as usual but he didn’t. Thanks to him first for sharing before to proceed further. He didn’t succeeded to get lib32 folder instead he found this note, which may save […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!