RE: Query

Hi Mukund,

I have some queries:

1. Can u tell me the maxm no of columns that can be included in
index....is it 32??
2. which package is used for debugging of procedures, triggers and
functions.....(dbms_output or dbms_describe or dbms_SQL or
dbms_transaction or ????)

Rgds
Lavinder K Singla
Software Engineer - CAPS
Infosys Technologies Ltd.
Mohali, Punjab, India.
Tel:(0172)390510,257191 Extn:6187


-----Original Message-----
From: mukund karegar [mailto:[email protected]] 
Sent: Friday, February 07, 2003 11:58 AM
To: Lavinder Kumar Singla
Subject: RE: init.ora


license_max_users will give the info about max users
that can connect..

if you want to know, how many nusers are connected,
then query the view v$session.

to know their memory utilization, query v$sesstat and v$statname.

if you want any more info, please feel free to write
back..

cheers

mukund
--- Lavinder Kumar Singla
<[email protected]> wrote:
> Hi Mukund,
> Thanx for ur kind response.
> 
> Actually I m just a beginner to Oracle.
> I wanted to know the complete/usage functionality of
> this init.ora file.
> Does init.ora contain the total no. of users at an instance?If not,
> where is that info stored in Oracle?
> Is there a scheduler in Oracle?
> 
> Waiting for ur response.
> 
> Thanx & Rgds
> Lavinder K Singla
> Software Engineer - CAPS
> Infosys Technologies Ltd.
> Mohali, Punjab, India.
> Tel:(0172)390510,257191 Extn:6187
> 
> 
> -----Original Message-----
> From: mukund karegar
> [mailto:[email protected]]
> Sent: Friday, February 07, 2003 9:47 AM
> To: Lavinder Kumar Singla
> Subject: re: init.ora
> 
> 
> hi lavinder,
> most of hte parameters of init.ora are self
> explanatory (such as control file location , etc).
> if
> you have a particular paramter that you want to know
> more about then post teh query.. coz init.ora can
> have
> about 250 parameters.. so its a waste to explain
> them
> when one does not know which one are you looking
> for..
> 
> regards
> Mukund
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].