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.
- Here is what im hoping someone can tell me:(OH THAT LOOKS TOTALLY
WHACKED OUT, DUH FIX THAT!!!)
- I write reports, I have no control over Oracle. I dont have sysadm
to it.
- I can't adjust my SQL statements besides running stored procs.
- Reports are taking days to get back, yeah I said DAYS, small ones
hours.
- The server is a Xeon dual 500, 1 gig of ram, multiple drives in
raid.
- NT 4.0 latest patches, running Oracle and a imaging system.
- Memory is sometimes maxing out, while cpu utilization is running
around 40%
- 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.
- I cant do a bstat or statspack or tell you buffer hit rates... etc.
- I can get into DBA studio
Here is what DBA tells me: (version 8.1.7.00)
- Shared Pool : 43 Meg
- Buffer Cache: 39 Meg
- Large Pool : 0
- Java Pool : 19 Meg
- Number of Concurrent Users : 49
- Sort Area Size : 128 K
- I know im doing large sorts/groupings.
- Some reports are doing full table scans, some not, even the nots
are taking
hours. The fulls are days.
- 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... :)
Received on Thu May 16 2002 - 11:22:16 CDT
