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
Memory Upgrades
Prepaid Phone Card
Cell Phones
Promos and Premiums
Televisions
Get Business Software
Laptops
Disney World Tickets
Imprinted Gifts
Online Universities


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



 

Enterprise Portal Architect
Professional Technical Resources
US-WA-Seattle

Enterprise Portal Architect
Professional Technical Resources
US-IL-Chicago

Enterprise Portal Architect
Professional Technical Resources
US-NY-New York


Featured in the eBook Library for Technology Professionals
Putting the Green into IT
Sponsored by HP
Electricity use in data centers is skyrocketing, sending energy bills through the roof, creating environmental concerns and generating negative publicity. "Going Green" means looking to technologies like virtualization, energy-efficient chips and racks, and implementing policies that extend beyond the data center. Learn more. Click here.

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
eBook: Storage Networking, Part 1
Sponsored by HP
A storage network is any network that's designed to transport block-level storage protocols. But understanding the ins and outs of networked storage takes you deep into several of protocols. This guide covers SANs, Fibre Channels, Disk Arrays, Fabric, and IP Storage. Learn more.

The HP StorageWorks family of products includes All-in-One and Disk-Based backup systems. Optimized file serving, shared storage array (iSCSI SAN) and data deduplication offer control and confidence.




DBASupport Oracle Reports for DBAs
As an Oracle DBA you might think that Oracle Reports have nothing to do with you, and you might be missing out on a simple means of generating reports to identify a source file, create an external table, write an SQL script and more.

Oracle: MOVE vs SHRINK Commands
This article discusses re-organizing a table using the move and shrink commands, then compares how the rows are compacted within Oracle blocks and how row chaining is resolved.

DBA Insider - Useful PL/SQL Packages
Oracle supplies quite a large complement of pl/sql stored procedures, packages, and functions, which can help with some of a DBA's day-to-day needs. This article looks at some of the useful ones that we can add to our DBA or Developer toolbox.

Hands-on Oracle: Backup and Recovery Games - Creating Datafiles
Learn how to recover from the loss of a datafile, when you don't have a backup of that file.

Looking at Memory Usage for Oracle Processes
When an Oracle instance starts, or an application uses the Oracle database, the associated Oracle processes are allocated and consume memory. Learn how to use the V$PROCESS view and V$PROCESS_MEMORY to look at this memory usage.

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.

» More Features...

Receive articles via our XML/RSS feed




DBASupport News Oracle Launches Oracle Access Management Suite
Oracle today unveiled Oracle(r) Access Management Suite, a comprehensive offering for next generation access management.

Oracle Counters SQL-Injection Holes With Update
There were an additional seven patches for PeopleSoft and J.D. Edwards applications, seven for the recently acquired BEA product suite, and six for Oracle E-Business Suite.

Oracle updates its enterprise performance management system, details Hyperion integration
Oracle unveils a number of enhancements to its enterprise performance management system and detailed its Hyperion integration efforts in a lengthy and wide-ranging Internet press conference.

Oracle WebLogic Apache Connector Lets Remote Users Execute Arbitrary Code
A vulnerability was reported in Oracle WebLogic in the Apache Connector. A remote user can execute arbitrary code on the target system.

Oracle Patches 45 Vulnerabilities
BEA joins the quarterly roundup of Oracle critical patch updates.

iDefense confirms the existence of three vulnerabilities in Oracle products
iDefense confirms the existence of two vulnerabilities in Oracle Corp.'s Oracle Database product and one vulnerability in Oracle Corp.'s Oracle Internet Directory.

Oracle expands application testing support
Oracle has expanded support for previous releases of Oracle Database to help organizations institute hardware and software changes, including upgrades to Oracle Database 11g.

Oracle still top dog in tough database market
However, open source offerings are nipping at its heels.

Oracle Critical Patch Update Pre-Release Announcement - July 2008
Oracle announces the pre-release of 45 security fixes.

Oracle Backports Real Application Testing to Speed Upgrades to Database 11g
Oracle officials hope extending support for the Real Application Testing feature to Oracle 10g and 9i Release 2 databases will help with the uptake of 11g.

On Exceptions and Rules
Best practices for where, when, and how to handle exceptions.

Oracle and Enterprise 2.0
Its a key part of the focus as the vendor outlines the integration roadmap around its acquisition of BEA.

nCipher to provide encryption key management for Oracle Database 11g
nCipher plc today announced its nShield and netHSM key management solutions are now integrated with Transparent Data Encryption...

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.

» 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
Using the New ListView Control in ASP.NET 3.5
Debugging SQL Server Stored Procedures Through Visual Studio.NET
Turn Off Auto-Commit for Better Performance
The Baker's Dozen: 13 Tips for Building Database Web Applications Using ASP.NET 3.5, LINQ, and SQL Server 2005 Reporting Services
Build a Generic Histogram Generator for SQL Server


Database Administration Forum Latest Forum Threads
Topic By Replies Updated
  table partitions in oracle 10g mdvreddy 1 July 23rd, 11:30 AM
  RMAN nocatalog reeshe 13 July 23rd, 10:27 AM
  time_remaining ever increasing in v$session_longops gtcol 6 July 23rd, 08:38 AM
  Data Modeling Question Bob Just 17 July 23rd, 05:18 AM


Database Development Forum Latest Forum Threads
Topic By Replies Updated
  PLS-00302: component 'A' must be declared jyothsna1612 1 July 23rd, 01:55 PM
  2 rows become 1...... jay_l_a 6 July 23rd, 10:40 AM
  Query with subquery containing group clause doesn't return any rows - WHY ? amasny 0 July 23rd, 06:01 AM
  Oracle Trigger airnewhouse 5 July 21st, 12:42 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