Friday 31 August 2018

Overview On Oracle RAC Resource Mastering

The GRD is a central repository for locks and resources, it is distributed across all nodes (not a single node), but only one instance masters a resource. The process of maintaining information about resources is called lock mastering or resource mastering. I spoke about lock remastering in my BACKUP section.
Resource affinity allows the resource mastering of the frequently used resources on its local node, it uses dynamic resource mastering to move the location of the resource masters. Normally resource mastering only happens when an instance joins or leaves the Oracle RAC environment, as of Oracle 10g R2 mastering occurs at the object level which helps fine-grained object remastering. There are a number of parameters that can be used to dynamically remaster an object
_gc_affinity_time    specifies interval minutes for re-mastering
_gc_affinity_limit    defines the number of times a instance access the resource before remastering, setting to 0 disables remastering
_gc_affinity_minimum    defines the minimum number of times a instance access the resource before remastering
_lm_file_affinity    disables dynamic remastering for the objects belonging to those files
_lm_dynamic_remastering    enable or disable remastering
You should consult Oracle before changing any of the above parameters.
For more information visit Mindmajix

Thursday 23 August 2018

NetSuite Interview Questions

If you're looking for NetSuite Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research NetSuite has a market share of about 8.2%. So, You still have opportunity to move ahead in your career in NetSuite Development. Mindmajix offers Advanced NetSuite Interview Questions 2018 that helps you in cracking your interview & acquire dream career as NetSuite Developer.
Q: Explain what is a Lead and how Leads are captured in Netsuite?
In accounting terminology, a lead is classified as an individual who is interested in the product or a service that is been offered and they are in a state to take a decision to purchase the product or service.
Within Netsuite, the term “Lead” is considered as a standard object where several other informational fields are captured while taking up Lead information.
Q: Explain what is a Lead Generation Process?
The lead generation process actually starts after the fact, i.e. when a product is completely developed or the service is readily available for the consumers. A lead generation process is nothing but a marketing strategy where the products or services are presented to the consumers to try them out and further promote them to sign up for the regular usage of the product or the services that the company is offering.
Most of the time lead generation process is taken up by the sales team of an organization. One has to make sure that they have sound knowledge about the product or the service where they are going to promote.
Q: Explain the lead conversion process in Netsuite?
The lead conversion process in NetSuite can be executed in two different methods:
>> Within the system, for an opportunity, if we have keyed in the estimates, sales transactions then the lead is automatically converted as per the default statues.
>> If you are explicitly using the lead conversion process then you can follow the below process:
1. Click on the convert button on lead record
>> The above process is commonly used in sales organizations and business to consumer businesses
Q: List out the process flow for procuring to pay process in Netsuite and let us know how it works?
The procure to pay process in Netsuite is as follows:
1. Purchase Order Entry
2. Purchase order Approval
3. Receiving
4. Matching
5. Bill Approval
Q: List out the process flow for Lead to cash process in Netsuite?
The process flow for Lead to cash is as follows:
1. Lead
2. Opportunity
3. Quote
4. Order
5. Fulfill
6. Invoice
7. Billing
Q: Explain what is the purchase order cycle in Netsuite?
The purchase order cycle in Netsuite is as follows:
1. Receiving
2. Update Inventory
3. Enter Bills
4. Bill Payment
5. Accounting posting
Q: What is Suitescript, explain briefly?
Suitescript is nothing but a Java-based API that enables the developers an enhanced ability to use an extended version of Netsuite.

Friday 10 August 2018

Access to Network Services in Oracle Database - Oracle DBA

What is a listener?
Listener is a process that resides on the Oracle server whose responsibility is to listen for incoming client connection requests and manage the traffic to the server.
- By default, the listener name is (amazingly enough) “listener” (but you can call it anything you like). It listens for connection requests on a particular port (the default port number in 8.0 and above is 1521, but once again, you can set this to any valid port number if you wish). A client knows where to contact the listener (the machine it’s running on, and the port it’s listening on) because a local configuration file, called “tnsnames.ora”, gives it the necessary information. More advanced configurations can dispense with the tnsnames.ora (for example, you can opt to install a “names server”, which does the same job of telling the client where to find the listener).
- Upon receiving a connection request from a client, the listener can do one of two things. Either it will spawn a new server process, and redirect the client to talk directly to that server process… at which point, the listener drops out of the picture altogether, and continues to listen for connection requests from other clients. This is known as ‘bequeathing’ the server process to the client, in the sense of ‘making a gift’ –and the client is then said to have a bequeath session.
- Or it will inform the client of the network address of a server process which has already been created when the instance was started (a “pre-spawned server process), and the client is then able to make direct contact with that server process. Note again, however, that once the connection is established between the client and the server process, the listener simply continues to listen for new connection requests. This is known as ‘redirecting’ the client to the server process, and hence the client is said to have a redirect session. The only real difference between bequeath and redirect sessions is that, in theory, it takes longer to set up a bequeath session (the server process has to be created from scratch, for a start). However, the drawback with redirect sessions is that you have to pre-spawn a bunch of server process and hope that enough clients want to connect to make them useful… overdo it, and you just have a lot of processes chewing up memory and CPU cycles for no particular reason.
- Whatever type of session you end up with, though, it’s important to realise that the Listener is merely instrumental in establishing the connection; once established, the listener plays no further part in client-server communications. It is, therefore, possible to kill a listener, and no existing user would be any the wiser.
- The above description applies only to dedicated server configurations, where each user is connected directly to one server process that does nothing but service that user’s requests. It is also possible, however, to configure Oracle in what is known as multi-threaded server configuration (now known in 9i, more accurately, as “shared server configuration”). The only real difference this makes to the listener is that, upon receiving a client connection request, the listener redirects the connection to a dispatcher process, several of which are pre-spawned at instance startup. Yet again, however, once the client connection is established, the listener plays no further role in the communications process and continues to listen for new requests
- A single listener process can listen out for client connection requests on a variety of different networking protocols (such as tcp/ip, ipx/spx, Appletalk and so on). A single listener can also listen out on multiple ports for a single protocol (for example, port 1521 for tcp/ipan d port 1526 for tcp/ip) –but there are additional configuration issues when you use anything other than the default port of 1521 for tcp/ip connections (the short story is that local_listener must be set in the init.ora of the instance using the non- default port address).