(Torsten Winterberg and Stefan Scheidt) Oracle JDeveloper has gone through an amazing evolution over the past few years. While older versions were a little bumpy at times, Oracle JDeveloper 10g offers an integrated development environment with substantial features—including modeling, coding, debuggi
Tag: Oracle
Oracle9i Analytic SQL Features, Part 3
(Brad Cowdrey) This article will take an in depth look at the GROUPING SETS and composite columns through examples including syntax and behavior. In addition, this article will build on the information and examples from the previous articles in the series. All of the examples run off of a base t
Availability and Recovery with Oracle
Oracle Database 10g comes with a number of new features such as new features in flashback, Data Guard and transaction recovery monitoring. Also covered here are RMAN improvements and general database recovery improvements.
Oracle Overhauls Analyzer Engine
(Jim Wagner) Oracle officials took the wraps off software formerly known as Sales Analyzer and Financial Analyzer, giving it a new database engine and name. Oracle Enterprise Planning and Budgeting (EPB) fills a gap in the Redwood Shores, Calif., company’s ERP software suite, providing real-time
Monitoring Oracle processes in Windows NT
(Ravinder Bhalla) It’s much easier to monitor CPU usage in a Unix environment for each individual Oracle process (i.e., PMON, SMON, DBWR) as compared to NT. In NT, there is only a single process (i.e., oracle.exe). In order to get the status of individual threads of Oracle processs in a Windows envi
Taking Abstraction One Step Further
(James Holmes) One of the hottest new concepts in programming today is aspect-oriented programming (AOP). Once used primarily in academia and research-and-development organizations, AOP today is making inroads into mainstream development. Using AOP is an evolutionary way of developing software that
Five things to unlearn about Oracle
(Bob Watkins) As I continue to teach Oracle 9i, I find more database administrators (DBAs) running current versions of the software but still living within the limitations of older versions. Here are five more things that it’s time to unlearn about the Oracle database.
PeopleSoft technology could boost Oracle’s ailing apps biz
(Robert Westervelt) Oracle Corp.’s desire to snatch up rival PeopleSoft Inc. could give Oracle application users the attention they have been craving. (R)
Oracle 10g’s Undo Advisor
(James Koopmann) As a DBA, you are always faced with the critical question of whether the undo that you have created is in fact sufficient for the transaction mix on your database system. Oracle has now given us an Undo Advisor in Oracle 10g to help simplify the answer.
Architecture (Sample chapter)
(Rick Greenwald, Robert Stackowiak and Donald Bales) If you understand the architecture of Oracle Application Server, you will have an excellent framework for understanding how the product works. Learning how the various components of Oracle Application Server interact can help you avoid many p
