Free Newsletters:
Database Journal  
DBAnews  

DBASupport

 The Knowledge Center for Oracle Professionals

Search DBAsupport:
 
HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Technical Docs Tools & Utilities Forums
internet.com


» HOME
» FEATURES
    11g Central
    10g Central
    9i Central
    8i Central
    Oracle News
» COMMUNITY
    Scripts
    Forums
    FAQ
    OCP Zone
» RESOURCES
    Resources
    Technical Docs
    Tools & Utilities
    Tech Jobs


internet.commerce
Be a Commerce Partner
Corporate Gifts
Compare Prices
Find Software
Dental Insurance
Televisions
Imprinted Gifts
Compare Prices
Promotional Items
Web Hosting Directory
Imprinted Promotions


internet.com
Internet News
Internet Investing
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ECommerce/ Marketing
ISP Resources
ASP Resources
Wireless Internet
Downloads
Internet Resources
Internet Lists
International
EarthWeb
Career Resources

Search internet.com
Advertise
Corporate Info
Newsletters
E-mail Offers



 

Senior Software Engineer
Thomson
US-MA-Boston

Systems Administrator
Care.com
US-MA-Waltham

Test Analyst / Tester
Professional Technical Resources
US-OR-Portland


Speed Up Your Code and Save Time Doing It!
Sponsored by AMD
Newest release of AMD CodeAnalystTM Performance Analyzer integrates into Microsoft® Visual® Studio, so you can gain deeper insight into your code's performance at the click of a mouse. This new integration makes it even easier to explore "what if?" scenarios so that you can get the fastest code out in record time. Download CodeAnalyst now! Click here.
Learn more at AMD Developer Central.

Featured Solutions for Technology Professionals from Internet.com
PDF: Storage Is Changing Fast--Are You Ready?
Sponsored by HP
The storage landscape is headed for dramatic change, thanks to new technologies like Fibre Channel over Ethernet (FCoE), pNFS, object-based storage and SAS that will affect everything from NAS and SANs to disk drives. Get the knowledge you need to make the most of your storage environment, now and in the future. >>

Featured Solutions for Technology Professionals from Internet.com
Whitepaper: Storage Management Costs in the Enterprise
Sponsored by HP
This report should be read by anyone responsible for choosing storage solutions for their organizations or for making administrative personnel decisions in the data center. Many factors contribute to the ownership cost for enterprise storage. Get the comparison of Mid-Range Array Solutions here. Learn more.

Whitepaper: Virtualization from the Data Center to the Desktop. Meet evolving demands more effectively as you transform your IT infrastructure from a cost center to a strategic business asset.




DBASupport Oracle Database 11g: Database Replay, Part 3
The final article in this series illustrates how to use Oracle Database 11gR1's new Database Replay (DBR) features to capture and prepare a workload from a current Oracle 10gR2 single-instance database environment and then replay that identical workload in an Oracle 11gR1 Real Application Clusters (RAC) testing environment.

Product Review Toad Data Modeler 3
Quest Software has hit the ball out of the park with its Toad Data Modeler 3 (TDM) application. Ease of use, a huge amount of functionality, and an outstanding support base all combine to make TDM a superb product. Read on to learn more...

Oracle Automatic Storage Management
ASM provides many benefits, but also requires learning new concepts, commands, utilities, and administration tasks. Sean Hull examines what ASM solves, and what it takes to manage and weigh the pros and cons.

Oracle Applications Reference Books
Aside from Oracle's own documentation covering Oracle Apps and a few books covering specific modules, the published books landscape regarding EBS is fairly barren. There are two notable generalist coverage books available that can help you get a good jump on learning Oracle Applications.

Oracle Database 11g Common Background Processes
To understand Oracle background processes is to understand how Oracle works--offering opportunity to tune effectively. Learn about the processes that are typically running after a fresh, common, and basic installation.

Oracle Database 11g: Database Replay, Part 2
Part 2 of this series - demonstrates how Oracle 11g Database Replay can be used to capture and prepare a workload from a current Oracle 11g production database environment (P+0) and then replay that identical workload in an Oracle 11g testing environment that represents the next iteration (P+1) of the database system.

Oracle DBA in an Oracle Applications World Part 2
Steve Callan presents a simple but effective means of replicating your production environment for the first time on a new machine.

Oracle 10g Cloning Guide: A Small County Government Approach
This document offers one approach to database refreshes for Oracle 10g databases on Windows 32 and 64 bit servers.

Oracle Warehouse Builder Automated ETL Processing
Steve Callan offers a high level overview of what it takes to automate a load, covering each and every project item you need to address for this to work.

Multi Table Loop
This article examines how to loop through multiple tables to process the data.

Programming, Perl + Oracle
Perl is a powerful scripting language that can meet your day-to-day scripting needs as a database administrator, and if used prudently, and responsibly, as a language to build large web-based applications. Here's a quick introduction to using Perl with Oracle.

Create your own reports with Oracles Snapshot Information
If you are tired of running the same old Oracle AWR reports, not getting to the data quickly, or just need to write your own, then this article will get you started.

Oracle Database 11g: Database Replay, Part 1
This article provides a primer for using Oracle 11g Database Replay to effectively predict the performance of rapidly changing applications within increasingly fluid database environments.

Oracle DBA in an Oracle Applications World
Steve Callan takes a look at what is behind the smoke, mirrors, and curtains of Oracle Applications.

Oracle Indexing - What, Where, When?
If you are new to databases, or perhaps new to Oracle, you may find the discussion on indexes and indexing strategy complicated. Don't fret. To get started it's fairly straightforward, and as long as you pay attention to the options relevant to day-to-day DBA needs, it should remain fairly simple.

» More Features...

Receive articles via our XML/RSS feed




DBASupport News Sybase-to-Oracle Migration Accelerated By ANTs Software
ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracles current Sybase Safe Switch Program...Sybase-to-Oracle Migration Accelerated By ANTs Software...

Oracle Updates Entire Family of Oracle Berkeley DB Embeddable Databases
Oracle announces new releases of Oracle Berkeley DB, Oracle Berkeley DB XML and Oracle Berkeley DB Java Edition.

Oracle Still Top Dog in Tough Database Market
The leading database vendor retained strong market share in 2007, but faces increasing competition from low-cost, open source alternatives.

Cache Payback
Oracle Data Provider for .NET (ODP.NET) enables you to take advantage of features exposed by the underlying Oracle Call Interface. One such feature new in Oracle Database 11g Release 1 and Oracle Database 11g Release 1 Client is the client result cache.

HP Blade Latest to Run Oracle Warehouse
Gestation period's over for the newest business intelligence product on the block.

Accelerating Data Warehouses
Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g.

Oracle Buys Skywire Software
Oracle today announced that it has agreed to acquire Skywire Software's application software business.

What will Oracle's price hikes mean for Oracle customers?
Oracle's decision to raise its list prices by 15% to 20% is cause for concern for both existing and prospective customers. But there are opportunities to offset those hikes, according to industry analysts.

Confio adds Oracle Explain Plans to DB monitoring
Confio Ignite for Oracle adds Top Plans and Top Objects to Database Monitoring Dimensions.

Oracle sets middleware lineup following BEA deal
Six weeks after closing its buyout of BEA Systems Inc., Oracle has prioritized its middleware lineup.

Making Database Connections
Connect to Oracle and third-party databases from Oracle SQL Developer.

Explore Oracle 10g's updated sample schemas
Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature.

Integrating Oracle's Hyperion Essbase - System 9 with Oracle Business Intelligence
A step-by-step guide to using Oracle's Hyperion Essbase System 9 as a back end for Oracle Business Intelligence Suite Enterprise Edition. From Oracle ACE Director Mark Rittman.

Enterprise 2.0: Oracle Plans New Business Apps, With A Social Twist
The forthcoming apps from Oracle mirror the look and feel of Web 2.0 social networking services -- including MySpace and Facebook.

Oracle Unveils Oracle Demand Signal Repository
Oracle Demand Signal Repository captures, cleanses and harmonizes large volumes of external demand data to give users insight to consumer and supply chain behavior.

» More News...

Receive news via our XML/RSS feed




Hierarchial Loop III
This script displays all of the employees working under a particular employee in a string, separated by a '|' as delimiter. To achieve this I created a function and then used the function to display all the employees working under a particular employee (Top down hierarchial traversal).

Backup in Noarchivelog in RMAN
This script will backup in noarchivelog using RMAN.

Measure the Buffercache Hit Ratio for User Wise
This script allows you to see the bufferhit ratio of all application users, when all application users are running on the server, so that you can measure individual performance.

Check Free Shared Pool and Flush
This script checks the free space in the shared pool and when the size is very small executes an alter system flush shared pool.

Hierarchial Loop II
This script displays all of the employees in SCOTT.EMP table, with all of the bosses they report to, in a hierarchial loop, along with their level in the hierarchy.

» More Scripts...



Latest Database Articles from DevX
Build a Generic Histogram Generator for SQL Server
Use UNION ALL Instead of UNION
Persisting Data in Your Windows Mobile Device
Generating Reports and Statistics in PHP
Leveraging Silverlight 2 with SQL Server and XML


Database Administration Forum Latest Forum Threads
Topic By Replies Updated
  How to free up memory? reeshe 4 July 4th, 12:59 AM
  ORA-14450: attempt to access a transactional temp table already in use areeb 2 July 4th, 12:50 AM
  RMAN - removing old catalog entries KenEwald 11 July 3rd, 02:28 PM
  RMAN - advisable maintenance? KenEwald 2 July 3rd, 02:27 PM


Database Development Forum Latest Forum Threads
Topic By Replies Updated
  Describing Tables in PLSQL Que 1 July 4th, 08:42 AM
  WeekNumber to start of week date hrishy 7 July 4th, 08:37 AM
  query required ahmsha1 3 July 3rd, 12:35 PM
  Conversion Of Rows Into Columns ru_lother 2 July 3rd, 12:30 PM







JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Solutions
Whitepapers and eBooks
IBM eBook: Planning a Service Oriented Architecture
IBM eBook: Choosing the Right Architecture--What It Means for You and Your Business
Microsoft Article: Will Hyper-V Make VMware This Decade's Netscape?
Avaya Article: Using Intelligent Presence to Create Smarter Business Applications
Intel Go Parallel Article: Getting Started with TBB on Windows
Microsoft Article: 7.0, Microsoft's Lucky Version?
Avaya Article: How to Feed Data into the Avaya Event Processor
IBM Article: Developing a Software Policy for Your Organization
Microsoft Article: Managing Virtual Machines with Microsoft System Center
Intel Go Parallel Article: Intel Threading Tools and OpenMP
HP eBook: Storage Networking , Part 1
Microsoft Article: Solving Data Center Complexity with Microsoft System Center Configuration Manager 2007
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
HP Video: StorageWorks EVA4400 and Oracle
HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind
Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Red Gate Download: SQL Toolbelt and free High-Performance SQL Code eBook
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
Silverlight 2 App and Walkthrough: Leverage Silverlight 2 with SQL Server and XML
IBM Article: Enterprise Search--Do You Know What's Out There?
HP Demo: StorageWorks EVA4400
Microsoft Article: The Progress and Promise of Deep Zoom
Microsoft How-to Article: Get Going with Silverlight and Windows Live
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES