Feeds:
Posts
Comments

Archive for the ‘Uncategorized’ Category

I ran into this recently so decided to share my “panic moments” with all in case it helps someone else. It happened that I accidentally deleted the file in TFS thinking I didn’t need it. Something like this:

 

image

And as per habit, I checked in the changes to get into this mess:

image

Luckily I remembered the option to “show deleted items” in Visual Studio:

 

ShowDeletedItems

After enabling it, I switched back to VS, did a refresh and sure enough the deleted file was there:

image

Then it was just a matter of choosing the “Undelete” option from the right-click menu and committing the change:

image

image

 

TFS committed the “undelete” operation and the file showed up – Phew!

image

Read Full Post »

Since we have CmdLets for other SCA tasks, implementing one for obtaining plant information, was the next logical thing to do. So without further ado, here’s one for Smart-3D plant: Get-SCAPlantInfo.

It takes parameters, SCAServer name, SiteDb, Plant name and an optional switch, TestNameGenerator, that allows testing the name-generator for the model database. When specified, it invokes the name-generator component for the model database and returns the computed count in the ComputedName property.

Here’s the help screen for Get-SCAPlantInfo. Note, that in PowerShell, you can look at help information for any command, by using the Get-Help CmdLet:

Get-SCAPlantInfo Help - Click for larger image

Get-SCAPlantInfo Help

Here’s the output of running the command against an Oracle database in Smart-3D V11R1. You get information on plant’s symbol share, the databases that constitute the plant, the las time reports and views were regenerated, the state of the catalog, the ComputedName value,  the count of S3D objects,  the users connected to the plant, etc.

Get-SCAPlantInfo

Plant info with details on report, views & catalog status

I think this will be pretty useful and combined with Get-SCADbServerInfo , Get-SCAPerfCounters, and PowerShell tasks and exporting (Excel/Html/etc.) capabilities, you can pretty much implement a dashboard that displays relevant information suited to your needs.

Read Full Post »

If you have dealt with performance issues related to configuration with Oracle, you surely know that setting the redo-log file size, is very important to control checkpoint activity. With earlier versions of Oracle, you had run bunch of scripts and monitor the database, to arrive at some approximation for it’s size. However with 10g onwards, Oracle has added the fast_start_mttr_target init parameter, that can help you  in correctly sizing the readolog files. The V$INSTANCE_RECOVERY view gives you the size via the OPTIMAL_LOGFILE_SIZE column.

So let’s see how we can obtain this value using SCA. If you run a scan in SCA without first setting the fast_start_mttr_target, you won’t see  the “Optimal LogFile Size” value under Redo Stats node as seen here:

SCA Scan

 So first you need to make sure that fast_start_mttr_target init parameter is set for your database. In my case I’m going to set it to 5 mins as shown below:


Now when I run a scan in SCA, you can see that I have an additional row under Redo Stats with name “Optimal LogFile Size” with a value, that Oracle has populated based on current database activity

Optimal LogFile Size

 I can also look at the current logfile size and determine whether they need to be resized as shown below: 


That’s all to it. Hopefully this will help you in easily figuring out the correct redo-log file size for your Oracle database environment.

Read Full Post »

As some of you know, we released System & Configuration Analyzer (SCA) about a week back. Those who don’t know about SCA, basically it’s a .NET application to gather detailed system and database information of a windows server to help troubleshoot performance issues related to non-optimal settings and/or resource constraints. Now the intent was to gather data from windows OS servers, but since it comes loaded with OCI “zero-configuration” dlls, some adventurous analysts, used it to connect and analyze Oracle database hosted on Linux.

I found this pretty cool so thought including it as a post. You can see the familiar UNIX (“/”) path separators in the image below. I guess, this does go with the adage: “Users can be more innovative than developers” 🙂

SCA (Linux Server)

 

 

 

 

 

 

 

I forgot to mention that, to only see “Database” information in SCA, you need to set the “Perf Collector Type” to database. In that case, SCA won’t pull OS (Linux) information and only collect database (Oracle) information.

SCA – Options for Linux Host

Read Full Post »

Hello world!

Welcome to my blog at WordPress.com. This is going to host my thoughts, views, issues & solutions related to my daily working with .Net, Scripting, Smaplant 3D and it’s .NET API and anything else I deem useful or interesting.

Read Full Post »