SomeCoolToolsforthePeopleSoftSupportTeamSession#20649March13,2006Alliance2006ConferenceNashville,Tennessee白银价格走势图•Foundedin1891•Privateuniversity•6,753undergraduate•8,093graduate•1,775faculty•7,565staffLocated30milessouthofSanFranciscoandjustnorthofSiliconValley.3StanfordUniversityandOracleProductscurrentlyinstalled:CampusSolutions8SP1PeopleTools8.22.05EnterprisePortal8.8SP1PeopleTools8.44.03EnterpriseLearningManagement8.8SP1PeopleTools8.45.124Student&HRSystemsStudent&HRsystemsispartofAdministrativeSystemsTheinfrastructuregroupisconsistsofa1-Manager5-systemanalysts,3-OracleDBAs2-WindowsAdministrators.AseparategroupofdevelopersarealsopartofStudent&HRSystems.5OverviewToolsweredevelopedtoaid•developers•helpmaintainsecurity•monitorenvironmentsTheInfrastructureTeamSupports•6learningmanagementdatabases•5enterpriseportaldatabases•9studentadministrationdatabases6TheTools•PSDeveloper’sPage•PSSecurityPage•PSStatusPage7Administrator’sPage8TheCoolTools9TheCoolTools10PSDeveloper’sPage•Upload/Download-SQR-COBOL-LogFiles-InputFiles•CheckSecuritySetups•SearchforvariousobjectsLookupDatabaseobjects-PL/SQL-packages-procedures-functions-triggers•RunOracleExplainPlansAllowsdevelopersto11PSDeveloper’sPage12PSDeveloper’sPage-SQR13PSDeveloper’sPage-Upload14PSDeveloper’sPage-Display15PSDeveloper’sPage-Download16PSDeveloper’sPage–AppServerLogs17PSDeveloper’sPage–ProcessLogs18PSDeveloper’sPage–SQROutput19PSDeveloper’sPage–SQROutput220PSDeveloper’sPage–SQROutput321PSDeveloper’sPage–CobolOutput22PSDeveloper’sPage–AppEngineOutput23PSDeveloper’sPage–SQRInput24PSDeveloper’sPage–SQRInput225PSDeveloper’sPage–DatabaseObjects26PSDeveloper’sPage–PL/SQLPackages27PSDeveloper’sPage–PL/SQLProcedures28PSDeveloper’sPage–PL/SQLFunctions29PSDeveloper’sPage-Triggers30PSDeveloper’sPage–SearchforFiles31PSDeveloper’sPage–StoredStatements32PSDeveloper’sPage–ExplainPlan33PSDeveloper’sPage–ExplainPlan34SecurityPage•EnterprisePortal•CampusSolutions(HR&StudentAdministration)•LearningManagementSystemRolesPermissionListsOracleDBRoles&UsersNavigationforSQRsDisplayssecurityfor35SecurityPage36SecurityPage–PSUserSecurity37SecurityPage–DatabaseSecurity38PSSecurityPage–SQRSecurity39PSStatusPageThispageprovides:•DatabaseVersion•ApplicationServers•ProcessSchedulers•ApplicationMessaging•Publicationandsubscription•Linkstothestatusfordatabases40PSStatusPage41PSStatusPageQuestions?43ContactsRossShimabukuroSystemAnalyst,Student&HRSystemsStanfordUniversityE-mail:ryshima@stanford.eduJeffButlerLeadSystemAnalyst,Student&HRSystemsStanfordUniversityE-mail:jbutler@stanford.eduCarolJordanManager,TechnicalInfrastructureStanfordUniversityE-mail:cajordan@stanford.eduThispresentationandallAlliance2006presentationsareavailablefordownloadfromtheConferenceSitePresentationsfrompreviousmeetingsarealsoavailable