I hope this is the correct group to post in - any help is appreciated.
I am writing some SQL to populate or update an Oracle table.  I
currently run this through JDBC, however, it will probably end up as a
PL/SQL procedure.

Does anybody know precisely what is included in the 'library cache'
"SGA component name" from v$sgastat?
I guess it is actually something like library cache handles plus other
things, especially since there are other "SGA component names" for

Hello everyone.  I currently have a simple table, DAILY, containing
various daily transactions.  The table has a date column, transaction
1, transaction2, transaction3 etc.   Example:
DATE       Transaction1       Transaction2     Transaction3

I'm trying to understand oracle exceptions. There appear to be many
different ways that exceptions are defined. Following is how I
understand it.  Please let me know if I'm wrong or if my terminology
is off.

Oracle 10.2.0.3 Ent
Do I have to manually delete the 'expired' flashback log from OFA?
'Expired' means those will not be needed for flashback up to
'db_flashback_retention_target'.

Is this who I think it is ?
;)
http://www.flickr.com/photos/18309730@N00/295965135/in/photostream/
http://www.flickr.com/photos/18309730@N00/295965213/in/photostream/

I have given the following question.  I need help on this.
Given a schema for a stock trades table that looks like:
*stocktrades (*
*  symbol    string,  -- stock symbol*

I'm using Oracle 10g, and trying to pick a 5% random sample from a
large table.
So far I've had no luck searching the groups or the net for a
solution.

Just read the
http://blogs.ittoolbox.com/oracle/guide/archives/recent-open-source-oracle-proje
cts-19233
and thought - maybe it is interesting to share. I personally found the
mentioned http://ora-safe-search.sourceforge.net/ very useful.

Vennela Technologies Pvt. Ltd. is a Leader in ERP Training and
Projects in India Vennela Technologies has been in Training from last
4 years. Vennela trained more than 4000 users in Oracle Applications
till date.

Currently, I'm working on Oracle 8.1.7.4 database on AIX5.2 (32 bit).
I am planning to upgrade the AIX version from 5.2 to 5.3.
Could anyone provide me some information on the things I need to take
care of at the Oracle database level during this OS Migration?

I tarred and moved the entire u01 oracle directory to another machine.
Oracle server work fine on the new server. The Enterprise Manager and
iSqlplus doesn't seem to start.
Are there files in other directories that I may need to move? I already

The sysaux tablespace is growing pretty faster than other tables in my DB.
I'm using 10g RAC.
Obviously all db related and grid agents details get stored there. Is this is
the usual character of this tablespace.

I need to make a DB Link from a Oracle10 to a Oracle7. There is no
possibility to install another version.
Does anyone know if this is someway possible?
Many thanks,

  I am trying to generate DDL scripts for each table, view and other
indexes under a schema. I tested using DBMS_METADATA package and its
get_ddl procedure. However, I can only output the create table (view,
indexes) statements for all the tables in a schema in one script, not