ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: December 2014
http://ergemp.blogspot.com/2014_12_01_archive.html
Ergem PEKER 's Oracle Blog. Tuesday, December 9, 2014. Fetching Multiple Rows with EXECUTE IMMEDIATE. Execute immediate is very handy for executing dynamic SQL statements inside PLSQL block. It can accept IN and OUT parameters and can also return output values to PLSQL variables by into. Clause. But returning values can be tricky because of the multiple returning rows. For single row returns into. Clause works fine but for multiple rows, hitting the following exception is quite easy. Posted by Ergem Peker.
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: June 2013
http://ergemp.blogspot.com/2013_06_01_archive.html
Ergem PEKER 's Oracle Blog. Tuesday, June 11, 2013. Compressing LOB segments with securefiles. After moving the LOB column with the storage option of "SECUREFILE" and "MEDIUM COMPRESS" option the size of the LOB segment decreased to approx. 833Mb. More than 1/25 compression which is as valuable as gold in this production database. Http:/ blog.trivadis.com/b/mathiaszarick/archive/2012/03/05/lob-compression-with-oracle-strange-multiple-physical-reads.aspx. Posted by Ergem Peker. Labels: 11g New Features.
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: July 2011
http://ergemp.blogspot.com/2011_07_01_archive.html
Ergem PEKER 's Oracle Blog. Tuesday, July 19, 2011. Hasty DBA's Most Probable Errors while testing TDE. Here I tested Oracle Transparent Data Encryption in 10gR2 (10.2.0.4) database which is installed on AIX 6.1 to see how it works and if there are some undocumented difficulty while using the technology. As i was too hasty and careless, i have seen most of the cheap errors. ORA-28368: cannot auto-create wallet. ORA-28336: cannot encrypt SYS owned objects. Solution: Do not test under SYS schema :). And th...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: Change Data Capture using Streams
http://ergemp.blogspot.com/2014/07/change-data-capture-using-streams.html
Ergem PEKER 's Oracle Blog. Monday, July 7, 2014. Change Data Capture using Streams. I found this dusty script from my old shelves which enables change data capture feature enabled in oracle database 11.2.0.4 enterprise edition running RHEL 6.2 64bit. Here, i will share how i enabled my oracle database change data capture feature. Begin - dbms capture adm.build; dbms capture adm.prepare table instantiation(table name = 'sch dmall.product'); end; /. If exists, first drop the change set exec dbms cdc publi...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: November 2010
http://ergemp.blogspot.com/2010_11_01_archive.html
Ergem PEKER 's Oracle Blog. Saturday, November 13, 2010. Basic Team Coding Extension for Oracle. Our development group is complaining about override each other 's codes by recompiling the same PLSQL program unit that is actively in development with any other developer. TOAD has builtin Team Coding functionality but there are developers not using TOAD in the development department. Without first declaring in which schema you want Team Coding should work everything works as they should be. First PCK TCODE ...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: February 2012
http://ergemp.blogspot.com/2012_02_01_archive.html
Ergem PEKER 's Oracle Blog. Tuesday, February 21, 2012. Which audit options should be enabled. For an Oracle Database is a smooth operation which needs a restart of the instance. But the real question comes after enabling the audit options: "Which audit options should we set? SELECT 'audit ' name ';' FROM system privilege map WHERE ( name LIKE 'CREATE%' or name LIKE 'ALTER%' or name LIKE 'DROP%' or name LIKE 'EXECUTE%' or name LIKE 'GRANT%' or name LIKE 'BACKUP%' or name LIKE 'EXPORT%' or name LIKE 'IMPO...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: December 2010
http://ergemp.blogspot.com/2010_12_01_archive.html
Ergem PEKER 's Oracle Blog. Thursday, December 30, 2010. Error in checking condition of instance on node. After rebooting both rac nodes srvctl started to complain about the condition of the second node of my cluster. Srvctl also complains when i was trying to start the instance on the second node. So i decided to start the instance manually by using sqlplus. It seems problem is solved. Posted by Ergem Peker. Tuesday, December 28, 2010. I have installed a one node RAC 10gR2 on RHEL5.5 for test purpos...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: September 2011
http://ergemp.blogspot.com/2011_09_01_archive.html
Ergem PEKER 's Oracle Blog. Monday, September 12, 2011. Random Data Generation and DBMS RANDOM. Generating random data itself is already a subject of its own. But here i can only write about the needs of random data in a database environment and how a database developer or administrator can generate the random data to fulfill his/her requirements. I personally used random data generation in three main purposes up to now. DBMS RANDOM.VALUE(arg1 number, arg2 number). Returns a random value between the supp...
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: September 2013
http://ergemp.blogspot.com/2013_09_01_archive.html
Ergem PEKER 's Oracle Blog. Friday, September 27, 2013. OOW Notes - ASM New Features on 12c. Thursday 12:30 - ASM New features. 1to1 ASM to server. 10years old in oracle database. Grid computing . cloud computing. More consolidation → more database instances per node. More clustering → more nodes in clusters. Maximize ASM robustness because increased number of database instances running on large servers. Minimize ASM overhead because of large clusters. Engineered systems (EXADATA and database appliance).
ergemp.blogspot.com
Ergem PEKER 's Oracle Blog: Fetching Multiple Rows with EXECUTE IMMEDIATE
http://ergemp.blogspot.com/2014/12/fetching-multiple-rows-with-execute.html
Ergem PEKER 's Oracle Blog. Tuesday, December 9, 2014. Fetching Multiple Rows with EXECUTE IMMEDIATE. Execute immediate is very handy for executing dynamic SQL statements inside PLSQL block. It can accept IN and OUT parameters and can also return output values to PLSQL variables by into. Clause. But returning values can be tricky because of the multiple returning rows. For single row returns into. Clause works fine but for multiple rows, hitting the following exception is quite easy. Posted by Ergem Peker.