RE: Oracle World anyone?
Tanel, Could you please let me know where I can find info. about this data server internal course ? thanks, > -Original Message- > From: Tanel Poder [SMTP:[EMAIL PROTECTED] > Sent: Friday, August 15, 2003 1:59 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle World anyone? > > Hi! > > In Europe, Tom Kyte is going to be in Denmark in Jan 2004 :) > Check <http://miracleas.dk/en/events.html#MasterClass> > > But yes, IMO the hottest courses delivered by Oracle Education are the > Data Server Internals series. > > Tanel. > > > - Original Message - > From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > Sent: Friday, August 15, 2003 7:39 PM > Subject: Re: Oracle World anyone? > > > > Jared et al, > > I was just told by my new boss that I have to have any requests for > any conferences/shows in by Sept. 5th (his budget deadline). It's been > years since I worked for a company that would pay for me to go anywhere, > so, for 2004, what would you (or others on the list) recommend? It'd prob. > have to be scheduled already to appease the budget gods, so any dates, > locations, web-sites? Also, it would have to be Oracle- or MS SQL > Server-based, as that's what I support (9i, and 2000, respectively, all on > Win2ks (do I hear violins playing)). Finally, what's the 'hottest' (read > that as the most beneficial) Oracle course these days for a DBA that's > been around since 6.0 and is now working with 9i? Internals? > > Thank you, > > Paul R. Sherman > DBA/Sr. Appl. Analyst > Bacou-Dalloz > office - 401-232-1200 x200 > cell- 401-935-2802 > > > > > Jared Still <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > > 08/15/2003 11:49 AM > Please respond to ORACLE-L > > > To:Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: Oracle World anyone? > > > > > Sorry Steve, I'm saving my money for HOTSOS and IOUG. > > Would love to of gone just get a chance to meet friends > and eat in SF restaurants. > > The timing is bad anyway, as it's right during my vacation, > and I intend to spend that doing non-work related stuff. > > I even had a free pass. > > Jared > > On Thu, 2003-08-14 at 18:24, Steve McClure wrote: > > Just completed the registration, and was wondering how much > company I was > > going to have there. > > Who else has plans to attend? > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Steve McClure > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You > may > > also send the HELP command for other information (like > subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still >INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > > --------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Li, Xiangli INET: [EMAIL
materialized view log
Hi, All I have a question on how to interpret materialized view log, which has a field change_vector$$. I think this fields record all the changes on master table, I need to understand the updates on the master table so I can develop my own API to copy the change to a flat file. Any help would be appreciated. regards, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle training
> Hi, DBAs Just wonder if there is any good oracle training programs for oracle performence tuning, backup&recovery etc. ? thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PS lock
No, I didn't get enqueue waits. rgds, Li > -Original Message- > From: Diego Cutrone [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 15, 2001 4:48 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: PS lock > > Hi, > PS lock is related to Parallel Slave Synchronization. > > > Are you getting a lot of enqueue waits of this type? > > HTH > > > > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Wednesday, August 15, 2001 1:56 PM > > > > Hi, DBAs > > Anybody knows about PS lock , mode in 6, and exchange deadlocks equal to > 1 > > in v$sysstat, can this be a problem? > > this is ver 8.0.5 on hp unix. > > > > thanks®ards, > > Li > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Li, Xiangli > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Diego Cutrone > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PS lock
Hi, DBAs Anybody knows about PS lock , mode in 6, and exchange deadlocks equal to 1 in v$sysstat, can this be a problem? this is ver 8.0.5 on hp unix. thanks®ards, Li -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pinned objects
Hi, all I kept packages in shared pool, try to reduce number of parses for main packages. But I still found many parse counts in trace file as following. (Status for package ModelCache in v$db_object_cache is 'YES', and db is 8.0.5 on NT4.0) BEGIN ModelCache.RemoveModelData(INCASENO => :001); END; call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 41 0.34 0.78 0 0 0 0 Execute 41 0.52 1.06 0 0 41 41 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 82 0.86 1.84 0 0 41 41 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 21 Could anyone explain to me why ? thanks®ards, Li -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Li, Xiangli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ODBC issue???
Title: ODBC issue??? Hi, DBAs We are running a third party application on oracle8.1.6 with oracle odbc drive8.1.6.3. Everything works fine when application launched a single process, but it generated following error message when two processes running concurrently. --ora 1461, 0, "can bind a LONG value only for insert into a LONG column" I guess when running in multi-process mode, the SQL strings submitted from application to oracle server exceed the limitation on ODBC driver ( 4000 characters?). Is there any other issues I missed? thanks®ards, Li
RE: RE: MS access
Title: RE: RE: MS access thanks for all. rgds, Li -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:47 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: MS access Yes, Dan is right, I just pulled up this info from Acess Help ( U can find more info when u search for "Specification" in access help) *** Database specifications *** Attribute Maximum Database (.mdb) file size 1 gigabyte. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity. Number of objects in a database 32,768 Modules (including forms and reports with the HasModule property set to True) 1024 Number of characters in an object name 64 Number of characters in a password 14 Number of characters in a user name or group name 20 Number of concurrent users 255 *** -Original Message- From: dan williams [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: MS access I've been working in Oracle for 4 years and Access for 6 years, and can assure you that for Access 97 (size limit is 1 g), Access 2000 (size limit is 2 g), Access 2002 (size limit is 4g). I've had 500 mg database that work fine in a multiuser environment, however if there is a need for a enterprise solution, then using a enterprise tool is better suited. --- [EMAIL PROTECTED] wrote: > Kevin!!! > > Li, > In reality Access does have a file size limit, but I believe it > is much > lower than 1GB. Regrettably there is no way around it, except as > Kevin stated > to use a pass through query to Oracle. One should understand that > Access is > designed as a single user system that gets bastardized into multi > user > applications with a lot of resulting trouble. > > Dick Goulet > > Reply Separator > Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]> > Date: 5/24/2001 9:02 AM > > MS accessIf it's true use an Oracle Database...hehehhhehhh...Just > kidding...sorry:( > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Li, > Xiangli > Sent: Thursday, May 24, 2001 11:57 AM > To: Multiple recipients of list ORACLE-L > Subject: MS access > > > Hi, List > Is there anyone happen to know what's the database size > limitation for MS > access97? I heard it's 1 gigabytes, how to overcome it if that's > true? > > thanks > Li > > > > MS access > > charset=iso-8859-1"> > > > > size=2>If > it's true use an Oracle Database...hehehhhehhh...Just > kidding...sorry:( > > > face=Tahoma > size=2>-Original Message-From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Li, > XiangliSent: > Thursday, May 24, 2001 11:57 AMTo: Multiple recipients > of list > ORACLE-LSubject: MS access > Hi, List > size=2>Is > there anyone happen to know what's the database size limitation > for MS > access97? I heard it's 1 gigabytes, how to overcome it if that's > true? > thanks > size=2>Li > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dan williams INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file Thanks all. Very clear and it works. rgds, Li -Original Message- From: Reardon, Bruce (CALBBAY) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file On NT, if you don't want to lose any listener.log entries and you want to keep using the same logfile name then you will need to use set log_file twice. Also, under NT (at least with 815 and 817) don't specify an extension for the log file - it automatically gets ".log" appended. For example (something like the following untested code): lsnrctl set log_file temp1 ren listener.log listener_tmp.log lsnrctl set log_file listener copy /b listener_tmp.log + temp1.log listener-date.log del listener_tmp.log del temp1.log You could put the date into the archived listener log using the for command to process output of date/t and time/t. Note that using set log_file requires the listener password to be entered. This can be automated under NT by using something like: rem create the temp file echo set password %lnrpwd% > %lnrstart_file% echo stop %1 >> %lnrstart_file% echo exit >> %lnrstart_file% echo. >> %lnrstart_file% rem feed it into lsnrctl lsnrctl < %lnrstart_file% Regards, Bruce -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, 25 May 2001 5:53 To: Multiple recipients of list ORACLE-L Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever the old file. -Original Message- Sent: Thursday, May 24, 2001 1:58 PM To: ORACLE-L; Xiangli.Li May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log >>listener.log.hist ex listener.log < 1,$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($(($v_lines * 10)) / 100)) v_purge=$(($v_lines - $v_keep)) ex listener.log < 1,$v_purged wq EOF -Original Message- Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: ->Hi List, ->As a regular maintainance work,I have moved the listener.log file to ->listener.log.old ->and 'touch'ed the listener.log, expecting the logging into this new file. ->But I am observing the logging being done to listener.log.old, instead. ->I could not recall any such previous experience. ->FYI, I cannot do any 'experiments' as far as this system is concerned as I ->have to deal with ->desupported HP-UX(10.01), Oracle (7.2.2.3). ->I have my logging being done to default path($ORACLE_HOME/network/log), as ->no parameter settings in listener.ora. ->Has anybody experienced this? -> ->TIA, -> ->Suren ->Oracle DBA ->Sony Electronics Ltd. -> -> The file handle listener is using is still pointed at the old file. To fix this you need to stop and start the listener. This will not affect anybody who is already connected. I'm not sure if a reload will do the same thing. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc. [EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: < http://www.orafaq.com> -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californ
RE: MS access
Title: RE: MS access it seems only access 2000 supports 2gb files. thanks. Li -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 2:12 PM To: Multiple recipients of list ORACLE-L Subject: RE: MS access I believe it is 2gb. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message----- From: Li, Xiangli [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Subject: MS access Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file
May I know how to clear the content of listener.log without restart listener on NT platform ?
thanks.
Li
-Original Message-
From: Brian MacLean [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener.logwriting to renamed file
Reload doesn't close/reopen the file. Here is a couple solutions
How's about a fast cat/clear solution:
#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log <
1,\$d
wq
EOF
Or if you wish to purge 90% of the file:
#!/bin/ksh
wc -l listener.log | read v_lines junk
v_keep=$(($((${v_lines} * 10)) / 100))
v_purge=$((${v_lines} - ${v_keep}))
ex listener.log <
1,${v_purge}d
wq
EOF
-Original Message-
From: Thater, William [ ]
Sent: Thursday, May 24, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener.logwriting to renamed file
On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:
->Hi List,
->As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new file.
->But I am observing the logging being done to listener.log.old, instead.
->I could not recall any such previous experience.
->FYI, I cannot do any 'experiments' as far as this system is concerned as I
->have to deal with
->desupported HP-UX(10.01), Oracle (7.2.2.3).
->I have my logging being done to default path($ORACLE_HOME/network/log), as
->no parameter settings in listener.ora.
->Has anybody experienced this?
->
->TIA,
->
->Suren
->Oracle DBA
->Sony Electronics Ltd.
->
->
The file handle listener is using is still pointed at the old file. To fix this you need to stop and start the listener. This will not affect anybody who is already connected. I'm not sure if a reload will do the same thing.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates.
--
Please see the official ORACLE-L FAQ:
--
Author: Thater, William
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: MS access
Title: RE: MS access Hi , DBAs Thank you veyr much for all replies. I think I have to go for oracle. rgds, Li -Original Message- From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: MS access Li, 1GB for Access would be huge...and cause very poor performance. The only way to overcome the size limitation is to upgrade to a real database...preferably Oracle, but that SQL Server thing would work as well for a DB that size. Ed Haskins Oracle DBA Verizon Wireless -Original Message- From: Li, Xiangli [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Subject: MS access Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
MS access
Title: MS access Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
off topic: c, c++ and java list
Title: off topic: c, c++ and java list Hi, all Could anyone tell me there is any list regarding C, C++ and Java ? thanks li
RE: oem2.2
mand: jar -xvf OMS_22_1486038.JAR The existing VtcGenerateReportObject.class and TCLScriptString.class files will be properly overwritten. 4. Restart the Management Server. Patch Application Instructions for Console and DBA Studio ~~ 1. Go to the machine(s) on which the Console and DBA Studio runs. 2. Exit the Console and/or DBA Studio. 3. Untar/Unjar OMS_22_1486038.[TAR/JAR] to the $ORACLE_HOME directory. On Solaris, you can untar the file via the following command: tar -xvf OMS_22_1486038.TAR On Windows platforms, you can unjar the file using WinZip or via the following command: jar -xvf OMS_22_1486038.JAR The existing VtcGenerateReportObject.class and TCLScriptString.class files will be properly overwritten. 4. Relaunch the Console and/or DBA Studio. References ~~ @ : HTX TEMPLATE FILES NOT CORRECTLY INSTALLED @ : ERROR WITH GENERATING OF REPORTS OF SERVICE NAMES IS @ QUOTED @ : CAN'T VIEW EACH REPORT FOR DB, LISTENER,NODE DUE TO @ HTML NAME DIFFERENCE @ : DIFFERENCE IN FILENAMES BETWEEN THE DBA STUDIO AND @ SYSTEM REPORTS . -Original Message- From: Li, Xiangli [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Subject: oem2.2 Hi, all I want to create HTML report by using "generate enterprise report" under system menu in OEM 2.2, but got following error, ** Report ** User: SYSMAN, Service: SYSMAN, Query: 0, Report: --INIT-- ** Message ** Unable to find template files files HTML generation files missing - Please apply the reports agent patch. ** Error ** Intelligent Agent does not have the HTML generation files May I know which patch I should apply? thanks. li
oem2.2
Title: oem2.2 Hi, all I want to create HTML report by using "generate enterprise report" under system menu in OEM 2.2, but got following error, ** Report ** User: SYSMAN, Service: SYSMAN, Query: 0, Report: --INIT-- ** Message ** Unable to find template files files HTML generation files missing - Please apply the reports agent patch. ** Error ** Intelligent Agent does not have the HTML generation files May I know which patch I should apply? thanks. li
filesystem buffer ON/OFF ?
Title: filesystem buffer ON/OFF ? Hi, all I have a database running oracle8.1.6 on HP-UX 11 (64 bit). We enable file system buffer on OS level. I think bypassing the filesystem buffer will improve performance because right now, both oracle and the filesystem are performing this operation. If I am right, should I turn off file system buffer only for data, index segments, how about system,rollback segs. and temporary segs. ? Any suggestion are very welcomed, and any website talking about this? because I have to convince my SA guys. thanks in advance. li
RE: Qualifying columns to improve performance?
Title: RE: Qualifying columns to improve performance? -Original Message- From: Arn Klammer [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 10:30 PM To: Multiple recipients of list ORACLE-L Subject: Qualifying columns to improve performance? At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine the table to which each column belongs. Is this still a valid rule? Does this apply to statements in PL/SQL procedures/packages? Or are they different, because they are checked at compile time? -a ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
ODBC driver
Title: ODBC driver Hi, DBAs We have a application which causes oracle error 1461 when using oracle ODBC 8.1.6.3, but it works well with Microsoft ODBC driver, any suggestion for this? And I also want to know where I can find all version oracle ODBC drivers because I may use 8.1.6.1. thanks. li
X$ tables
Title: X$ tables Hi, DBAs Anyone know where I can find docs which interpret the definition of X$ tables as well as their columns ? thanks in advance. li
RE: Check the constraints
Title: RE: Check the constraints Hi, The SQL impact from Toad maybe can help. rgds, -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Check the constraints Hallo Anyoine know about any program that can check all the constraints after the database is designed? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
