Re: Using RMAN

2002-01-16 Thread Nikunj Gupta
Hi, I am not sure... what your exactly plan to do... But, You can configure RMAN to backup on DISK and use some TAPE MANAGEMENT UTILITY or SYSTEM UTILITY (If it is there) to backup from your DISK. Also that utility can delete after successful backup from DISK to TAPE depending on configurati

Re: memory resource...

2002-01-16 Thread shuan
hi! john...   while i installed the first db, it only consumes 10,000~20,000K memory. after the error occurred(ORA-12638, which solved now), it becomes memory sucker. that's why i'm curious about it.   and..i'm learning oracle, so my pc will b quite slow if oracle consumes too many memory. an

RE: SAME, WAFL and RAID

2002-01-16 Thread C.S.Venkata Subramanian
May I please have a copy of this paper? Thanks >-Original Message- >Sent: Wednesday, January 16, 2002 00:38 >To: Multiple recipients of list ORACLE-L > > >Hi, > >WAFL is Write Anywhere File Layout... > >Its the file lay out used by snapshot supported storege Devices(NetApp >Storege Etc

RE: memory resource...

2002-01-16 Thread Suhen Pather
Shuan,       The oracle.exe process memory usage is dependant on the size of the SGA.     The difference in the memory used for each of the oracle.exe processes is due to the different SGA sizes.       Regards     $uhen   hi, DBAs...   i'

Re: memory resource...

2002-01-16 Thread orantdba
Hi Shuan, This has nothing to do with how your service is started and everything to do with the value of the initiazation paramaters that are used to start the database.  The simple answer is that you can get oracle to use less memory by reducing the value of these parameters.  The most likel

memory resource...

2002-01-16 Thread shuan
hi, DBAs...   i'm using Win2000 Advance Server, with Oracle Enterprise Edition 8.1.6. by using task manager, i found tat the ORACLE.EXE is using about 58,556K memory for one db, which is start manually. and ORACLE.EXE for another db is only about 10,000K, which is start automatically when serv

Re: RMAN backup and restore Q?

2002-01-16 Thread Sona
This error occurs when you are trying recovery on an open database.the database should be in MOUNT mode for recovery. Sona - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 4:25 AM > > Hi All, > > > I'm in the process o

Re: limit user CPU usage

2002-01-16 Thread Sona
Kevin, You can also use Resource manager to limit the CPU usage on certain user groups . It's pretty cool. HTH - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 1:42 PM > Thanks, Ron, I will try it. > > Kevin Wang > >

Re: Lookup Table Usage

2002-01-16 Thread Rachel Carmichael
you could turn auditing on on the table and count the number of times it was selected --- Whittle Jerome Contr NCI <[EMAIL PROTECTED]> wrote: > Hi, > > Oracle 7.3.4 on Unix. > > The database has dozens of little lookup tables. I'd like to cache > those > used the most. Is there a way to see ho

Re: Why doesn't Oracle kill dead connections?

2002-01-16 Thread Sona
But in my case if DCD is set up and the browser is closed will the web server know that the connection has been closed and will it tell Oracle to kill the session? TIA - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002

RE: mystery cartesian join

2002-01-16 Thread Khedr, Waleed
Did you try (only if you have it true on the system level): alter session set star_transformation_enabled = false -Original Message- Sent: Wednesday, January 16, 2002 3:52 PM To: Multiple recipients of list ORACLE-L Thanks for the insight. I will rewrite my query to not use the view a

RE: Partitions

2002-01-16 Thread Jack C. Applewhite
You asked which of two outcomes will occur if you partiton tables after development: 1. "...do we have to change the code for accessing diffrent partition..." or 2. "...this will handle by oracle itself." Of your two proposed outcomes, 1. is the former and 2. is the latter. Oracle will handle ac

RE: mystery cartesian join

2002-01-16 Thread Jared . Still
Star query uses it, but was not mentioned in the original post. The query in the original post also does not look like a star join to me. The following is also from MetaLink. Doing cartesian products is normal expected behavior from the CBO as it sometimes is cheaper (in CBO terms and also t

Using RMAN

2002-01-16 Thread Sona
Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to i

RE: How to calculate user load on the system

2002-01-16 Thread Aponte, Tony
Title: RE: How to calculate user load on the system Then you're in luck.  I'd recommend starting with Oracle Response Time Analysis from www.orapub.com.  Although it won't give you exactly what you need, it will help you get to the next step.  Once you understand a session's response time co

Re: Why doesn't Oracle kill dead connections?

2002-01-16 Thread Mogens Nørgaard
DCD was invented and implemented for 7.1 of Oracle because of the strange and wonderful handling of timeout stuff in Unix. Typically, it can take between 8 and 80 hours for Unix to discover that a session should be killed since it no longer has a connection to the Oracle database. The problem

Disaster recovery using RMAN

2002-01-16 Thread Sona
Hi Here in my company we are planning to put together a disaster recovery plan using RMAN would like to test various recovery scenarios using RMAN. Could anyone provide the information on the procedures followed in a testing like this? TIA

RE: Lookup Tables

2002-01-16 Thread DENNIS WILLIAMS
Hamid - Are these small tables? Have you considered caching them in memory using Oracle's KEEP pool? This may not be as pertinent to your immediate design as your other questions (like IOT), but it does bear on your question about putting them in a separate tablespace. If you cache them in memory,

RE: snapshot too old

2002-01-16 Thread Suhen Pather
Seema, The "ORA-1555 snapshot too old" occurs when export tries to construct a read consistent view of your data from rollback segments, which has been overwritten or reused for new transactions. Other sessions are updating data while the export is running in consistent mode (using consistent =

RE: How to calculate user load on the system

2002-01-16 Thread Aponte, Tony
Title: RE: How to calculate user load on the system Raj, sorry for me being confused.  Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)? Tony -Or

RE: How to calculate user load on the system

2002-01-16 Thread Jamadagni, Rajendra
Title: RE: How to calculate user load on the system Database Load ... is the main target at this time ...   Thanks Tony,   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed h

Re: Lookup Table Usage

2002-01-16 Thread Jared . Still
Use database auditing. Lookup 'audit' in the SQL manual. Jared "Whittle Jerome

RE: mystery cartesian join

2002-01-16 Thread Jared . Still
> Try putting in an ORDERED hint and see if that helps. Good call! The following link is a discussion of a similar nature, and the cartesian product was eliminated through the use of the 'ordered' hint. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_

Re: procedure error

2002-01-16 Thread Jared . Still
Peter, That won't work either. DROP and CREATE commands can only be executed in a procedure via dynamic SQL. Such as the older DBMS_SQL package, or the newer and much easier to use EXECUTE IMMEDIATE. Jared

RE: OT -: SQL BackTrack info

2002-01-16 Thread Jared . Still
Ok, you guys are really missing the support issue. :) The support is very bad. Yes, you don't need it often. But when you do need it, they don't have it. SQL*Backtrack is normally run as a menu to the back end tools. As I recall, even most of the commands used in cron for scheduled backups

RE: mystery cartesian join

2002-01-16 Thread Jared . Still
Thanks for the explanation Kevin. I was obviously to lazy to RTFM on that. :) As for the joins, I would still verify that those are being done correctly when joining views. Jared

RE: How to calculate user load on the system

2002-01-16 Thread Jamadagni, Rajendra
Thanks Dennis, Ian, Yes, that is another approach ... right now I am looking at what I can do within Oracle. As for DB links, very little stuff goes across for this application, so would not be a bottleneck right now. Raj __ Rajendra Jamadagni

Lookup Tables

2002-01-16 Thread Hamid Alavi
I have about 50 lookup tables in my database(we are in the middle of design) just want to check with you guys if define all these lookup as IOT is there any advantage also do I have to put all the Primary Key for these lookup tables in separate Tablespace or NOT? asking for performance issue durin

Re: snapshot too old

2002-01-16 Thread Marin Dimitrov
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 23:55 > > Hi > At time of export i am getting following error > "EXP-8: ORACLE error 1555 encountered > ORA-01555: snapshot too old: rollback segment number 6 with n

RE: procedure error

2002-01-16 Thread Jamadagni, Rajendra
DROP and CREATE are DDL functions ... you have to use DBMS_SQL package or Native Dynamic SQL (execute immediate) statement to achieve this.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any

RE: Lookup Table Usage

2002-01-16 Thread DENNIS WILLIAMS
Jerry - If they are stored in separate tablespaces, it would be easy. However, we DBAs tend to not keep small code tables in separate tablespaces. You can dump v$sqltext to an O.S. file and search for these table names to get an idea of how often they are used. On Unix, for example, grep can tell

Re: procedure error

2002-01-16 Thread Peter . McLarty
try changing CREATE OR REPLACE PROCEDURE Primus_Report AS Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP  to CREATE OR REPLACE PROCEDURE Primus_Report AS BEGIN Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP -- = Peter M

RE: Partitions

2002-01-16 Thread Hamid Alavi
what do you mean the latter Jack -Original Message- Sent: Wednesday, January 16, 2002 2:00 PM To: Multiple recipients of list ORACLE-L The latter. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Tex

FW: Oracle Un@@#Breakable

2002-01-16 Thread Jamadagni, Rajendra
It depends on what the meaning of the word unbreakable is ... Check http://www.securityfocus.com/news/309 > HTH > Raj > __ > Rajendra JamadagniMIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is p

RE: How to calculate user load on the system

2002-01-16 Thread DENNIS WILLIAMS
Raj - I don't know DGUX, but if the users each have their own system login, the system administrator may be able to help. With forms, that may not help. >From my experience, there isn't any ready way within Oracle. Another idea might be to sample the system load and number of users for eac

RE: How to calculate user load on the system

2002-01-16 Thread MacGregor, Ian A.
Take a look at V$SYSSTAT. I'm not sure if it's the answer because your question specifies a set of users. V$SYSSTAT includes all users not just a particular set. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002

RE: procedure error

2002-01-16 Thread Bala, Prakash
You need to use 'Dynamic SQL' in order to drop and create tables. -Original Message-From: Lance Prais [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: procedure error Why in toad when I try

Freeable memory

2002-01-16 Thread Michael Ghelli
All, In trying to solve some Library Cache latch contention issues, I've been stumped on the following issues: 1) Do freeable chunks get coalesced during an ALTER SYSTEM FLUSH SHARED_POOL. 2) If freeable chunks are freed when a session disconnects, is there a way to determine chunks per ses

procedure error

2002-01-16 Thread Lance Prais
Why in toad when I try to create a stored proc where I drop and create a table I get the following error:    PLS-00103: Encountered the symbol "DROP" when expecting one of the following:    begin function package pragma procedure subtype type use   cur     Here i

Re: designer6i vs. designer2000

2002-01-16 Thread Eric D. Pierce
http://www.oracle.com/corporate/investor_relations/news/index.html?history.html "1993 Moves character mode applications to the client/server model " (free registration required:) http://otn.oracle.com/products/designer/pdf/50426.pdf - http://otn.oracle.com

snapshot too old

2002-01-16 Thread Seema Singh
Hi At time of export i am getting following error "EXP-8: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 6 with name "R03" too small" Please suggest Thanks -Seema _ Chat with friends online

RE: Partitions

2002-01-16 Thread Jack C. Applewhite
The latter. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, January 16, 2002 3:07 PM To: Multiple recipients o

RE: How to calculate user load on the system

2002-01-16 Thread Jamadagni, Rajendra
Dennis, Actually we have N users on the system where N is a variable. Of that I have a certain group of users, I need to monitor and see how much load they put on the system. The idea is out on N total users on the system, X number of users use only one part of application 95% of the time (becau

Lookup Table Usage

2002-01-16 Thread Whittle Jerome Contr NCI
Hi, Oracle 7.3.4 on Unix. The database has dozens of little lookup tables. I'd like to cache those used the most. Is there a way to see how often a table is queried? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-

Partitions

2002-01-16 Thread Hamid Alavi
List, If we use partitioning for a big tables after finish development, do we have to change the code for accessing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments

RE: How to calculate user load on the system

2002-01-16 Thread DENNIS WILLIAMS
Raj - I found your question a bit unclear. Did you mean: - For 10 users, our application requires 50% of a 300-mhz CPU - There are two groups of users on the system. How do I figure out how many resources group A would use. I just thought you might get better assistance by clarifying your questi

RE: mystery cartesian join

2002-01-16 Thread Kempf, Reed
Thanks for the insight. I will rewrite my query to not use the view and see if the optimizer is more friendly with the execution plan. Thanks also to SteveO for the rewrite idea. ReedK DBA from Montana -Original Message- Sent: Wednesday, January 16, 2002 1:04 PM To: Multiple recipients

Re: Which Character set?

2002-01-16 Thread Cherie_Machler
Ron, Thanks for taking time to provide this detailed reply. It is quite helpful. Cherie Machler Gelco Information Network "Ron Thomas"

RE: OT -: SQL BackTrack info

2002-01-16 Thread Valuthur, Srikanth
Its a great product for the price. I have used it in and out for 5 years internationally and truly it is the best backup/recovery product we have. There are some pros and cons to using the tool: Pros: 1. Great product, works brilliant & works all the time. 2. Upgrades are simple. Cons: 1. Pr

RE: mystery cartesian join

2002-01-16 Thread Khedr, Waleed
Hey guys you have not heard about STAR SCHEMA execution plan? -Original Message- Sent: Wednesday, January 16, 2002 1:48 PM To: Multiple recipients of list ORACLE-L This may be a STAR schema execution plan where Oracle joins dimensions and use Nested loop + index to join it to the fact.

How to calculate user load on the system

2002-01-16 Thread Jamadagni, Rajendra
Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ... I have been asked a simple question, and I am stumped ... Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Form

RE: Using procedures instead of coding update/insert

2002-01-16 Thread Rakesh Gupta
That was me who made that statement about prepared statements being faster than stored procedures. It was not a general statement.. As my e-mail states, we have done some testing. Our test included inserts into more than 10 different tables on different system configurations (Sparc solaris-E-45

RE: Raw I/O

2002-01-16 Thread Martin Kendall
Hey now, be nice :-). The best thing is to point people towards the archives. Martin http://oracle-rescue.com -Original Message- Mladen Sent: 16 January 2002 19:57 To: Multiple recipients of list ORACLE-L Real life opinion from me: Yes, Oxford is using it. Yes, it is faster. Yes it m

RE: Which Character set?

2002-01-16 Thread Martin Kendall
There is also a problem with 8.0.5 Client software not being "happy" with the ISO8859 part 15 characterset. The symptoms are that of either not displaying certain characters or displaying spurious chars (whatever is in the given code page for the given value from the database...) The only thing

Database Views

2002-01-16 Thread SRAJENDRAN
I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called

RE: mystery cartesian join

2002-01-16 Thread Toepke, Kevin M
A MERGE CARTESIAN JOIN is one of the new paths the optimizer can take in Oracle 8(i?) If you really, truely are not missing a join clause, the following may be what is happening Basically, what Oracle does is perform a cartesian product (CT) on 2 tables via a merge-join operation. Generally

RE: mystery cartesian join

2002-01-16 Thread Thomas Jeff
Title: RE: mystery cartesian join Maybe the optimizer thinks there's a many-to-many relationship between si_log and sm_monitor?   Try putting in an ORDERED hint and see if that helps. Jeff T. -Original Message- From: Kempf, Reed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January

RE: Raw I/O

2002-01-16 Thread Gogala, Mladen
Real life opinion from me: Yes, Oxford is using it. Yes, it is faster. Yes it makes it practically impossible to backup without a 3rd party backup tool. Yes, it is boring to chew "raw vs. cooked" debate over and over again. Why doesn't someone come up with something new and not yet discussed topi

Re: Which Character set?

2002-01-16 Thread Ron Thomas
Given- - Oracle Applications 11.5.4 - HPUX 11.0 - Support for English, Brazilian Portuguese, and Simplied Chinese required UTF8 - DB, forms, reports, and Apache servers all run with NLS_LANG=American_America.UTF8 Problems- - Any Oracle reports generated require printing via a utility called past

RE: Which Character set?

2002-01-16 Thread Thomas Jeff
Title: RE: Which Character set? I'd like to know about these pains also, as we are using UTF8 on all our AIX 4.3.3, 8.1.7.0 e-commerce databases w/o any major problems; all of which were converted from WE8ISO8859P1.   The only problem we've really encountered thus far is a compatibility issu

RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-16 Thread Deshpande, Kirti
Chris, You should see the waits in V$SESSION_EVENT as well, as these are rolled in to the V$SYSTEM_EVENT. You have to query V$SESSION_EVENT when these thread are active. And you will have to query it repeatedly as it reports waits as and when session encounters some. I would also consider the im

Raw I/O

2002-01-16 Thread Witold Iwaniec
Hi all I am looking for some "real life" opinions about Oracle raw I/O - are people using it, is there really a performance gain? Any other pros, cons? I have seen some info on Metalink but "real life" often is quite different... Thanks Witold == Witold Iwanie

RE: mystery cartesian join

2002-01-16 Thread Kempf, Reed
Here is the structure of the underlying base table si_log table. I also do not know what a "MERGE CARTESIAN JOIN" is. The data returned is correct and the tkprof output looks OK except for the elapsed time the query took and the cartesian join portion. desc si_log Name

RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-16 Thread Nick Wagner
Title: RE: How to set DBWR_WRITE_PROCESSES in Oracle8i? Since I didn't see this yet, I thought I might add it in.  Try increasing the PCTFREE, perhaps there are two many transactions happening in the same block, and oracle is locking the entire block until the other transaction if finished

RE: mystery cartesian join

2002-01-16 Thread Mercadante, Thomas F
Reed, What is the structure of the SI_LOG table (the one being accessed by the view). Furthermore, what is a "MERGE JOIN CARTESIAN" - anybody? I am thinking that this is normal, in that the query was broken up into two distinct parts, and the results of those parts should be "MERGE JOIN CARTESI

RE: OT -: SQL BackTrack info

2002-01-16 Thread Smith, Ron L.
We have been using it for about 5 years on both Unix and NT. We have it connected to Netbackup to handle the tapes. We love it. I agree that the support is not what it used to be but we hardly ever need support. Although, the last time we called we got a support person that knew more about Ora

Re: FW: new to DBA

2002-01-16 Thread Eric D. Pierce
*warning* if using the following material on human subjects, do not get in ears of damagers, they are usually already obstructed beyond repair, but in case some use of the ears can be redeemed, the use of said product would simply make the effort to get damagement to "listen" all that much harder

Re: Which Character set?

2002-01-16 Thread Cherie_Machler
Ron, Can you elaborate on the "pains" you are having getting UTF8 working correctly? We are preparing to convert some databases to UTF8. I'd appreciate any specific details that you can provide. We are using 8.1.7.2 and 9.0.1 on Sun Solaris 2.6. Cherie Machler Oracle DBA Gelco Information N

RE: mystery cartesian join

2002-01-16 Thread Khedr, Waleed
This may be a STAR schema execution plan where Oracle joins dimensions and use Nested loop + index to join it to the fact. Some times it's very efficient but if you do not like it I think there is a parameter in init.ora that disables it. Regards, Waleed -Original Message- Sent: Wednes

RE: mystery cartesian join

2002-01-16 Thread Jon Baker
Title: RE: mystery cartesian join are the joins themselves correct? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: mystery cartesian join It's impossible to p

RE: How to set DBWR_WRITE_PROCESSES in Oracle8i?

2002-01-16 Thread CC Harvest
Thanks Kirti and Paul for the reply. The instance is up for only 3 days. We know there are very heavy inserts in the database. Yes, There are high waits for 'buffer busy waits' event in V$SYSTEM_EVENT view. But I didn't see 'buffer busy waits' in V$SESSION_EVENT. I may try to increase the freeli

RE: Re: Which Character set?

2002-01-16 Thread Jim Hawkins
We use WE8ISO8859P1 as a corporate standard for all databases globally with no problem. Haven't tried UTF8 yet though. Jim "Ron Thomas" <[EMAIL PROTECTED]> wrote: > >Unless you have the need to support other languages other than English or need to >support characters >like the Euro, don't bo

RE: mystery cartesian join

2002-01-16 Thread Jared . Still
Reed, Please reply to the list as well. I don't seen any key information here. And taking a closer I caught the part about this join being done on views. Joining views can be problemetic. You need to ensure that the joins in a view ( if any ) are correct, and that all columns of the primary

Re: call vs execute - stored procedures

2002-01-16 Thread Jared . Still
Glenn, I believe that CALL needs to be terminated with a semicolon. Jared Glenn Stauffer

RE: designer6i vs. designer2000

2002-01-16 Thread Jared . Still
And interestingly enough, a DBA could be much more productive with CASE 5.1 and Forms 3 than would ever be possible on the GUI versions. Jared "Kimberly

Re: mystery cartesian join

2002-01-16 Thread Jared . Still
It's impossible to precisely determine where the cartesian product is coming from with out knowing the primary keys of the si_monitor and sm_log_type slt tables. If your join does not include all columns of the parent table(s), there is the possibility of a cartesian product. ( it's data dependa

Re: OT -: SQL BackTrack info

2002-01-16 Thread Jared . Still
It was a good product when owned by Data Tools. It is now owned by BMC, and the support is poor. My experience with this tool is as of December 2000. As far as object extraction, it did not work as of December of 2000. They had been claiming that it would for some time, but the DBA in charge

Re: Which Character set?

2002-01-16 Thread Ron Thomas
Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers

OT -: SQL BackTrack info

2002-01-16 Thread Gautam_Reddy
Title: Message I am looking for some guidance from people who use this product. Is it a value add to the organization or not. If possible also let me know how in the hell does it do a online object extraction from the backup.   Would appreciate all your comments and recommendations   Thx G

call vs execute - stored procedures

2002-01-16 Thread Glenn Stauffer
I am working up a script to run the dbms_stats.gather_database_stats() procedure and have run into something for which I haven't yet found an explanation. Maybe someone here can tell me why I can run dbms_stats.gather_database_stats from Python like this (Perl would be similar, I believe, sinc

RE: Calling a procedure from a procedure

2002-01-16 Thread Todd Carlson
Don’t use the execute. Primus_Dump_TEST_2(Solution);     Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Lance Prais Sent: Wednesday, January 16, 2002 9:57

Re: SQL Loader Direct Load - Problem with Index Rebuild

2002-01-16 Thread Ron Rogers
Jay, Had the same problem when I used a script during the move of data. A look at the database tablespaces and indexes showed that the indexes all resided in TEMP and were not perminently written into the designed tablespace before the next partition started. The TEMP filled and the remaining inde

RE: Calling a procedure from a procedure

2002-01-16 Thread Bala, Prakash
Lance, just remove the word 'execute' -Original Message-From: Lance Prais [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002 10:57 AMTo: Multiple recipients of list ORACLE-LSubject: Calling a procedure from a procedure I need to execute a procedure with in a lo

Re: Calling a procedure from a procedure

2002-01-16 Thread Rachel Carmichael
I believe you don't need the "execute" within pl/sql --- Lance Prais <[EMAIL PROTECTED]> wrote: > I need to execute a procedure with in a loop of another. I need to > pass a > variable to the second procedure. I am using Execute, looks like > this: > Execute Primus_Dump_TEST_2(Solution); > > G

mystery cartesian join

2002-01-16 Thread Kempf, Reed
Hello gurus, I have a query which seems to have a mystery cartesian join in it and I can't seem to locate it. I would definitely appreciate some help if possible. My view doesn't have a join associated with it and it appears that I have the correct number of joins for the number of tables I am

Calling a procedure from a procedure

2002-01-16 Thread Lance Prais
I need to execute a procedure with in a loop of another.  I need to pass a variable to the second procedure.  I am using Execute, looks like this:Execute Primus_Dump_TEST_2(Solution);   Getting this error:PLS-00103: Encountered the symbol "PRIMUS_DUMP_TEST_2" when expecting one of the foll

RE: Reporting database with Time Finder

2002-01-16 Thread peter . lomax
Sonja, that is a very interesting question. I have tested the source/target scenario under Digital Unix. We did come across a command that allowed you to mount the devices with the same name on the same server with a mount /ignore(?). There may well be a ruse to rename the whole battle ship. It b

RE: RE : Table partition on part of a field

2002-01-16 Thread Ball, Terry
One thing to consider is adding a field to the table for the three positions and have a trigger fire to insert the substr from the other field. It will slow things down, but would give you the field needed to do the partioning. Terry > -Original Message- > From: [EMAIL PROTECTED] [mailt

RE: Calling a procedure from a procedure

2002-01-16 Thread Karniotis, Stephen
Remove the word execute.  Within PL/SQL you do not need EXECUTE.  That is a SQL*Plus command.   Thank You   Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct:  (248) 865-4350 Mobile:  (248) 408-2918 Email: [EMAIL PROTECTED] W

RE: Oracle Performance monitoring tools.

2002-01-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: Oracle Performance monitoring tools. What's the current price tag of Quest's Spotlight? Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer:  "Let the programmers by many and the managers few, Then all will be productive"  - The Tao of Programming

Which Character set?

2002-01-16 Thread Smith, Ron L.
I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? Ron Smith -- P

Reporting database with Time Finder

2002-01-16 Thread Sonja Šehović
Hi! Oracle 8.1.7 on AIX, on EMC discs boxes which are synchronized with SRDF. At the target site, we have BCV volumes. We want to open reporting database on a daily basis. Now we can open target database with the same AIX volume group as the primary database. My question is do you have experience

SQL Loader Direct Load - Problem with Index Rebuild

2002-01-16 Thread Miller, Jay
Hi, Okay, this is the second time this has happened and while I have a guess I'd appreciate any feedback on the issue. Last night during a direct load to one of our datawarehouse tables 4 of the index partition rebuilds failed with the following errors (the remaining partitions were fine, as wer

Re:RE: Why doesn't Oracle kill dead connections?

2002-01-16 Thread dgoulet
Question 1 is how long does the report take to run? If you have DCD set up with a time-out of 1 second your network is going to take a heck of a hit just from probe packets. The most common setting I've run into is 15 to 30 minutes so that does not help. Setting up a profile for the Internet us

Forms hint text font size

2002-01-16 Thread Boivin, Patrice J
Is there a way to specify a custom font size for Forms 6i hint text associated with a field? I notice that it is possible for ToolTips, but not for Hint Text. I just posted to the ODTUG listserv but usually they reject my e-mails because I am not a member. Regards, Patrice Boivin Systems Analys

RE: Oracle 8.1.7 install error

2002-01-16 Thread Seefelt, Beth
I get a lot of those when installing on NT. I usually go into explorer, rename the existing file to .old and hit Retry and the install continues on. Sometimes that won't work if the file is truly locked by another process. In that case you have to find who has locked the file. I use the Handle

RE: designer6i vs. designer2000

2002-01-16 Thread Kimberly Smith
They are just different tools of the same product and not one I would choose to learn if all I wanted to learn was data modeling. It is a tool that is best used for the complete life cycle, from process modeling, all the way to generating your code. Unless you are committed to doing that (with ma

Re: Oracle 8.1.7 install error

2002-01-16 Thread Ron Rogers
Ron, Does the dll already exist from a prior install failure? If it is NOT an NT dll then move it to another location and try the install again. Check the permissions and ownership on the file and make sure that you can overwrite it. Ron, ROR mª¿ªm >>> [EMAIL PROTECTED] 01/16/02 09:10AM >>> I kee

RE: designer6i vs. designer2000

2002-01-16 Thread Szecsy Tamas
Designer 4 is here since some monthes, you have to download patch 4a from metalink. Tamas Szecsy -Original Message- Sent: Wednesday, January 16, 2002 14:45 To: Multiple recipients of list ORACLE-L Alas, the last time I looked, the OTN download for Designer was missing. The latest is De

RE: Why doesn't Oracle kill dead connections?

2002-01-16 Thread Karniotis, Stephen
Much of this is controlled through Oracle’s SQL*Net product.  It needs to be configured.  It also depends on what version of the database you are using.  Oracle8.0/8i and beyond have mechanisms called profiles (oracle7 had them as well but didn’t work well) that can assist in dead connecti

  1   2   >