I need to get a session_connected high water mark on my 9208 database.
Using
select RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION,
INITIAL_ALLOCATION from v$resource_limit where

Oracle 10g DBA on Redhat Enterprise 4.0 Linux Administration
We are Launching new batch on Oracle 10g Database administration
Vennela Technologies is a premier Education services provider in Asia
Pacific with a huge client base in India , Europe and North America .

I want to update a column with the count of rows which share a common
value.
I'd like to be able to do it with count( ) as an analytic ...
[9.2 & 10.2]

So easy even a two year old can do it !
Work (well really cant's call it work) less than 2 hours a week.
Make a nice extra income!
Realistic $200.00 to $600.00 partime.

I have two environments - test and dev - on the same oracle instance,
but on different users.
I need to migrate test to dev with a shell script.
imp/exp works almost fine:

I have a little problem building a query which selects top-N tuples with
respect to day and an other field.
Tha base table contains aggregated data for a web server, there are
different directories with pages inside and hits and this is aggregated

Dear Oracle gurus,
Suppose my app has a statement like the above (or below):
SELECT Field1, Field2....Fieldn FROM MyTable FOR UPDATE
and I've just issued it. The phone then rings "Honey,

Rainbow Tables for CAIN:
- only for system account
- up to 8 characters passwords;
- 100 torrent files;

I have to take backup of 110GB Database. I have taken physical backup
on tape, now I want to take Logical backup of whole database.
What parameters should I use in EXP command (Using 9i Exp) ?
Thanks and Regards,

I am considering data access solution where every data request from
the applications invokes a single stored function, and I am wondering
if may result in resource contention.
The single generic function will accept a CLOB containing the id of

I have a project whereby an Inventory Module is to be built on the
already existing Sales and Finance (Receipts only) modules that are
already in place. Kindly let me know urgently if anyone is interested.
Regards,

is there any workshop on oracle 9i sql/pl-sql, that's going to be held
in bangalore in the near future. if any one knows please do reply in
this thread.
thanks and regards

Allow me to take this opportunity to introduce to you our "TechUnified
Consulting" has been adjudged as the "Best Emerging Company" for the
year 2007.We are a premier HR consulting based in Bangalore, currently
working with a large number of IT companies and helping them in

Hi all, I have here a query to sort name, job function and department,
the query is working but I don't know how to restrict the selection, I
mean instead of sorting
all departments and functions, I onli need to sort employees who are

Is it possible for a single query to be split across different
instance of the RAC?
In Toad in the longops tab of the session browser the instance id of
the query is displayed but i dont see it in the v$session_longops