Category: remote services

Oracle Utility – isqlplusctl

Oracle Utility – isqlplusctl

October 14, 2011 | By | Add a Comment

Hi Friends, Today we discuss about isqlplusctl utility of Oracle. Use isqlplusctl to start and top the iSQL*Plus application server. The iSQL*Plus application server requires to be started before you can use iSQL*Plus utility of Oracle. Syntax Isqlplusctl   [start/stop] Parameters: Start Starts the iSQL*Plus application Server. Stop Stops the iSQL*Plus application Server. Example: To start […]

Read More

Oracle Utilities Undocumented-dbfsize

Oracle Utilities Undocumented-dbfsize

December 6, 2010 | By | Add a Comment

Hi Friends, There is hidden and undocumented Oracle utility available called DBFSIZE. This Oracle utility provides exact size of file, which is connected with Oracle software. Means we can get size of control file, redo log file, datafile size using DBFSIZE undocumented Oracle utility. DBFSIZE utility doesn’t available for Windows platforms. How to use DBFSIZE […]

Read More

Tuning of gc current block 3-way wait in RAC Oracle Database

Tuning of gc current block 3-way wait in RAC Oracle Database

November 30, 2010 | By | 1 Comment

Hi Friends, What is the gc current block 3-way wait or gc current block 2-way wait event. Following article is explaining the more detail of gc current block 3-way wait secret with performance tuning of wait event in RAC Oracle Database. So many times oracle rac database wait event gc current block 3-way wait logs […]

Read More

Oracle DBA Scripts- PGA management and pga_aggregate_target

Oracle DBA Scripts- PGA management and pga_aggregate_target

November 10, 2010 | By | Add a Comment

Hi Friends, Here you can find out some useful and important Oracle DBA scripts for managing and administrating Database very easily. Oracle DBA Scripts-1: How to check hidden PGA parameter setting from Oracle hidden parameters. Following scripts are very useful to get hidden pga parameters. Kindly execute with SYSDBA privilege. select a.ksppinm name, b.ksppstvl value […]

Read More

ORA-01045: user SCOTT lacks CREATE SESSION privilege

ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By | Add a Comment

Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give […]

Read More

Save Oracle Licensing cost using Smart Computing

Save Oracle Licensing cost using Smart Computing

October 13, 2010 | By | 1 Comment

Save Oracle Licensing cost using Smart Computing. Unfortunately installation takes placed by non-specialists of Oracle software, installation done with analysis of client needs and application structure details. Due to this reason client has to spend more charges of Oracle licensing cost when it doesn’t require Oracle Enterprise Edition.

Read More