Max Extents Error
Hi, I have a table which consists of Long Raw column in addition to other columnsof Number and Varchar2 datatypes. I have the datafile size set to 2GB. The average length of the messages goes up to 100M, sometimes more than that. I have now added three datafiles to that tablespace each greater than the first datafile. But I still keep getting the ORA-01631 Max extents reached for table "A" error. What do I do resolve this error? I am using 8K as the DB block size on SOlaris with Oracle 816. It is not a prod environment instead a dev environment. Thanks Sanjay
Oracle Installation on DiskArray -
Hi, My company is planning to install Disk Array on Solaris. After that, I am going to install Oracle. I just wanted to know whether is there any special consideration or steps to be taken to install Oracle on this Solaris? If so what are the steps? Where can I get that steps from? I am using Solaris 8 with Oracle 817 Sanjay
Oracle Installation on DiskArray
Hi, Thanks to those who replied. I was wondering whether which RAID level to implement. My database is not a very critical 24x7 database. It is a development database. There are going to be only a few users accessing this database. Infact the data as such is not very important as it is test data. Any suggestions on which RAID level to implement? TIA Sanjay
Help with Oracle
Hi, I want to display thedata fromfew tables into Excel sheet. How do I do that? Is there any tool available? Sanjay
Re: Table Storage Estimates
Thanks all for the solution. I too thought of having a 1 : 1 relationship by separating the long raw column from the table. But I believe I am not permitted to do that (Strange). Since this is a third party product, I am not suppose to change any of the design issues and also the datatype. I believe row chaining is obvious in this situation. Also the average row length is 10M. The size of the database block size is 8. When I queried the dba_extents to find the number of blocks that have been occupied, it showed 16620 and the number of rows are 113. I am totally confused now. Any help greatly appreciated. Sanjay - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 12:46 AM Your estimate comes to around 1 row per block. What is the average row lenght once data is in the db ? Do you have row chaining ? What is your block size ? Can you increase it ? If a lot of queries do not need the long raw column you can put it in another table with a 1 to 1 relationship with the parent table. If your planning to have 200 rows of 1 block each, I do not understand why you are adding datafiles as the data should not occupied more than 3200K if you blocksize is 16K. Increase the size of the initial datafile instead of adding new ones. --- Sanjay Kumar [EMAIL PROTECTED] a crit : Hi, I have a table which has a structure similar to the following. MID NOT NULL VARCHAR2(24) NAME VARCHAR2(512) PRIORITY NUMBER(38) PERSISTENT CHAR(1) EXP_DATE DATE BODY LONG RAW I estimated the table storage for this table using the formula given in the Oracle documentation. It comes to around 1 rows per block. It is estimated that the number of rows for this table will not exceed 200. My questions are 1. Doesnt this lead to fragmentation.? 2. I have added three datafiles to this tablespace as of now and it seems like this might require more space. How do I effectively redesign this table to avoid contention and chaining? 3. Moreover, initially when there were 105 rows inserted, I issued a count(*) and it took about 5 minutes? How do I reduce the time taken to execute the query? I would highly appreciate if someone comes forward to help me on this. I am using Oracle 8.1.6 on Solaris Sanjay = Stephane Paquette DBA Oracle [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Sanjay Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Document Preparation for a table
Hi, I am asked to prepare a document listing all possible suggestions for an effective tuningof a single table. The table has five to six columns with one column having a Long Raw datatype. The average row that gets into the database is about 1GB. Could anyone give me possible suggestions? I was planning to start from DB Block Size. I also thought of having 16 as the block size. I would like to know whether is this a good idea of having 16? Sanjay
Table Storage Estimates
Hi, I have a table which has a structure similar to the following. MID NOT NULL VARCHAR2(24)NAME VARCHAR2(512)PRIORITY NUMBER(38)PERSISTENT CHAR(1)EXP_DATE DATEBODY LONG RAW I estimated the table storage for this table using the formula given in the Oracle documentation. It comes to around 1 rows per block. It is estimated that the number of rows for this table will not exceed 200. My questions are 1. Doesnt this lead to fragmentation.? 2. I have added three datafiles to this tablespace as of now and it seems like this might require more space. How do I effectively redesign this table to avoid contention and chaining? 3. Moreover, initially when there were 105 rows inserted, I issued a count(*) and it took about 5 minutes? How do I reduce the time taken to execute the query? I would highly appreciate if someone comes forward to help me on this. I am using Oracle 8.1.6 on Solaris Sanjay
Oracle JDBC Thin Driver Licensing Issue
hi, Does anyone know whether Oracle JDBC Thin Driver can be shipped to the clients without getting any license from Oracle?. Is it free for shipping? Sanjay
SQL Text
hi, I want to see the latest SQL Statements that I sent to Database. I know that I can make use of V$sqlarea but it restricts only tofirst 1000 characters. But my query is more than that. Any help. Sanjay
User objects in System tablespace
Hi, I have a situation where in all the user related objects (tables) have been created in System tablespace. I believe there is no convention followed while creating these tables. Now, how do I separate these user related objects and put them in Users tablespace? Vinay