�ݺ�ߣshows by User: omnibug

�ݺ�ߣshows by User: omnibug / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: omnibug / Wed, 23 Jul 2014 21:54:07 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: omnibug Oracle plsql code refactoring - from anonymous block to stored procedure /omnibug/oracle-plsql-code-refactoring-from-anonymous-block-to-stored-procedure oracleplsqlcoderefactoring-fromanonymousblocktoprocedurepublic-140723215407-phpapp01
How to move your Oracle PL/SQL code from an anonymous block in a file to a database stored object. In a simple procedure you achieve huge gains in security, performance, object reuse, and more. With a small enhancement comes a great financial cost reduction and productivity increase.]]>
How to move your Oracle PL/SQL code from an anonymous block in a file to a database stored object. In a simple procedure you achieve huge gains in security, performance, object reuse, and more. With a small enhancement comes a great financial cost reduction and productivity increase.]]> Wed, 23 Jul 2014 21:54:07 GMT /omnibug/oracle-plsql-code-refactoring-from-anonymous-block-to-stored-procedure omnibug@slideshare.net(omnibug) Oracle plsql code refactoring - from anonymous block to stored procedure omnibug How to move your Oracle PL/SQL code from an anonymous block in a file to a database stored object. In a simple procedure you achieve huge gains in security, performance, object reuse, and more. With a small enhancement comes a great financial cost reduction and productivity increase. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracleplsqlcoderefactoring-fromanonymousblocktoprocedurepublic-140723215407-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> How to move your Oracle PL/SQL code from an anonymous block in a file to a database stored object. In a simple procedure you achieve huge gains in security, performance, object reuse, and more. With a small enhancement comes a great financial cost reduction and productivity increase.

Oracle plsql code refactoring - from anonymous block to stored procedure from Carlos Oliveira

]]> 1335 5 https://cdn.slidesharecdn.com/ss_thumbnails/oracleplsqlcoderefactoring-fromanonymousblocktoprocedurepublic-140723215407-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Oracle foreign key missing index - a single index can boost performance /slideshow/oracle-foreign-key-missing-index-a-single-index-can-boost-performance/36969892 oracleforeignkeymissingindexpublic-140714154045-phpapp01
In Oracle databases, a foreign key does not require that the column being restricted should have an index. Update and Delete operations on referenced tables may have a heavy impact in performance, overloading the server. A single index can reduce the cost of these DML operations.]]>
In Oracle databases, a foreign key does not require that the column being restricted should have an index. Update and Delete operations on referenced tables may have a heavy impact in performance, overloading the server. A single index can reduce the cost of these DML operations.]]> Mon, 14 Jul 2014 15:40:45 GMT /slideshow/oracle-foreign-key-missing-index-a-single-index-can-boost-performance/36969892 omnibug@slideshare.net(omnibug) Oracle foreign key missing index - a single index can boost performance omnibug In Oracle databases, a foreign key does not require that the column being restricted should have an index. Update and Delete operations on referenced tables may have a heavy impact in performance, overloading the server. A single index can reduce the cost of these DML operations. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracleforeignkeymissingindexpublic-140714154045-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> In Oracle databases, a foreign key does not require that the column being restricted should have an index. Update and Delete operations on referenced tables may have a heavy impact in performance, overloading the server. A single index can reduce the cost of these DML operations.

Oracle foreign key missing index - a single index can boost performance from Carlos Oliveira

]]> 657 2 https://cdn.slidesharecdn.com/ss_thumbnails/oracleforeignkeymissingindexpublic-140714154045-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Oracle performance project public /slideshow/oracle-performance-project-public/27133508 oracleperformanceprojectpublic-131012180422-phpapp02
]]>
]]> Sat, 12 Oct 2013 18:04:22 GMT /slideshow/oracle-performance-project-public/27133508 omnibug@slideshare.net(omnibug) Oracle performance project public omnibug <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/oracleperformanceprojectpublic-131012180422-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" />

Oracle performance project public from Carlos Oliveira

]]> 386 2 https://cdn.slidesharecdn.com/ss_thumbnails/oracleperformanceprojectpublic-131012180422-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 ITIL Foundation V3 /slideshow/itil-foundation-public/21176378 itilfoundationpublic-130514143307-phpapp02
Follows a series of flashcards I produced to study for the ITIL FOUNDATION V3 certification exam. ]]>
Follows a series of flashcards I produced to study for the ITIL FOUNDATION V3 certification exam. ]]> Tue, 14 May 2013 14:33:06 GMT /slideshow/itil-foundation-public/21176378 omnibug@slideshare.net(omnibug) ITIL Foundation V3 omnibug Follows a series of flashcards I produced to study for the ITIL FOUNDATION V3 certification exam. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/itilfoundationpublic-130514143307-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> Follows a series of flashcards I produced to study for the ITIL FOUNDATION V3 certification exam.

ITIL Foundation V3 from Carlos Oliveira

]]> 1848 4 https://cdn.slidesharecdn.com/ss_thumbnails/itilfoundationpublic-130514143307-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Sql and PL/SQL Best Practices I /omnibug/sql-and-plsql-best-practices-i sqlandplsqlbestpracticesipublic-120718074639-phpapp02
In this first of a series of presentations, we'll overview the differences between SQL and PL/SQL, and the first steps in optimization, as understanding RULE vs. COST, and how to slash 90% response time in data extractions running in SQL*Plus.]]>
In this first of a series of presentations, we'll overview the differences between SQL and PL/SQL, and the first steps in optimization, as understanding RULE vs. COST, and how to slash 90% response time in data extractions running in SQL*Plus.]]> Wed, 18 Jul 2012 07:46:37 GMT /omnibug/sql-and-plsql-best-practices-i omnibug@slideshare.net(omnibug) Sql and PL/SQL Best Practices I omnibug In this first of a series of presentations, we'll overview the differences between SQL and PL/SQL, and the first steps in optimization, as understanding RULE vs. COST, and how to slash 90% response time in data extractions running in SQL*Plus. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlandplsqlbestpracticesipublic-120718074639-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> In this first of a series of presentations, we'll overview the differences between SQL and PL/SQL, and the first steps in optimization, as understanding RULE vs. COST, and how to slash 90% response time in data extractions running in SQL*Plus.

Sql and PL/SQL Best Practices I from Carlos Oliveira

]]> 2300 2 https://cdn.slidesharecdn.com/ss_thumbnails/sqlandplsqlbestpracticesipublic-120718074639-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-omnibug-48x48.jpg?cb=1527796966 From Oracle from 7 to 11g and Postgres. Design new data models. Install and build new databases. Maintain databases (backup/recovery, crash recovery, datafile management, parametrization, etc.) Performance tuning (identification and resolution of performance problems, both in database and application layers). Training on database administration and performance tuning. https://cdn.slidesharecdn.com/ss_thumbnails/oracleplsqlcoderefactoring-fromanonymousblocktoprocedurepublic-140723215407-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds omnibug/oracle-plsql-code-refactoring-from-anonymous-block-to-stored-procedure Oracle plsql code refa... https://cdn.slidesharecdn.com/ss_thumbnails/oracleforeignkeymissingindexpublic-140714154045-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/oracle-foreign-key-missing-index-a-single-index-can-boost-performance/36969892 Oracle foreign key mis... https://cdn.slidesharecdn.com/ss_thumbnails/oracleperformanceprojectpublic-131012180422-phpapp02-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/oracle-performance-project-public/27133508 Oracle performance pro...