troubleshooting Question

Host command not working/ printing data without commit/ slow working

Avatar of Shehzad
Shehzad asked on
Oracle Database
6 Comments1 Solution703 ViewsLast Modified:
hi ,
Recently i installed a fresh copy of oracle on my clients system but the problem is that the host command is not working

The next question is the suppose there is a system on cash sale counter and a slip is printed on commit of every sales the problem is the it takes about four seconds for the slip to start printing as it first starts the report background engine and then formats / processes the report . is there a way to speed up this process i.e can i print the slip without running a report ( the sales form is master-detail) further is it ok that i am tracking the current stock through views from all the transaction tables i.e purchase, sales ,returns,etc.

how can i speed up the populating of a record group made through these views as it take about 3 sec to populate the list ( populating for validation of qty as it cannot be greater than stock

please help me out sorry for asking many questions in one posting
ASKER CERTIFIED SOLUTION
venkotch

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros