« August 2006 | Main | October 2006 »
September 27, 2006
Query Tunning
Oracle used a CBO or Cost Based Optimizer but still supports RBO or Rule Based Optimizer for select statements. RBO will be discontinued with Oracle 10i. CBO relies on statistics which need to be kept up to date. Since wouprd is set up a little differently becase of spriden, CBO does not always give the best performance. This is true especially with the table tbraccd. Sometimes as in the feed processes, the RBO works a lot better. I cut the feed down by almost 3 hours using the RBO compiler hint. This will supposedly not be an issue once we go to one database.
Posted by wendlerb at 10:25 AM | Comments (0)
September 26, 2006
SHRTPOP
People with no degrees not showing up despite following directions and leaving degree parameter blank. The program has 3 main select macros run depending on parameters used. There is a macro2 used when using a population select which was tied to degree table during ver 7.2 to get multiple levl codes. It used to be tied to sgbstdn. We can put an outer join on it to get everyone in population selection. Also, when you use a population, most of the parameters in job submission are ignored. So you can't get people with no degrees when nothing is entered in degree parameter by changing it to an outer join and be able to select based on degree. It's one or the other.
Posted by wendlerb at 9:59 AM | Comments (0)
September 20, 2006
Tgrappl
I put the /*+ Rule */ compiler hint into this job submission program and it sped up substantially.
Posted by wendlerb at 1:50 PM | Comments (0)
September 19, 2006
Check doc num mismatch
We had a series of checks print on SIS where the doc num did not match th check num. Have no idea how this happened but the two sequences were off from each other so I reset them to match the next check number. Tey seem to be fine since. I fixed about 9 bad records in banner by updating tables tgrzchk and tbraccd.
taismgr.tgrzchkd
taismgr.tgrzchkc
Posted by wendlerb at 2:54 PM | Comments (0)
September 15, 2006
TSAMASS
This form was throwing a warning for every student that had a hold. The code is a program unit on the form and I commented out the hold check.
Posted by wendlerb at 2:24 PM | Comments (0)
September 13, 2006
Credit Card, Banner Web
We use an IPayment server which is no longer officially supported by SCT but will work till Banner 8.
Modified packages:
BWCKCPMT
BWGKIPAY
WebTailor parameters:
CCREADPIPETIME 15
CCRESPONSEPIPETME 180
CCUSEADDRESS Y
CCWRITEPIPETIME 15
IPAYMENTSERVER XXXXXXX...
GTVSDAX groups:
PMTSERVER PMTSEVER OPS
PMTSRCE CRDCARDPMT Y
AUTHSETTLE CRDCARDPMT Y
PMTSTORENO CRDCARDPMT 4
Multiple Merchant ID Hierarchy:
LEVEL
CAMPUS
COLLEGE
DEFAULT
Banner setup forms:
GTVCCRD - set up credit card types
GTVPROC - define processes using credit card (WEBCCREGFEES)
GORCCRD - rules for validation
GOAMERC - Merchant ID form We use detail WVSA and third party WOUACCT
Posted by wendlerb at 1:49 PM | Comments (0)
September 12, 2006
Tgrappl
This is still taking almost 3 hours to complete causing the back end of the feed to run against the shutdown of the database.
Posted by wendlerb at 8:48 AM | Comments (0)
September 8, 2006
Tgrfeed and Tgrclos
We have been unable to get a feed since the upgrade. We could tell the cursor was stuck at f_query_one_lock in the package tb_receivable. The code looked ok but did have this or piece with rowid and pidm. Apparently when running in a plsql block it had trouble with it. Jeremy added a /*+ rule */ to the statement and it did the trick.
Posted by wendlerb at 1:15 PM | Comments (1)