10.2.0.2 Ent Ed
Is there a way to determine the max number of sessions for a given
time frame with the database, either from awr reports or from a v$
view.

Please let me know how to check the db time at specific
moment....let's say i want to check what is the time at db level
now....not at OS level using sysdate function.....
Reply soon.

10.2.0.2 AIX5.2 64bit Ent Ed is our database system in question.
We have an application that keeps crashing periodically and can't seem
to find the issue to address. It is a vendor package so we don't
control the logging or the actual fixing of the issues. I have pretty

I have a large perl program which connects to oracle and calls
procedures in a package using:
call user1.package1.procedure1(args);
user1 is the owner/creator of "package1".

I am trying to install oracle client 10.2.0.1 on Solaris 9.
Installation completes with success but i have porblems with
privileges for all the directories under Oracle Home.  instead of
having 755 or drwxr-xr--x for all the directories and sub directories

I have a procedure that returns a boolean value, How can i print this
value or is there any way from which i can fetch the value returned
from the procedure to a variable of a varchar2 datatype

I was using an Orcale 9i server on one of my applications and it
worked fine.
Now I installed a new server and got installed an Oracle 11g
I am getting errors in the application which I didn't get before on my

I have a problem that I can't resolve. I hope that someone have a
response.
I use the package DBMS_DATAPUMP to do an export of my database into a
file.

 I have Windows application connect to the Oracle database server
through ODBC all the time.  However, we found the application
disconnect from database on each day morning.  The error involved
"TNS-12152 unable to send break message", "ora-12570 TNS packet write

I'm migrating an application from sql server to oracle.
We have tables with column that use user defined data type, for
example
CREATE TABLE AA (

CREATE OR REPLACE PACKAGE p_tst
IS
      v_var int := 1;
END;

I'm just finishing up my B.A. in database technologies, and I've been
looking for my first position in the field. There are lots of Oracle
jobs in my area (Tampa, FL) but no one seems to be interested in new
graduates with no experience. I've heard that other areas in the US

Can someone tell me how flashback works?
When I execute:
execute dbms_flashback.enable_at_time(sysdate - 10/1440);
What exactly is happening here? Does this mean that just for

I am preparing myself to the 1z0-031 DBA OCA exam. Can anyone help me and
provide me with the prometric tests for this exam?
It would be very useful while studying and taking these tests in order to
pass this proper exam afterwards.

I am preparing myself to the 1z0-031 DBA OCA exam. Can anyone help me and
provide me with the prometric tests for this exam?
It would be very useful while studying and taking these tests in order to
pass this proper exam afterwards.