I've been on the dark side using DB2 for a couple of years. Good to be back. Anyway DBMS_STATS appears to be creating incorrect statistics for AVG_COL_LEN. It...
Has anyone built their PS_HOME on a SAN and mounted it to multiple UNIX servers thus eliminating installing on each individual server? Thanks in advance...
Doesn't sound like it will work... You'd have to NFS mount it to each server, and then you'd in effect have all your servers referencing the same directory...
Ron, The obvious tables to keep are the PSoft Dictionary tables. If you have Davids book, you will find them in Chapter 4. Mark ... Send instant messages to...
Yes, the plan is to NFS mount. Create a separate config for each appserv, web server and prcs so none share the same log directories, etc. They will share the...
Question: How will you apply a tools patch and migrate it through your instances and how do you test the custom code you mention before moving it to a higher...
I have considered using the keep and recycle pools in the past, but I never found that they particularly helped. Remember that this is about keeping objects...
In this case, although I agree in theory, I will have to disagree with you David, as the Keep buffer has been proven useful on our 8.9 instance. We are running...
You are right, this table it isn't cached by the application server. I have picked up performance problems with queries on this table in the past (and I...
I'm not sure about the user response, but I increased the SGA target to cope. Current settings are 1Gb min for KEEP (I will be increasing this) and the...
Hi, I need a unix script to rename a file as timestamp tagged at the end. If i have a file named file.txt created on 01/07/2005. I need the script such that it...
Something like this? This keeps a rolling weeks worth. ... PS_DIR='/global/gl_ha/software/psoft/fin840/sib_input' timestamp=`date +%Y%m%d_%H%M` day=`date +%a` ...
Hi Prathap, In your shell script you can add the following ...... ...... DT=`date +'%d%m%Y'` /**** This will store the date in DT variable in ddmmyyyy...
HI, I am trying to scripts which monitors all the spaces issues in peoplesoft DB. Need your help in invoking sqlplus in unix shell scripts.. Any help is...
Hello everyone, We are upgrading our Oracle databases from 8i to 9i. The 9i installation guide recommends using Optimal Flexible Architecture (OFA). Has...
Hi Everybody, We are encountering some issues with migrating PS App in SQL server to Oracle 10g. We tried to import Data Mover export(sql server) and tried to...
You are right that Oracle doesn't permit more than one LONG column per table. Otherwise, when you try to create it you get: ORA-01754: a table may contain...
Quite frankly, I can't imagine really needing more than one long per table/record, myself, if that many. Heck, even in the apps I see them used in, they...
I would highly recommend that you follow the OFA installation guidelines. It makes administration of Oracle databases a lot easier, especially when you have...
Thanks very much for ur time.... What we are thinking is the following option.SInce u mentioned we may get runtime error ,thout of posting our way of...
You cannot use CLOBs in your applicaiton. It is supported and it doesn't work. If you convert LONGs to CLOBs you get runtime errors in the PeopleSoft ...
Hello All, I have an Oracle 10g r2 database here and I'm using Windows Active Directory external authentication for a number of users. The usernames have been...
Hello All, Does anyone has a unique way of of migrating forward MPs/Bundles to other PS databases? I have just finished MP6 updates to HR8.9/PT8.47. MP/Bundles...
Does it matter? OraSoft will not support your application if you're not using CA as your upgrade tool, according to the GSC. peace, clark 'the dragon' willis ...
Could you direct me to the GSC doc that stated that please? Thanks Ty ... _________________________________________________________________ Get FREE company...
Consider the possibility of using PeopleSoft Long with a limit on the number of characters. I have not tested this with more recent versions, but if you create...
Graham Bowden
grahambowden@...
Nov 10, 2006 7:19 pm
2244
The limit is still 2000 characters (because early versions of PT8.4 were certified with Oracle 8i - the limit on VARCHAR2 was increased to 4000 from Oracle...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
