Sri Satyanarayana Vratamu in Telugu Script

శ్రీ సత్యనారాయణ వ్రతము తెలుగులో.

Part 1 : Vratakalpamu (వ్రతకల్పము)
Part 2 : Kadha, Vishnu Sahasra Naamaavali (కధ, విష్ణు సహస్ర నామావళి)

Download original documents and rotate counterclockwise for better readability.

Courtesy/Publisher: గొల్లపూడి వీర సామీ సన్, రాజమండ్రి

See Also:
Hanuman Chalisa (హనుమాన్ చాలీసా) and Sandhya Vandanam (సంధ్యా వందనము) in Telugu Script

Read More

PeopleSoft Financials 9.0 (Day-in-the-Life) Benchmark on Oracle Sun

It is very rare to see any vendor publishing a benchmark on competing products of their own let alone products that are 100% compatible with each other. Well, it happened at Oracle|Sun. M-series and T-series hardware was the subject of two similar / comparable benchmarks; and PeopleSoft Financials 9.0 DIL was the benchmarked workload.

Benchmark report URLs

	PeopleSoft Financials 9.0 on Oracle's SPARC T3-1 Server
	PeopleSoft Financials 9.0 on Oracle's Sun SPARC Enterprise M4000 Server

Brief description of workload

The benchmark workload simulated Financial Control and Reporting business processes that a customer typically performs when closing their books at period end. "Closing the books" generally involves Journal generation, editing & posting; General Ledger allocations, summary & consolidations and reporting in GL. The applications that were involved in this process are: General Ledger, Asset Management, Cash Management, Expenses, Payables and Receivables.

The benchmark execution simulated the processing required for closing the books (background batch processes) along with some online concurrent transaction activity by 1000 end users.

Summary of Benchmark Test Results

The following table summarizes the test results of the "close the books" business processes. For the online transaction response times, check the benchmark reports (too many transactions to summarize here). Feel free to draw your own conclusions.

As of this writing no other vendor published any benchmark result with PeopleSoft Financials 9.0 workload.

(If the following table is illegible, click here for cleaner copy of test results.)

Hardware Configuration	Elapsed Time		Journal Lines per Hour		Ledger Lines per Hour
	Batch only	Batch + 1K users	Batch only	Batch + 1K users	Batch only	Batch + 1K users
DB + Proc Sched  1 x Sun SPARC Enterprise M5000 Server  8 x 2.53 GHz QC SPARC64 VII processors, 128 GB RAM App + Web  1 x SPARC T3-1 Server  1 x 1.65 GHz 16-Core SPARC T3 processor, 128 GB RAM	24.15m Reporting: 11.67m	25.03m Reporting: 11.98m	6,355,093	6,141,258	6,209,682	5,991,382
DB + Proc Sched  1 x Sun SPARC Enterprise M5000 Server  8 x 2.66 GHz QC SPARC64 VII+ processors, 128 GB RAM App + Web  1 x Sun SPARC Enterprise M4000 Server  4 x 2.66 GHz QC SPARC64 VII+ processors, 128 GB RAM	21.74m Reporting: 11.35m	23.30m Reporting: 11.42m	7,059,591	6,597,239	6,898,060	6,436,236

Software Versions

Oracle’s PeopleSoft Enterprise Financials/SCM 9.00.00.331
Oracle’s PeopleSoft Enterprise (PeopleTools) 8.49.23 64-bit
Oracle’s PeopleSoft Enterprise (PeopleTools) 8.49.23 32-bit on Windows Server 2003 SP2 for generating reports using nVision
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 64-bit + RDBMS patch 9699654
Oracle Tuxedo 9.1 RP36 Jolt 9.1 64-bit
Oracle WebLogic Server 9.2 MP3 64-bit (Java version "1.5.0_12")
MicroFocus Server Express 4.0 SP4 64-bit
Oracle Solaris 10 10/09 and 09/10

Acknowledgments

It is one of the complex and stressful benchmarks that I have ever been involved in. It is a collaborative effort from different teams within Oracle Corporation. A sincere thanks to the PeopleSoft benchmark team for providing adequate support throughout the execution of the benchmark and for the swift validation of benchmark results numerous times (yes, "numerous" - it is not a typo.)

(Original post is at:
http://blogs.sun.com/mandalika/entry/peoplesoft_financials_9_0_day)

Read More

Oracle 11g : Poor Performance Accessing V$SESSION_FIX_CONTROL

PeopleSoft HCM, Financials/SCM 9.x customers may have to patch their Oracle database server with RDBMS patch 9699654. Rest of the Oracle customers: read the symptoms and decide.

In couple of PeopleSoft deployments it is observed that the following SQL is the top query when all queries are sorted by elapsed time or CPU time. 11.2.0.1.0 is the Oracle database server version.

SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID')

The target query is being executed thousands of times. The poor performance is due to the lack of a proper index. Here is the explain plan that exhibits the performance issue.

-------------------------------------------------------------------------------
| Id  | Operation  | Name       | Starts | E-Rows | A-Rows |   A-Time   |
-------------------------------------------------------------------------------
|   0 | SELECT STATEMENT |       |      1 | |      1 |00:00:00.02 |
|*  1 |  FIXED TABLE FULL| X$QKSBGSES |      1 |      1 |      1 |00:00:00.02 |
-------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(("BUGNO_QKSBGSEROW"=:B1 AND
       "SID_QKSBGSEROW"=USERENV('SID') AND "INST_ID"=USERENV('INSTANCE')))

20 rows selected.

Oracle Corporation accepted this behavior as a bug and agreed to fix in Oracle RDBMS 12.1. Meanwhile an RDBMS patch was made available to the customers running 11.2.0.1 or later. 9699654 is the bug# (Bad performance of V$SESSION_FIX_CONTROL query) - so, Solaris SPARC customers can download the RDBMS patch 9699654 directly from the support web site. Customers on other platforms: please search the bug database and support web site with appropriate keywords.

After applying the RDBMS patch 9699654, the optimizer was using an index and the query performance was improved as expected. Also the target SQL query was no longer the top SQL - in fact, no references to this particular query were found in the AWR report. The new explain plan is shown below.

----------------------------------------------------------------------------------------------
| Id  | Operation               | Name               | Starts | E-Rows | A-Rows |   A-Time   |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |                    |      1 |        |      1 |00:00:00.01 |
|*  1 |  FIXED TABLE FIXED INDEX| X$QKSBGSES (ind:1) |      1 |      1 |      1 |00:00:00.01 |
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(("BUGNO_QKSBGSEROW"=:B1 AND "SID_QKSBGSEROW"=USERENV('SID') AND
              "INST_ID"=USERENV('INSTANCE')))

20 rows selected.

Read More

Oracle's Optimized Solution for Siebel CRM 8.1.1

A brief explanation of what an optimized solution is and what it is not can be found in the previous blog entry Oracle's Optimized Solution for PeopleSoft HCM 9.0. We went through a similar exercise to publish another optimized solution around Siebel CRM 8.1.1.

The Siebel solution implements Oracle Siebel CRM using a unique combination of SPARC servers, Sun storage, Solaris OS virtualization, Oracle application middleware and Oracle database products.

URLs to the Siebel CRM white papers:

• Optimized Solution for Siebel CRM 8.1.1 : A Technical White Paper
• Optimized Solution for Siebel CRM 8.1.1 : A Business White Paper

White you are at it, do not forget to check the 13,000 user Siebel CRM benchmark on the latest SPARC T3 platform.

Read More

Oracle's Optimized Solution for PeopleSoft HCM 9.0

According to Oracle Corporation: Oracle's optimized solutions are applications-to-disk solutions that are comprised of Oracle's Sun servers, storage, and networking components, Oracle Solaris, Oracle Enterprise Linux, Oracle Database, Oracle Fusion Middleware and Oracle Applications.

To be clear, an optimized/optimal solution is neither a software package nor a hardware system bundled with pre-tuned software. It is simply a set of recommendations based on some testing performed in labs. The recommendations typically provide sizing guidelines for small, medium and large configurations, best practices, tuning tips and some performance data. Customers can refer to these guidelines when deploying enterprise applications on Oracle hardware to achieve optimal configuration for better TCO and ROI.

The PeopleSoft solution implements two modules in Oracle PeopleSoft Enterprise Human Capital Management (HCM) 9.0 to demonstrate how Oracleʼs servers, disk storage and advanced flash based storage technology can be used to accelerate database transactions to achieve unprecedented application performance. Workload consolidation is achieved through server consolidation while maintaining the appropriate balance of performance, availability, cost and expected future capacity requirements.

The optimized solution technical white paper can be accessed from the following URL:

    Oracleʼs Optimized Solution for PeopleSoft Human Capital Management Consolidation using M-series servers, Flash and Enterprise Storage

A corresponding solution brief targeting less patient is available at:

    Oracle's Optimized Solution for PeopleSoft HCM - A Business White paper

(Original blogpost location:
http://blogs.sun.com/mandalika/entry/oracle_s_optimized_solution_for)

Read More

Instructions to Turn ON/OFF Hardware Prefetch on SPARC64 Systems

The hardware prefetch is ON by default on M-series servers such as M8000/M9000, M4000/M5000, M3000

The following excerpt is from a SPARC64 document:

Hardware speculatively issues the prefetch operation based on the prediction that there is high possibility to access to the following continuous address in the future, if there have been load accesses for a consecutive address.

Although this feature is designed to improve the performance of various workloads, due to the speculative nature, not all workloads may benefit with the default behavior. For example, in our experiments, we noticed 10+% improvement in CPU utilization while running some of the PeopleSoft workloads on M-series hardware with hardware prefetch turned off. Hence irrespective of the application/workload, the recommended approach is to conduct few experiments by running representative customer workloads on target M-series hardware with and without the hardware prefetch turned on.

Instructions to Turn On/Off Hardware Prefetch:

1. Connect to the system Service Processor (XSCF)

   
   % ssh -l <userid> <host>
   

2. Check the current prefetch mode by running the following command at XSCF> prompt

   
   XSCF> showprefetchmode
   

3. Find the domain id of all mounted system boards (or skip to next step)

   
   XSCF> showboards -a
   

4. Power-off all configured domains

   
   XSCF> poweroff -d <domainid> [OR]
   XSCF> poweroff -a
   

   From my experience, on larger systems with multiple domains configured, all domains must be powered off before the SP lets changing the prefetch mode. If someone has a correction to this information or better instruction that minimizes disruption, please let me know. I'd be happy to update these instructions.

5. Wait until the domain(s) are completely powered off. Check the status by running showlogs command

   
   XSCF> showlogs power
   

6. Change the prefetch mode to the desired value

   
   XSCF> setprefetchmode -s [on|off]
   

7. Verify the prefetch mode

   
   XSCF> showprefetchmode
   

8. Finally power-on all configured domains

   
   XSCF> poweron -d <domainid> [OR]
   XSCF> poweron -a
   

9. Disconnect from SP, and wait for the OS to boot up

Note to Sun-Oracle customers:

If the default value of hardware prefetch is changed, please make sure to mention this in any service requests, bug reports, etc., that you may file with Oracle Corporation. Unfortunately none of the standard commands on Solaris report the status of hardware prefetch - so, providing this additional piece of information beforehand will help the person who is analyzing/diagnosing the case.

+Original blog post URL

        http://blogs.sun.com/mandalika/entry/instructions_to_turn_on_off

Read More

Instructions to Restore Files from a Windows Filesystem using Ubuntu Live CD

Windows users who have not interacted with any kind of UNIX or Linux distribution before are the target audience of this HOW-TO blog post.

1. Download the latest version of Ubuntu 32-bit ISO image from the following location:

           http://www.ubuntu.com/getubuntu/download

2. Burn the ISO image onto a CD or DVD so you can try running Ubuntu Linux from the CD (Live CD option)

3. On the target system (running Windows or any other OS but does not recognize the disk drive(s) containing Windows FS) boot Linux from the CD or DVD that you burned

4. Once the OS boots up: launch the partition editor

   

5. Look for NTFS, FAT or FAT32 filesystems and note down the corresponding partition names.

   

   In the example, /dev/sda1 and /dev/sda2 are the Windows filesystems.

6. Launch system terminal (command line interface)

   

7. Mount the Windows filesystem using the "mount" command.

   

8. Finally navigate to the mounted filesystem using the graphical user interface.

   
   
   
   
   

9. Insert an USB flash device

   Ubuntu recognizes the USB drive and mounts it automatically. Type "df -h" on the command line terminal and look for "NO NAME". "NO NAME" filesystem is the USB file system.

10. Backup your files from the Windows filesystem to the USB filesystem

Read More