RE: Change Manager

Nothing is so important. It is just the gentle man below wanted to know how he can keep track of changes on his objects, this is an option open to him. George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit

RE: Change Manager

send the HELP command for other information (like subscribing). “This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp " -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard INE

RE: Finding SID of current session

V$mystat, to what would you join this to understand the values/statistics, v$session_event? George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit) Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27

Finding SID of current session

Hi there all. How can I find the sid of the current session, I got a pl/sql procedure that needs to do a select from v$session_event but only want to do it for it's own session so I need to know this for the where clause ? George __ George Le

RE: Any German here ? Character set

Title: Any German here ? Character set Correct   The difference between the P1 and P15 is P15 got P1 + euro support.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell

Oracle 9i (9.2.0.4)- RH AS 2.1 HP Itanium

Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573

RE: any script to parse alert log ?!

Hi there Hope this helps. First the ksh file. #!/bin/ksh # # File : check_alertlog.ksh # Created : 01/02/2002 # Modified : 04/02/2002 # : 20/02/2002 Removed the CC for the email # # By: George Leonard ([EMAIL PROTECTED

RE: logon trigger

Hi there Your' the man, the people here laughed when we saw this working and that was the problem. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11

RE: logon trigger

iate 'Alter session set OPTIMIZER_MODE = choose;';    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;'; end; /   George ________ Geor

RE: logon trigger

Thx, I also found this last night.   I will wait for the developers so arrive so that they can test their process.   George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel

RE: logon trigger

the user, setting it's session to CBO etc etc. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:

RE: logon trigger

E = 10485760;';    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';   end; /   George ____ George Leonard Oracle Database Ad

logon trigger

query; Alter session set SORT_AREA_SIZE = 10485760; Alter session set OPTIMIZER_MODE = choose; end; / George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax

RE: Determine process of index build - HOW

v$sqltext s where a.sid =b.sid and b.sql_address = s.address and a.sofar <> a.totalwork order by b.sid, last_update_time /   George ________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: 

Determine process of index build - HOW

Hi there How can I see how far my index build has is. I got a table with 43 mil records. It is taking forever as expected but would like to see how far it is, Any idea. Oracle 8.1.6.3 (32Bit) on Solaris 2.6 on Sun E10K George George Leonard

RE: Staspack Grapher/Viewer ?

http://www.statsviewer.narod.ru fantastic product. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http

Re-creating control files with larger maxdatafile setting

Hi all Does someone maybe have a step by step guide to re-creating the control files. I have found that one the my databases the maxdatafiles has been set to small, would like to increase it now. thx George George Leonard Oracle Database

RE: bind variables

If you want to show anyone the different in seed between using bind variables and not using them Tom Kyte's Expert one on one got a nice example, it is in chap 2 or 3 I think. George George Leonard Oracle Database Administrator Dimension

RE: Oracle 9i and memory required

Hi I got it working with 384MB on redhat 7.2, Dell Optiplex GX1 desktop. (test install). George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail

RE: How to speed up import

Import with indexes=n Then build index creation script with indexfile= incrfile.sql rows=n Then use sqlplus user/password @incrfile.sql George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel