There are many reasons to deploy Oracle on Linux. The more important ones are the flexibility and non-proprietary characteristics of Linux. But the key advantage is that the entire server side code stack from the OS to the application layer is supported by Oracle. Using the best practices Oracle has
Tag: Oracle
AppsWorld: Oracle pushes on integration, customer advocacy
(Marc L. Songini) Having slipped from the No. 2 slot in the business applications market to No. 3, Oracle Corp. is taking pains to boost market share. At its AppsWorld 2004 user conference here, officials from the software maker touted the company’s various initiatives, which include boosting in
Oracle on Windows
(Steve Callan) Microsoft takes a beating at times from frustrated users of its own products and from users of third party products hosted on Windows. When it comes to using Oracle on Windows, it seems that a frequently appearing solution to problems is to reboot the PC. In reality, rebooting is nece
Using Oracle’s Time Zone Feature
(James F. Koopmann) A few articles back I wrote on a comparison between the DATE datatype and the TIMESTAMP datatype. This article goes one step further and explores Oracle’s TIME ZONE feature of the TIMESTAMP datatype. In particular, Oracle has added the "WITH TIME ZONE" and the "WITH LOCAL TIME ZO
Oracle Net Configurations: Find the Weak Link
(Shirish Joshi) Performance and connection are the main issues developers and testers face when deploying Oracle applications. Most of the connection issues can be traced to how the Oracle Net Services and its related components are configured. According to the Oracle Manual, Oracle Net Services
List Table Names, Rows, and Created Date
(Pasupuleti Sailaja) This script will display table names, number of rows existed in table and table created date in current login user for any ORACLE version. (script)
Oracle Optimizer: Moving to and working with CBO – Part 7
(Amar Kumar Padhi) In the final installment of this series, we will cover the basics of using Stored Outlines and Oracle Application specific information.
Log4plsql: Open-Source Tool for PL/SQL Logging
(Guillaume Moulard) The implementation of logs is a significant element in development strategy: exhaustive yet concise logs are required to enable code debugging and the tracing of functional events. At the same time, however, in this era of diminishing resources it is necessary to minimize the wor
Safety in Numbers
(Shari Caudron) Every hour of every day, in countries all around the world, people work in hazardous environments. They dive deep below the surface of the ocean on salvage expeditions. They descend into mines, clean toxic waste, and fight fires—or try to prevent them. These people know their jobs ar
Cloning a Oracle Database
Cloning a database means creating an identical copy of a database, either on the same machine as the original, or on a different one. Additonally, it means changing the database name, and the Instance name. But those are both optional steps if the clone is being created on a different machine. Ev
