i need to produce a report which shows the sum last down level
employees and only those
i ve done an attempt which i am posting, but it is giving me weird
results(my fault), it is giving me roots also as wel as nodes,

I want to flush the shared_pool in order to "accelerate" effects of changing
cursor_sharing parameter. What is the risk, if it exist, on a production
server with batch running?
Regards,

I am trying to install Oracle Financial 11i on a Dell D410 laptop
under Windows XP. I found a tutorial on the net and followed every
step.
I start to install the Unix commands and the VC ++ environnement, then

Hello *,
I'm new to performance tuning and linux , so any pointers to speed up
my investigation is much appreciated.
I've just installed a 10.2.0.3 on a 64bit Linux AS. I created a few

Oracle 10.2.0.3.0
Windows Server 2003
Enterprise Edition
I have a process where I have a cursor which returns approximately 36

I have the following query that returns 1 row:
SELECT REPORT_DATE, STARTS FROM SUBSCRIPTIONSUMMARYDATA WHERE
REPORT_DATE IN (TO_DATE('01/20/2008','MM/DD/YYYY'),
TO_DATE('01/21/2008','MM/DD/YYYY'))

In my VB 6.0 code, I have tried to connect to oracle-database,
but program just hang (even there is no exception !!!)
Code is :
In alert.log there is a massage (it sometimes occurs when the above hang,

anyone have code snippets that copy a table from one schema to another?  i
usually use toad to do this but i really would like to find more automated
way.

What I am trying to accomplish is to get an understanding of how much
columns are being used in a table.  We are working on creating a data
warehouse, and I need to know which columns are important and being
used and vice versa.  My plan is to get a number of how many nulls /

Previously we were on Oracle 8i and we had a bunch of jobs in the job
queue, which ran fine.
Last week we moved to 10g, and none of the jobs are running.  Why is
this?  Can someone give me a suggestion?  I have the JOB_QUEUE_PROCESS

I have created, and run, as sysdba this script to create an user and a
view.
drop view ADNAM;
create view ADNAM as select Serial from reporter.status;

I'm using 10gR2 on Windows 2003 Server, and my problem is that
the database doesn't start automatically after a system reboot.
I get ORA-01034 and ORA-27101 even half an hour after starting
up the machine. I can start the DB manually with no problem.

Oracle 10.2.0.3.0,
Windows 2003 Server
8GB Memory
8 CPU

I am a beginning Oracle 9i user and I was hoping that someone can help
me.  I think I have the basic SQL statements down pat, but this
problem is a little too advanced for me.
Let's say that I have Table A with the following columns:  Food_ID,

how can I create a pfile (on filesystem) from spfile, if spfile is on ASM.
I cannot open my db with startup nomount.
I have an ORA-00371: not enough shared pool memory
I'm trying to fix this but cannot create the pfile.