Showing posts with label PL/SQL. Show all posts
Showing posts with label PL/SQL. Show all posts

Friday, May 19, 2017

Oracle SQL Developer Command Line (SQLcl)

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience,  all while also supporting your previously written SQL*Plus scripts


Monday, May 31, 2010

Oracle Edition Based Redefinition the end of a BIG BANG for application upgrades

When upgrading an application or implementing improvements on stored PL/SQL procedures rule is compiling of those objects needed. During this phase, the end users can not using the application, they must wait until the whole change in the application implemented is finished or otherwise unexpected behavior may occur. In Oracle 11g Release 2 this problem is solved by usubg editions. With editions it is now possible to do live deployments of the new code to compile, whitehout users have to wait for implementing the changes. This is the end of a 'BIG BANG' at application upgrades. It is even possible to have multiple application versions operational.

In this blog i will descibe the mechanism of the Edition Based Redefinition.


Friday, December 18, 2009

DBMS_PROFILE: Overview what can be done to tune the PL/SQL APPLICATIONS

DBMS_PROFILE

The profiler provides us with a source code tuning for our PL/SQL applications. It is still a unknown feature for developers and DBA’s. In the past, you would tune your PL/SQL applications using SQL_TRACE and TKPROF or by using dbms_output. Well, you no longer have to do this. There is a DBMS_PROFILER package available as of oracle 8i version.