Reducing cluster waits by Granville Bonyata
If you’re seeing high cluster waits because you have multiple processes all inserting into the same set of tables, the cluster waits are resolved by pointing to a single node on the cluster. But just pointing to a single node defeats the rollover benefits of running on RAC. To that end, Oracle gives us Services … Read more
Dbms_xplan by Granville Bonyata
I am extremly busy these days and do not have any time to blog.That’s why my friend Granville Bonyate decided to write few small posts.Here is the first on in series. Having worked with Oracle for many (twenty!) years, I sometimes find new features released several years ago that I didn’t catch at the … Read more
Resolving Oracle specific errors ( ORA-01031, ORA-00942 etc.)
I lost a count how many times I run into ORA-01031 error .Since I am the one executing the query I can see which SQL statement I am running and then focus on specific objects to find missing privilages. It gets more difficult when end-user get this error.Thanks to Oracle events this is easy to resolve. … Read more
Disabling Oracle Streams Propagation when nothing else works
It’s been a while since I wrote any post .. I need vacation too Here is very short one but useful tip for folks that are using Oracle Streams. I know everyone is talking about GoldenGate but trust me Oracle Streams are good solution if you do not have budget for GoldenGate.Oracle is working very hard … Read more
Export / Import data over db link – using dbms_datapump and dbms_file_transfer packages
– Datapump FULL MODE EXPORT – DECLARE h1 NUMBER; — data pump job handle job_state VARCHAR2(30); — job state status ku$_Status; — data pump status job_not_exist exception; pragma exception_init(job_not_exist, -31626); BEGIN h1 := dbms_datapump.open(operation=>’EXPORT’,job_mode=>’FULL’, remote_link=>”, job_name=>NULL, version=>’COMPATIBLE’); dbms_datapump.add_file( handle=>h1, filename=>’test.dmp’, directory=>’DPUMP_DIR’, filetype=>dbms_datapump.ku$_file_type_dump_file); dbms_datapump.add_file( handle=>h1, filename=>’test.log’, directory=>’DPUMP_DIR’, filetype=>dbms_datapump.ku$_file_type_log_file); dbms_datapump.start_job(h1); job_state := ‘UNDEFINED’; BEGIN WHILE (job_state != … Read more
Visitors to this site
