Oracle 9.0.1.3 or 9.2.0?
Hi DBAs We are upgrading from 8.1.5 to 9.x. I thought of finding out which release of 9i is more stable. As We have got 9.2 couple of weeks back, I was just wondering what is worth going for 9.2 instead of 9.0.1.3? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Statistics not updated
Hi DBAs The DB is 8.1.5 on Solaris under CBO. The statistics for some of the tables are getting updated after issuing analyze table. I tried with dbms_utility also but no result. What could be wrong? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RE: Statistics not updated
No. -Original Message- Sent: 29 November 2001 15:30 To: Multiple recipients of list ORACLE-L Are you seeing 'UNABLE TO EXTEND TEMP TABLESPACE...' in your alert log? -Original Message- Sent: Thursday, November 29, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi DBAs The DB is 8.1.5 on Solaris under CBO. The statistics for some of the tables are getting updated after issuing analyze table. I tried with dbms_utility also but no result. What could be wrong? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Troiano, Paul (CAP, GEFA) 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: Raj Gopalan 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).
RE: Oracle Reports....
Give a try by tracing the session used by the report. -Original Message- Sent: 25 October 2001 16:05 To: Multiple recipients of list ORACLE-L Thanks Rachel, I'll check these tables to see what dets they hold. The problem I have is that I can't phone the user and say are you running that report, because they have a big nasty lady who will come and bite my head off if she thinks we're actually trying to help!! ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 25 October 2001 14:35 To: Multiple recipients of list ORACLE-L you should be able to pull the queries out of v$sql, v$sqlarea and/or v$sqltext --- Thomas, Kevin [EMAIL PROTECTED] wrote: Hi all, Sorry about the non-DBA related post...but I reckon you guys will be able to point me in the right direction! Our client is running some Oracle Reports (v2.5) that are killing our database, in that the queries contained in them have an average hit rate of less than 2%!!! Guess what, it get's better, they don't have the source code anymore!! Is there a way of either a) re-engineering the executable, or b) a third party tool that will extract the queries or show the report in a text version (?!?). Any thoughts guru-type-people ;o) Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Thomas, Kevin 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: Raj Gopalan 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).
RE: Unix Cron Job
$crontab -- Press enter
0 1 * * * /blah/blah/blah.sh
-- Press {CTRL}+D
-Original Message-
Sent: 03 October 2001 17:21
To: Multiple recipients of list ORACLE-L
Hi List,
I am not a Unix person and want to scheduled a batch job to run on Unix
machine every night at 1:00 AM, if you have any script for this or similar
really appreciate.
Thanks in Advance
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
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: Raj Gopalan
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).
Slightly OT : IFS Search is Slow.
Hi
We are using IFS 1.1 version on HP UX. Large number of XMl documents are
loaded into IFS ( around 5.5 gb of table space occupied).
Our req. is , given a file name , we need to lookup for the same in IFS
repository and load it if exists. Search is based on file name ( attribute
search) not file contents ( content search) .
The following is the function we have wriiten to search
public String ifsDocSearch(String name, String path, String owner)throws
Exception
{
FolderRestrictQualification frq = new FolderRestrictQualification();
FolderPathResolver fpr = new FolderPathResolver(ifsSession);
fpr.setRootFolder();
Folder startFolder = (Folder) fpr.findPublicObjectByPath(path);
frq.setStartFolder(startFolder);
AttributeQualification aq = new AttributeQualification();
aq.setAttribute(oracle.ifs.beans.Document.CLASS_NAME,NAME);
aq.setOperatorType(aq.EQUAL);
aq.setValue(name);
AttributeQualification aq1 = new AttributeQualification();
aq1.setAttribute(oracle.ifs.beans.Document.OWNER_ATTRIBUTE,oracle.ifs.beans.
Document.OWNER_ATTRIBUTE);
aq1.setOperatorType(aq.EQUAL);
aq1.setValue(owner);
String arr[]= new String[2];
arr[0]=DOCUMENT;
arr[1]=FOLDER;
SearchClassSpecification scs=new SearchClassSpecification(arr);
AttributeSearchSpecification ass = new AttributeSearchSpecification();
ass.setSearchClassSpecification(scs);
SearchClause sc = new SearchClause(aq, frq, SearchClause.AND);
SearchClause sc1 = new SearchClause(sc, aq1, SearchClause.AND);
ass.setSearchQualification(sc);
Search s = new Search(this.ifsSession,ass);
s.setSearchSpecification(ass);
s.open();
SearchResultObject sro=s.getItems(0);
if(sro==null)
{
System.out.println(sro is null);
return null;
}
oracle.ifs.beans.Document myDoc = (oracle.ifs.beans.Document)
sro.getLibraryObject();
if(myDoc == null)
{
System.out.println(my doc is null);
return null;
}
vxweb.vxhelper.VxDebug.timer(File IO);
StringBuffer sb = new StringBuffer();
BufferedReader bufferedReader =
new BufferedReader(myDoc.getContentReader());
for (String l_nextLine = bufferedReader.readLine();
l_nextLine != null;
l_nextLine = bufferedReader.readLine()) {
sb.append(l_nextLine);
sb.append(\n);
}
vxweb.vxhelper.VxDebug.timer(File IO);
System.out.println(sb);
return sb.toString();
}
The search seems to be slower. it takes around 2-4 sec. -
Is there any way this can be tuned better for faster searching?
do we need to create any indexes file names in IFS schema ?
Other Info : processing mode :MTS
table space for ifs : localymanaged
Thanks in Advance
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
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).
Higher Consistent Gets...
!! Please do not post Off Topic to this List !!
Hi
I am having problem with a query. This query fetches rows from a table which
has 15 million rows.
The problem is, when I execute this query with subquery, the consistent gets
are 4700. Where us without the subquery the consistent gets are just 400. If
I execute the subquery alone, the consistent gets are just 5.
Here is the main query with subquery results in cons.gets of 4700:
select pd.holiday_id holidayID, pd.package_number l_package_number,
min(pd.tfr_price) l_tpr_price
from fr_search_query pd
where pd.departure_date between TO_DATE('06/10/2001','dd/mm/')
and TO_DATE('13/10/2001','dd/mm/')
and pd.location_code in (select location_code
from gn_location
connect by prior location_code=parent_code
start with location_code='3142')
and ROWNUM 301
group by pd.holiday_id , pd.package_number
order by pd.location_name, pd.location_code, pd.accom_unit_name,
pd.accom_unit_code, pd.departure_date, min(pd.adult_price)
Trace results
Rows Execution Plan
--- ---
0 SELECT STATEMENT GOAL: CHOOSE
96 SORT (ORDER BY)
96SORT (GROUP BY)
96 COUNT (STOPKEY)
96 NESTED LOOPS
5137 INLIST ITERATOR
5138TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF
'FR_SEARCH_QUERY'
8566 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'FR_SEARCH_QUERY_IND_1' (NON-UNIQUE)
96 VIEW
5136SORT (UNIQUE)
1 CONNECT BY
2 INDEX GOAL: ANALYZED (FAST FULL SCAN) OF
'PK_GN_LOCATION' (UNIQUE)
1 TABLE ACCESS (BY USER ROWID) OF 'GN_LOCATION'
1 TABLE ACCESS (FULL) OF 'GN_LOCATION'
Running just the subquery results in cons.gets of just 5.
select location_code
from gn_location
connect by prior location_code=parent_code
start with location_code='3142'
Rows Execution Plan
--- ---
0 SELECT STATEMENT GOAL: CHOOSE
1 CONNECT BY
2INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_GN_LOCATION'
(UNIQUE)
1TABLE ACCESS (BY USER ROWID) OF 'GN_LOCATION'
1TABLE ACCESS (RANGE SCAN) OF 'GN_PARENT_LOCATION_CODE'
(NON-UNIQUE)
Both the tables, indexes are analyzed. The optimizer mode is choose.
How do I tune this or Am I missing something obivious??
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
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).
RE: STOP THE PRESS!!
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: Kevin Lange 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: Raj Gopalan 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).
Extent's datafile.
DBAs I manually allocated extents of a table to different datafiles. Which performance views will give information relating extents and datafiles? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Recall: Extent's datafile.
Raj Gopalan would like to recall the message, Extent's datafile.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RE: Locally managed tablespaces
But I am having rollback segments using LMT.. I am on 8.1.5... -Original Message- Sent: 19 July 2001 18:57 To: Multiple recipients of list ORACLE-L Actually, I discovered that you cannot use it for the rollback tablespace either. Oh, you can create the tablespace no problem but then you cannot create the rollback segments in it. Something that the doco failed to mention. I did catch the temporary one in the doco though. -Original Message- Sent: Thursday, July 19, 2001 10:32 AM To: Multiple recipients of list ORACLE-L You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Hillman, Alex 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: Kimberly Smith 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: Raj Gopalan 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).
RE: PL/SQL
vPOSTAL_NO:=lpad(replace(nvl(POSTAL_NO,'0'),' ',''),6,'0'); -Original Message- Sent: 29 June 2001 13:30 To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Raj Gopalan 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).
RE: Quick select question
Try with dynamic sql from user_tables which displays the table_name and then the count on it. -Original Message- Sent: 20 June 2001 18:17 To: Multiple recipients of list ORACLE-L All, Anyone know how to get a list of tablenames and the count of rows in them TABLE_NAMECOUNT === == LEE10 LEE1 25 LEE2 17etc etc I know it can be done if the tables are analyzed and from user_tables but was wanting to know how to do it from sqlplus. Tru64 8.0.5.0.0 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 reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Shared server model
DBAs, I am working for a web developing and hosting company. My boss came out with an idea of putting all the DB in a massive(!!) server so that we dont need to have seperate server for each DB. He argues this is better idea than having DB server for each site. I am not sure how this will work. Any thoughts on this would be helpful to me.. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Ora-600 : Internal error code.. Help!!!
DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RE: Shared Pool info - V$sqlarea.
Thanks Chris. The problem I am facing is 100% CPU usage and memory paging out at times. I tought the starting point is v$sqlarea. Purchasing of Precise SQL or SQL Vision can not happen here immediately. The RAM size is 512MB and SGA is 210MB. The buffer cache hit ratio is 99%. I was just wondering is there any way to find out the cause of this problem? TIA Cheers Raj -Original Message- Sent: 01 June 2001 19:51 To: Multiple recipients of list ORACLE-L Oracle has no guarentee how long statistics and plans will be available for statements, depending on the activity of the database they may be there for 2 seconds they may be there for 2 weeks. Products like Precise SQL and SQL Vision Lab help in that manor where they capture transactions and activity continuously in a non-intrusive manor. This is the only guarenteed way to get 99.999% of the transactions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 12:16 PM To: Multiple recipients of list ORACLE-L DBAs The statistics in v$sqlarea is getting flushed very often. In the morning I found the a query which has more than 10,000 disk reads as the top one. But now the top most query with disk reads has not more than 100 disk reads. I have not bouncd the DB or flushed the shared pool. The overall library cache hit ratio is 97%.where us SQLAREA hit ratio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Christopher Spence 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: Raj Gopalan 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).
Shared Pool info - V$sqlarea.
DBAs The statistics in v$sqlarea is getting flushed very often. In the morning I found the a query which has more than 10,000 disk reads as the top one. But now the top most query with disk reads has not more than 100 disk reads. I have not bouncd the DB or flushed the shared pool. The overall library cache hit ratio is 97%.where us SQLAREA hit ratio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Deleting Files in NT
DBAs How do I delete files from NT which are older than a week. I need this to organise my backup dump files. Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RMAN Catalog - Backup Strategy
DBAs I am taking the export backup of RMAN catalog DB from the Target DB server , immediately after the target DB RMAN backup. Is it a decent way or can it be done better? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RE: Alert log
Hi I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any idea how to control it in 8.1.5? Raj -Original Message- Sent: 12 May 2001 00:18 To: Multiple recipients of list ORACLE-L Raj, It's new archiving tracing introduced in 8i. If you're on 8.1.6 or later you can control the level of tracing with the LOG_ARCHIVE_TRACE parameter. See the following docs: Note 94055.1 Init.ora Parameter LOG_ARCHIVE_TRACE Reference Note Note 104405.1 ARCH tracefile messages VALIDATE, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Raj Gopalan 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).
RE: Alert log
Rafiq But I want my db to be archived.. Raj -Original Message- Sent: 11 May 2001 21:46 To: Multiple recipients of list ORACLE-L Your archiving is TRUE instead of false Check for log_archive_start FALSE change this parameter to false and rebounce your database. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 May 2001 08:46:06 -0800 DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Raj Gopalan 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).
Alert log
DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RMAN Question
DBAs, I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode. I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable. I know that I wont be able to recover the tables in nologging mode. What I would like to know is about the recovery possibility of other tables in logging mode. Will there be any problem during recovery as these datafiles are in unrecoverable status? TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RMAN Backup Size
DBAs I have taken hot backup using RMAN. The total Size of the Database is 5200MB(By Sum(byes) in Dba_data_files). Where us the backup file size put together is 4600MB. Where am I missing the remaining 600MB? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
Background Process
DBAs I facing severe IO on the server. I got no clue why. I find three oracle background processes which I never heard of. They are ora_i101_orcl, ora_i102_orcl, ora_i201_orcl. Any idea what is this? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RMAN-06004 Error
DBAs, I have taken DB backup using RMAN. The backup completed successfully. When I execute list backupset, I am getting the following error RMAN list backupset; RMAN-03022: compiling command: list RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: list RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL: nume ric or value error: number precision too large ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052 ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729 ORA-06512: at line 1 This is the first time I am using RMAN and I could not find anything to sort out this issue in metalink. Any Idea what could be the cause? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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).
RE: RMAN-06004 Error
Thanks Natasha. I have more than 400 Backup pieces. I will try and limit it less than 99. Regards Raj -Original Message- Sent: 09 April 2001 17:06 To: Multiple recipients of list ORACLE-L Raj This might be related to bug# 1311017 where there is a limit of 99 backup pieces. How many backup pieces do you have? Have you placed an iTAR with OTS? Regards Natasha - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 11:46 AM DBAs, I have taken DB backup using RMAN. The backup completed successfully. When I execute list backupset, I am getting the following error RMAN list backupset; RMAN-03022: compiling command: list RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: list RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL: nume ric or value error: number precision too large ORA-06512: at "RMAN.DBMS_RCVMAN", line 7052 ORA-06512: at "RMAN.DBMS_RCVMAN", line 4729 ORA-06512: at line 1 This is the first time I am using RMAN and I could not find anything to sort out this issue in metalink. Any Idea what could be the cause? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Natasha Batson 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: Raj Gopalan 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).
RE: Sql question
On subsequent select select * from mytable where rownum 40 minus select * from mytable where rownum 20. This will bring rows between 20 and 40. On the next select, replace 40 with 60 and 20 with 40 -Original Message- Sent: 03 April 2001 15:26 To: Multiple recipients of list ORACLE-L Surjit, The syntax is: Select * From MyTable Where RowNum 21 Andmore of your predicates ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Surjit Sharma Sent: Tuesday, April 03, 2001 7:46 AM To: Multiple recipients of list ORACLE-L All I am sure this question has come up here before. I need to get the limited number of rows from a table at a time (say 20 rows ) using sql . I know this can be achieved using PL/SQL. This is typically required in web based applications where you can only show a few records at a time. Your comments are highly appreciated. Regards. Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Raj Gopalan 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).
RE: Rollback seg for an entire session, not just per transaction?
Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ 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: dana 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: Raj Gopalan 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).
RE: RE: Rollback seg for an entire session, not just per tran
Oops.. That was typo :-) -Original Message- Sent: 03 April 2001 17:01 To: Raj Gopalan; Multiple recipients of list ORACLE-L Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment space with the exception of SYSTEM. The processes all crashed with an Oracle error that said the SYSTEM rollback segment was strictly for changes in the data dictionary. Therefore NO it does not get used for user session transactions outside of data dictionary stuff which we all know does an autocommit. Dick Goulet Reply Separator Author: Raj Gopalan [EMAIL PROTECTED] Date: 4/3/2001 8:50 AM Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ 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: dana 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: Raj Gopalan 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: Raj Gopalan 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).
RE: book topic request
Joe I am interested.. Raj -Original Message- Sent: 29 January 2001 19:41 To: Multiple recipients of list ORACLE-L The idea has been thrown around for a pocket manual for logminer, is there any interest in something like this? I mean would you buy something like a pocket manual that cover such a specific topic in depth? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe S. Testa 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: Raj Gopalan 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).
RE: V$log Status
My system is in archive mode. What wonders me is that even after archive files are created the status of the log file is in ACTIVE state. -Original Message- Sent: 02 February 2001 14:21 To: Multiple recipients of list ORACLE-L Most of the times in an archivelog databases that happens because the arch process is still working. If it was a noarchivelog database, it would be a block recovering what is going on. Regards. -Mensaje original- De: Raj Gopalan [SMTP:[EMAIL PROTECTED]] Enviado el: viernes 2 de febrero de 2001 13:26 Para: Multiple recipients of list ORACLE-L Asunto: V$log Status Hi All, I am doing a batch update which updates around 100,000 rows. While this updating is in progress, the system slows down all in a sudden for few minutes before it continue to work normally. The archive log is enabled and I have 5 online groups with each 10 MB size. If I check the V$log while updation in progress, I find the status is in ACTIVE even after the archive file written for that log. This sequence continues until all the log files except current one in ACTIVE state. After couple of minutes all the ACTIVE status getting changed to INACTIVE. Any Idea what could be the reason for this? I got 8.1.6 undex solaris. TIA Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Trassens, Christian 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: Raj Gopalan 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).
