RE: Find CPU clock speed on HP-UX 11
Hi I am also not aware of HP but on solaris u can find using prtdiag command U can find this command in /usr/platform/sun4u/sbin Regards Pawan Dalmia Database Administrator Orange-9820018753 Extn -5064 -Original Message- Sent: Thursday, October 16, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what clock speed they operate. I can get the number of CPUs through glance or top, but I have no idea about the clock speed. How would I get that information? I would know how to do it on Solaris though... ;) Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). 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 unauthorized. 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pawan Dalmia 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).
ORA-03113 will creating db
Hi All, I am Installed Oracle 8.1.7 on Solaris 8 on sun sparc machine(1 gb Ram) . Installation went off sucessfully without any Problem. But at time of creation of database through DB Assist it is giving ORA-03113 end-of-file on communication channel.I have even tried to create database manually but i am getting same error i am when i saying startup nomount pfile=... my oracle_home and oracle_sid are set properly Is the setting of kernel parameter to do with this error . follwoing are the parameter set by me in /etc/suystem file set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=210 set semsys:seminfo_semmns=205 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).
Unix Question
My var partition is 99% full of which there are lot of files in /var/tmp directory. Can i delete this files ? Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).
Tablespace Design
Hi DBA gurus, One of the application is going live .At presenr data is 15GB and will grow more by 10 GB in year time. What is the right approach of tablespace design having more files of smaller size(10 files of 2 GB ) or less file of bigger size (3 files of 8 gb ). No tables in this application is partitioned all the files will be on a single disk I am Orcale 8.1.7 on Win 2K. 2) Following is output of my v$waitstat . Kinly give som suggestions CLASS COUNT TIME -- -- -- data block 46251 0 sort block 0 0 save undo block 0 0 segment header 15 0 save undo header0 0 free list 0 0 extent map 0 0 bitmap block0 0 bitmap index block 0 0 unused 0 0 system undo header 0 0 system undo block 0 0 undo header 1225 0 undo block 55 0 Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).
Resizing of redo log
How is it possible to increase the size og online redo log files Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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: Resizing of redo log
I am extremly thankful to U and all those who replied to my query. Thanx once again -Original Message- Sent: Tuesday, August 27, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Pawan, To increase the size of your redo log is a multi step operation: Basically you ; select * from v$log; Gets info about logs... select * from v$logfile; Gets more info about logs... alter system switch logfile; Allows you to force a particular log active... alter database drop logfile group 1; Drops a non active log alter database add logfile group 1 'ORA:oranw734\database\glcd1-1.rdo' size 10 M; Creates a new log.. alter database add logfile member 'SYS:\glcd1-2.rdo' to group 1; Adds a second log to the group... Perform the above steps until you have resized all of the logs to the size you want and have cycled them through the active status to make sure they work. Ron ROR mª¿ªm [EMAIL PROTECTED] 08/27/02 07:18AM How is it possible to increase the size og online redo log files Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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: Ron Rogers 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: Pawan Dalmia 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: Catalog target db on different version O/S
Hi Thanx all for reply. Tim my both the database are 8i but different release 1)Target 8.1.5 on Solaris 8 2)Catalog db 8.1.6 on Win2k will different O/S and different version be a problem Pawan -Original Message- Sent: Monday, August 19, 2002 11:58 PM To: Multiple recipients of list ORACLE-L The RMAN executables and scripts have to reside in a server running Oracle8.x and above (i.e. the target database server), but the database housing the recovery catalog database is just a database that holds tables, indexes, sequences, views, and stored procedures/functions/packages. RMAN doesn't run on Oracle7, but it doesn't need to. EBU is completely out of the picture (as it should be!)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:58 AM But it does not include rman...and EBU won't do it. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:53 AM I'm not recommending 7.3.4 for the repository Why not? It seems to be the most stable 7+ version available. :) Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/19/2002 06:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Catalog target db on different version O/S Years ago, we backed up an 8.1.5 production database (along with it's dev environment) with the RMAN catalog housed on an NT workstation running 7.3.4. Worked just fine. We eventually upgraded the NT box to 8.1.5 also, but that was just an export/import and we were off and running again... The RMAN recovery catalog is just another database application to the database housing it. There really aren't any version-specific demands placed by RMAN upon that database (of which I'm aware), save that it is accessible by SQL*Net. I'm not recommending 7.3.4 for the repository, though... :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 5:28 AM Hi List, I am planning to start taking backups through RMAN.Database is around 60GB(Solaris Oracle 8.1.5) and therfore i am planning to using Catalog.Since There is no space on our solaris box i am planning to create catalog db on WIN2K machine(Orcale 8.1.6) . will there be compatiblity issues considering my target database is Oracle 8.1.5 on Solaris 8 and my catalog database is oracle 8.1.6 on WIN2K Thanking all in advance Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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: Tim Gorman 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: 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Amount of redo
Hi, I am highly thankful for u replies as a result i was able to take imp. decission. Pawan -Original Message- Sent: Sunday, August 18, 2002 3:38 PM To: Multiple recipients of list ORACLE-L I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 4:43 PM yechiel, I didn't miss the comment, it's not relevant. Archived logs are merely copies of redo logs that have been filled. Whether or not archiving is turned on, redo logs get filled and reused. Oracle tracks the log switches no matter what mode you are in, it just doesn't make the copy of the redo log if you aren't in archive log mode. So he can definitely track log switches in the alert log or in v$log_history. Given the number of switches in a week (this is approximately the number of archived logs that will be created), he can multiply that by the size of his largest redo log (hopefully they are all the same size but take the largest one if they are not). That will give him the maximum amount of space his archived logs will take in a normal week, barring any unusual load activity. Now archived logs generally are NOT the full size of the redo logs so this will overestimate. But it's better to have too much space than too little Rachel --- Yechiel Adar [EMAIL PROTECTED] wrote: Hello I do not think that you can estimate the amount of disk space required for archive log without turning archive log on and checking each day to see how much space you already used. To all who replied: I think that you missed his comment that currently he is NOT working with archive log on. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 2:08 PM Hi List, I want to put my databse in archive mode(Presently it is non archive mode).I want to estimate space that will be required for archive log taking we will be keeping one week archive on disk. How can i find out amount of redo generated in a week. Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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: Yechiel Adar 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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: Yechiel Adar 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
Catalog target db on different version O/S
Hi List, I am planning to start taking backups through RMAN.Database is around 60GB(Solaris Oracle 8.1.5) and therfore i am planning to using Catalog.Since There is no space on our solaris box i am planning to create catalog db on WIN2K machine(Orcale 8.1.6) . will there be compatiblity issues considering my target database is Oracle 8.1.5 on Solaris 8 and my catalog database is oracle 8.1.6 on WIN2K Thanking all in advance Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).
Export to tape
Hi List, How can I take export backup directly to tape. What i need to specify for file Parameter ? Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).
Amount of redo
Hi List, I want to put my databse in archive mode(Presently it is non archive mode).I want to estimate space that will be required for archive log taking we will be keeping one week archive on disk. How can i find out amount of redo generated in a week. Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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: DB link problem
Hi Arvind From the error message it is clear that remote tables ae having some object type columns which is not permitted. -Original Message- Sent: Friday, August 09, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Dear All, i have created a DB link to remote database its working perfectly with some tables of remote DB but fails with some tables.. 16:27:08 SQL select * from zone_mst@arvind; select * from zone_mst@arvind * ERROR at line 1: ORA-22804: remote operations not permitted on object tables or user-defined type columns. Regards Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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).