RE: Auto Extend

By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if

RE: Rebuilding indexes

Jeremiah, Thanks -- I knew someone would know better than me how to do this! Another post to save for when I get to have a standby db again :) Rachel From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE:

RE: Auto Extend

On our old AIX system we had to set a system parameter for the file system that allowed us to have files bigger than 2 GB. I do not know if your system has something like that. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you

Re: OT: Archiving not possible with SQL Server?

You mean like the programmers of the Oracle Applications? What would we need for that, a missile? (What kills me is that, they don't use declared foreign key constraints in the database. Presumably, since the code base is so old, if they introduced them now everything would break. You'd

Re: Re[2]: 4 join methods?

On Thursday 31 May 2001 06:41, [EMAIL PROTECTED] wrote: I wonder if their thinking of the star join?? Dick Goulet Isn't that actually just a sort merge? Just guessing here, didn't RTFM. No flames please! :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: OT: Archiving not possible with SQL Server?

Title: RE: OT: Archiving not possible with SQL Server? I protest Jared's removal from the list for telling jokes! Henry please reconsider! :) --Chris [EMAIL PROTECTED] -Original Message- From: Gary Weber [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 4:50 PM To:

OT: web page counter needed

Hello, sorry for this OFF-OFF-OFF... topic question. I'm looking for a counter which counts all visited pages, not just current page visited. thanks... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED]

RE: TOAD v/s PL/SQL Developer

There is a massive concern here about the cost of Toad. Since it is so high we have been forced to get only a few licenses only give it to the most prolific users. This is the pits ! If you have an alternative I would ABSOLUTELY APPRECIATE any information you have on it !! Kevin

RE: Auto Extend

OK .. Never is a harsh word.Depending on your environment and in my opinion based on the environments I was in I still say never. -Original Message- Sent: Thursday, May 31, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Never say never :) I opted for 4 GB files

RE: SQL TRACE

Merhaba, If aggeragate=false, which is not default, SQL statement length does not make sense since each SQL are same lenght in raw file and output. in addition to Ed, check your output. If there ara a lot of kernel calls such as parse,fetch, etc. row file will be larger than output.

RE: Rebuilding indexes

Hello, Richard, If you want to use NOLOGGING operation on primary database, this is still possible to keep STANDBY in sync. Regularly check output of select FILE#, UNRECOVERABLE_CHANGE# from v$datafile; on primary and standby database, and , in case UNRECOVERABLE_CHANGE#

RE: Auto Extend

On Thu, 31 May 2001, Kevin Lange wrote: By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with

RE: select question

Title: RE: select question -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] If you know the size of the number (in position count not value) you can use the RPAD(sum(field),count,0) to populate the right end of the return value to zero. ex. the sum value is =

RE: select question

Lisa - I liked your old signature better :). [EMAIL PROTECTED] 05/31/01 03:17PM I believe you'll want to rpad your return value. select rpad(26.5,5,0) from dual returns 26.50 or format it in SQL*Plus. HTH Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the

RE: Auto Extend

I am running multiple Oracle 7.3-8i databases on NT. Is there someone on this forum who can answer my question:which parameter I need to set up to increase the file size limit? I have a feeling there may not be one. I was told by one of the super-senior Oracle people :-) there is an Oracle (not

Rebuilding indexes(simple way)

Hi Friends I have 20Gb Table with 3 indexes each 3,6,6Gb size. Recenly we deleted some 2 yrs data from it. So I want to rebuild the Indexes..Iam planning add some datafiles to it and just rebuild it, so that the new and old indexes fits easily. Is there any better way??? Thanks Raghu

Re:RE: About parallel server

Matt, I know I read that somewhere and yes it could also have referenced a different OS. If I manage to find the reference I'll happily share it with the rest of the group, I'm just so in vacation mode right now that I really don't give a *^%. But, I will admit that the docs on MetaLink

RE: DB2 vs Oracle

Mark, I'd like to have a copy of that document too.. - Uma -Original Message- Sent: Thursday, May 31, 2001 3:24 PM To: Multiple recipients of list ORACLE-L Ditto -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:16 AM To: Multiple recipients of list

RE: 4 join methods?

No, Oracle 8i will actually merge indexes and perform a pseudo join when possible without going to either table directly. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent:

Tablespace Allocation Type Extent Management

I seem to be confused about the relationship between tablespace management and allocation methods. What is the USER allocation_type (as reported by DBA_TABLESPACES)? I thought this corresponded only to dictionary-managed tablespaces--I see it associated with locally-managed tablespaces as well.

Re: deadlock error in oracle8.1.7 on sun solaris

Hi, It's most likely that you should change your code. If you need furher help, please attach trace file. -- Web: htpp://www.unal-bilisim.com Questions and Answers: http://www.unal-bilisim.com/qa/discus/index.html Seema Singh wrote: Hi Some time I am receiving the following information

RE: ORACLE NAMES /LDAP

Interesting...Oracle must have changed their minds on this issue. I know we complained that it seemed crazy for us to pay for OiD when ONAMES is free...considering Oracle is de-supporting ONAMES and practically forcing customers to go with OiD (LDAP). I guess they actually used some of the

RE: TOAD v/s PL/SQL Developer

I have been using PL/SQL Developer for many years and put alot of functionality requests for some of the new features in the 3.x and 4.x product. I would be more than happy to answer any questions you have about the product. But to answer your question. The debugger in PL/SQL developer simply

Re: How do I corrupt a block

You can write a little perl script to write over the block. Just open the datafile, sysseek to (block_number)*(block_size), then syswrite(chr(0),block_size). Strangely though, the naive approach of overwriting a block entirely with nulls results in a block which is not detectable with

Re: TOAD v/s PL/SQL Developer

We have been using free TOAD for over a year and have gotten from them somehow an extenstion of the expire license to not expire for the next 5 years. This version of TOAD meets our needs so we see no reason to upgrade for most of us. Randy Pace Phone 801 495 9300 9662 S 700 E Fax 801

Re: Resizing Log file

You need to add new log groups/members of the appropriate size, and drop the old ones. -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 3:38 PM hi dba's, In my DB, oracle 816, NT4, the redolog member's size is

RE: TOAD v/s PL/SQL Developer

Did you try EZSQL? Alex Hillman -Original Message- Sent: Thursday, May 31, 2001 3:38 PM To: Multiple recipients of list ORACLE-L Folks, Just got an e-mail from my Damager that there is a concern about the cost of TOAD licensees and an effort is being made to find a suitable

Re: Urgent: PL/SQL lock timer event

Someone is doing: dbms_lock.sleep(x) where 'x' is seconds. It won't be causing any performance problems - its a 'quiet' wait hth connor --- Naik, Sandesh S [EMAIL PROTECTED] wrote: Hi, I need urgent assistance is resolving issues with PL/SQL lock timer. My query is waiting on this event

Re: How do I corrupt a block

unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: 'novicedba' [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:40 PM I do not recommend this, but since you are bent on doing this: (Hope you are on Unix)

Re: Resizing Log file

offline, drop, create, online in that sequence for the inactive logfiles. ROR mª¿ªm [EMAIL PROTECTED] 05/31/01 03:38PM hi dba's, In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm having only two groups with a single member each. I tried with alter database command,

RE: How do I corrupt a block

There are un-documented init.ora parameters that can be used to corrupt such things as the rollback segments and tablespaces. Maybe there is one that can be used to corrupt a specific block of a datafile as well. Contact ORacle Support and see if they have any of these. They would be

RE: How do I corrupt a block

talk to your lead duhveloper..they are usally good at that ;-) Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any

Re: How do I corrupt a block

BBED isn't an option unless you can talk Oracle support into taking part in your experiment - unlikely. (Or perhaps find an appropriate WaReZ site! (8-o) Any hex editor will do if you aren't particular about exactly what you change in the block. If you know Oracle block internals you can get a

RE: Rebuilding indexes

yup -- that's what I used to try to do From: Thater, William [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rebuilding indexes Date: Thu, 31 May 2001 12:09:37 -0800 On Thu, 31 May 2001,Rachel Carmichael scribbled on the

RE: 4 join methods?

Yes I know it and sometimes I enforce it using index_join hint. Regards Waleed -Original Message- Sent: Thursday, May 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L No, Oracle 8i will actually merge indexes and perform a pseudo join when possible without going to either

Re: Oracle 8.1.7 and Apache

please mail them to me too - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 01, 2001 1:53 AM Ken, (FYI, I used a version of Apache (1.3.12) that came from Apache's web site, not the version that came with Oracle. And my web servers

RE: Implementing Stored Procedures

Title: Implementing Stored Procedures hi lisa, we do have staging area (dba -directory)inproductionwhere all the scripts ...(sql,forms,reports) are kept and with change request forms they are implemented... if any problems with the scripts they willl go to owner of change requester. And

RE: TOAD v/s PL/SQL Developer

Hi Chris, Thank you for your detailed response. I have forwarded it to our Developers. It would be very helpful.. Glad to know that you have contributed to the product's functionality. Thanks. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original

RE: Auto Extend

I personally have 2G files and would never shy away from them. Nothing worse then having a rather huge database with 6 million files when there is really no valid excuse for it. I would have happily gone bigger then 2G as well if it were not for the Sun Omniback agent. I will do it on the HP

Re:Rebuilding indexes (simple way)

Raghu, Index rebuilding is one of those maintenance items that needs doing every once in a while. Therefore my take is to have a separate tablespace where I can rebuild the trashed index into, and then rebuild it a second time back into where it originally came from, but with the correct

Oracle system sizer

Has somebody practical experience with the Oracle system sizer of Compaq ? Does the suggested configuration comes up to expectations ? Regards, Rene --== Sent via Deja.com ==-- http://www.deja.com/ -- Please see the official

Re: Fire your DBA's you don't need them anymore...

What a hoot! I mean all these wild statements about not needing DBA's anymore (or sometime in the future). Is Oracle actually getting simpler with each new release? With tongue firmly planted in cheek, here is the Oracle 5.1 DBA OCP exam. You be the judge... Q1) How do you cold start an

RE: TOAD v/s PL/SQL Developer

Mark Qualter who handles support for the product is great. Very responsive to requests reguarding features as well as bugs. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/31/01 6:33 PM Hi Chris, Thank you for your detailed response. I have forwarded it to our

Re: 4 join methods?

I also sent an inquiry to Tim Gorman, who wrote the article on the CBO. He's no novice. He says the fourth join method is 1. nested loops 2. sort merge 3. hash join and 4. cartesian product ! I kid you not. By the way, if you're on 8i and haven't already set init parms

HELP! / RE: OT: Archiving not possible with SQL Server?

are you a complete idiot? On 31 May 2001, at 13:34, Bowes, Chris wrote: I protest Jared's removal from the list for telling jokes!Henry please reconsider! :) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat

Re[2]: Fire your DBA's you don't need them anymore...

Don't hold your breath!! BTW: Do you remember the claim of the nuclear power industry? That by the turn of the century electricity would be so cheap and plentiful we could waste it at will. Tell that to those folks in California!!! Dick Goulet Reply

RE: Auto Extend

which parameter I need to set up to increase the file size limit? There isn't one. On NT the filesize is limited by the type of filesystem (FAT, FAT32, NTFS, etc...). I suspect the bug in question is bug 711563, and it's fixed in the latest 7.3.4.x and 8.0.x patchsets. Yet another reason

RE: Snapshot Logs Explanation Needed

OK, checked TFM and there are two type of fast refresh snapshots: primary key (new in 8) and rowid. For a rowid snapshot, when the table (EMP) is updated, a row is added to the snapshot log (MLOG$_EMP) containing mainly the type of action, timestamping info, and the rowid (MLOG$_EMP.M_ROW$$) of

Standby Databases and DB Links

Has anyone been successful in using their standby database operating in read-only mode through a dblink? I can't find any admonishment in the docs. The dev guys says it will be find for the front-end java code to fail on any updates. Ritchie Lau [EMAIL PROTECTED]

Re: Re[2]: Fire your DBA's you don't need them anymore...

---excerpt from trivia site--- On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig) favorite TV program? Lost in Space Combat Beverly Hillbillies CBS Evening News with Walter Cronkite [answer:] CBS Evening News with Walter Cronkite --- On 31 May 2001, at

Re: About parallel server

Some OPS-capable platforms (Tru64? VAX?) already allow cooked files for OPS. Oracle9i will support files for OPS only on certain supported cluster file systems. Veritos has been explicitly mentioned and Veritos people say their cluster file system for parallel server will be available by the

RE: How to encrypt Password in Export script file ?

Hi Gurus, Thanks to those who replied. We feel that Unix account is easily hacked, so we will not implement the method that Rachel mentioned. We will probably encrypt the password in another file. Before exporting, we will decrypt the password before passing the password to the export script.

Re: How do I corrupt a block

Jared, BBED is available on UNIX, you just have to make it with the make command. cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed The bbed command can allow you to soft corrupt a block and you can use the dd command to hard corrupt the block. The bbed command does

RE: TOAD v/s PL/SQL Developer

Take a look at the product Kirti mentioned, PL/SQL Developer, it is a GREAT product. And $1,000 for 20 licenses, But it is $150 for a single. I absolutely love it compared to anything out there. I have converted at least 50 developers to using it. -Original Message- To: Multiple

RE: ORACLE NAMES /LDAP

Sorry about asking these question , because currently I'm not in my office so I don't have the document ,Why we need to use Oracles Names /LDAP ?? -Original Message- Sent: Thursday, May 31, 2001 11:51 PM To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle

RE: problem with trunc()

Here's the query and execution plan. Like I said, it took 6-7 hours just to get that without executing. Any insight appeciated. Remember: I know the workaround (avoid trunc). I'd just like to know *why* it doesn't work. Some of the values were dummied up ('' etc.). The actual query

Urgent: How to set Oracle block size for various OS

Hello gurus, Could you please advise how to set the block size for various operating systems? eg HP, aix etc. also this is for oracle 8. This is urgent, and you can give me any thing, eg url, white paper, etc. thanks and regards, raja Get 250 color business cards for FREE!

Help! ORA-00164 - autonomous trans problem in 8.1.7 NOT in 8.1.5

Recently upgraded a development database from 8.1.5 to 8.1.7 with the u080105 script. There is now a certain type of code that errors out with a ORA-00164 autonomous transaction disallowed within distributed transaction. But the same code works on 8.1.5, as if a piece of functionality was

Re: ORACLE NAMES /LDAP

The most simple analogy is would you prefer to manually maintain a host file on each client or use a single facility such as a DNS server ot provide the mapping between hostname IP_number? At some point switching from using TNSNAMES.ORA files on all Oracle servers client to a

Re: ORACLE NAMES /LDAP

The most simple analogy is would you prefer to manually maintain a host file on each client or use a single facility such as a DNS server ot provide the mapping between hostname IP_number? At some point switching from using TNSNAMES.ORA files on all Oracle servers client to a

Re: Re[2]: Fire your DBA's you don't need them anymore...

Beverly Hillbilies. At 04:37 PM 5/31/01 -0800, you wrote: ---excerpt from trivia site--- On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig) favorite TV program? Lost in Space Combat Beverly Hillbillies CBS Evening News with Walter Cronkite [answer:] CBS

RE: Tablespace Allocation Type Extent Management

Title: RE: Tablespace Allocation Type Extent Management -Original Message- From: Walter K [mailto:[EMAIL PROTECTED]] I seem to be confused about the relationship between tablespace management and allocation methods. What is the USER allocation_type (as reported by

Difference between a couple of v* manuals

Hi I have been sent the following I keep coming across references (in the other Oracle 8.0.5 documentation) to a document called the Oracle8 Server SQL Reference, presumably distinct from the Oracle8 SQL Reference. Any idea whether there really is a separate document with that title? If so,

RE: Oracle 8.1.7 and Apache

pl send me the files. TIA -- On Thu, 31 May 2001 12:23:58 Fisher, Julie wrote: Ken, (FYI, I used a version of Apache (1.3.12) that came from Apache's web site, not the version that came with Oracle. And my web servers and database servers are on different machines. And my web servers are

Import Problem

Hi I saw this over on the Sun System admin list and was interested in the cause of it. My suspicion is that it has something to do with 2GB files limits Oracle data base using the imp command on my Solaris 2.6 server this is the message that I receive Import: Release 8.1.5.0.0 - Production on

RE: Missing DDL?

Sean, Another option would be: Get yourself a copy of strings from http://www.sysinternals.com/misc.htm#Strings (a very useful site for NT utilities that should have been in NT!). Do the export (someone else suggested a full export is required) Then do a strings -a export_file.dmp |

RE: Suggestions on SCSI

Hi, The suggestion given to go for 18Gigs HDD(SCSI) is a good one. I have seen in H/W that what u get today u will not get tomorrow. I mean they become obselete. H/W vendor will say that they nolonger manufacture the same. Ultra fibre scsi is a technology HDD maufactures use for I/o transfer.

Re: Difference between a couple of v* manuals

Hi, I have gone thru the manual list. For me Oracle SQL Server ref and Oracle SQL ref sounds the same. There are 2 more manual SQL*Plus quick ref and SQL*Plus user's guide and ref. I have come across these manuals only. HTH Venkat -- On Thu, 31 May 2001 21:05:19 Peter McLarty wrote: Hi I

Re: Re[2]: 4 join methods?

Star join or STAR SCHEMA is used for DSS Systems. It actually uses Cartesian product in its methodology but still employs Oracle join methods to actually do the joins between the tables. So there are still 3 join methods.Cartesian (as somebody mentioned earlier is product rather than a join) Sam

Re: How to send email from pl/sql in 806?

hi, the package involved is utl_tcp, i created it under sys. the procedure is also created without any error under sys. do i still need to grant execute privilege on it, when sys itself is the owner. saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: how much ram per oracle process?

i guess the SGA size is also included in the SZ -- From: Henry Chan[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 5:59 AM To: LazyDBA.com Discussion Subject: how much ram per oracle process? Environment: Sun 2.7,

<    1   2   3