Rollback segments size calculation

Hi all I am getting ORA-01555 in my database and the solution is to create huge rollback segments but my doubt is how to calculate the size of this huge rollback segments . Now I have 24 G of space in rollback segment tablespace .But still i am getting the error.The

RE: Database Health Template-OT

Dennis .. You are right ...but what can we do if someone demands for such a report .. They want to analyze and track every info . Shibu -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Thu 11/20/2003 12:34 AM To:

RE: Database Health Template-OT

? CSW Simon. -Original Message- Shibu MB Sent: Wednesday, November 19, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Hi all, I am looking for a template

RE: Database Health Template-OT

to use them(im still annoyed by that).. its garbage. From: Shibu MB [EMAIL PROTECTED] Date: 2003/11/19 Wed AM 08:50:07 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Health Template-OT

Database Health Template-OT

Hi all, I am looking for a template where i can fill the health of the databases daily and send it to my boss .Though i have prepared one i still doubt i have missed some thing :). If anybody has any format for such a report please share it .

RE: Redo log corruption

). Daniel Shibu MB wrote: Dan , My oracle version is as given below BANNER Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production

RE: Who is using temp tablespace?

Rick , This query will help you to find who is using the space SELECT a.username, a.osuser, a.sid||','||a.serial# SID_SERIAL, c.spid Process, b.tablespace tablespace, a.status, sum(b.extents)* 1024*1024 space FROM v$session a,v$sort_usage b, v$process c, dba_tablespaces d WHERE

ORA-27102: out of memory in Tru64

not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: standby creation-solved

I got the solution ... these are the basics of standby .. i am going to read the docs once more ..:) Shibu -Original Message- From: [EMAIL PROTECTED] on behalf of Shibu MB Sent: Fri 10/31/2003 12:14 PM To: Multiple recipients of list ORACLE-L

Redo log corruption

Hi all , While applying archive logs to my standby database i got theerror ORA-00353: log corruption near block 207725 change 111482169731153 time 10/25/2003 12:14:01 Can anybody tell me how archive logs can get corrupted ?? How can i avoid oracle from generating corrupted archive logs

RE: Redo log corruption

corrupted the logs. I don't recall if I encountered it in 8i as well, but there is something in the back of my mind saying it may still exist in later releases. Daniel Fink Shibu MB wrote: Hi all , While applying archive logs

standby creation

Hi all , I have a doubt in creating standby databases . I took one cold backup from primary database last week and restored the backup in standby database .After taking the cold backup i have added one more tablespace to primary database .Now my doubt is to bring my standby database up

RE: hrs to run catpatch.sql

Hi , For me it took approximately 2 hrs to run catpatch.sql and don't have any probs yet Thanks to kirti and brad for the info ... Shibu -Original Message- From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED] Sent: Wed 10/15/2003 7:54 PM

hrs to run catpatch.sql

transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle Express and transaction mode

is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shibu MB INET: [EMAIL PROTECTED] Fat City Network Services

Oracle Express help

Hi all, Can anyone give me info about oracle express list ? Is there any oracle express gurus here ?? I need some help for oracle express. Thanks Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments

few questions on 9i

Hi all Can any body help in answering these questions 1. What features of Oracle 9i do you recommend to use? Why? 2. What are the features of Oracle 9i you do not recommend? Why? 3. Have you had any problems with any of the Oracle 9i features? Please elaborate. If any, how did you

Naming Conventions....

Hi all... What are the naming conventions u guys follow when designing a database ???.Can anybody send me a general document on this. I am trying to make the attribute name unique in my database but i dunno what naming convention i have to follow for this .. I have tried all

DataGuard Remote Process startup Failed- Error

Hi friends.. I am trying to create a stand by database using dataguard and i am getting the error ' DataGuard remote process startup failed' . In primary and secondary database oracle agent is running . I have management server installed in the primary node itself . i have set