Re: 9i - Dynamic SGA - SGA_MAX_SIZE
Hi! I think sbrk() (which calls brk()) can be executed with negative value to reduce total heap size for a process? Anyway, on windows, SGA_MAX_SIZE didn't affect allocation of virtual memory, my SGA was 200M and max_size was set to 512M, still only 200M was allocated at startup. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 03, 2003 7:19 AM Kirti, problem is in the malloc mechanism. The subroutine to free the memory doesn't return it to the OS, it returns it to the allocation pool instead. As a consequence, when oracle does free, its address space is not going to go down. You realize, of course, that malloc, calloc, realloc and free are the only options, because of their portability. There are low level allocation routines like brk() to increase the address space, but unaware of any routine to decrease the address space. Here is the manual page for the library subroutine called mallopt, which is mostly obsolete but still exists on HP-UX. The mechanism remained the same, but the control was taken away from the users. Manual page does illustrate the mechanism, though. malloc(3C) malloc(3C) NAME malloc(), free(), realloc(), calloc(), mallopt(), mallinfo(), memorymap() - main memory allocator SYNOPSIS #include stdlib.h void *malloc(size_t size); void *calloc(size_t nelem, size_t elsize); void *realloc(void *ptr, size_t size); void free(void *ptr); void memorymap(int show_stats); SYSTEM V SYNOPSIS #include malloc.h char *malloc(unsigned size); void free(char *ptr); char *realloc(char *ptr, unsigned size); char *calloc(unsigned nelem, unsigned elsize); int mallopt(int cmd, int value); struct mallinfo mallinfo(void); Remarks The functionality in the old malloc(3X) package has been incorporated into malloc(3C). The library (/usr/lib/libmalloc.a) corresponding to the -lmalloc linker option is now an empty library. Makefiles that reference this library will continue to work. Applications that used the malloc(3X) package should still work properly with the new malloc(3C) package. If the old versions must be used, they are provided in files /usr/old/libmalloc3x.a and /usr/old/libmalloc3c.o for Release 8.07 only. DESCRIPTION The functions described in this manual entry provide a simple, general-purpose memory allocation package: malloc() allocates space for a block of at least size bytes, but does not initialize the space. calloc() allocates space for an array of nelem elements, each of size elsize bytes, and initializes the Hewlett-Packard Company- 1 - HP-UX Release 9.0: August 1992 malloc(3C) malloc(3C) space to zeros. realloc() changes the size of the block pointed to by ptr to size bytes and returns a pointer to the (possibly moved) block. Existing contents are unchanged up to the lesser of the new and old sizes. If ptr is a NULL pointer, realloc() behaves like malloc() for the specified size. If size is zero and ptr is not a NULL pointer, the object it points to is freed and NULL is returned. free() deallocates the space pointed to by ptr (a pointer to a block previously allocated by malloc(), realloc(), or calloc()) and makes the space available for further allocation. If ptr is a NULL pointer, no action occurs. mallopt() provides for control over the allocation algorithm and other options in the malloc(3C) package. The available values for cmd are: M_MXFAST Set maxfast to value. The algorithm allocates all blocks below the size of maxfast in large groups, then doles them out very quickly. The default value for maxfast is zero (0). M_NLBLKS Set numlblks to value. The above mentioned ``large groups'' each contain numlblks blocks. numlblks must be
Risks Involved In Using Profiles
Hello All, I have a task at hand in identifying the resource limits for each resource in dba_profiles . I would like to know the risks involved in each resource limit and finally identifying a correct value for each limit . Can somebody please point me to a document or can share your own research !! TIA, Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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).
Re: sar
I don't see how sar is a root access issue. On the Sun Solaris servers at my site, I can always execute sar as oracle, I don't have to ask the SysAdmin for permission. {setting up the sa1 and sa2 jobs as cron jobs is done by root, though}. Hemant At 07:44 AM 31-07-03 -0800, you wrote: Just got this email from my SysAdmin when I asked for access to sar. Anyone know what he is talking about? We are on AIX 4 and 5. I cannot give you direct access to the sar command. Because of the parameters the command allows, it would be equivalent to giving full root access. If you could give me some details on the kind of information you would like to be able to collect, maybe we could set up some kind of command to obtain it. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
Delete statement is very slow !!
Can someone explian me why this delete statement is very slow ?? any suggestions !!! pl find the details below !! Thanks Madhu Statement: delete from tabke_name where eow_dateADD_MONTHS(TO_DATE(:b0,'MMDD'),((-1)* :b1)); PLAN: + Plan Table | Operation | Name| Rows | Bytes| Cost | Pstart| Pstop | | DELETE STATEMENT | | 1M| 20M| 66106 | | | | DELETE |WIN_STORE | | || | | | TABLE ACCESS BY GLOBAL I|WIN_STORE | 1M| 20M| 66106 | ROWID | ROW L | |INDEX RANGE SCAN |WIN_STORE | 1M| | 2616 | | | Session_IO: + 11:27:49 SQL @session_top_sql OS UserDB User SID # of UndoBlk LOG IO PHY IO HASH VALUE SQL ADDRESS -- -- -- -- -- batchusr RTKBATCH 77 52349 6223101 987505 1253119663 C000BB3BC2B8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana 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).
Re: 9i - Dynamic SGA - SGA_MAX_SIZE
Thanks, Mladen. That makes sense. One just needs to make sure (by testing) that the OS supports this feature. - Kirti --- Mladen Gogala [EMAIL PROTECTED] wrote: Kirti, problem is in the malloc mechanism. The subroutine to free the memory doesn't return it to the OS, it returns it to the allocation pool instead. As a consequence, when oracle does free, its address space is not going to go down. You realize, of course, that malloc, calloc, realloc and free are the only options, because of their portability. There are low level allocation routines like brk() to increase the address space, but unaware of any routine to decrease the address space. Here is the manual page for the library subroutine called mallopt, which is mostly obsolete but still exists on HP-UX. The mechanism remained the same, but the control was taken away from the users. Manual page does illustrate the mechanism, though. malloc(3C) malloc(3C) snip __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).
RE: That Veritas thing
Hi folks, It might well be the reason that veritas is not configured properly. Thats why it is causing all these crashes. I am not here to defend Veritas; just an FYI I am using Veritas product to run my HAT cluster on IBM p690 AIX 5.L with Oracle 9.2.0.2 and I do not have any issues. Thanks Shaibal Sr.Oracle DBA Oracle Engineering Discover Financial Services From: Matthew Zito [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: That Veritas thing Date: Thu, 31 Jul 2003 10:49:36 -0800 I'd vote for the middle option. Veritas AC for RAC is hideously complex and there's about a million ways to be running on it even though the config is fundamentally broken. It could also be the clustered file system, of course, since cluster file systems are Hard Problems (tm). Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com http://www.gridapp.com/ -Original Message- Goulet, Dick Sent: Thursday, July 31, 2003 2:29 PM To: Multiple recipients of list ORACLE-L That point was not disclosed. Personally, I vote for the later. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, July 31, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Thanks for the rumor gossip Dick, Is this in reference to the Veritas clustered file systems technology? Or the Veritas Cluster Manager product? Or a file systems manager person? Curiouser and curiouser... -Original Message- Sent: Thursday, July 31, 2003 9:19 AM To: Multiple recipients of list ORACLE-L Folks, While we're on Veritas's backs, I recently (like Tuesday night) heard from an Oracle employee (to remain nameless) that Orbitz will be issuing a retraction of their claim that their Oracle RAC implementation was the root cause of the outage they had. Seems the true culprit is, guess who, as the file system manager. It is supposedly also causing other problems with non Oracle stuff too. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 30, 2003 8:29 PM To: Multiple recipients of list ORACLE-L The database backup is only export. Once in a while they are supposed to be doing a cold backup. Finally found someone that said they can't use the Oracle Veritas agent with Oracle 9.0.2 and Failsafe and/or clustering. They have given them a case number and are working on it. When he brings up the Oracle agent it crashes... Well, that's why we aren't getting any backup... except the export and MAYBE a cold backup once in a while. Thanks list. Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web: http://www.b2bsol.com/ www.b2bsol.com _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder 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).
RE: Redo Logs Problem
Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
How to Lock and unlock a table until SP completes
Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Redo Logs Problem
Just Out of curiosity. How come changing the TS to LMT would reduce the excessive Redo generation. Regards, Rajesh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of VIVEK_SHARMA Sent: Monday, August 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo Logs Problem Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
RE: Redo Logs Problem
Thanks to all who have replied But the problem has been resolved. It was due to a background scheduled process which was deleting records from log tables. I was able to find out this by joining v$session,v$transaction and v$sql dynamic performance views. However thanks again to all for your enlightening answers. This list is great. Regards Munish Bajaj -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003 11:19To: Multiple recipients of list ORACLE-LSubject: RE: Redo Logs Problem Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation -Original Message-From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 4:04 PMTo: Multiple recipients of list ORACLE-LSubject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj