Premium Essay

Oracles

In: Computers and Technology

Submitted By mairaakram
Words 3763
Pages 16
RESEARCH SUMMARY
We took samples of 300 diabetic patients from different regions of the city. The samples were used there to analyze what quantity of medicines and which type of equipments and medicines are commonly used by different families, depending on the level of the treatment and other factors.
The Data was collected through proper surveys which included questionnaires, face to face discussions and internet. Average of different medicines consumed and equipments used, helped to evaluate what amount of different medicines are preferred mostly. It was done to know the appropriate ratio of various types of medicines and equipments.
After doing so, routes were set. The delivery charges were set after deep consideration of various factors which includes petrol, being consumed by vehicle. Eventually everything was set and thus a proper platform was laid to calculate the Profits, revenues and Cost spend by the System.
PROJECT SCOPE

Our Project which is about Mobile Diabetes Support across Lahore. This project has made us learn the different aspects of practical implementation of the theoretical matter we have gone through under your kind supervision.
As far as this project is concerned, we want to propose a commercially feasible and socially suitable way of Mobile Diabetes Support to the doorstep of the diabetic patients.
In this regard we gathered some useful information about the types of medicines and equipments used by the diabetic patients, the preferred medicines and equipments used by the diabetic patients, the consumption of different medicines, no of times the unavailability of particular medicine at the neared store, no of times the inconvenience of time and distance to the medical store, and the transportation facility. By putting these collective efforts we hope for a more practical and physically sustainable plan.

SCOPE BASELINE

A…...

Similar Documents

Free Essay

Oracle

...gv$session s, sys.gv$lock c, sys.gv$locked_object l, dba_objects o, sys.gv$lock k, gv$lock v WHERE o.object_id = l.object_id AND l.session_id = s.sid AND k.sid = s.sid AND s.saddr = c.saddr AND k.kaddr = c.kaddr AND k.kaddr = v.kaddr AND v.saddr = s.saddr AND k.lmode = l.locked_mode AND k.lmode = c.lmode AND k.request = c.request ORDER BY object; ***************** 11G TO 10G (XE) 1. expdp ETAG_CHTBW/etag@vw FULL=N VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.dmp LOGFILE=ETAG_CHTBW.log dump generated in : D:\app\Administrator\admin\vw\dpdump in 10g (XE for eg) put the dump generated above in this location (where 10g is installed) before running the below command: c:\oraclexe\app\oracle\admin\XE\dpdump 1.1 GRANT read, write on directory data_pump_dir to ETAG_CHTBW 2. impdp etag_chtbw/etag_chtbw FULL=Y DIRECTORY=data_pump_dir DUMPFILE=ETAG_CHTBW.DMP LOGFILE=ETAG_CHTBW.DMP_imp.log ***** TABLESPACE (MINEXTENTS) ERROR RESOLUTION (IN CASE U GET IT): ALTER TABLESPACE ETAG_DAT01 ADD DATAFILE 'C:\oraclexe\oradata\XE\MY_TS2.DBF' SIZE 90M AUTOEXTEND ON NEXT 200K MAXSIZE 200M; **************************** REF CURSOR **************************** Passing REF CURSOR as parameters to sub-programs In the previous section, we already started working with sub-programs (or sub-routines). In this section, I shall extend the same with the concept of "parameters" (or arguments). Every sub-program......

Words: 1277 - Pages: 6

Free Essay

Oracle Payables

...Critical Details about EBS R12 Upgrades Presented By Susan Behn VP, Oracle Practice Objectives/Agenda  Provide a high level view of topics to consider when upgrading to R12  When is a “technical” upgrade possible  What do I need to research more  When is the right time for training  What do I include in my budget/timeline  Functional Topics  Technical Topics 2 Overview  Are you aware that…  There are over 1500 new features in R12    A responsibility can now access data in multiple organizations R12.1 was released in April 2009    How does this impact custom Responsibilities How will all these new features be “discovered” Quicker data entry for shared services organizations   The user interface to the Oracle Diagnostics scripts was rewritten in OA Framework in R12.0.6   12.0 focused on Financials 12.1 focused on everything else including HR Utilizes role-based access control requiring role grants from the user management responsibility Setup reports in diagnostics can help you find missing setups 3 FINANCIALS - GL 4 Financials - GL  Legal Entities have significant functionality in R12  Should reflect legal corporate structure  Utilized by Accounting Functions, E-Business Tax, Intercompany, and Bank Account  Balancing segment is associated with legal entity – not ledger  Bank account is owned by legal entity  Align your Ledger structure with your business plan  Operating units are......

Words: 3253 - Pages: 14

Free Essay

Dell and Oracle

...Oracle Corporation It’s a huge company that provides enterprise software and computer hardware products and services. It develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems. It is organized into three businesses: software, hardware systems and services. Its software business consists of two segments: new software licenses and software license updates and product support. It’s hardware systems business consists of two segments: hardware systems products and hardware systems support. It authorizes database and middleware software, including database and database management, application server and cloud application, service-oriented architecture and business process management, business intelligence, identity and access management, data integration, Web experience management, portals, and content management and social network software, as well as development tools and Java, a software development platform; and applications software comprising enterprise resource planning, customer relationship management, financials, governance, risk and compliance, procurement, supply chain management, enterprise portfolio project and enterprise performance management, business intelligence analytic applications, Web commerce, and industry-specific applications software. It also provides customers with rights to unspecified software product upgrades and maintenance releases; Internet access to technical content;......

Words: 2530 - Pages: 11

Free Essay

Oracle Apps

...skilled and have much to offer potential employers and their clients. Currently, I am a System Engineer with Tata Consultancy Services Limited. Primary Skills: 2years & 9 Months of experience as Technical Consultant in Oracle E-Business Suite Applications. Resume Details: • 2 years and 9 month of analysis, design, development and support experience in Oracle apps. • Has exposure in working with Onsite – Offshore models. • Experience in all phases of the system development /implementation life cycle. • Experience in Oracle Apps R12,11i,Fusion • Worked in projects having R12 Implementation, Upgrades and Oracle Fusion • Experience of Development Data Conversions and Implementation • Proficient in, Packages writing stored procedures and functions using SQL & PL/SQL.  • Experience of Developing Reports (PL/SQL Reports). • Have good Knowledge on BI Publisher Reports • Have knowledge on Oracle Reports • Self-motivated, excellent team player with proven leadership skills. • Excellent communication and interpersonal skills. Project Summary: CIGNA HEALTH CARE |Description |Cigna is a Re-implementation or Oracle EBS Applications from R11.5.10.2 to R12.1.3. Like to Like Re-Implementation, with no | | |business process changes, except for standard functionalities that come with R12 – SLA. The main......

Words: 1310 - Pages: 6

Free Essay

Oracle Rac

...A white paper prepared with Oracle and IBM technical collaboration March 2010 Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability Executive Overview ........................................................................... 2 Introduction ....................................................................................... 2 Problem validation ......................................................................... 3 Examining the AIX Error Logging................................................... 3 Examining the Oracle oprocd logging ............................................ 4 Recommendations for system stability............................................... 5 1. Implement AIX tuning recommendations for Oracle ................... 5 2. Modify Oracle ‘diagwait’ parameter............................................ 6 3. Install the required updates and patches ................................... 8 4. Reduce heavy paging activity. ................................................. 11 Appendix A: Oprocd logging examples ............................................ 14 Clean oprocd log files .................................................................. 14 Oprocd log files showing scheduling delays................................. 14 Oprocd log files after a node reboot or CRS restart .................

Words: 4075 - Pages: 17

Free Essay

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also......

Words: 1424 - Pages: 6

Free Essay

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle......

Words: 3160 - Pages: 13

Premium Essay

Oracle Backup

...Oracle Backup There are two type of back • Cold backup (Offline) • Hot Backup (Export) Cold backup Procedure Setup 1. Copy backup from Source Check the Oracle version & Path Open Comd Prompt and typecomd Tnsping [database_name] Then type Sqlplus Type username /password @ DB name as sysdba Check the How many DB install on system Click on Start Button and type services.msc and press enter this screen display Press O and search Oracleservice[DB name] Stop the service Now press the stop button on the left side Now go to your Oracle home directory and open it . Go to DB directory and Copy the Folder and past to the backup path After finish the copy then start service of “Orlaceservice[DB Name] Your cold/hard back Complete. Restore the Backup (On Same Version and installation Path) Step 2. Create New DB Click Start Button and type dbca and press next Select Create Database and Press Next Select General Purpose and Press Next Type Globaldatabase and SID and Press Next Uncheck Configure the database with Enterprise Manager Enter the Password for Sys and System and press Next Select File System and Press Next Select Use Common Location for all database and click Browser Select the Path and Press Ok and then Next Uncheck Specify Flash Recovery Area Press next on simple Schemas Press Next Press Finish Press Ok Press Finish Database......

Words: 662 - Pages: 3

Free Essay

Oracle Ebs

...to Oracle EBS 1.1 About EBS 1.2 EBS Application Products 2. The EBS architecture 2.1 Desktop Tier 2.2 Application Tier 2.3 Database Tier 3. Oracle EBS database features 3.1 Monitoring Features 3.2 Performance Features 3.3 Scalability Features 3.4 Business Intelligence Features 3.5 Security Features 4. Oracle EBS user list 5. Oracle EBS success stories 5.1 Home Box Office (HBO) 5.2 Mallcom limited 5.3 AT&T INC. 5.4 Facebook 5.5 HCL 1.1 ORACLE EBS Oracle's E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management(CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. The software utilizes Oracle's core Oracle relational database management system technology. The E-Business Suite contains several product lines often known by short acronyms. Significant technologies incorporated into the applications include the Oracle database technologies, (engines for RDBMS, PL/SQL, Java, .NET, HTML and XML), the "technology stack" (Oracle Forms Server, Oracle Reports Server, Apache Web Server, Oracle Discoverer, Jinitiator and Sun's Java). Oracle Corporation brands the on-line technical documentation of E-Business Suite as eTRM — "E-Business Suite Technical Reference Manuals". The applications found in the Oracle EBS include: * Oracle......

Words: 7162 - Pages: 29

Premium Essay

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring......

Words: 652 - Pages: 3

Premium Essay

Oracle and Microsoft

...Financial Statement Analysis: Oracle Corporation and Microsoft Corporation ACCT-504-10236: Acct Fin: Managerial Use,Anlys Professor: Leonard Hope Oracle Corporation is a US based company that headquarter in Redwood city, CA. It is a multinational computer technology company that develops and markets computer hardware systems. Oracle is second only to Microsoft as the largest software maker by revenue. The company was founded in 1977 under the name of Software Development Laboratories. It went through many name changes only to land the name Oracle Corporation in 1995. They offer many products and services such as software, hardware, middleware, Oracle Beehive, and many applications. Like Oracle Microsoft is a US based computer technology company. It is headquarter out of Redwood, WA. It was founded in 1975 in Albuquerque, NM by Bill Gates and Paul Allen. It is multinational company that serves as the largest software maker by revenue. In 1985 Microsoft partnered with IBM to write the operating systems. However, by the 90s Microsoft own operating system, Microsoft Windows, took 90% of the worlds personal computers. As of 2013 Microsoft has a global annual revenue of $77.85 billion dollars. They employ 110,000 people in 105 different companies. They develop, license, support, and manufacture a large range of software products. Use this Excel spreadsheet to compute ratios; show your computations for all ratios on this tab and also include your commentary. The......

Words: 1088 - Pages: 5

Free Essay

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or......

Words: 106399 - Pages: 426

Premium Essay

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number of...

Words: 580 - Pages: 3

Free Essay

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download......

Words: 1320 - Pages: 6

Premium Essay

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2