»
Oracle Certification - The Last Word on OCP for Oracle8i
want to do and you have not started yet,
today is the day you need to start
studying--even if you are an old hand at Oracle.
»
Bulk Binds and Collects in PL/SQL - Part - 1
This article begins a discussion of how to work with collections. Previous versions of Oracle had limitations for collection usage in regards to SQL statement processing. Bulk Bind and Collect features were introduced to reduce the SQL processing overhead by efficient use of collections in PL/SQL code.
»
Striking Gold with LogMiner - Part 1: Getting Started
Oracle's LogMiner utility has been around for several years
now, and it originally appeared as a new feature (as opposed to being an
improvement of something else). The purpose of this series is to help demystify some of the
procedures, illustrate some examples of using LogMiner, and to recommend cases where
LogMiner should be a DBA's primary tool for recovering lost data.
»
Executing External Programs From Within Oracle
Finally, Oracle 10g has given us the ability to execute
external programs from within Oracle. James Koopmann takes a look at what needs to be done
to expose this new feature.
»
Creating NOT NULL Columns in Huge Oracle Tables
Databases are often taxed by applying SQL statements to enormous
tables. One such activity is when we add a new NOT NULL column with default
value to a huge transaction table. Amar Padhi shares several methods to add a
new column with default value, comparing the advantages and disadvantages of each.
»
Oracle's Sample Schemas: Saying Goodbye to Scott
Did you know that Oracle's "Scott" schema is
slated for the bone yard? How many thousands of people have learned SQL,
SQL*Plus, and PL/SQL on the back of poor old Scott? Steve Callan introduces
the new 'crew'--HR, OE, PM, QS and SH.
»
Surviving a Database Disaster with RMAN Backups
Follow along with this real-world disaster scenario and learn how
one company recovered their databases using RMAN backups.
»
New Features in Oracle 10g for SQL*Plus and iSQL*Plus
Don't wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features!
»
Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT
To secure sensitive data, Oracle provides developers with the DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM package. You may feel the need of a decoder just to keep track of all the acronyms and to decrypt the errors in Oracle's sample code, but once you see how easy it is to use, you'll be able to take Oracle's code example and modify it for your own use.
»
Connecting with Oracle: Accessing Oracle via Access and Excel
Giving your users the ability to access an Oracle database using either Access or Excel is easy to do. It takes all of three minutes to set up the link or connection. Learn how in Connecting with Oracle, Part 4.
»
Generating random numbers and strings in Oracle
Generating random numbers or strings is oft-times a necessity. Oracle provides a random number generator that is faster than writing your won random generation logic in PL/SQL, and can generate both character and alphanumeric strings. Perhaps it is time to learn more about the DBMS_RANDOM package.
»
CASTing About For a Solution: Using CAST and Table Functions in PL/SQL
When an Oracle database suddenly becomes unavailable, the immediate reaction is to do something -- right now! -- to solve the problem, which sometimes makes the problem worse. This article discusses some examples of when it's really best to stop and think before proceeding.
»
A Practical Guide to Data Warehousing in Oracle, Part 6
Materialized Views are continually enhanced by Oracle to leverage data warehouse performance and maintainability. This is the first in a mini-series of articles that will introduce the concept, identify some of their uses and describe some potential problems with them.
»
Multiple Temporary Tablespaces in Oracle 10g
The creation and use of temporary tablespaces has just taken another leap in performance and manageability, which should make us all re-think how we have created and assigned our users to temporary tablespaces.
»
More Features...
»
.com Solutions Inc. releases FmPro Migrator 2.08 Enterprise Edition
:
.com Solutions Inc. releases FmPro Migrator 2.08 Enterprise Edition for MacOS X and Windows - New Release Adds FileMaker to Oracle 10g Migration Feature and Improvements to PostgreSQL Migrations.
»
Gates' eMail Discussed PeopleSoft Stake
:
Oracle's trial over its PeopleSoft acquisition reveals how rivals reacted to its potential impact on the enterprise software market.
»
ObjectFX Completes Oracle® 10g Platform Integration Requirements
:
SpatialFX® Users See Benefits From Ongoing Partnership with Oracle.
»
Ellison 'Green' with Envy
:
Analysts debate whether
Oracle is after SAP's high-end or Microsoft's mid-tier.
»
Quest Software Simplifies Database Code Optimization with V. 8.0 of Toad® for Oracle
:
Quest Software, Inc. (Nasdaq: QSFT), a leading provider of application, database and Windows management solutions, today announced version 8.0 of Toad® for Oracle. Version 8.0 of Toad for Oracle provides productivity and code quality enhancing features.
»
Oracle Keeps Microsoft Up at Night
:
The Justice Department is wrapping up its case to prevent Oracle from proceeding with its $7.7 billion takeover bid for PeopleSoft. By Michael Singer
»
Oracle SA gears up to wow techies with second annual Developer Day
:
Oracle South Africa has announced that the next developer and technologist orientated conference will take place on 27 July at Vodaworld in Midrand.
»
Acucorp and Oracle Ease Migration from Legacy Systems to Open Platforms
:
Acucorp ACUCOBOL-GT(r) Development System Certified for Oracle(r) Database 10g.
»
New Course Extends Learning Tree Oracle Curriculum - Oracle Database 10g Introduction: Hands-On
:
Learning Tree International announced today the addition of a new hands-on course, Oracle Database 10g Introduction, to its roster of Oracle-focused courses.
»
Lumigent Technologies Introduces Data Auditing Solution for Oracle
:
Entegra Helps Enterprises Reduce Risk from Data Use and Comply with Government Regulations.
»
Judge Rules Expert Witnesses Will Take the Stand
:
U.S. District Court Judge Vaughn Walker ruled against motions from the U.S. Department of Justice and Oracle Corp. to block expert witness testimony.
»
Oracle, DOJ Documents May Lose Seals
:
Legal maneuver by a federal judge could shift some enterprise software strategies.
»
Oracle trial judge wants more disclosure
:
He said too much material is being filed under seal in the DOJ vs. Oracle case.
»
Oracle Tip: Choosing an efficient design for Boolean column values
:
When designing a database table structure, it's important to choose an efficient strategy for storing a logical Boolean that you can use in many programming environments. Learn how in this tip from Builder.com.
»
Data auditing readied for Oracle systems
:
Lumigent to ship new version of Entegra
»
Oracle Trial Focuses on DOJ's 'Big Three' Theory
:
Testimony in the Department of Justice antitrust trial against Oracle zeroed in on the government's key theory that PeopleSoft Inc. is one of only three companies that compete...
»
PeopleSoft's Standing Debated at Trial
:
The DoJ's argument to block Oracle's takeover of PeopleSoft hinges on the Global 2000's view of competition in the ERP marketplace.
»
Unauthorized Access Vulnerabilities in Oracle EBusiness Suite
:
Security vulnerabilities have been discovered in Oracle EBusiness Suite.
»
Oracle Still King of Database Software Market
:
But downward price pressure is lurking for all the players.
»
More News...
»
9i Tablespace Growth
This script will show you your tablespace size, what percentage is used and free, and the number of fragments that happened.
»
Find Datafiles Added per Month
To find datafiles added per month for version 8 and above.
»
Connect to Database Without Setting Environment
This script will gather the information from /var/opt/oracle/oratab, will set the environment and will prompt you to type a valid sid.
»
Create the Control File
This is brief information about control file.
Take the controlfile information from trace file and does changes accordingly.
»
Which DML's are running? How much Rollback?
Each transaction will be put in the v$transaction table. This query will give you which rollback segment they are using and how much. It will also show how much temp space they are using.
»
More Scripts...
