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.
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.
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.
Subscribe to:
Posts (Atom)