RE: Temporary Tablespace and RAC
I agree. I have a similar situation with my 8.1.5 OPS database [going to 9iRAC next month]. One instance is used by query-only users and the other by transaction users, to reduce the probability of block-pinging. However, as both use the same schema, both share the same TEMPORARY Tablespace. A bad query can blow the usage of the Temporary Segment from the Query Instance and reduce the available space for the Temporary Segment of the Transaction Instance. What makes it worse is that the Tablespace datafile is a Raw Device and I cannot resize or extend it any more !! At least on 9iRAC on Tru64CFS, I will be placing the Temporary Tablespace on a Unix File System so that I can resize or add new files. One option would be to create a seperate Schema with all the required SELECT [and INSERT/UPDATE/DELETE] privileges and use the seperate Schema from the second instance. Then, have a seperate Temporary Tablespace for each schema ! Hemant At 11:24 AM 21-03-03 -0800, you wrote: Here's a scenario - Connections are load balanced (server-side) over both the instances of the RAC. Temp Space is 10GB. User A (non-expert) connects to instance 2 from a GUI tool and clicks on the data-tab of a 50-million row table and chooses to order by some huge column. This results in temp space allocated to Instance 2's temp segment and allocated to session A. 9.5 GB has been allocated to Instance 2's temp segment, user is still running query. Instance 1 has only 500MB in its TEMP segment to serve its sessions. A production application B connects to instance 1 and runs a valid query which doesn't have enough TEMP space since all the space has been de-allocated from Instance 1's temp segment and allocated to Instance 2 temp segment. At this point sessions connected to Instance 1 have very little or no temp space. If 10 GB could be split among instances, or even separate TEMP tablespaces tied to each instance, then you can (to some extent) guarantee TEMP space at instance level. You're trying to protect sessions connected to one instance from a rogue-session on another instance which is draining all TEMP space. Another way is to have obscene large TEMP space, but there should be a better way to handle this. Hope this makes sense. Any ideas? -Original Message- Sent: Thursday, March 20, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Hello Ashok What are u seeing to make you believe that you need separate temp segements per instance? Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 20 Mar 2003 17:14:18 -0800 Is there a way in RAC that I can create 2 TEMP tablespaces which can be explicitly assigned to separate instances of RAC. Or is there a way that to specify the size of the instance-specific temp segments? If I have a TEMP tablespace with a size of 10GB, how can i split it between 2 instances with 5GB each. We're using 9.2.0.2. Are there any white papers that talk about how TEMP is managed in RAC? As I understand it, if you have a single TEMP tablespace, there will be 2 temp segments created under the TEMP tablespace specific to each instance and extents will be allocated from those segments to each instance's session, but Oracle doesn't allow for TEMP space to be pre-allocated between instances. Depending on the instance-specific TEMP segment's requirements, it allocates and deallocates automatically between segments. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Balakrishnan, Ashok - VSCM INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My personal web site is :
Memory taken by s session
Title: Memory taken by s session Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC
Re: Memory taken by s session
Take a look at v$sesstat for the statistics on pga and uga memory used hth connor --- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote: Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Memory taken by s session
Hussain Ahmed Qadri, hi, from oracle, you can get it from v$sesstat, in oracle9i ,you can even get the more detailed data from v$process. From Unix os, for solaris, you can use pmap, on linux, you can use /proc/spid/status. FOr other os, I hope others can share there experience. Good luck Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org(China Oracle User Group) === 2003-03-22 00:13:00 ,you wrote£º=== Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he performs certain query, which returns over a few thousand records or more, what is the effect on the memory usage of that session. Any guidelines perhaps? Regards, DBA SKMCHRC = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Foreign Key Not Found ??
Hi List , Can you help on this Problem Please . We have an application with about 100 table ,In some forms that have foreign keys when we try to select a value we get this message ( fk has been violated parent key not found ),but the foreign key exist !!. THis happens on records that are new foreign keys only ,i solve the problem by droping the foreign key and build it again . Does any one of you faced such sitituation .. Thanks for any help or suggestion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally Managed Tablespaces
The other pctincrease option that preserves a multiple of the extent size is 100. Similiar to LMT autoallocate extent sizes always being a multiple of 64K. Have Fun :) Rachel Carmichael wrote: pctincrease=0 and set the storage parameters at the tablespace level and do NOT put storage parameters on the individual objects. you can fake the workings (without the bitmap!) of an LMT by doing that. Next extent=initial extent, pctincrease=0 will effectively allocate extents of equal sizes --- [EMAIL PROTECTED] wrote: thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. Ryan From: BALA,PRAKASH (HP-USA,ex1) [EMAIL PROTECTED] Date: 2003/03/21 Fri PM 12:54:41 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Locally Managed Tablespaces Once you set to uniform extents, pctincrease will default to 0. Most Oracle gurus advise to just use uniform extents for all situations. -Original Message- Sent: Friday, March 21, 2003 10:59 To: Multiple recipients of list ORACLE-L This is probably pretty basic, so please keep in mind that Im a developer and Im trying to pick up more of the DBA side. I am assuming that the preferred way to create a tablespace in 8i, 9i is as follows(this is out of OTN docs) CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; When you use Uniform Extents you know longer have to worry about tablespace fragmentation correct? You also do not need to worry minimum,initial,and next extents correct? What are some rules of thumb for setting PCTINCREASE(there is another PCT setting too right)? A DBA I used to work with said you should almost always use zero for PCTINCREASE. Could someone please tell me why? The default is like 40? Is there a time when I should not use Uniform Extents? Thanks... hope this isnt too basic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BALA,PRAKASH (HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Locally Managed Tablespaces
thanks for all the responses to such a basic question. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 22, 2003 6:03 AM The other pctincrease option that preserves a multiple of the extent size is 100. Similiar to LMT autoallocate extent sizes always being a multiple of 64K. Have Fun :) Rachel Carmichael wrote: pctincrease=0 and set the storage parameters at the tablespace level and do NOT put storage parameters on the individual objects. you can fake the workings (without the bitmap!) of an LMT by doing that. Next extent=initial extent, pctincrease=0 will effectively allocate extents of equal sizes --- [EMAIL PROTECTED] wrote: thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. Ryan From: BALA,PRAKASH (HP-USA,ex1) [EMAIL PROTECTED] Date: 2003/03/21 Fri PM 12:54:41 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Locally Managed Tablespaces Once you set to uniform extents, pctincrease will default to 0. Most Oracle gurus advise to just use uniform extents for all situations. -Original Message- Sent: Friday, March 21, 2003 10:59 To: Multiple recipients of list ORACLE-L This is probably pretty basic, so please keep in mind that Im a developer and Im trying to pick up more of the DBA side. I am assuming that the preferred way to create a tablespace in 8i, 9i is as follows(this is out of OTN docs) CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; When you use Uniform Extents you know longer have to worry about tablespace fragmentation correct? You also do not need to worry minimum,initial,and next extents correct? What are some rules of thumb for setting PCTINCREASE(there is another PCT setting too right)? A DBA I used to work with said you should almost always use zero for PCTINCREASE. Could someone please tell me why? The default is like 40? Is there a time when I should not use Uniform Extents? Thanks... hope this isnt too basic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BALA,PRAKASH (HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Foreign Key Not Found ??
hi which oracle server and forms versions ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 22, 2003 1:43 PM Hi List , Can you help on this Problem Please . We have an application with about 100 table ,In some forms that have foreign keys when we try to select a value we get this message ( fk has been violated parent key not found ),but the foreign key exist !!. THis happens on records that are new foreign keys only ,i solve the problem by droping the foreign key and build it again . Does any one of you faced such sitituation .. Thanks for any help or suggestion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Salaheldin Aboali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Query Tuning urgent
BDY.RTF Description: RTF file
Re: Error while running export backup shell script
I am not sure if you got a answer to your question. I read a few answers and they looked like they were pointing you in wrong direction. The file mknod should be executable by everyone of the system as a defualt. The problem with mknod is that it is located in the /usr/sbin directory. This directory is not normally in your PATH, unless you have a very liberal UNIX Admin. Just include this is the PATH PATH=${ORACLE_HOME}/bin:/usr/sbin:${PATH} I am not sure if you are running this through Oracle's crontab. But a good practice when you are running from cron is to assume that you get no path. Set every path even /bin and /usr/bin. Then 99% of all cron problems usually go away. The other problem I saw was that you have a few lines that are being split into multiple lines, I will assume that this is a email problem only. Another good practice is to keep lines below 80 characters. This way you can print your scripts and even pass them on to evil operating system like micosoft without them being affected. From old UNIX Admin. that debuged my share of scripts. later, Charles Hart From: Krishnaswamy, Ranganath [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Error while running export backup shell script Date: Thu, 20 Mar 2003 23:43:36 -0800 Hi List, I have got a shell script for taking full export backup which I am attaching with this mail as .sql file as I cannot send .sh file as file attachments. I am getting the following error when I run the script in full_exp_20030321_1309_job.log: ### #Starting fullexportlsyrs.sh at Fri Mar 21 13:09:41 GMT 2003 # fullexportlsyrs.sh[3]: mknod: not found fullexportlsyrs.sh[4]: /export/home/ranganat/backups/full_exp_20030321_1309_pipe : cannot open LRM-00112: Message 112 not found; No message file for product=ORACORE, facility= LRM EXP-00019: Message 19 not found; No message file for product=RDBMS, facility=EXP EXP-0: Message 0 not found; No message file for product=RDBMS, facility=EXP/ export/home/ranganat/backups/full_exp_20030321_1309_pipe: No such file or direct ory # #Job run time was: 0 hours, 0 minutes, 0 seconds # #Ending fullexportlsyrs.sh at Fri Mar 21 13:09:41 GMT 2003 with an exit status o f 127 # What should I do to eliminate the above errors and run the scripts successfully? Any help in this regard is very much appreciated Thanks and Regards, Ranganath fullexportlsyrs.sql WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. fullexportlsyrs.sql _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charles Hart INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Query Tuning urgent
[EMAIL PROTECTED] wrote: The following qry takes large amt of time to retrieve data on production database. Reason being for a single row in psd, there are multiple records in piar_fr_psd representing diff parties. How to optimise this qry . Select CUST_BAS_NO,BR_COD,CUST_NAM,BR_NAM from ( select distinct(decode(b.sys_id,'TRDENG',rtrim(a.cust_bas_no),rtrim(a.cosmos_ba se_no))) cust_bas_no , a.br_cod br_cod ,pty_nam cust_nam,bank_name br_nam, rank() over (partition by decode(b.sys_id,'TRDENG',rtrim(a.cust_bas_no),rtrim(a.cosmos_base_no)),a .br_cod order by pty_nam) as rk from piar_fr_psd a, psd b, bank_br c where a.psd_id=b.psd_id and a.psd_serial_num = b.psd_serial_no and b.bank_id = c.bank_id and (((sys_id = 'TRDENG') and (a.cust_bas_no is not null)) or ((sys_id 'TRDENG') and (a.cosmos_base_no is not null))) ) where rk = 1 order by br_cod,cust_bas_no; Thanks Manoj Manoj, Very quickly your DISTINCT seems totally useless since you have your 'where rk = 1' condition to ensure you return a single row. Your join with bank_br could be done at the highest (least nested) level. I note that, bar the bank name, everything comes from PIAR_FR_PSD. When you say that there are multiple records for each row in PSD, does it mean that occasionally you can have two or three rows, or that you generally have dozens of rows? I think that in the first case DISTINCT might prove to be better than the analytic function, especially since you have an ORDER BY anyway. In the second case, the analytic function is probably by far the best solution. But as said above, having both seems redundant. A bit awkward to use a column from one table to interpret a table from another; design doesn't seem to be flawless. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Locally Managed Tablespaces
AUTOEXTEND can be abused for sure, but it can also be a big time saver. Say you want to load 100 gigabytes of data, and you have 5 disks to spread it out on. You opt for 5 files of 4 gig each on each disk. That gives you 20 files to create in your tablespace. Creating 100 gig of datafiles takes awhile. If you start each file out as 500m with a next size of 500m and a max of 4g, you can defer the time spent creating the files to load time, rather than waiting around for 100g of files to be created before you start loading. Still takes the same amount of time, but you get to go home earlier. :) Jared On Friday 21 March 2003 18:23, Jacques Kilchoer wrote: Well, my first suggestion would be to buy a software package from a reputable software company that lets you predict object growth and an estimate of when your tablespace will be full. Contact me for more details. :) But seriously, you can write a report that shows the number of extents and the amount of freespace in each tablespace, and review the report periodically (say once a week). Which is what I did back in my production DBA days. I imagine you could have a database procedure that checks the free space in a tablespace and sends you an e-mail, or even pages you if you have e-mail forwarded to a pager. Setting the datafiles to autoextend just pushes the problem back to the OS level - how do you know when your disks will be full? -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] so for normal business you should not use autoextend? You should monitor it yourself? What are some tips for monitoring the database to see if you need to extend your tablespace manually? Do you use DBMS_ALERT and read the v$ views and then broadcast a message if you need to extend a tablespace? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problems installing Developer on XP
http://otn.oracle.com/software/products/forms/content.html has a link to download Oracle Forms Developer/Services 6i Release 2 for Windows 98/NT/2000/XP that was posted 13 Feb 03. Note: this is the first Forms 6i installer that can install on Windows XP Professional (previous versions were disabled). The OTN Forms statement of direction is worth reading: http://otn.oracle.com/products/forms/htdocs/FormsSOD.html Looks like Windows XP Professional will be the last Windows platform to be certified for Forms 6i client/server deployment. Also, OTN has a certification matrix for Forms 6i: http://otn.oracle.com/products/forms/htdocs/clientsod_forms6i.html Have Fun :) Babette Turner-Underwood wrote: I am trying to install Developer 6i on a Pentium 4 Xeon The Oracle Universal Intaller has a problem and tries to send error report to Microsfot. I checked Metalink and the workaround was to search for symcjit.dll in the install directories and rename to symcjit.old ... did this. Also the solution was to replace JInitiator 1.1.7 with JInitiator 1.1.8. I checked and when I installed Oracle 9i on this machine the 1.1.8 was installed and I do not have the 1.1.7 under c:\programs\oracle\jre Any other ideas on what to do ??? Thanks - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problems installing Developer on XP
Thanks Chip, I will take a look at this when I get time. In the meantime, I found one solution My local expert showed me how to get this to run Right click on setup.exe and under properties, can set the compatibilty to Windows2000. It worked !! - Babette -Original Message- Sent: Sunday, March 23, 2003 12:04 AM To: Multiple recipients of list ORACLE-L http://otn.oracle.com/software/products/forms/content.html has a link to download Oracle Forms Developer/Services 6i Release 2 for Windows 98/NT/2000/XP that was posted 13 Feb 03. Note: this is the first Forms 6i installer that can install on Windows XP Professional (previous versions were disabled). The OTN Forms statement of direction is worth reading: http://otn.oracle.com/products/forms/htdocs/FormsSOD.html Looks like Windows XP Professional will be the last Windows platform to be certified for Forms 6i client/server deployment. Also, OTN has a certification matrix for Forms 6i: http://otn.oracle.com/products/forms/htdocs/clientsod_forms6i.html Have Fun :) Babette Turner-Underwood wrote: I am trying to install Developer 6i on a Pentium 4 Xeon The Oracle Universal Intaller has a problem and tries to send error report to Microsfot. I checked Metalink and the workaround was to search for symcjit.dll in the install directories and rename to symcjit.old ... did this. Also the solution was to replace JInitiator 1.1.7 with JInitiator 1.1.8. I checked and when I installed Oracle 9i on this machine the 1.1.8 was installed and I do not have the 1.1.7 under c:\programs\oracle\jre Any other ideas on what to do ??? Thanks - Babette [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).