(Arup Nanda) Frustrated by trying to allocate the precise amount of memory required for different pools? Automatic Shared Memory Management makes it possible to allocate memory where it’s needed most, automatically.
Tag: Oracle
Get Unique from Duplicates
(Yakov Shlafman) This script shows how to extract unique “valid” accounts from a group of duplicates using Oracle’s analytical function ROW_NUMBER().
Oracle Tip: The end of rule-based optimization in Oracle 10g
More than a decade ago, all Oracle databases used what is now called rule-based optimization, which uses a fixed strategy to optimize a query’s results. (R)
Vulnerabilities found in E-Business Suite 11i
(Robert Westervelt) Multiple SQL injection vulnerabilities have been discovered in the Oracle E-Business Suite 11i and Oracle Applications 11.0 that could allow an attacker to take control of the database and applications. (R)
Oracle’s explain plan
Whenever you read or write data in Oracle, you do so by issuing an SQL Statement. One of Oracle’s task when it receives such a statement is to build a statement execution plan. An execution plan defines how Oracle finds or writes the data. For example, an important decision that Oracle has to take i
JDeveloper 10g Is For PL/SQL Developers Too!
You’ve probably noticed by now that JDeveloper 10g Production has now been released on OTN. Congratulations to Brian Duff, Steve Muench, Shay Shmeltzer, Gerard Davison and all other others in the JDeveloper product team who worked on this release. Steve Muench wrote a couple of articles recently
Oracle Tip: Use the CSSCAN utility before character set migration
Oracle DBAs may try to import a full database export–only to get warnings about character set incompatibilities. This problem is compounded because the default database character set is ASCII, yet the recommended character set for international databases is one of the Unicode character sets, such a
Mass Software Deployment with Oracle 10g
(Sudip Datta) Why should DBAs and IT managers care about improving deployment management? Datta: If you were to define deployment in terms of the full software lifecycle, it would include things such as installation, patching, cloning, software configuration, compliance tracking—such as tracking
Use Location Information in Enterprise Reporting
(Justin Lokitz and Madeline Alameda) Location information is everywhere; it can be found across all lines of business, all industries, and in virtually every organization and department in the world. However, most organizations regard location information in one of only two ways: –Location as a
Oracle Service Manager
(Rob Kayman) My goal is to create a Microsoft Windows utility to watch and administer, in a simple manner, Oracle Windows services on local and remote machines. The baseline operation of the utility mirrors the Service Manager that ships with Microsoft SQL Server 2000. I used Visual Studio .NET 2003