Fw: lock problem

I will power on terminal A because I know that , I switched it before. If we have more terminal , think if we have 200 termianl and one of them power off. !!! but I do not know which one is it. In this case which one is lady !!! ( I see all terminals (lady ) in the session (Las Vegas) but

RE: URGENT Help on tracking unauthorized login to Oracle Database

AUDIT SESSION also captures failed logins -- look for RETURNCODE=1017 in SYS.AUD$ e.g. alter session set nls_date_format ='DD-MON-HH24:MI:SS'; select os_username, username, userhost, terminal, timestamp, returncode from sys.dba_audit_session where returncode != 0 order by timestamp / However

Oracle DBA Needed in Kansas City, Kansas area

If you enjoy interesting work, then join this Major Consulting Firm in the Kansas City, Kansas area that needs an Oracle DBA to provide client database support. This is a Staff position and the first project is for 6 months with extensions in Overland, Kansas. *Only candidates in Kansas or nearb

Re: lock problem

> Ali TOYGAR wrote: > > Hi , > I have a problem. > I wrote an sql : in TERMINAL A > > select col1,col2 > from tableX > where col1 = ... > for update > > I wrot same sql , in other terminal TERMINAL B > >

Re: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ?

thank you Poul , How is your hardware on server ? - Original Message - From: Paul Vallee To: Multiple recipients of list ORACLE-L Sent: Friday, February 08, 2002 8:48 PM Subject: Re: DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ? Hi Bunyamin, list

Oracle9i with multiple block sizes

Hi, Anyone running oracle9i with multiple datablock sizes in their database...? I am looking for the result for this query from a database which has multiple block sizes? SELECT *FROM X$KVIS: You can reply to me directly if you choose to do so. Best Regards, K Gopalakrishnan Bangalore, INDIA

Re: BIG DATABASE second post

Thank you , This gives me a good idea . Thank you so much ... - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 8:33 PM > --=_MAILER_ATTACH_BOUNDARY1_2002211105121037412975 > Content-Type: text/plain; charset=us-ascii

lock problem

Hi , I have a problem.         I wrote an sql  : in TERMINAL A       select col1,col2         from tableX where col1 = ... for update   I wrot same sql , in other terminal TERMINAL B       select col1,col2        

Re: BIG DATABASE second post

Yes I do have a database with 4000+ concurrant users at any given point in time. Server configuration - Sun 2.8 , sun 6500 server with 10 CPUs and 20 gig RAM. The database is running in MTS (multithreaded server ) environment with 35 dispatchers and 350 shared server. SGA size is about 3.5 gi

RE: BIG DATABASE second post

I have the solution, if you do contact me later i will send you the solution -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Sunday, February 10, 2002 4:38 PMTo: Multiple recipients of list ORACLE-LSubject: BIG DATABASE second post I am wonde

RE: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error

Claudio, Thanks for the info. It sounds like Oracle's recommended solution worked for you. I'm worried about the folks who said it didn't and was curious if anyone else had found the extent > max_io_size solution didn't work. Oh well, once things calm back down on that QA box we will take the tim

RE: Download a database

I had read somewhere on metalink that no supported Oracle database is available for W2K Millennium Edition. HTH, Rajesh -Original Message- [EMAIL PROTECTED] Sent: Sunday, February 10, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Anyone who knows ifthere is a possibility to d

RE: ORA-01000: maximum open cursors exceeded

Hello Dave I have 2000 open cursors on 816 NT with no problems. I think that the limit is to let you know when someone is not closing cursors or behaving badly. We have the same feature in ADABAS on the MF with max concurrent users. We can bump it up but an error means usually that someone is not

BIG DATABASE second post

I am wondering if any of you has a database with over 1000 active (making transaction at the same time ) clients ? If yes , What is your DB Server OS ? DB Server RAM and CPU count? Are you using Parallel Server for load balancing or Do I need it for 1000 active users?   Thank you So much ? A

Re: Download a database

Hmm, Oracle9i for NT? Look at http://otn.oracle.com/software/content.html JP On Sun 10. February 2002 07:38, you wrote: > Anyone who knows ifthere is a possibility to download some edition of > oracle database to your harddrive? I am running Windows 2000 Millenium > Edition. > > Thanks in advan