Wednesday, January 31, 2018

Oracle Concurrent connections limit

The number of sessions/concurrent connections the database (oracle) was configured to allow:
    SELECT name, value FROM v$parameter WHERE name = 'sessions';

The number of sessions currently active:
    SELECT COUNT(*) FROM v$session;

Complete Query:
    SELECT
      'Currently, ' 
      || (SELECT COUNT(*) FROM V$SESSION)
      || ' out of ' 
      || VP.VALUE 
      || ' connections are used.' AS DATA
    FROM 
      V$PARAMETER VP
    WHERE VP.NAME = 'sessions';

OUTPUT:
DATA
Currently, 93 out of 172 connections are used.

Resource Name and Connections:
    select resource_name, current_utilization, max_utilization, limit_value from v$resource_limit where resource_name in ('sessions', 'processes');

Want to increase the concurrent connections/sessions, open init.ora file inside oracle setup and increase "processes, cursor_limit and sessions".
However this change require Oracle Restart.

Friday, January 12, 2018

GIT commands

GIT commands help:

List of Branches:
    git branch -a
    
* master                                  //* means current branch in your local system
  remotes/origin/HEAD -> origin/master
  remotes/origin/master    

Create a branch:
  git branch NEW_BRANCH_LOCALLY
  
List of branches again:
  git branch -a
  NEW_BRANCH_LOCALLY
* master                                  //* means current branch in your local system
  remotes/origin/HEAD -> origin/master
  remotes/origin/master
  
Rename a GIT branch (Locally and Remotely):
    git branch -m old_branch new_branch         # Rename branch locally.    
    git push origin :old_branch                 # Delete the old branch from remote.
    git push --set-upstream origin new_branch   # Push the new branch, set local branch to track the new remote.

Delete a Branch in GIT:
    git branch -d THE_LOCAL_BRANCH      (Delete local branch).
    git push origin :THE_REMOTE_BRANCH  (Delete Remote branch).
    or
    git push origin --delete THE_REMOTE_BRANCH 

Sync your Local branches with Remote (Update):
    git fetch -p     
    git fetch THE_REMOTE_BRANCH


Switch branch in local system:
    git checkout THE_LOCAL_BRANCH
Switched to branch 'THE_LOCAL_BRANCH'    
    
    
Commit to a branch in GIT remote:
    git push -u origin 2B_BLOB
    git push origin 2B_BLOB

Commit changes to master branch in GIT remote:    
    git push -u origin master    


Create new branch in GIT remote:
    git remote add 2B_BLOB
    

Merge Request:
    git merge THE_REMOTE_BRANCH/master


Add changes:
git add *      or FILE_NAME

Commit:
git commit -m "Message"

Status:
git status