I haven't checked this before responding, but I think that if the AE process is not restartable, it may not write the current step information (because it...
I'll start by plugging somebody else's book. I think the best description of how to tune any system (not just a PeopleSoft one) is set out in the first...
Do you have software on your Unix machines that enables printers or print queues to be defined, e.g. for an HP Laserjet? Does the printer have an IP address?...
And that recommedation is reasonable. Unfortunately, I often see people collecting a snapshot every 3 hours, or even less frequently. Sometimes I use a...
In the past, Process Scheduler called a script when running an SQR process. I can't seem to find the script now, so maybe they've changed it in newer...
Hi, What are the steps you are taking to refresh regions (environments)? In other words, whenever you are asked to refresh your test environment, do you...
How can i set the cache to be separated for each users who logged in to app designer via terminal server ? we have 20 users who uses the same box (using...
Here you go.... ... From: psftdba@yahoogroups.com [mailto:psftdba@yahoogroups.com]On Behalf Of kellykday Sent: Thursday, September 01, 2005 2:32 PM To:...
Generally, this is what we do. 1. We do an export of the source database. 2. Then we shut down appservers and process schedulers of target database. 3. Run...
That's pretty much exactly how we do it. One major difference is that we actually take two exports. The first is a User-mode export, with ROWS=N. The second...
How about having them login to Terminal Server with different usernames, and then giving them unique cache directories in Configuration Manager? A quick check...
Roger, Thanks. Do you shutdown source before export? One of our DBAs keeps shutting source before the export which I dont understand. I keep telling him that...
Hello all, We are running SAHR 8 and FS 8.4 on Oracle 9i. Our primary platform is an IBM p690 running AIX 5.2. The databases, web servers, app servers, and...
James, Speaking as one who started in this business as a mainframe type of guy, choose ...(drumroll)... option number 1. The benefit of the separation of your...
We use cold copy method (CRMS, Fins, HR) - which is much quicker - then we rename the DB, bring it up. For Data Mover scripts etc. we follow a similar method....
So, the majority is using export/import. Any reason not to use hot backups to recreate the database? I mean, at the very least they should be faster to restore...
Roberto Yes, we shutdown the db and make a disk copy or ftp the files to dev/test server. We also have a dataguard copy on another server, so we can activate...
Our printers are all on Network and not connected to Windows straight. Print out commands are sent straight to a share on Windows servers from the clients....
The method Shirley suggests is the quickest by a long way. If you go to Metalink you'll find lots of examples of the method to use. Bob Ellis PSE Data...
What is the problem you are trying to solve by splitting up? Is is performance issues, upgrade independence, different usage patterns, operating system...
Graham Bowden
grahambowden@...
Sep 2, 2005 7:45 am
1242
We're using Hotbackups. Currently I can do a refresh of a 55Gb Live database in 20minutes (Sun SparcIII kit with 1Gb network interfaces). Compare that to an...
Hi, everyone. I wasn't going to join the discussion, but this is very important part of the task for any dba who had issues with region refresh... so here it ...
I agree, for the most part. Export/Import is a serious waste of time. We use a combination of hot and cold backups, depending on the source system (PRD has...
Shaun, Would it be possible for me to convince you to post your scripts for after refresh clean-up? I'd like to look at them and see if we could use them here ...
The main reason we use exp/imp is that it allows us to utilize less space for our test environments. We can selectively eliminate unneeded tables (namely...
I didn't cover RMAN as I have yet to find time to build and test it, but from what I've seen lately, it looks to be better than the Hotbackups. I'm hesitant...
Well, option 1 has been discussed for quite some time mainly because of a particular performance issue. Occasionally, one of our SAHR web servers would go...
Shaun, Your 2 hours, does that include import and export? Either way, that seems fast to me. Do you change any init parameters for the import? What how big is...