RE: Function

Hi Divya, here is ur modified script. declare id number; lv_function_name varchar2(100); y varchar2(40); z number; t number; begin select function_names INTO lv_function_name fromfunc; id:=dbms_sql.open_cursor; y:='select '||lv_function_name||' from dual'; dbms_sql.parse(id,y,dbms_

RE: Function

Hai All We are using Oracle 8 . I tried out using DBMS_SQL. declare id number; x varchar2(100); y varchar2(40); z number; t number; begin select function_name into x from func; id:=dbms_sql.open_cursor; y:='select '||x||' from dual'; dbms_sql.parse(id,y,dbms_sql.NATIVE); z:=dbms_sql.execute(id);

RMAN: nocatalog; remove backed up archived redos

Ramon, Thanks for the reply. I guess I've tried the delete part as well. Here's another attempt at it: - List of Backup Sets Key Recid Stamp LV Set Stamp Set Count Completion Time --- -- -- -- -- -- -- 70

RE: date format in ksh

Title: RE: date format in ksh > -Original Message- > From: Suhen Pather [mailto:[EMAIL PROTECTED]] > > Thanks for the reply. > I am passing a hardcoded date. > I am not getting a date from the > "date" command in ksh. > > What my ksh does is retrieves $1 and must check if the date f

Re: FW: Oracle Training from InterTrain SPAM

report her to spamcop --- [EMAIL PROTECTED] wrote: > > > Yeah, I've asked her to knock it off. > > The reply was more spam. > > Jared > > > > > > "Ko

RE: New Oracle Install and Old Data Files

Regina, Yes there is - but you probably don't want to do it yourself if you're not a DBA ... do a backup control file to trace: alter database backup controlfile to trace; shut down the database and modify the sql in the file you created so it contains the information for the tablespaces you

RE: date format in ksh

Jared, Thanks for the reply. I am passing a hardcoded date. I am not getting a date from the "date" command in ksh. What my ksh does is retrieves $1 and must check if the date format is in DD-MON-YY eg. 02-FEB-01. It uses the hardcoded date (passed in as argument 1) in the script. If the date i

New Oracle Install and Old Data Files

Okay People, I am not the DBA and don't have all the details but this is our situation the way it was explained to me: We had a server crash to the point where Unix and Oracle had to be reinstalled, however the disks containing our data tablespaces (that is, everything but the system tablespa

Re: FW: Oracle Training from InterTrain SPAM

Yeah, I've asked her to knock it off. The reply was more spam. Jared "Koivu, Lisa"

RE: SAP and Oracle

Yes. All SAP instances, prod, sandbox, a, test and dev for all users. You could have as many SAP users as you want, but the license wouldn't cover additional databases on the same node. Todd -Original Message- Smith Sent: Friday, October 26, 2001 4:55 PM To: Multiple recipients of list

RE: Oracle Training from InterTrain

Yaaa! I finally got it! Now I don't feel like a second-class DBA! -Original Message- Sent: Friday, October 26, 2001 6:42 PM To: Abiy Alemu; Andrea Mohammed Ahsanuddin; Andrey Bronfin; Angela Quaglio; Anjan Thakuria; April Wells; Barbara Baker; Bill

Two RAID Adapters????

I know I'm asking this question at 5pm on a Friday afternoon, but lets see who doesn't have anything to do this weekend. I have a PowerEdge 6500 with two PERC3/DC adapters, how do I get them to work together? I have read the docs and visited the Dell support site, but the information they c

RE: # of concurrent connections

select * from v$resource_limit -Original Message- Sent: Friday, October 26, 2001 5:11 PM To: Multiple recipients of list ORACLE-L Isn't there a way to tell what the high water mark is for connections to the database? I have been trying to figure it out but have not seen anything yet.

Security Alert : Oracle 9iAS Web Cache

Our security folks just sent me this. The Federal Computer Incident Response Center (FedCIRC) and Computer Emergency Response Team/Coordination Center (CERT/CC) have issued an advisory (FA-2001-29/CA-2001-29) which discusses a buffer overflow vulnerability with the Oracle9iAS Web Cache. This vu

Re:FW: Oracle Training from InterTrain SPAM

Sure did, used the delete key on it. Dick Goulet Reply Separator Author: "Koivu; Lisa" <[EMAIL PROTECTED]> Date: 10/26/2001 12:50 PM Anyone else get this spam? > -Original Message- > From: Cindy Connors [SMTP:[EMAIL PROTECTED]] > Sent: Fr

RE: SAP and Oracle

When you say for SAP only do you mean all the people who connect to SAP will be covered? -Original Message- Sent: Friday, October 26, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Your SAP license comes with a 'limited-use' Oracle license, which means you can use it for SAP only

Re: # of concurrent connections

Is this what you are looking for? orst>desc v$license Name Null?Type - SESSIONS_MAX NUMBER SESSIONS_WARNING

Re: # of concurrent connections

Look at v$license. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 5:10 PM > Isn't there a way to tell what the high water mark is for connections t

RE: Oracle Training from InterTrain SPAM

Not directly to me, but I remember it being sent to the list as a whole on one of the other Oracle related list servers I follow. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- Sent: Friday, October 26, 2001 3:50 PM To: Multiple recipients of list ORACLE-L A

RE: Oracle Training from InterTrain SPAM

Title: FW: Oracle Training from InterTrain SPAM Yep.  There's a list of suckers in the To list, and I am A-number-1 sucker du jour.   Bambi.   -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 3:50 PM To: Multiple recipients of list

RE: Oracle Training from InterTrain SPAM

I dunno. There is a magic wand called "Block Sender"" in your Outlook. -Original Message- Sent: Friday, October 26, 2001 4:50 PM To: Multiple recipients of list ORACLE-L Anyone else get this spam? -Original Message- Sent: Friday, October 26, 2001 6:47 PM To: Bambi Be

# of concurrent connections

Isn't there a way to tell what the high water mark is for connections to the database? I have been trying to figure it out but have not seen anything yet. I thought I used to do this way back when I started my career. Kimberly Smith GMD Fujitsu Database

RE: SAP and Oracle

Your SAP license comes with a 'limited-use' Oracle license, which means you can use it for SAP only. Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 ext. 3246 -Original Message- Smith Sent: Friday, October 26, 2001 3:35 PM To: Multiple recipients of list ORACLE-L

RE: Oracle Training from InterTrain SPAM

Title: FW: Oracle Training from InterTrain SPAM I did ...   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: An

RE: backup of large databases

What OS are you running Mike?  I was thinking of implementing that for some of our bigger databases as the IO is brutal during backups. -Original Message-From: Hand, Michael T [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 1:35 PMTo: Multiple recipients of list ORAC

RE: Execution time for export/import vs. alter table move tablesp

Dennis, Cost-justifying bringing in an outside resource to perform the required QA test cycle. There is no money or resource currently to do that. Otherwise, we'll have to wait until next year when they can bundle the QA effort for the Oracle upgrade in with the next release cycle of our prod

Re: pl/sql cd bookshelf book

At 12:35 PM 10/26/2001 -0800, you wrote: Hello all, Does anyone have this book?  It says it has the entire PL/SQL Programming Book on it but it doesn't say if it's specifically Feuerstein's book, either on Amazon or on O'Reilly's site.  Can anyone confirm that it is Feuerstein's book? It has al

RE: pl/sql CD bookshelf book

Title: pl/sql cd bookshelf book Yes,   I have it and I love it. It actually has 6 books in it, searchable and definitely nice to have.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opin

RE: Java in the database

I use Perl. A lot. The only thing it can't do is wash my car. I'm working on that. :) How about 200k sessions per hour? 2.5 million pages per hour? http://www.perl.com/pub/a/2001/10/17/etoys.html Jared

FW: Oracle Training from InterTrain SPAM

Title: FW: Oracle Training from InterTrain SPAM Anyone else get this spam?  -Original Message- From:   Cindy Connors [SMTP:[EMAIL PROTECTED]] Sent:   Friday, October 26, 2001 6:47 PM To: Bambi Bellows; Brian Norrell; Charlie Mengler; Cherie Machler; Chris Guidry; Danny Hughes; D

Re:SAP and Oracle

Kimberley, I believe you are correct. PeopleSoft does not either, although they will for an added premium which is above & beyond Oracle's licensing. Dick Goulet Reply Separator Author: Kimberly Smith <[EMAIL PROTECTED]> Date: 10/26/2001 12:35

Re: Execution time for export/import vs. alter table move tablespace command

you can tweak export import better i feel as "move" does not give you too many options. we recently did a export of ~60Gb that took us about 45 minutes to complete. This speed was mainly due to hacking of parameters like buffer etc. however this was on a high end sun box(not 10K) .. ymmv Deepak

RE: pl/sql cd bookshelf book

Title: pl/sql cd bookshelf book Yes and yes.  -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: pl/sql cd bookshelf book Hello all, Does anyone have this book?  It says i

SAP and Oracle

Does anyone know if we need to buy our licenses separate for Oracle when using SAP? Sometimes, when a vendor product runs on top of a database they supply that but I do not think SAP is one. Thanks a head of time. Kimberly Smith GMD Fujitsu Database Ad

Re: backup of large databases

We use rman with veritas netbackup. generally schedule backup everyday .. (incremental) and weekly full backups .. backups run in night time and pump data into tapes located on east for databases located in east coast data center and tape libraries on west for other set of db's located in west da

RE: backup of large databases

Ed, We have a 550Gb database which we backup nightly via a disk mirror set split.  The mirror set is then mounted on our failover/reporting hardward and written to tape.  Archived redo logs are written to tape twice daily and kept on disk for 3 days.   8063 on Compaq Tru64   Mike Hand Pola

pl/sql cd bookshelf book

Title: pl/sql cd bookshelf book Hello all, Does anyone have this book?  It says it has the entire PL/SQL Programming Book on it but it doesn't say if it's specifically Feuerstein's book, either on Amazon or on O'Reilly's site.  Can anyone confirm that it is Feuerstein's book? Thanks Lis

RE: Java in the database

Christopher-   Do you have first-hand experience with the performance of Orion, either within iAS or as a stand-alone servlet engine?  The '5x faster' seems to come from an Oracle source, which I suspect is referring to Java stored and executed within Oracle.  I'm not sure whether Orion as a

Re: backup of large databases

We are using RMAN with EDM doing BCV copy of the database. >>> [EMAIL PROTECTED] 10/26/01 02:51PM >>> Hello, I'm curious how people handle the backups for large/very large databases; 200gb or greater. My questions are not targeted towards any specific hardware platform, but

RE: OMW

Contact Oracle Migration Workbench Support [[EMAIL PROTECTED]]. They were very helpful to me on my conversion from MS SQL Server to Oracle. -Original Message- Sent: Friday, October 26, 2001 3:00 PM To: Multiple recipients of list ORACLE-L Hi all: I'm having problems using OMW to migra

RE: Execution time for export/import vs. alter table move tablesp

Just listened to a talk by Kevin Loney (noted Oracle author). Table-table data movement (alter table move) is the fastest way to move data in Oracle. How much faster depends on your system. My experience says twice as fast is a safe guess. Cost justifying an upgrade?? What ogres do you work for? D

OMW

Hi all: I'm having problems using OMW to migrate from mysql to Oracle8i. If a date field in mysql database has a default date, OMW doesn't seem to add the to_date to convert to date from character. Also the numbers are being converted to oracle numbers with precision 250 which is higher than max

Execution time for export/import vs. alter table move tablespace command

I am doing a cost justification for upgrading a data warehouse from 8.0.4 to 8.1.7. I need to submit it today and don't have time to do a test on a very large table. Does anyone have anecdotal evidence or experience in the time difference required to reorg a tablespace using the export/import t

Re: event= to capture deadlock debug info

Hello, I am facing a similar situation which occurs sometimes. We have some clients who either due to power or network problems drop their connections. The problem is that once this happens other clients also have problems in accessing the particular tables. There are no ORA-600 nor trace files

RE: backup of large databases

150-gig. Cold backups weekly, archivelog. Uncomfortable with that. Moving toward RMAN and Veritas for tape. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 26, 2001 1:51 PM To: Multiple recipients of list ORACLE-L Hello, I'm curious

RE: Hiding tkprof password from ps -ef

Title: RE: Hiding tkprof password from ps -ef Ah, thanks for the reminder Mladen. -Original Message- From:   Gogala, Mladen [SMTP:[EMAIL PROTECTED]] Sent:   Friday, October 26, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Hiding tkprof password from p

8.1.7.2 and AQ

Just a FYI, For anyone who is going to patch to 8.1.7.2 and are using AQ should check out Note 151613.1. Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S

RE: Java in the database

feels good to be re-assured .. even if its a friday. anyways with the .com bubble burst, java seems back in the coffe pot for now at least. hope pl/sql is around too; Deepak --- Christopher Spence <[EMAIL PROTECTED]> wrote: > Actually I believe it will be, in 9i they clearly > made some improv

Re: backup of large databases

Ed, We have a 180 Gig database on Sun Solaris 2.6, version 8.0.4 of Oracle. We use RMAN and Veritas to back up to tape. Archiving is turned on. Full hot backups are done once a week. Incremental backups are done at mid-week. It takes about eight hours to do the full backup to tape. We used

Re: v$sql and v$sqlarea

check out V$FIXED_VIEW_DEFINITION --- Greg Moore <[EMAIL PROTECTED]> wrote: > I want to understand the difference between v$sql > and v$sqlarea. Apparently > they are both views of the same x$ table. Does > anyone know where I can view > the code that creates these two views? > > Thanks. >

RE: Java in the database

In a recent class, the instructor mentioned that since JAVA came into picture, there is an internal race between pl/sql team and java team. One example of that can be seen at pl/sql native compilation facility. He said, there is more to come. So don't throw away your pl/sql knowledge, it's in for

RE: v$sql and v$sqlarea

Title: RE: v$sql and v$sqlarea > -Original Message- > From: Greg Moore [mailto:[EMAIL PROTECTED]] > > I want to understand the difference between v$sql and > v$sqlarea.  Apparently > they are both views of the same x$ table.  Does anyone know > where I can view > the code that creat

RE: Java in the database

Actually I believe it will be, in 9i they clearly made some improvements (very notable ones) in PL/SQL. I would suspect it will be around for a while. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Dead connection detection(DCD)

Hi I found some of when client reboot or application server reboot the connection with DB still available at DB end. I want to implement SQLNET.EXPIRE_TIME=10 value at DB server .Please help me to clarify following query a)What will be effect to create sqlnet.ora file on solaris DB SERVER box if

RE: Hiding tkprof password from ps -ef

Well, Lisa, you're forgetting that some shells leave history of commands in files like $HOME/.sh_history and that username and password can be pisked up from there. -Original Message- Sent: Friday, October 26, 2001 2:26 PM To: Multiple recipients of list ORACLE-L John, it runs so fas

backup of large databases

Hello,     I'm curious how people handle the backups for     large/very large databases; 200gb or greater.       My questions are not targeted towards any     specific hardware platform, but we are using     Oracle 8.1.7. I'm assuming that archiving is enabled.   Are backups done

RE: Java in the database

Take a look at OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than Web Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core now.     "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them,

RE: Java in the database

So a huge Trading exchange written in Perl? Not sure about that. Perl is cool, but I couldn't see it used for everything. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Orac

RE: Hiding tkprof password from ps -ef

Title: RE: Hiding tkprof password from ps -ef never been responsible for a fully sphincter-ized system, eh Lisa?   Love the sig, btw!     bona fide oracle question:   anyone personally using a doc scanner and InterMedia to manage their tech data? -Original Message-From: Koivu,

v$sql and v$sqlarea

I want to understand the difference between v$sql and v$sqlarea. Apparently they are both views of the same x$ table. Does anyone know where I can view the code that creates these two views? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET:

RE: Hiding tkprof password from ps -ef

Title: RE: Hiding tkprof password from ps -ef John, it runs so fast, isn't this overkill?  Just curious.  Of course I have never been responsible for a system that had anal-type security implemented, either. Lisa Koivu Oracle Database Potato currently in Replication Mode. Fairfield Resorts,

Re: date format in ksh

date +%d-%b-%Y man date. You may have to look at the man page on a system with more recent documentation, such as linux. The man page on Solaris is incomplete. JARed

RE: INITRANS storage parameter

We had no negative impact from those blocks left with initrans=1. And it truely did stop our locks. I hope it works for you as well. Kevin -Original Message- Sent: Friday, October 26, 2001 11:32 AM To: 'Kevin Lange '; 'Multiple recipients of list ORACLE-L ' So the existing data blo

Re: Java in the database

I don't know details about Oracle App server 'cause I'm no Java freak :-) I have purchased Oracle 9i App Server v.1.0.2.1 for developing and our developers told me don't purchase Oracle App Server for production, because it's Apache with Tomcat and we are not using special features of OAS. I ha

Re: ORACLE-L Digest -- Volume 2001, Number 299

sorry if this is a duplicate ORACLE-L Digest -- Volume 2001, Number 299 > > -Original Message- > > Sent: Thursday, October 25, 2001 10:25 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Are there any issues with Oracle that I should know about when the > > clocks roll back t

Re: Java in the database

Do you mean Oracle Database Cache? JP On Fri 26. October 2001 18:25, you wrote: > We have a production application using Tomcat and Oracle, but it's > primarily long-running "batch" processes with a small number of web users > (3-4). For the second phase, completed in a couple of weeks, we will

RE: INITRANS storage parameter

So the existing data blocks that were assigned to INITRANS=1 would not have any negative impact, right? Now I remember that was you had the problem and I read your note and kept for reference. Now I am facing the same problem. Thank you. Bing -Original Message- To: Multiple recipien

Re: Oracle Installer line mode

AFAIK you MUST use the Java Installer. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Daiminger, Helmut"

RE: ORA-04031, how to prevent fragmentation?

Regarding flushing the shared pool... A couple of weeks ago I had hard copies of 2 Metalink docs side by side on my desk and I highlighted paragraphs on each which were completely contradictory. One said flushing did absolutely no good and the other said it could help. In practice it doesn't seem

RE: Unable to rebuild database from hot backup

Luckily I have never had this situation in production, and what I have read also suggests using the ascii file created from 'BACKUP CONTROLFILE TO TRACE' for recovery. I just had a little time on my hands and decided to give it a try. As I stated, I am by no means an expert in recovery (more lik

RE: i need check fragmentation of index

Watch out though!  From the 8.1.6 documentation:   "Validating the structure of an object prevents SELECT, INSERT, UPDATE, and DELETEstatements from concurrently accessing the object. Therefore, do not use this clause on thetables, clusters, and indexes of your production applications during

Re: Java in the database

Jan- Please do let us know how you do with 500 users. "Oracle App Server = Apache + Tomcat" Is this true?  I know that "Oracle HTTP Server" (ha ha) is basically Apache.  And I know that the Oracle Jserver was basically the Jserv precursor to Tomcat.  But I thought 8.1.7 and 9i came with a new

RE: URGENT -- db already exist ???

I've found having Oracle\bin in your environment path will prevent you from deleting some .DLLs. Remove it and reboot. -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -Original Message- > From: Igor Neyman [

RE: Hiding tkprof password from ps -ef

Simple. USe OPS$ account. -Original Message- Sent: Friday, October 26, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Now we have identified how to call sqlloader and sqlplus without showing the password on a ps -ef anybody know how to do it for a tkprof run? John O

RE: Instance Name in Sql Prompt

Now it works correct for the both cases, Thanks, that's what I was looking for, Gracias, Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de [EMAIL PROTECTED] Enviado el: Friday, 26

Re: Java in the database

We have a production application using Tomcat and Oracle, but it's primarily long-running "batch" processes with a small number of web users (3-4). For the second phase, completed in a couple of weeks, we will have 200-300 users but they will be doing light work with displaying a simple report sc

cleaning up the OEM 2.2 repository

How often have you had to de-register all events, remove all nodes, shut down the OMS, re-start the OMS, and then rediscover all nodes? Or rebuild the repository? I received a parent key violation error this time, asked Oracle Support if I could just go into the child table to delete the bad reco

RE: Java in the database

Thanks Jan, I was just curious because here, we are using PL/SQL and the New Features course for 8i made such a big deal out of Java in the database. I took the course when 8.1.5. had been released and no patches were yet available. I don't know how the economic slump will affect "new" projects

Hiding tkprof password from ps -ef

Title: Hiding tkprof password from ps -ef Now we have identified how to call sqlloader and sqlplus without showing the password on a ps -ef anybody know how to do it for a tkprof run? John Oracle DBA BTcellnet * [EMAIL PROTECTED] ( 0113 388 6062    Desk ) 07713 066194  BT Mobile **

RE: Database link in the same DB

Title: RE: Database link in the same DB Lisa, I can't remember the details off hand (need to dig up some old notes), but I believe I have done something like this to help deal with private database links on an import. Objects with private database links imbedded in them are a big mess on imp

Re: Java in the database

Hi, as far as you only use servlets and jsp, both Oracle and IBM took a very close look at Apache + Tomcat. Websphere is basically "Apache" inside, just like OAS. bye, Stefan Jan Pruner schrieb: > :-) > Wait 2 weeks and I will tell you how is it running up to 500 people. > > "Oracle and BEA wh

RE: Unable to rebuild database from hot backup

Is this recovery method valid? The loss of controlfiles is supposed to be recovered using the trace file generated from a previous BACKUP CONTROLFILE TO TRACE, isn't it? At least according to the Oracle8 Backup and Recovery class it is. The part that concerns me is that you are recovering using

RE: Concealing SQL Loader password from ps -ef

Here's how to do it from a UNIX script for SQL*Plus: sqlplus -s /nolog< @calanais.comcc: >Subject: RE: Concealing SQL Loader password Sent by: rootfrom ps -ef 10/26/

Re: Java in the database

:-) Wait 2 weeks and I will tell you how is it running up to 500 people. "Oracle and BEA who have a nice little Java engine to sell you " It has only other product name, but inside is it the same Oracle App Server = Apache + Tomcat JP On Fri 26. October 2001 15:50, you wrote: > Jan- > > I've h

Re: Monitoring Tool with a difference

Anything against using statspack ? hth connor --- Denham Eva <[EMAIL PROTECTED]> wrote: > Hi Gurus, > > Ok, I urgently require recommendations for software > which can monitor a > Oracle Database for a 24Hr period and create > a report on the health of the system. > Please if anyone has used

Re: URGENT -- db already exist ???

Small addition to the instruction below: Sometimes, when trying to delete Oracle home directory (say D:\Ora8i), you may get an error, saying "could not delete" some oracle .dll (don't remember the exact name) from d:\Ora8i\bin directory - file "is in use". This may happen, because MSDTC (Microsof

[Q] how to check ORACLE SQL*NET client on NT/2000???

Does their has way on NT to check folowing ORACLE relate staff: 1. how many clients sql*net connection on server? (if my memory correct their has tool from NT resource kit can check threads, I forget the name.) 2. how to check each client connection memory usage? 3. how to check each cl

Re: [Q] what difference between count(0), count(1) and count(*)

>--- aaa aaa <[EMAIL PROTECTED]> wrote: >> Can anyone tell me what is difference between : >> >> select count(*) ... from .. >> >> select count(0) ... >> >> select coun (1) ... >> select count(2) ... For other insights take a look at http://www.oracledba.co.uk/tips/count_speed.htm There

Re: Java in the database

Jan-   I've heard some concerns about the scalability of Tomcat as an app server.  Of course, some of those concerns are voiced by guys like Oracle and BEA who have a nice little Java engine to sell you for $10-20K per CPU.  I know a lot of people use Tomcat for prototypes and such, then go

RE: Concealing SQL Loader password from ps -ef

Simplest way is not to enter the password on the same line with the userid. If you wait for SQLPlus to prompt you for the password, it doesn't show up with ps -ef. On the other hand, doing this in a script is more problematical. Anyone have any examples?

Re: Where 1 = 1

I've never used it with a monster query but I do use it's inverse all the time. Create table test1 as (select * from test2 where 1=0); This creates a copy of the structure of the original. Leave off the where and you also copy the data. Maybe they just want to make explicit that which is impli

RE: Unable to rebuild database from hot backup

Tim, > You can not simply cancel a "recover > database using backup > controlfile" since Oracle is expecting you perform a > complete recovery ( > since your not using the UNTIL CANCEL/TIME/CHANGE ) > and canceling a complete > recovery leaves the stop SCN in the controlfile at > infinity... The

negative value in v$shared_server

Title: negative value in v$shared_server Does Oracle still show negative numbers in some of the v$ tables if the values go above 2 billion in version 8.0.5?  (the old signed vs. unsigned 32 bit integer problem) I though they fixed all those issues in 7.3 or 8.0.3, but I'm getting reports of

RE: Where 1 = 1

thanks, you sparked my memory, I KNEW I'd seen it somewhere :) we had built a system where the users submitted the information they wanted to select on through a form and we dynamically built the sql statement. Since the program to build the statement always included WHERE, by hard-coding WHERE 1

Where is the debugger package in oracle 7 and how is it called?

Hi, we are using TOAD for debugging Oracle PL/SQL packages. I would like to ask if some one knows how to bringt TOAD to debug Oracle 7 PL/SQL packages. According to the Help it can do this, on the other hand I can not seem to find the dbms_debug package neigther in the database, nor in the orant\

Re: Oracle9i-Download

it may not be zipped -- just copy it to the name you want to use --- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> wrote: > Hi guru's > > anybody had an exp of downloading oracle 9i for nt/2000 from oracle > site? > > I downloaded 3 winzip files. But i'm not able open the 2nd zip file,

Re: ORA-04031, how to prevent fragmentation?

Hi, *Pin packages into the shared pool *enlarge the shared pool *flush the shared pool at regular intervals *use bind variables i.s.o hardcoded values or a combination of those Jack "Blum, Marc" <[EMAIL PROTECTED]>@fatcity.com on 26-10-2001 11:55:18 Please respond to [EMAIL PROTECTED]

Re: Java in the database

PL/SQL. Java code only on Tomcat-Jakarta (Apache). JP On Thu 25. October 2001 19:16, you wrote: > Out of curiosity, is anyone using the java engine for procedural code, or > are most people still using PL/SQL? > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Adm

Base table of materialized views

I have posed this question to Oracle support and have yet to receive an understandable answer, so I thought it best to ask the experts. I used to run under 8.1.5 with compatibility set to 8.0. Whenever I created a snapshot I had an underlying table snap$_ that was the physical table residing in

RE: ORA-04031, how to prevent fragmentation?

You can either issue an "alter system flush shared pool", or increase the value of your shared_pool_size. Another option would be to pin some or your most used/larger packeges in to your shared pool. HTH Mark -Original Message- Sent: Friday, October 26, 2001 10:55 To: Multiple recipient

  1   2   >