| DB optimization/performance [message #55562] |
Fri, 31 January 2003 09:11  |
denni
Messages: 24
Registered: August 2002
|
Junior Member |
|
|
hello
I'm a programmer having to take on DBA responsibilties.
We have a database that consists of approx 7gig storage
that is located in the Pledgemaker Tablespace.
The past couple days the performance seems very
slow and labored. We do alot of transaction processing
throughout the course of an 8 hour day..plus
we have managers running queries and reports on large
volumns of data.
The following represents the current state of the db:
SQL> @free
TSNAME PCT_FREE
------------------------------ ----------
PLEDGEMAKER 892.16
ROLLBACK 400
ROLLBACK 100
SYSTEM 64.01
TEMP 900
TEST 100
6 rows selected.
SQL> @spacebound
no rows selected
SQL> @dbgrowth
Month Growth in MG
-------------- ------------
2002 December 2000
2002 February 1000
2002 May 2000
=======================================================
I would be very much obliged if someone could explain,
in simple terms, how to go about analyzing and optimizing a db.
also..is there a way to create a second instance
of the db where users can do OLTP on one instance
while managers can run reports & queries on a
second instance without both needs causing hangups
and conflicts with one another.
thanks in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
