By Shishir Dani – Almost all Oracle DBAs need to continually check the status of various tablespaces in the database. Here is a SQL script that will generate a bar graph showing the status of tablespaces in the database.
Tag: Oracle
Ellison Tells OracleWorld: Spend Less
By John Taschek – Larry Ellison, part-time Oracle Corp. captain and full-time sailor, closed out the OracleWorld show here on Thursday by pointing out all the problems with the high-tech industry. Ever the salesman, as well as sailor, the Oracle chairman and CEO also said that Oracle has all the ans
Oracle’s message to Exchange customers: Switch!
By Margie Semilof – From a technology standpoint, Oracle Corp.’s messaging and collaboration platform may be better than those offered by competitors. It may be less pricey too.
Sending E-mails from Oracle Database
In his first article for DatabaseJournal, Amar Kumar Padhi details how to take advantage of an e-mail server option in Oracle 8i that allows you to send mail from within your code.
Form Builder 5.0
Book by Stephen Edelstein – Sample Chapter 8: LibrariesPrevious versions of Oracle’s Forms Designer tools, SQL*Forms and Oracle Forms, had two ways of sharing procedural code with multiple applications:User Exits let designers write procedures in a programming language (C, COBOL, For
Get Sample Records
by Pulkit Mathur – Here is a tip to get sample records from a table. Suppose there are 100 records in a table and you want to see the 5th, 10th …95th, and the 100th record. Or the 1st, 3rd, 5th… record.
Oracle Submits New API Spec to the JCP
By Clint Boulton – To assuage the pain of software developers, Oracle Corp. Tuesday it said it has submitted a new Application Programming Interface (API) specification designed to facilitate the creation of extensions that are fully interoperable with any Java Integrated Development Environment (ID
Oracle readies grid engine
By Paul Krill and James Niccolai – LOOKING TO LEVERAGE growing interest in grid computing, Oracle will detail its grid strategy in a bid to position its technology as a foundation for distributed applications.
A pseudo-random number generator with a twist
(Richard Stucke) Here is a pseudo random number generator function that is simple to use and has the added capability of limiting the range of random numbers produced. There are times when you don’t want just any random number from 1 thru 9999; for example, you may want all the random number to be f
Wireless In An Uncertain World
With little fanfare, companies are continuing to develop practical wireless applications for the enterprise. Here’s how they’re using Oracle’s flexible XML-based development environment to do it.