Securing the Database Structure

orafaq.net -- Author: Hussain Ahmed Qadri 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

RE: RAC or Oracle Fail Safe

esh  -Original Message- HREF="" PROTECTED]">mailto:[EMAIL PROTECTED]  On Behalf Of Hussain Ahmed Qadri Sent:   Wednesday, July 16, 2003 8:44 PM To: Multiple recipients of list ORACLE-L Subject:    RAC or Oracle Fail Safe Hello all, We have setup a Microsoft Cluster

RE: RAC or Oracle Fail Safe

any one explain the benefits of using RAC over Oracle Fail Safe, or vice versa. > > Regards, > > Hussain > > DBA SKMCH&RC > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hussain Ahmed Qadri > INET: [EMAIL PROTECTED] > >

RAC or Oracle Fail Safe

explain the benefits of using RAC over Oracle Fail Safe, or vice versa. Regards, Hussain DBA SKMCH&RC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hussain Ahmed Qadri INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Undo Analyze Table

then the table access. These two parameters give the same slant toward the index access path and nested loops path as RBO. For the rest, buy Jonathan's book. On 2003.06.16 02:54, Hussain Ahmed Qadri wrote: > Hi, > We have two DBs, a production and a development, identical query was run

Undo Analyze Table

hence slowing the query down. I know the optimizer, after analyzing, would have chosen the better path in its own sense but its not producing the desired result and it is taking ages now. is there any way to undo that? Regards, Hussain Ahmed Qadri DBA SKMCH&RC

DB Link in forms6

both the databases. Regards, Hussain Ahmed Qadri DBA SKMCH&RC

RE: Memory taken by s session

every query I run from that session. Any explanation as to why? Regards, Hussain -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 22, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Memory taken by s session Hussain Ahmed

Memory taken by s session

Title: Memory taken by s session Hi all, Can anyone tell me what is the memory any session takes when it logs on to the database? That's is, when a person opens a SQL plus window, how much memory is allocated to that session (just opening it and then the session is idle). And when he perform

Buffer_Pool KEEP

Title: Buffer_Pool KEEP Hi all, Is there any way / script to find whether the tables kept in KEEP Buffer pool performing fine i.e. do they really need to be in the KEEP buffer pool or should they be removed. Tables that I want to check are in the buffer pool for over 6 months and I want to kno

RE: Trace file size...

Title: RE: Trace file size... Hi Jeremiah, When ever I run a certain Automation script file, I get an error pointing it to a trace file S000.trc or S001.trc, when I check these files they both point out that they are full, *** TRACE FILE FULL *** What should I do to get rid of this error, wh

Trace File Full

Title: Trace File Full Hi all, We run an automated script for taking database backups. A third party tool is used to call the script which runs the export commands. The problem that we are facing is that when ever the script runs, it fails with the following error ORA-00600: internal error

Database Load & Server Specs

Title: Database Load & Server Specs Hi all, I have three questions, would appreciate if any of you can help me on that, its important because I need these answers to support my claim of our server being over loaded. First is; is there query to find out the number of transactions at any time?

RE: 100% CPU utilization, urgent

ECT v.SID, SUBSTR(s.NAME,1,30) "Statistic", v.VALUE FROM V$STATNAME s, V$SESSTAT v WHERE s.NAME = 'CPU used by this session' AND v.STATISTIC# = s.STATISTIC#         

RE: Re: 100% CPU utilization, urgent

which is cauing problem. > >Hope thi resolves your problem, Goodluck > >Pankaj > >--- Hussain Ahmed Qadri <[EMAIL PROTECTED]> wrote: > >> HI all >> We have a consistent problem of CPU utilization >> 100%. We have had this >> problem since Saturday, bu

RE: Re: 100% CPU utilization, urgent

lting in 100% CPU utilization. > >you can check it by pressing ctrl+shift+esc. There >will be a tab Processes. Under thi tab it will how >each process that i running on your machine. > >My own experience says it will a trojan or >something >like that which is cauing problem.

Server specifications

Title: Server specifications Hi all, Can anyone tell me if there is any general guide line or benchmark, which tells us that for running a certain number of transactions in a specified time, or for a certain size of DB, the Server Configuration should be like what? And what is the way of fin

100% CPU utilization, urgent

Title: 100% CPU utilization, urgent HI all We have a consistent problem of CPU utilization 100%. We have had this problem since Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal on Sunday as well. But its back to 100% since morning, that

Safe Database Environment

Title: Safe Database Environment Hi all, Can any of you suggest the configuration for a safe, fault proof, and minimum downtime Database environment? (In terms of how many servers, RAID or disk ARRAY or any combination. A minimum configuration is what I am looking for). Right now we have o

RE: Import from FoxPro to Oracle

for visual foxpro. So is there any possibility of simplifying the import procedure? -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Friday, November 15, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: Import from FoxPro to Oracle > Huss

Import from FoxPro to Oracle

Title: Import from FoxPro to Oracle Hi ALL, Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7. If yes how. TIA Hussain

RE: Oracle taking 100% CPU

Title: RE: Oracle taking 100% CPU The CPU becomes normal after the database is shutdown. So it's Oracle that is causing problems. I thought that it would be some rollbacking and roll-forwarding going on but, since morning, I don't think so. So I have some clues that it has something to do with

Oracle taking 100% CPU

Title: Oracle taking 100% CPU HI all, We have a development server, a replica of the production. Some process produced a lot of archives and it ran out of archiving space. Now it was the only location specified for the archives and it was mandatory. So when no space was left on it to store t

RE: OT- Improving server performance

ECTED]] Sent: Sunday, November 10, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT- Improving server performance > Hussain Ahmed Qadri wrote: > > Hi > > Would moving the temporary tablespace, rollback tablespace and Archive > files location to a hard dr

OT- Improving server performance

Title: OT- Improving server performance Hi Would moving the temporary tablespace, rollback tablespace and Archive files location to a hard drive other than the hard drive which contains the datafiles, improve performance of the server? Index and Datafiles are already placed on different har

Adding more space to server

the other options, if any? Anything else that I need to keep in mind? Thanks and regards, Hussain Ahmed Qadri DBA SKMCH&RC

RE: Relation Between Oracle Sessions

so I wanted to know if there was any indirect method, like from some views or something that can help me track that relationship. If there is something that is confusing, please let me know. Thank you for your time. Regards, Hussain Ahmed Qadri DBA SKMCH&RC -Original Message

Relation Between Oracle Sessions

session, their relationship basically? Thanks in advance Hussain Ahmed Qadri DBA SKMCH&RC Pakistan

Standby DB - confusion

Title: Standby DB - confusion Hi all, Can anyone shed some light on the following entries of the Alert log file? This appears when an archive is copied to the standby database and although archiving is complete, this message still appears. The alert log file of the standby database doesn't s

Failed to archive log....

temporarily any threat? * What could be the reason for it? * If the first archiver fails (ARC0) and then the second (ARC4) fails too, why does it try to archive the next seq# rather than finishing the previous one? * Any reason for this inconsistency? Thanks & Regards, Hussain Ahmed Qadri DBA SKMCH&RC

9iAS - Error WTE-03503

management server name written in the management server field. Which username would it be. What can be the problems with wte-03503, and possible solutions for that. Regards, Hussain Ahmed Qadri DBA Shaukat Khanum Memorial Cancer Hospital And Research center

Oracle and Character formatting

display a simple value rather than the formatted one. Is there any way to do such a thing. Would appreciate any advice on it. Oracle 8.1.7, WINNT4 Hussain Ahmed Qadri DBA Shaukat Khanum Memorial Cancer Hospital and Research Center Lahore Pakistan

Standby Database-No space on Disk

another partition, repartition this old-temporary partition by adding more space to it. And then copy that temporary-datafile back to this old partition and startup the database for the Standby mode. Would appreciate any prompt suggestions. Regards, Hussain Ahmed Qadri Database Administrator Shaukat

Stanby Database- Archive Transfer Problem

. Average time for log switch, under normal conditions, is roughly 12-15 mins, but for some reasons it starts getting missed after a regular transfer of 3-4 archive files. Our network is 10Mbps and is sllow off and on. What could be the reason for the delay. Hussain Ahmed Qadri Database

MTS Question

WAIT (common)(meaning its idle)... Does any of this help in explaining the effect of -ve value. Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk

Standby Database Problem

) So in such case WHAT happens to the STAND BY Database??? Looking forward to your replies Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk

Updating a non-Oracle DB using Oracle

services or any better way ? Regards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk

RE: Table Lock

Try creating indexes on the foreign key columns, in the child tables.     Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pkHussain Ahmed Qadri Database Administrator Shaukat Khanum Memo

Standby Databse Problem

gards, Hussain Ahmed Qadri Database Administrator Shaukat Khanum Memorial Cancer Hospital & Research Centre [EMAIL PROTECTED] www.shaukatkhanum.org.pk

IFRUN60_dump_*

. We are using Developer6 on WINNT4, along with Oracle8i. Is it an error related to Forms Runtime, or the Menu. Any ideas and solutions? Regards Hussain Ahmed Qadri DBA SKMCH & RC

Oralce 8i/9i with Pentium4

with this. Representatives from the Intel company said that this is an Oracle problem and "dumping the un-installed Oracle8i on the hard drive and running the setup from there" is a solution given by the Oracle Company. Any body with a complete knowledge??? Thanks and Regards, Hussain Ahmed Qadri DBA SKMCH & RC

Temporary Tablespace Logging Problem

Title: Temporary Tablespace Logging Problem Hi all, Is there a way to alter a TEMPORARY table space to Logging from NoLogging. I issue the command, ALTER TABLESPACE TEMPORARY LOGGING; The same command holds good for every other tablespace except for Temporary. I need to this because I wanted