Re: HELP ME!!!! PLEASE!!! before i leap off a bridge. Im waiting days for info...

If you are running out of memory, then you are paging, which is satan for Oracle. Your SGA doesn't look like it would take up a gig, so trash that imaging system. Something is chewing on your memory. Find out what it is and get rid of it.

Tom
OraclePower.com

"Marc Blum" <marc_at_marcblum.de> wrote in message news:3ce3eda8.8244605_at_news.online.de...
> What about
>
> format c:
>
> ?
>
>
> On 16 May 2002 09:22:16 -0700, mikes2nd_at_yahoo.com (mike) wrote:
>
> >okay ill explain the problem: Its taking years to get reports back
> >using a report writer. First let me explain the situation. Im new at
> >this place.
> >I have no control over the DB. No db admin, no Bstat, no nothing, just
> >looking.
> >
> >A. Here is what im hoping someone can tell me:(OH THAT LOOKS TOTALLY
> >WHACKED OUT, DUH FIX THAT!!!)
> >
> >1. I write reports, I have no control over Oracle. I dont have sysadm
> >to it.
> >2. I can't adjust my SQL statements besides running stored procs.
> >3. Reports are taking days to get back, yeah I said DAYS, small ones
> >hours.
> >4. The server is a Xeon dual 500, 1 gig of ram, multiple drives in
> >raid.
> >5. NT 4.0 latest patches, running Oracle and a imaging system.
> >6. Memory is sometimes maxing out, while cpu utilization is running
> >around 40%
> >7. Database is very simple some 5 tables. with the main running 13
> >million rows
> > with about 500 char size, others are fairly small
> >ranging(1000-400,000) rows.
> > Indexes are all on single colums. A ton of those.
> >8. I cant do a bstat or statspack or tell you buffer hit rates... etc.
> >9. I can get into DBA studio
> > Here is what DBA tells me: (version 8.1.7.00)
> > 1. Shared Pool : 43 Meg
> > 2. Buffer Cache: 39 Meg
> > 3. Large Pool : 0
> > 4. Java Pool : 19 Meg
> > 5. Number of Concurrent Users : 49
> > 6. Sort Area Size : 128 K
> >10. I know im doing large sorts/groupings.
> >11. Some reports are doing full table scans, some not, even the nots
> >are taking
> > hours. The fulls are days.
> >12. Can i do a bstat without admin or higher security?
> >
> >Of course im not a Oracle officianado.
> >
> >here is the Oracle server init props:
> >
> >background_dump_dest = %RDBMS80%\trace
> >compatible = 8.1.7
> >control_files = "F:\DB\DATABASE\ctl1db.ora"
> >control_files = "H:\DB\DATABASE\ctl3db.ora"
> >control_files = "G:\DB\DATABASE\ctl2db.ora"
> >db_block_buffers = 10000
> >db_block_size = 4096
> >db_domain = WORLD
> >db_file_multiblock_read_count = 16
> >db_files = 1024
> >db_name = DB
> >distributed_transactions = 5
> >global_names = TRUE
> >instance_name = db
> >job_queue_interval = 10
> >job_queue_processes = 0
> >log_archive_dest_1 = "LOCATION=d:\oracle\ora81\RDBMS"
> >log_buffer = 8192
> >log_checkpoint_interval = 10000
> >max_dump_file_size = 10240
> >open_links = 4
> >optimizer_mode = CHOOSE
> >parallel_max_servers = 5
> >processes = 59
> >remote_login_passwordfile = BLAHBLAH
> >service_names = database.world
> >shared_pool_size = 45534336
> >sort_area_size = 131072
> >timed_statistics = TRUE
> >user_dump_dest = %RDBMS80%\trace
> >
> >Does anything stick out like a sore thumb as totally blatantly
> >wrong?????????????????????????????
> >
> >help me please... :)
>
> regards
> Marc Blum
> mailto:marc_at_marcblum.de
> http://www.marcblum.de
Received on Thu May 16 2002 - 14:12:12 CDT