Re: Script and control file

Hi, Within your *.sql script you can jump to the OS and give OS commands. e.g: host sqlldr. (start with host). I have used it with import and it works. Jack

Re: Table size

select * from user_segments is a good start.. hth connor --- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Hello all, > > How do I come to what tables are present in a > particular tablespace and then when I found the > table, can I come to know what amount of space it > consumes? > > eg. I want

How to drop unique index

Hi Gurus, I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE (column_name);" unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL> SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME

Re: Is the ability to do "field-level" encryption free in Enterprise Edition?

>From a money perspective - yes >From a resource perspective - no, using the obfuscation toolkit does add lots of cpu to your processing (if you're handling lots of rows) hth connor --- [EMAIL PROTECTED] wrote: > > We are in the process of upgrading most of our > databases to 8.1.7.1 > (Enter

io size of Unix machine

How can I find the logical or physical I/O size on a Sun Solaris machine ? Thanks, ~aslam application/ms-tnef

Testing tools

Hello if there any testing tools for QA staff / developer to test on bulk data which can measure it performance,efficient.of the program/PLSQL/sqlscript ??? The function of the tools is , prepare bulk data , testing , generate report . If no such tools , what might be an advice ? Be

Number Vs. Varchar2 Datatype

Title: Number Vs. Varchar2 Datatype Hi list, We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) , The main decision to be made right n

Performance tuning

HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overh

RE: archive redo logs on NT

i guess you forgot to do svrmgrl> archive log start; > -- > From: SAMI SALEM[SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 5:03 PM > To: LazyDBA.com Discussion > Subject: archive redo logs on NT > > Hi DBAs, > > I'm having a problem with archive redo l

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

hi, i created the package and the procedure after modifying the ip of our mail server in the procedure body. it gave no error during creation but is not executing the procedure send_mail. should i give it all four arguments. but it still not executing saying ora-06512 what should i do. i ve 8.1

connect on oracle database

hi DBA Masters: If i have any application (sybase / informex) not oracle tools make it. how to connect from this application on the oracle database?? thank you hish _ Get Your Private, Free E-mail from MSN Hotmail at http://ww

Re: How to drop unique index

Try out this Drop index U_SPYADH_2 ; Regards Magesh - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 5:50 PM > Hi Gurus, > > I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE > (column_n

Ynt: Performance tuning

It's not possible to solve any performance problems without CPU usage and waits. I recommend: - get Event1006 trace file of your sqlloader session as defined at http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#prepar eTrace . - run itrprof at http://www.unal-bilisim.com/produ

Re: Performance tuning

Okay fill us in why would you try and inane thing like that on only 128MB RAM. NT would be barely running on that without getting your instance up. I am not that good yet at calculating what amount of RAM you need for a given SGA but I am thinking that you are running in swap What is the disk

RE: Test Model

Testing what? Load performance? Data Integrity? Bank balance? Brain capacity? User stupidity? -Original Message- Sent: Tuesday, May 29, 2001 10:02 To: Multiple recipients of list ORACLE-L Hi List, Anybody knows any model or tools for testing. Thanks in advance = Hamid Alavi 4268

RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]

You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new "key" called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman

RE: connect on oracle database

Hish, Crack out some manuals double quick - get some RDBMS training, and learn a little about what you are playing with here! Sybase and Informix are not actually applications - they are Relational Database Management Systems (RDBMSs) that are competitors to Oracle. To answer the question thoug

Analyze table and locking

All,   Just a quicky !!   Anyone know if there are any locking issues while analyzing statistics for objects ??   TIA   Lee   The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the rea

Re: archive redo logs on NT

mount the database in exclusive mode, do not open. issue.. archive log start. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 3:40 PM > i guess you forgot to do > > svrmgrl> archive log start; > > > -- > > From:

Re: Number Vs. Varchar2 Datatype

Title: Number Vs. Varchar2 Datatype this always a better decision to decide the datatypes of such columns keeping in mind the future requirements. u may come to a certain point where u think, number datatype to be better and somewhere to varchar2.   u said number datatype which is not always

Re: How to drop unique index

Suggestion given by Magesh should work for a non-constraint index. If it is index created by Oracle during the time when you created your unique constraint you won't be able to get rid of that index until you eliminate your constraint. - Original Message - To: "Multiple recipients of lis

RE:

That's a laugh, I went to a continuing education seminar once at Carleton University, in Ottawa. The seminar was called Effective Living. The teacher was a social worker, and he emphatically told everyone NEVER to ask why, just adapt to life and keep moving... I had unreconcilable disagreements

Re: How to drop unique index

Hi, Did you try : SQL> drop index index_name ; ?? HIH, Antonio Belloni "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>@fatcity.com on 30/05/2001 05:50:25 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Script examples for NT. (yuk!)

Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is "weak" at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you w

RE: Error while executing stored procedure as system user

When you use privileges in stored procedures, you need to have the privilege explicitly. In other words, you cannot get the privilege from a role. If you do a grant create user to MyRole. Grant myRole to myUser. Then try to create user as myUser it will work, but if you try to create user from

RE: backspace in Oracle.

I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix have. Granted it is only Novell 3.12. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot --

RE: Analyze table and locking

Yes, table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I believe. Vadim Gorbounov Oracle DBA -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22 AMTo: Multiple recipients of list ORACLE-LSubject: Analy

RE: backspace in Oracle.

There isn't any known bug under NT. But there are many memory leaks and poor drivers, that tend to lead to early rebooting. In my experience. I think the worst problem with NT is not the os but the drivers, even though Even though I hate NT, for the money, it works well. But if you try to get

RE: Problem with many (160 - 170) sessions in the database on

just my input. where are the load metrics documented, meaning where does it say 5M or more per session? i want to know for future reference. we're putting in a solution, oracle 8i on windows 2000/windows 2000 advanced server ~4-to-8G of RAM so there are options if you need additional RAM in exc

RE: Analyze table and locking

Hi Lee, Compute option locks a table, but 'estimate' doesn't Regards, Ed -Original Message- Sent: 30 ??? 2001 ?. 15:22 To: Multiple recipients of list ORACLE-L All, Just a quicky !! Anyone know if there are any locking issues while analyzing statistics for objects ?? TIA Lee

RE: Analyze table and locking

Ok, now I'm confused One reply - It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. Another --- Compute option locks a tabl

Re: How to drop unique index

If it is an unique index that enforces unique constraint you cannot simply drop it You have to drop unique constraint alter table tablename drop constraint constraintname; an example follows SQL> desc qaqa1 NameNull?Type --- ---

RE: Analyze table and locking

I think thats the reason why we have two options - Estimate and Compute Statistics. Rajaram. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 7:22 AM To: Multiple recipients of list ORACLE-L Subject:Analyze table and lo

Re: Installing Apache on Sun

shouldn't be any problems running apache on the same server. at least i've set up oracle on solaris 7 with apache installed. Jon Baker Database Engineer (1/5) <[EMAIL PROTECTED]> Rukmini Devi wrote: > > Hi List, > > SunOS

Re: Error while executing stored procedure as system user

In fact, the restriction on use of privileges granted via a role applies to *all* stored objects (e.g., views), not just stored PL/SQL code. Paul Baumgartel [EMAIL PROTECTED] 917 549-4717 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday,

RE:

This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Original Message- Patrice J Sent: Wednesday, May 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L That's a laugh, I went to a continuing education seminar once at Carleton Univers

Re: Performance tuning

Azhar,   I agree with the other responses (more RAM, don't use OPTIMAL on your RBS's) but would also suggest dropping all indexes except PK until the load is done, the rebuild them.  Also, does this table have any triggers?  If so, if can you disable them during the load, that will help spe

RE: Performance tuning

I would not recommend using optimal as it will cause the segment to have to shrink. Your better of doing it manually on lulls of activity and size the segments bigger if need be. Segments should not be frequently shrinking. "Walking on water and developing software from a specification are ea

Re: Analyze table and locking

It depends. For instance, 'analyze index validate structure' takes out 'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze index compute/estimate statistics' does not. For more info see 'Practical Oracle 8i' by Jonathan Lewis - very good book.   Igor Neyman, OCP DB

RE: Creating a sorted table

This is totally NOT accurate. Yes there are performance gains storing index data ordered. Perhaps great on range scans. Yes you can reorder tables and indexes. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspo

Moving CLOB data from one db to another.

I am migrating data from one database[database1] to another[database2]. I have a link[dblink] between the two and one of the tables[CLOB_TABLE] have CLOB datatype for one of their attributes[CLOB_BODY]. I need to cursor through this CLOB_TABLE and then insert the cursor variable values into databa

RE: Number Vs. Varchar2 Datatype

Title: Number Vs. Varchar2 Datatype VARCHAR2 is more efficient marginally for sorting and indexing.   Oracle claims numeric primary key is faster, but there has been proof otherwise.   But if your data is number, it should be stored as a number.  The speed difference is very marginal.   "W

RE: Creating a sorted table

Title: RE: Creating a sorted table That is version specific, but you can use an index hint to do this in older versions.   "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From

RE: Performance tuning

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Peter McLarty wrote "Are you running RAID

RE: backspace in Oracle.

Uptime yes... BUT was there anything running on them as complex as a database? Just joking. I have used Novell in the past ver 2.something and it served the purpose very well. At my current work location we use 4.12 and it is okay at best. Upgrading to 5.1 this year before we install a financia

Missing DDL?

Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some other

Build an exact copy of a database using export / import

When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of

Re: How to drop unique index

that's not dropping a unique index, that's dropping a column! to drop an index: drop index ; doesn't matter if it is unique or not. If you are trying to drop a unique constraint, that's different. first find the name of the unique constraint on that table" select constraint_name from user_c

Re: backspace in Oracle.

On Wed, May 30, 2001 at 05:01:22AM -0800, Christopher Spence wrote: > I have built Novell boxes that have 2100+ days of uptime :) > > Now that is stability that I have yet to see even unix have. > Granted it is only Novell 3.12. Novell uptime: http://www.theregister.co.uk/content/5/18265.html =

RE: Performance tuning

I agree. Is your Shared_pool_size set to 239MB? You can't ask Oracle to allocate this much memory with excessive swapping on your NT box. If you can't add mode RAM, I would cut that to around 50 MB. I would also do what Peter recommends below. There are always a few more things to try (like direct

Re: Performance tuning

Actually we have to Since Data is being loaded in development environment. that is why we have 128 meg ram. (Regarding RAM i have no other choice) i have the NT performance monitor and it shows that it is not using swap heavily. Currently disk configuration is not RAID . however we have no di

RE: Analyze table and locking

Analyze index validate structure takes shared lock on the table disallowing any changes to the table or indexes. That's the only way to validate the structures. In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any ta

Re: Performance tuning

Peter is right. Look at your SGA it's 285M. If you only have 128M on the machine you are running your at least 75% of your db in swap. I would recommend 512M MINIMUM on this system push for more if you can. RAM is relatively cheap right now for intel machines get some. After that you need

Re: Performance tuning

Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SA

RE: OT: random equipment seen ???/ RE: V$SESSION.OSUSER returns

If you every try and knock a cat off of something when she really does not want to go you will see that quite clearly. It really is quite amazing (and annoying). -Original Message- Sent: Tuesday, May 29, 2001 7:12 PM To: Multiple recipients of list ORACLE-L \ ? Eric, duct tape not nee

Re: Analyze table and locking

Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. Raghu. >From: Robertson Lee - lerobe <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTE

RE: Database slowdown after 100 days uptime

Hi Bruce As I understand ur server uptime is 242 days.Right!If this is the case then Please reboot the server would solve this problem.The similar kind of problem I faced in past. Hope this will help u.If you would like to more information then please visit metalink. Thanks -Seema >From: Raymo

RE: Performance tuning

Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my hea

RE: backspace in Oracle.

Ya, but I can keep a NT box for a long time to, if I don't touch it. -Original Message- Sent: Wednesday, May 30, 2001 6:01 AM To: Multiple recipients of list ORACLE-L I have built Novell boxes that have 2100+ days of uptime :) Now that is stability that I have yet to see even unix hav

RE: Creating a sorted table

Diana, You might wanna check out www.kx.com Those guys have a lightning rocket of a dbms, and it is based, in part, on storing data in search/sort-dependent order. (There is a bunch of background data on the site itself.) In any case, reading up on other dbms technologies has a place in any

RE: backspace in Oracle.

Six years? No downtime in any way? That would be...uh.unusual. I am sure the details are fascinating...do tell. || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 9:01 AM || To: Multiple recipients of list ORACLE-L || Su

Re: io size of Unix machine

Are you trying to find maximum size of the IO possible in Sun/Solaris ? Kernel parameter maxphys parameter determines the maximum size of the IO possible from the OS. By default, it is around 128k depending upon what hardware you use(sun4d=124k, sun4u=128ketc ). If you user veritas volume manag

RE: Analyze table and locking

Not necessarily. 8i+ DOESN'T require _ANY_ lock to COMPUTE while collecting statistics (99.99% of total operation time). It needs short lock to start and complete analyze. Regards Vadim -Original Message- Sent: Wednesday, May 30, 2001 9:07 AM To: Multiple recipients of list ORACLE-L Hi

RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]

On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wedn

OT (everybody has a bad day once in a while...)/ RE: Creating a sorted table

On 30 May 2001, at 8:10, Christopher Spence wrote: > This is totally NOT accurate. http://www.amazon.com/exec/obidos/ASIN/B5BYQH ---excerpt--- Tales of the Arabian Nights Barbie and Ken Our Price: $99.99 This item will be rele

RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns

mainekoon cats. Almost as big as dogs, and do pull sleds. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:21 AM To: Multiple recipients of list O

RE: RE: RE:

Reminds me of a bad joke... What did the farmer say when his tractor broke? -Original Message- Sent: Wednesday, May 30, 2001 12:03 PM To: Kevin Kostyszyn; [EMAIL PROTECTED] Just because! Reply Separator Author: "Kevin Kostyszyn" <[EMAIL PROTECTE

RE: Performance tuning

John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I believe. RAID 5 will require additional writes by DBWR which is going to be huge overhead during a dataload. - Ethan Post -Original Message- Sent: Wednesday, May 30, 2001 6:51 AM To: Multiple recipients of list ORACLE-

RE: backspace in Oracle.

Hey, NT could be up for 2100+ days, I mean, by the time you get there it won't even be able to play solitaire, but it will be up. -Original Message- Spence Sent: Wednesday, May 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I have built Novell boxes that have 2100+ days of up

re: Script examples for NT. (yuk!)

http://www.ultratech-llc.com/KB/Scripts/?File=Scripting.BAT (also see bottom of this message for more URLs) http://www.ultratech-llc.com/KB/?File=!Contents.TXT --forwarded message follows-- [Date sent: Wed, 30 May 2001 10:32:11 -0400 To: Recipients of WINNT-L digests <[EMAIL P

RE: Build an exact copy of a database using export / import

Well, depending on the size of the db and some other network stuff, I do the following. I shut down the real db, copy all of the data files, controlfiles and init file to a machine with Oracle on it. Then you can create the service (NT), alter any of the datafiles if necessary (on different logi

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

Yeah, I'd say that proportion would have worked in my group too. And when I interviewed others, I rarely got any great people applying, and it's almost solely because at that level, dollars were so much better as independents, and the only people who wanted to come were visa-sponsors or relative n

RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns

On Wed, 30 May 2001,Christopher Spence scribbled on the wall in glitter crayon: ->mainekoon cats. Almost as big as dogs, and do pull sleds. and like laps. and if you don't make one for them, they just tangle your feet till you fall down and then climb in your lap.;-) -- Bill Thater

RE: Analyze table and locking

Many thanks -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 30 May 2001 17:10To: Multiple recipients of list ORACLE-LSubject: RE: Analyze table and lockingAnalyze index validate structure takes shared lock on the table disallowing any changes to

Re: Problem with many (160 - 170) sessions in the database on NT

I'm going to retract part of this post, as it has been pointed out to me that 7.3 on NT normally consumes about 1.5 meg of RAM per session. This is of course dependent on SORT_AREA_SIZE. I've obviously disremembered common memory usage stats for 7.3.x. That and a lot of my 7.3 experience in on

Re: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]

If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file.

Is DBMS_OBFUSCATION free in Enterprise Edition?

We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this version of Enterprise Edition server or is it part of an extra-cost add-on. All definitive answers welcome. I have a call in to Oracle but they have not yet responde

PL/SQL Error

Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or type

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

On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: > > should i give it all four arguments. but it still not executing saying > ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- A

RE: Database slowdown after 100 days uptime

Its not a general Oracle or Unix thing because we had out AIX boxes up and running Oracle 7.3.4 and 8.1.6 for many months at a time with no reboots. -Original Message- Sent: Wednesday, May 30, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Hi Bruce As I understand ur server uptim

RE: RE: RE:

Actually I say: "You know what the farmer said when the cow died?" "Geesh, it never did that before." "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2

RE: session pga memory value is much higher than Sort_Area_Size

I had the same problem. First, i realized that - it seems - there are other things that will bump the PGA. For me it was insert /*+ append */. However, after upgrading from 8.1.5 to 8.1.7 the problem went away. Hope this helps, and your mileage may vary. Good luck, Yosi > -Original Messag

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

Yeah, I think they've got a retention problem, since the money is better outside, and consultants have a good idea of what they're being billed for. But the internal resources are great, as are their internal email lists. Of course, now we've got much of their internal stuff on metalink - if you

Re:RE:

Ours is not to wonder why, ours is just to do or die!! Reply Separator Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]> Date: 5/30/2001 7:02 AM This person was actually allowed to teach. Never ask why, yes that's a super philosophy on life. -Origi

RE: Script examples for NT. (yuk!)

My suggestion would be to install cygwin (http://sources.redhat.com/cygwin/). > -Original Message- > From: GLoughmiller [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 8:25 AM > To: ORACLE-L > Cc: GLoughmiller > Subject: Script examples for NT. (yuk!) > > > Quick question..

RE: Performance tuning

Raid 5 can consume as much as 60% overhead for writes. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 12:51 PM To: Multiple recipients of list ORAC

RE: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7

Try changing to VARCHAR2(31) instead of VARCHAR(31). Although I know there is no difference in varchar and varchar2 definition. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expresse

OT: Effective Living

Isn't that sort of like Taoism? Accept your lot, there must be good in it somewhere... Also, it seems to be the basis of many major religions to essentially never ask why. So, I guess it's a pretty popular philosophy. (Oh no, I feel a discourse by Eric coming on...) Diana Duncan TITAN Techno

Re: Missing DDL?

Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=. HTH, -- Anita --- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: > Created a

Re: Analyze table and locking

I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need

OEM Book Recommendation

DBAs, As a keyboard lover, hate to do this. But I need to study OEM. Any good Books / URLs / DOCs / PDFs Thanks in advance, -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1

After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris 2.6, we are having problems executing a procedure with CharArrayType as shown below. We don't get any error message. The package simply does not return any rows when there are rows out there that should be returned. The dev

RE: Build an exact copy of a database using export / import

Yes..Cloning is bit mature than export and import. BTW you don't need to have the same directoty tree in the target database. You can have a differenet directory tree ..(you can edit the control file script and it is done..) = Have a nice day !! -

RE: Performance tuning

Redo generation will not change. Just the archiving process, which on improperly laid out file system can be very painful process. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message---

Re: _sqlexec_progression_cost

I am using this parameter on 8.1.6.2 for the same bug: "1210242: CURSORS NOT SHARED WHEN TIMED_STATISTICS=TRUE DESPITE FIX FOR BUG 918002." -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 29 May 2001, Jerry C wrote: > Anybody have experience setting this parameter? It references a

RE: OT (everybody has a bad day once in a while...)/ RE: Creating

Huh? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 1:26 PM To: Multiple recipients of list ORACLE-L sorted table On 30 May 2001, at 8:10, Chris

RE: Creating a sorted table

Sure, and thanks. I appreciate the corrections, as one problem with doing this for a while is the aggregation of useless and no longer true "facts", which I'm finding I have more and more of. They feel like barnacles. :) I've finally decided to go get my OCP, which I hope will help scrape som

Re: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1

Cherie, I have no idea if this could be the case, but I noticed that the type is based on the datatype VARCHAR, not VARCHAR2. According to the docs, this shouldn't make a difference, but they've been warning since the introduction of VARCHAR2 that they may do something different with VARCHAR at

RE: connect on oracle database

Either MS ODBC or Oracle driver can do the connectivity. I found out that MS ODBC is more user-friendly. Just my $0.02. -Original Message- Sent: Wednesday, May 30, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hish, Crack out some manuals double quick - get some RDBMS train

RE: Performance tuning

Indeses are not critical for the application to run..It just helps them run faster at times. You could build you indexes with the "no logging" or "unrecoverable" option and that will save on the archivelog creation. Just be sure to take a backup after the indexes are rebuilt because you will n

  1   2   3   >