Re: sequences and cursors

> Here is the output: > > QL> / > Sai is:13 > Sai is:14 > Sai is:15 > Sai is:16 > Sai is:17 > Sai is:18 > Sai is:19 > Sai is:20 > Sai is:21 > Sai is:22 > Sai is:23 > > PL/SQL procedure successfully completed. > > On 12/09/2003 01:39:25

Re: sequences and cursors

t; ind:=ind-1; > end loop; > end; > / > > > Here is the output: > > QL> / > Sai is:13 > Sai is:14 > Sai is:15 > Sai is:16 > Sai is:17 > Sai is:18 > Sai is:19 > Sai is:20 > Sai is:21 > Sai is:22 > Sai is:23 > > PL/SQL procedure successfu

sequences and cursors

times of the available 500 cursors. the dev say nothing has changed nor has there been a increase in the load. can you please advise me whther this could be a issue or am i missing something here thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai

Re: how to recycle sbtio

al ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

reporting database

hi data movement for a reporting database from a OLTP intensive db is what i am interested in.

RE: building a reporting database

dennis i am sorry to have been real unclear. data movement is what i am interested in.

building a reporting database

hi   i am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good. - using aq and dq message processing - using snapshot replication - using ro standby database

Re: memory usage by dbw very high

read from the disk, we're talking about hard pagefault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode.If you have gtop (my kindest advice is to get it), you can set preferences and see kernel modefor the processes. Ones consuming large amounts of the kern

Re: memory usage by dbw very high

I/O. That is not so hard to do.>> On 2003.11.01 09:44, Tanel Poder wrote:> > Just for clarification, do you actually see swapping when starting a new> > process or you just guess linux would swap because you don't see "free"> > memory in top output?> >

RE: memory usage by dbw very high

rich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went thru all the processes and found dbwr using the max %mem. what could be the reason? sai"Jesse, Rich" <[EMAIL PROTECTED]> wrote: If I'm not mistaken, this figure includes the size of t

memory usage by dbw very high

hi   i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts. here are the spces version:9.2.0.4 os:Linux 2.4.9-e.24smp o/p from top: 1:44pm  up 29 days, 23:55,  4 users,  load average: 1.73

Re: anyone use oracle collaboration suite?

hi i have done the installation of collaboration suite as part of some assessment.this was done about 6-7 months back. the issues - no support from oracle.no proper documentation.infact support is totally unaware what the product is all about. - installtion of three tiers ..complete software in two

complete refresh

hi   does complete refresh of mvs always do a truncate of the table and then does an insert from the master site or is there a possibility when it deletes the records in the table and does a insert of the records from master site.  one more question is whether this functionality has changed from 7

Re: continuously copy archive redo logfiles to tape

hi kirti   i was using the below method to copy archives to drsites and running this cron very frequently. the job used to ship and delete them immediately after successful copy and i used to have fuser check. but soon we started hitting this issue when we used to ship archives even when they are b

Re: intermedia text and dbms_job problem

bill this is a bug..infact it was happening in 8i and oracle said they will try to fix in 9i. u have to call the procedure in the ur job and embed the sync index in ur procedure. here is a snippet.u can try this way.  create or replace procedure i_doc_sync   is   begin     ctx_ddl.sync_index( i

RE: FIRST_ROWS hints

ot; - Tom Lehrer.   -Original Message-From: Sai Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:54 PMTo: Multiple recipients of list ORACLE-LSubject: FIRST_ROWS hints   hi   i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. p

FIRST_ROWS hints

hi   i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me in understanding this.   i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i

suggestion

hi   there is a requirement for capturing sqls and cpu consumed by any session logging into the database . this info should be stored in the database.   can you please give me suggestions as to how i do this?   thanks sai  

3113 error

hi   when i am trying to refresh mviews on a 9.2.0.3 database from 8i database i get 3113 end-of-file-comminication-channel.complete refresh also fails with the same error   the above refresh has been running fine for sometime and and today this problem has started coming up. i even tried dropping

Re: materialized views - please help

iginal Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 26, 2003 9:04 PM Subject: materialized views hi   materialized views become invalid as soon as a complete or fast refresh of the mv is done. is this how it is supposed to work? the status is i

materialized views

hi   materialized views become invalid as soon as a complete or fast refresh of the mv is done. is this how it is supposed to work? the status is invalid in dba_objects and is set to 'N' in dba_mview_analysis. i have been struggling to understand this. i read thru few docs on metalink which talk ab

wait event

hi   i am trying to do some performance tuning.   null event is 9.2.0.3 is the number one in the list of 5 top wait events.what is this? i have gone through a few docs saying nothing to worry et al but i would like to understand this better.   thanks sai

antijoin

hi   i am trying to figure out which is a more efficient method to do an antijoin between two tables. The version is 9i and optimiser is choose.stats are the lates.   here is the query with not in and not exitsts: case 1: select distinct a.id from tab a where a.id not in (select b.id from b) / case

stats and query plans

hi   a very basic question   i have faced this issue a few times in the last couple of weeks. we have a few queries that seem to run remarkable well in rule based optimisation than in choose based optimisation. the queries, with all the object stats collected upto date, never returns a result while

RE: rman implementation

yes dennis.   this is what i am planning to do.   can you please mention the glitches and the parameters that have to be changed.   or some pointers from your implementaion which could be very useful.   thanks a lot saiDENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: SaiAre you planning to do a RMAN bac

rman implementation

hi   can someone give me pointers on pros and cons of implementing rman with netapp filers.   any pointers,white papers,case study,implementation doc will be very helpful.   thanks sai

latch

can someone please tell me what is shared pool latch(latch# 155) and how do we prevent this. i am facing this in 9i very frequently. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services

Re: SGA question

la > > memory available? > > > > suppose i have a 1gb ram can i start an instance > with > > sga 2gb. does virtual memeory play a part in this > > memory allocation? > > > > thanks > > sai > > -- > > Please see the official ORACLE-L FAQ:

SGA question

hi is it possible to have a sga bigger than the rela memory available? suppose i have a 1gb ram can i start an instance with sga 2gb. does virtual memeory play a part in this memory allocation? thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai

9.2.0.3 job coordinator bug

were suggested by oracle until the patch is available. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: shared memory issues in 9.2.0.3

still occuring..db will crash anytime..job queue is the heart beat of this db.. any clue on this issue thanks sai > > -Original Message----- > Sai Selvaganesan > Sent: Saturday, June 07, 2003 11:50 AM > To: Multiple recipients of list ORACLE-L > > > hi > we ha

RE: shared memory issues in 9.2.0.3

esses to exceed > there memory allocations. > The bug is fixed in 5L so the per process memory > limits are now enforced. We > ran into this on our first upgrade to 5L and the > symptom was 4031 errors > from processes that ran just fine on 4.3. > > Mark... > > -Or

Re: shared memory issues in 9.2.0.3

java pool size is set to 60 M in our environment. saiM Rafiq <[EMAIL PROTECTED]> wrote: Have you using java or by default any java objects installed. Ckeck for size of java pool which has default of 20M. If yes, try to increase size of java pool to min 50M. I have read some place that in newer vers

shared memory issues in 9.2.0.3

at is happening? cant question oracle..but why really mess around with job queue processes when that simple daemon has been working fine in all versions? anycase,gurus please help me out on this. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan

RE: performance questions

have some ideas on this but nothing is very > concrete. > > can someone give me some feedback on this..if u feel > that this is not a > right question to be put in this forum i apologize > but i would like to take > this up with someone who is interested and i wouldnt > use this mailing list > for the same. > > thanks for ur t

performance questions

hi gurus   this is a kind of query i have faced a few times in the recent past and which has really forced me to start this thread.   as everyone knows, there is always what we call a SLA or in other words a service level agreement (may be called differently in different places) which infact means

Re: archiving data

mmand.>> Please let us know where you found that 64K limitation. The ohter thin you> have to consider is that COPY is being depecrated in 10i, or whatever it> will be called; but then again, I hope your application will have ceased> using LONGs.>> Arup Nanda> www.proligence.com>

Re: archiving data

e this highly> > > automated since the main db and archival db will> > be on> > > different hosts, this will not be monitored and> > import> > > has to go thru w/o issues etc.> > > 2. create snapshot - but they dont work with> > > long..hen

Re: archiving data

w/o issues etc. > > 2. create snapshot - but they dont work with > > long..hence not an option. > > 3. getting sqlldr to work but i think it has that > 32k > > column size limitation. > > > > > > so can you please suggest me whetehr there is > > some

archiving data

something else i can do or option 1 is the best given the environment. the oracle is 8.1.7.2 on sun 2.8. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

unusable indexes.

am i missing something . thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 10053 trace

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

10053 trace

ease help me on this? thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and