Paging problem in SunOS

Hi,I am experiencing a massive performance problem due tohigh page-in operation In Sun OS 5.6/Oracle 8.1.7.The RAM is 512 M and SGA is around is 50M and no otherprocess is running on that m/c. Any suggestions. Thanks in advance. PradyutDo You Yahoo!? Yahoo! Health - your guide to health and

Licences for testing

We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence,

Re: Oracle IFS

Hi All, Oracle iFS is, of course, much slower in standard operations, such as file copying, saving and retrieving, but... It has really great features for searching as well as more protocols to access files (smb, nfs, http, webdav, and more). Another nice feature is customized smart file system,

RE: Licences for testing

Would the personal edition work for you? I don't think there would be a licensing issue with this. Dave -Original Message- Sent: Friday, May 03, 2002 7:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice

RE: Licences for testing

As far as I am aware : NO. It has played a major role in me not being able to obtain some more test boxes at my current job. I believe the licensing is a little better, but it is still there. Plus, you also need the OS (Sun Solaris) so you get hit there too. Hannah -Original

RE: Paging problem in SunOS

I think your SGA is too small. It should be around 200-250MB totally. -Original Message-From: Pradyut Mitra [mailto:[EMAIL PROTECTED]]Sent: Friday, May 03, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: Paging problem in SunOS Hi,I am experiencing a

RE: shared pool memory issue on OPS (non-MTS)

Jonathon, Currently we do not pin anything in the shared pool. Still nothing from Oracle on this yet. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 02, 2002

RE: Paging problem in SunOS

Hi Pradyut, Check the distribution of your DB on your disks: -Do U have multiple /raided Disk sub-system ? -If so, what is your lay out in as tablespace datafile(s) location, index datafile location, redo logs file location etc If possible post the above for an analysis of the same.

Re: Licences for testing

You could talk to your sales rep about short-term licensing, or you could just do it and hope they don't discover it. I've found that temporary servers have a tendency to become permanent though. |+--- || | ||

RE: Licences for testing

Last time I checked Oracle on Linux is free if it's used for testing only. If you don't mind using Linux (we use it extensively) it could be a viable option. --Walt Weaver Bozeman, Montana -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 7:43 AM To: Multiple

RE: Disaster Recovery Plan

Rick - I went to http://www.google.com and entered Disaster Recovery Plan, and found what appeared to be several high-quality links. You might start with Disaster Recovery Made Easy. Once you get beyond these, you will probably need a book on the subject. I imagine there are a number of good

Oracle - Access

Hallo, anyone who has a good hint on this: I have an appplication which goes against Oracle and when I am inthe application and run VBA code which connects to linked tables everything works fine. But when I have an icon on the desktop and runs that icon as shortcut then I get error messagelike

Re: Database Normalization-Outdated?

Ok. Since we are telling old stories around the campfire and at the risk of extending this thread even more, here are my 2bit stories :) Absolutely positively you must have RI on any tranactional system critial to your bussiness. If someone recommends otherwise, politely disagree then run if

DB Size

Hi all, How could one collect data from an Oracle Server to respond to the question: How big is (what is the size of your) Database ? Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network

Re: DB Size

you really might want to read the manuals -- specifically the reference manual on dba_data_files select sum(bytes) from dba_data_files will tell you the total size (in bytes) of all the datafiles in your database. There will also be space used by the control files, redo log files, archived log

RE: Remove an SID from sun solaris

You might try using DBCA to delete the old database/SID that is interfering with your current creation attempt. That should do the trick. If not, you will have to track down the occurrences of the SID in Oracle files like tnsnames.ora, listener.ora, oratab, etc. and remove them. HTH, David

RE: Create a new database

Hi all, In second run almost every thing goes OK except the PL/SQL part but I could open the database, but still looking for a link to download the patch2 for oracle 8.1.7 sun solaris. Tanks all for helping with this issue. BTW: Nobody answer how can I remove the SID name from oracle.

Re: One way replication in multimaster environment

Looks like snapshots make the most sense. --- Softhome - Fico [EMAIL PROTECTED] wrote: hi experts, In my replicated environment, i have one site (example: site X) that consolidate data from other sites (example : site Y and Z). I'm using multimaster to push transaction from site Y

Syntax For Dropping a default value?

Hi, Been searching for syntax to drop a default value (we decided NOT to use the default value) for a colmun. I looked in the docs and even tried to remove the default value via DBA Studio. No go. Can you not modify a column to REMOVE a default value specification? Thanks,

RE: Oracle - Access

Can you show us your code, call out the line that returns the error and give the exact error # message? Also, consider moving this to an msaccess list. One good one can be found at http://peach.ease.lsoft.com/archives/access-l.html Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed

RE: DB Size

Try this: spool files.txt set pagesize 60 set linesize 80 col name format a55 heading Control Files select name from sys.v_$controlfile / col name format a22 heading Dump / ARCH Files col value format a55 heading Location select name, value from sys.v_$parameter where name like

Re: DB Size

A good question for a friday afternoon before a bank-holiday weekend... Query the data dictionary to get the names and locations of the data files: select file_name, tablespace_name, bytes from dba_data_files; That will give you the size of all the files for data, indexes, rollback

Re: Oracle - Access

Try right-clicking on the icon on your desktop. Check under properties and see where the program is starting (it's under the shortcut tab). Maybe you're starting in the wrong directory. HTH

RE: Syntax For Dropping a default value?

try this: alter table table_name modify column_name default null; -Original Message- Sent: Friday, May 03, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Hi, Been searching for syntax to drop a default value (we decided NOT to use the default value) for a colmun. I

Re: DB Size

select sum(bytes) from dba_extents; This is a quick and easy though not totally accurate. Not every row in every block will be filled. Simon Waibale

Re: shared pool memory issue on OPS (non-MTS)

What do the v$resource_limit numbers look like on the other node ? Is there any other way that the bad node could have become the master for all the dictionary cache information ? Does one node start up a few minutes before the other ? Is there anything that makes one node the preferred not

Re: ERD generation tool - Active SCM

Yechiel, Yes, I have been there, done that, over and over... But then, there is a Toyota Corolla solution and maybe a Ferrari Testarosa solution. If we can control Dom Phoc without tieing his hands behind the back, wouldn't that would be the best: white paper:

Re: DB Size

SELECT SUM(BYTES) FROM ( SELECT BYTES FROM sys.DBA_DATA_FILES UNION ALL SELECT BYTES FROM sys.DBA_TEMP_FILES ) ; it's in bytes not kB or MB JP On Fri 3. May 2002 16:53, you wrote: Hi all, How could one collect data from an Oracle Server to respond to the question:

In an Analyze Necessary?

Hello Folks, A datawarehouse. There are only a few selected SQL's run against this database. And all this SQL's are tuned to optimum during design with hints embedded to take the least execution time. The SQL's currently execute in times, much better than what the expected response time was by

Re: Syntax For Dropping a default value?

I do not know how to remove it but you could ALTER TABLE table_name MODIFY(column DEFAULT NULL); Rick johanna.doran@s

Re: One way replication in multimaster environment

Not, if you want real-time row-level replication. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 11:33 AM Looks like snapshots make the most sense. --- Softhome - Fico [EMAIL

Re: DB Size

I like to use this SQL*Plus script: -- Begin script -- /** * File: spc.sql * Type: SQL*Plus script * Author: Tim Gorman (Evergreen Database Technologies, Inc.) *

SMJ, NL or HJ

Hello Gurus, A SQL tuning question. Given three large tables with the same millions of rows, and all three are referenced in a query, without any filter, as under: Select .. from largetableA a, largeTableB b, largeTableC c where a.empnum = b.empnum and a.empnum =

Re: pl/sql is INTERPRETED?

I used to work with Jared. He just has 'The Gift'. For those of us who are mere mortals it takes a little longer :-) --- Alex [EMAIL PROTECTED] wrote: You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably

RE: Paging problem in SunOS

Your SGA is pretty small by usual standards - which is not, in itself, a cause for alarm, and, in any case, you shouldn't experience the SGA being swapped in and out. In practice, it means that Oracle leaves lots of memory to other processes. I would look for the culprit on the client side -

Re: Oracle - Access

Looks like Access doesn't connect to Oracle db. Try to create connection to Oracle in Autorun procedure in MS Access. JP On Fri 3. May 2002 16:48, you wrote: Hallo, anyone who has a good hint on this: I have an appplication which goes against Oracle and when I am inthe application and run

RE: Create a new database

Hi Jared, I was off the listserv for about 2 months and probably missed the discussion on this. Do you have a pointer to where I can get information on what was messed up in the 8.1.7.3 patch? I was intending to schedule the 8.1.7.3 patch installations for some of my databases in the next few

Re: In an Analyze Necessary?

Don't fix, if it's not broken:-) Do something else with your spare time instead :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 11:48 AM Hello Folks, A datawarehouse. There are

RE: Syntax For Dropping a default value? - Resolved for now.

Yep, ALTER TABLE table_name MODIFY(column DEFAULT NULL); Works so I guess its ok. Was hoping to completely remove Thanks All. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: DB Size

Physical size (disk) or logical size (bytes of actual data)? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Simon Waibale [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 9:53 AM To: Multiple recipients of list ORACLE-L Subject: DB Size Hi all,

Re: YAPP / Oraperf / STATSPACK - Optimal SQL linesize and pagesize

Cherie, I have been trying to figure out your upload problems. And I noticed that your report of statspack looks like it is from 8.1.6, but there are some small differences. Can you tell me the source of this statspack, where did you get it ? Did you modify any of it. I am contemplating a fix,

How to simulate Block Corruption?

Hello Gurus, I am in the process of testing recovery options from block corruptions. So, my setup requires a db which is having block corruption problem. How to simulate block corruption in db? Any help? TIA, Sandeep. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: One way replication in multimaster environment

Very interesting question. Couple years ago, I had very similar problem: I had one central database, which had to consolidate data from multiple source databases (having identical schemas) in real time with as little delay as possible after transaction occurs on the source database, and at the

RE: SMJ, NL or HJ

Depends. The number of rows matching a given FK may vary widely. Collect stats, and let the CBO decide, it should not have it too wrong in such a case. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 03 May 2002 08:13:27

Re: How to simulate Block Corruption?

Hi If you are on a unix platform use dd to write to a datafile, this is what oracle uses in there Backup Recovery Class. On NT find a freeware hex editor and edit the datafile ! I know that there are multible event in Oracle to write corrupt block's, but forget them and use brut force !

Re: SMJ, NL or HJ

Consider analyzing the EMPNUM column for each table as well, to provide the CBO with possibly crucial data distribution information... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 03, 2002 11:18 AM Depends. The number of rows

Re: How to simulate Block Corruption?

-- Sandeep Kurliye [EMAIL PROTECTED] Hello Gurus, I am in the process of testing recovery options from block corruptions. So, my setup requires a db which is having block corruption problem. How to simulate block corruption in db? dd if=/vmunix of=$yourdbf bs=8k count=5; you now have

Re: In an Analyze Necessary?

Words of Wisdom ;-) But, me thinks, I will go ahead and disable that once a week analyze cron job. The CPU can be better utilized for the other night batch jobs. Thanks Raj

RE: One way replication in multimaster environment

Would you be able to send sample of your scripts. Thanks. -Original Message- Sent: Friday, May 03, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Very interesting question. Couple years ago, I had very similar problem: I had one central database, which had to consolidate data

RE: SMJ, NL or HJ

The CBO, presently does quite a good job. It chooses a sort merge join on the tables. Given my understanding of the data distribution in the tables, I agree its the best execution plan. But this kills my temporary tablespace, ORA-1652. To accomodate this query, I altered the sort area for the

Re: One way replication in multimaster environment

One way to handle this problem is to not schedule your jobs to push from Y and Z to X. If transactions occur on Y and Z, they will become deferred transactions, waiting to be pushed to X, but will never push. Then, periodically you can delete the transactions from Y and Z (bound for X). I

Re: How to simulate Block Corruption?

I remember reading a reply from X$ Gopal to a similar question, talking about the possible use of BBED, which is an Oracle support tool. Raj

9i Release 2 features/fixes

Does anyone know of or have a list of new features/fixes for Release 2 of 9i? I can't find anything on oracle.com except XML XML XML. Just wondering if OiD gets any better, I guess. :) TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: Licences for testing

I would not think you would need a license for evaluating the software. However, once you cross the line into development or production licensing is mandatory. Unless things have changed, the Oracle LINUX client is free, but the LINUX server requires licensing as defined above. Ian

Desginer 6i causing me grief

I am upgrading from designer 2.1.2 to designer 6i 4.2. I have installed Designer on my win2k workstation and craeted a new instance on a Solaris box running SUn OS 8. My version of Oracle is 64-bit 8.1.7.3. I closely follow the instruction in the install guide for creating a new repository. (The

Re: SMJ, NL or HJ

Since table B and C are using the same column to join to table A, then it should be possible to ensure that Oracle hashes tables B and C at the same time, then scans table A passing rows through each hash in turn. (The order can be permuted as necessary). If you can set the hash area size to

RE: 9i Release 2 features/fixes

Jesse, Check the Joe site www.oracle-dba.com -Original Message- Sent: Friday, 03 May, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Does anyone know of or have a list of new features/fixes for Release 2 of 9i? I can't find anything on oracle.com except XML XML XML. Just

RE: 9i Release 2 features/fixes

Yup, I've been there. And while the info's good, it's about the new features of 9i, and not of Release 2. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Ramon E.

RE: 9i Release 2 features/fixes

Bingo! I probably just overlooked that link on their site because it isn't named very well. I should have guessed. Thx! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message-

Re: Oracle - Access

I guess this is what has replaced Friday humor and recipes. Anything tangentially related to Oracle. David A. Barbour Oracle DBA, OCP AISD 512-414-1002

ORA-1025??

Hi friends, When Iam exporting thru pipes and mknod, Iam getting error:- PL/SQL Release 2.3.2.0.0 - Production Export done in US7ASCII character set Note: indexes on tables will not be exported About to export specified tables via Direct Path ... . . exporting table

Filesystems vs raw devices on Linux (?)

There was a mention at the RAID roundtable at IOUG-A Live! 2002 on some results published in this whitepaper: http://www.quest.com/whitepapers/Linux_Maximus_Part2.pdf The general consensus was that the test was most likely flawed, but with no specifics given. I am curious as to what was the

Re: ORA-1025??

Raghu Kota wrote: Hi friends, When Iam exporting thru pipes and mknod, Iam getting error:- PL/SQL Release 2.3.2.0.0 - Production Export done in US7ASCII character set Note: indexes on tables will not be exported About to export specified tables via Direct Path ... . . exporting

Re: Filesystems vs raw devices on Linux (?)

If I remember correctly, Stephane Faroult was mentioned as having shed some light on it. Don, You probably don't remember correctly. I hardly know what RAID stands for. I always try to do everything in memory :-). -- Regards, Stephane Faroult Oriole Software -- Please see the

Re: Filesystems vs raw devices on Linux (?)

The basic consensus of the discussion here was not the test itself but the analysis was somewhat flakey. The performance was generally reviewed purely with the stopwatch, so seeing where the bottlenecks were (on raw or any of the filesystems tested) was not really assessed or reported. But

Datawarehousing help

Okay, my background is OLTP, but we are looking at a data warehousing project here any and all help appreciated! Specifically: 1) does anyone have any experience with a product called SAS Datawarehousing Administrator (or SAS)? 2) how do I go about doing rough estimates of sizing needs,

Re: SMJ, NL or HJ

Thanks Jonathan, for your inputs. I am trying to understand hash joins. New to it. As I understand this, and looking at the plan that you have mentioned : hash table C hash table B table A 1. Tables B and C will be hashed in parallel, and Hash table for A

Re: 9i Release 2 features/fixes

You can sure that Oid will be better - because lets face it - it couldn't have got any worse :-) --- Jesse, Rich [EMAIL PROTECTED] wrote: Does anyone know of or have a list of new features/fixes for Release 2 of 9i? I can't find anything on oracle.com except XML XML XML. Just wondering

RE: In an Analyze Necessary?

Rajesh, You seem to be one of those lucky DBAs who don't have performance issues :) Just keep in mind that when statistics are NOT present and the CBO is forced by one of the many reasons, some defaults will be assumed. These defaults are absolutely invalid and incorrect. So, even if you analyze

IN() question

Slap me if this is a dumb question. Here's my pay methods SQL SELECT ASCII(PAY_METHOD), PAY_METHOD, COUNT(*) 2 FROM LEISURE_PLAN_MASTER_TEMP 3 WHERE MEMBERSHIP_CLASS = 'D' 4 GROUP BY PAY_METHOD; ASCII(PAY_METHOD) P COUNT(*) - - -- 67 C

RE: Licences for testing

Download the 30 day trial from OTN -Original Message- Sean Sent: Friday, May 03, 2002 5:09 AM To: Multiple recipients of list ORACLE-L We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short

RE: Licences for testing

Personal Oracle is indeed a product that needs to be licensed. -Original Message- Dave Sent: Friday, May 03, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Would the personal edition work for you? I don't think there would be a licensing issue with this. Dave -Original

Re: IN() question

In any equivalence operation (which includes non-equivalence, too), NULL never returns TRUE -- it just returns NULL which non-TRUE has the same result as FALSE. Only IS and IS NOT operators can be used to evaluate NULLs... - Original Message - To: Multiple recipients of list ORACLE-L

RE: Paging problem in SunOS

He is having paging problems and you are recommending that he increase his SGA? Could you explain how you feel that will solve his problem please? Thx -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul LiSent: Friday, May 03, 2002 6:48

RE: Datawarehousing help

Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis package. A scientist or engineer could load a set of test data into it and perform various arithmetic and statistical analyses. Today

Re: IN() question

Yes, your why is correct, NULL is neither equal nor not equal to any value. I usually nvl to return a space for null values when I have to consider them, then a not equal will work. At 03:43 PM 5/3/02 -0800, you wrote: Slap me if this is a dumb question. Here's my pay methods SQL SELECT

RE: IN() question

Thanks Tim. I thought so. Lisa -Original Message- From: Tim Gorman [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 8:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: IN() question In any equivalence operation (which includes non-equivalence, too), NULL

RE: IN() question

Hi Regina, thanks for your reply. Lisa -Original Message- From: Regina Harter [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 8:58 PM To: Multiple recipients of list ORACLE-L Subject: Re: IN() question Yes, your why is correct, NULL is neither equal nor not equal to

test - text file attachment / Re: ORACLE-L Digest -- Volume 2002, Number 123

what is factotum? ORACLE-L Digest -- Volume 2002, Number 123 -- From: Mercadante, Thomas F [EMAIL PROTECTED] Date: Thu, 2 May 2002 08:09:14 -0400 Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) what - you changing careers - trying out for Denis

RE: Datawarehousing help

Excellent dude. -Original Message- WILLIAMS Sent: Friday, May 03, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Rachel - I always find it helpful to understand something if I know the origins. I worked with SAS several years ago. At that time it was a statistical analysis

(Fwd) iDS 9.0.2 / Forms 9i Available

--- Forwarded message follows --- Date sent: Fri, 03 May 2002 10:15:26 -0800 O D T U G - D E V 2 K - L @ f a t c i t y . c o m d u n c a n . m i l l s @ o r a c l e . c o m Organization: Fat City Network Services, San Diego, California For everyone who's been

Spec'ing hardware

I'm about to start a new job and one of my first tasks will be to specify hardware for a new 9i database. I'd appreciate any procedures, tips, etc. for deciding the hardware configuration (CPU, memory) of a new server that will host the database. It'll mostly likely be a Sun machine. Thanks in

RE: Spec'ing hardware

Fewer, faster CPU's, more memory. The SA's have been really happy with the Sun servers they have now, The Sun Fire series. They prefer them over the Enterprise version. -Original Message- Baumgartel Sent: Friday, May 03, 2002 7:33 PM To: Multiple recipients of list ORACLE-L I'm about