Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

EMR 9.8.10 Archive_Obs

Page 1 / 2 Next

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

25 Posts

5 Users

0 Reactions

128 Views

RSS

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

Hello!

We have been experiencing some database slowness a couple of days a week on our Oracle DB. It seems to only last a few hours in the morning. Server utilization looks normal but it seems like no matter what we do it can take up to 45 seconds to load a chart.

I turned a ticket into GE about the slowness and they recommended that we turn on the Archive_Obs stored procedure.

So my questions are... Is anyone else utilizing this? If so have you seen performance increase? How does it affect those observations that are archived? Is it easy for the providers to look at the archived data?

Thanks!

Posted : September 21, 2015 12:50 pm

petemarkey

(@petemarkey)

Posts: 373

Honorable Member

curious, how many records are in your observations table?

Posted : September 21, 2015 3:06 pm

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Same question about how many obs in the table. Just loading SP10 shouldn't have effected it. But to answer your questions.

Is anyone else utilizing this?
Yes

If so have you seen performance increase?
Yep it can make a big difference. Depending on how many obs a pt has and how fast your DB server is.

How does it affect those observations that are archived?
Just doesn't download them when the chart is opened.

Is it easy for the providers to look at the archived data?
Yep they see missing where missing obs are and just have to hit the button get all obs to get all of them. Depending on the settings you use they may never have to hit the button usually the last 6 or so obs in any field is plenty.

Posted : September 21, 2015 4:07 pm

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

Is there a query or report I can run to see how many records are in the DB table?

Thanks.

Posted : September 21, 2015 4:15 pm

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Yes I just don't know the Oracle one off the top of my head. (Sorry its been a long while since I was on Oracle) It might also be in the ArchiveOBS directions.

Posted : September 21, 2015 4:21 pm

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

Are you running your Oracle Database in a virtual environment?

Posted : September 22, 2015 3:58 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

No the Oracle DB is a physical box.

Bovie I looked in the directions but they just tell you how to enable and disable it and the different options for the tool.

Posted : September 22, 2015 4:45 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Cody,

How long have you been on the EMR?

Posted : September 22, 2015 7:13 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

We have been on the EMR since 2005. We are a practice with 13 providers, so I am guessing that this would help us out a lot.

Posted : September 22, 2015 7:26 am

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

Oh ya I would just do it then. You can always go back if its an issue.

Posted : September 22, 2015 7:39 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

We have 83k patients in the DB. I am going to run it tonight but set it to only run for 6 hours to see if it completes or not.

Posted : September 22, 2015 7:50 am

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

Thanks for your response. If anyone is running Oracle DB in a Virtual setting and having this issue, please let me know how you are handling slowness/freezing as we are having similar issue and GE stated we are their only customer in a virtual environment.

Your feedback will be very valuable.

Posted : September 23, 2015 2:55 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

We are running Oracle DB in a virtual environment (VMware) and we have quite the opposite, our DB is fast and we rarely have speed issues that I know of. The DB itself is hosted on 8x SSD drives and the server has 4x vcpu and 24 gig of memory. We have spinning disks for OS, REDO, and arch.

We we have had issues before it was because our server was running off of 1 or 2 snapshots and those snapshots were hosted on the spinning disks and not the SSD drives.

We built the VMware environment to GE's specs and made sure everything was approved so I am not sure why they would tell you that no one is virtual.

Posted : September 23, 2015 5:03 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

To see how many records in your obs table in oracle (should work in sql as well):

select count(*) from obs

Posted : September 23, 2015 5:04 am

codyh3

(@codyh3)

Posts: 61

Trusted Member

Topic starter

It's interesting that you would be told you are the only virtual customer. Ha. I'm sure a lot of GE customers are.

Our server is Physical. Specs:

Dell R710

Intel Xeon X5660 @ 2.80 GHz

24 Gig Memory

Windows Server 2008 R2

Disks: 4 x 300 GB 15K SAS in RAID 10

We do have the DB and Arch on one RAID and the OS on another.

Posted : September 23, 2015 5:10 am

Page 1 / 2 Next

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed