This just seems weird.  I look at our SPFILE:  *.shared_pool_size=2G
I query v$parameter: 1073741824
I ran a query:
SHARED_POOL_USED SHARED_POOL_SIZE SHARED_POOL_AVAILPCT_SHARED_POOL_AVL

We just upsized to SQL server (Access 2003 front end). I am running
into error 3146 on a particular table. Part of my code, I have a
simple delete SQL statement and I am getting an error on this
statement.

We installed this Spotlight for Oracle software.  The software shows
an 85% re-parse rate against the Library Cache.  Here is the biggest
issue we have.  I do not think anything can be done, but maybe another
brain can figure something out:

I resisted joining linkedin.com for a long time, somehow I had the
idea it was for headhunters and finding jobs and that sort of thing.
My alumni association sent an email saying they now had a group there,
so I thought, ok, I'll join for that, there're some people I wouldn't

Hi Group,
I do this manually from time to time - but maybe there's a better
way ...
Does anybody know of a way, tool or whatever to convert classic oracle

How to read BLOB column using simple method.
I can do using TOAD ( export option).
Regards

I am on Oracle 10.2.0.3 on Windows 2003 32 bit. I have /3GB switch set
on and have a value of sga_target set to 2.x GB,
I am using a third party package and many queries are doing hash
joins. I cannot modify any queries because of no source code available

How can I programmatically get the SID and SERIAL# for my connection
from a client side program?
Many tia!
Mark

I am 10.2.0.3 on HP UNIX 11i
I  use sqlplus to run a query. I set set autotrace on which I think
calls dbms_xplan to display the sql plan. Query took 54 seconds
to complete (using UNIX time x command).

2 questions here:
First, in terms of minimizing the number of parse/execute calls, it is
suggested to use bind variables.  Is a bind variable the same as a
plsql variable?

2 questions here:
First, in terms of minimizing the number of parse/execute calls, it is
suggested to use bind variables.  However, why would a statement
like:   "SELECT address FROM emp WHERE name = 'John Doe';" get re-

iWare Logic provides “Oracle Apps 11i and R12 Training” and
Certification in Oracle Apps EBusiness Suite 11i as well as R12
Financials, HRMS, Supply Chain, CRM, Apps DBA in association with
Oracle University.

Oracle 11g has a table called  V$IOFUNCMETRIC which is a typical
metric table, like the set that was introduced in 10g. What confuses
me are 2 things:
1) SQL> select function_name from V$IOFUNCMETRIC;

Oracle 10.20.03.0, 64 bit
Windows 2003 Server
I'm trying to use regular expressions (REGEXP_REPLACE) to transform rows
like the following

I have large CLOB (XML) (way bigger than 32K) data that has NO
LINEBREAK/NL.....
I want to write the CLOBs to files.
Using UTL_FILE...is there anyway  to avoid newline --- so that the