Mini data generator

Will Hitchcock proposed a PL/SQL approach for generating the 1000 rows:

declare
i number := 1;
begin
for i in 0..999 loop
insert into pivot values (i);
end loop;
end;
/

Oracle Menu (om) is only a shell script.

Oracle Menu is only a shell script.

What does it do?
It just helps with often performed tasks and navigating around the file system and can give you useful information quickly.
It can help you perform some of the more monotonous tasks a DBA has to perform without having to know too much.
It can help you if you work between many sites often as it can hide some of the underlying differences, such as filesystem layout etc.

Drupal + Oracle: Inside the OraDrup Project

In this case study, it is described the OraDrup Project, which has the goal of combining the popular open-source Drupal CMS with Oracle Database.

Link 1
Link 2

Oracle RAC 10g on Oracle Enterprise Linux Using VMware Server

In this guide, you will learn how to install and configure two nodes on running Oracle RAC 10g Release 2 on Enterprise Linux and VMware Server. Note that this guide is intended for educational/evaluation purposes only; neither Oracle nor any other vendor will support this configuration.

How to stop Oracle XE from starting up with your computer

Eddie Awad blogs about "How to Give Your System a Break from Oracle XE".
---
There was a question on OraQA about how to stop Oracle XE from starting up with your computer. When you install Oracle XE on Windows, it creates a service called ?OracleServiceXE? with a startup type of ?Automatic? which means that the service starts automatically when the computer boots.

One way to prevent Oracle XE from starting up automatically is to change the startup type of the Oracle service to ?Manual?. You can do that by navigating to your Control Panel -> Administrative Tools -> Services, double click on the Oracle service and change the Startup type to Manual.

Another way to prevent Oracle XE from starting up automatically when Windows starts is to use the ORADIM command-line tool that is available with the Oracle database. From the DOS command line execute the following:

oradim -edit -sid XE -startmode manual

Now, when you want to use Oracle XE, you start it up like this:

oradim -startup -sid XE

And you shut it down like this:

oradim -shutdown -sid XE

Or you can use the ?Start Database? and ?Stop Database? shortcuts installed with Oracle XE. Navigate to Start -> All Programs -> Oracle Database 10g Express Edition ->Start/Stop Database

Now you know how you can squeeze out a bit of extra performance from your computer when you are not using Oracle XE :)

Sources and Resources:
- Eddie Awad's Blog
- ORADIM documentation
- Related AskTom thread

Integrigy Oracle Listener Security Check Tool Updated (v. 2.2)

AppSentry Listener Security Check is a tool to check the security configuration of the Oracle Database Listener and listeners for Oracle Applications 11i. Four checks are performed:
1. is a password set,
2. is logging enabled,
3. is ADMIN_RESTRICTIONS enabled, and
4. is LOCAL_OS_AUTHENTICATION set for Oracle 10g.

Download lsnrcheck.exe (754KB)

Leverage your Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows

If you're a database specialist interested in growing your DB2 skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. Recently updated for the latest versions of DB2 and Oracle, this article shows you how to use your current knowledge of Oracle 10g to quickly gain skills in IBM DB2 9 for Linux, UNIX, and Windows.

Link

Ruby on Rails with Oracle FAQ

Exploring Ruby on Rails (RoR)?
This FAQ provides basic information about connecting to Oracle, installation, and creating Oracle Database XE + RoR applications.
Link

Oracle built-in functions

A nice matrix of Oracle built-in functions

Install the Oracle DBA Toolbar

The Oracle DBA Toolbar (available for Internet Explorer only at the moment; a Mozilla/Firefox version is forthcoming) gives you one-click access to key DBA resources on OTN.

Features:
* Pop-up Blocker
* Integrated RSS Manager
* OTN Search
* One-click access to SQL*Plus install, Downloads, MetaLink, and more
* Online Support FAQ
Oracle DBA Toolbar