Featured
The Latest
-
How to find the session and SQL statement that is not closing the ResultSet?
There was an issue the other day where the application session ran out of open cursors resulting the following error… READ MORE
-
|
How to find the last time a session performed any activity?
In v$session the column last_call_et has value which tells us the last time (seconds) ago when the session performed any… READ MORE
-
|
Explain plan execution plan
Explain plan may not relay the correct execution plan optimizer may run, the following link shows an example Explain Plan… READ MORE
-
How to change unix prompt?
C-shell (csh) Example: set prompt=”[%n@%m %c] \! %” oracle@localhost ~] 39 % In this above example sets prompt to display… READ MORE
-
whereiz – find all version of a command
Using the following script it will find all version of a command in $PATH (from Unix Power Tools) $ cat… READ MORE
-
Run a logout script in k-shell
By setting trap one can run a logout script when a k-shell is being terminated. The built-in command trap in… READ MORE
-
|
How to find permissions granted on user in a database?
Run the following SQL to find permissions granted on users on the database select case when p.protecttype = 205 then… READ MORE
-
How to send an email not using xp_sendmail in SQLServer?
From the following KB article it list couple of store procedures which can be used to send email through SQLServer.… READ MORE
-
|
Using oradebug to dump call stack?
Using “oradebug dump errorstack <dump level>” one can dump the call stack of the process after attaching to a running… READ MORE
-
How to find row that has non-numeric value in a character column?
There can be a scenario where the datatype of the column is VARCHAR or CHAR but values that are suppose… READ MORE
-
How to suspend/resume a process using oradebug?
Suspend a running process SQL> oradebug setorapid 12 Unix process pid: 10932, image: oracle@localhost.localdomain (TNS V1-V3) SQL> oradebug suspend Statement… READ MORE
-
Using oradebug to set event
The following example shows how to set event on a oracle session To turn on event, needs to be run… READ MORE
-
Key Features in Primavera 6 V7
1. Upgrades can happen right from 5 through 6.2 a) The last release from the primavera before being acquired by … READ MORE
-
Deep-Dive into PPM at Oracle OpenWorld 2010
The Project Portfolio Management (PPM) track at Oracle OpenWorld will present a full lineup of expert speakers, including PPM product… READ MORE
-
New Primavera P6 Analytics Uses Oracle BI to Improve Project Portfolio Performance
Oracle’s Primavera P6 Analytics, released this spring, uses prebuilt business intelligence and analytics to improve project portfolio management and forecasting… READ MORE
-
Covering Primavera at OpenWorld 2010
Hello, This year I am planning to attend most if not all sessions for Primavera at OpenWorld in San Francisco.… READ MORE
-
Project Portfolio Management at Open World 2010
An increased level of scrutiny and accountability is driving enterprise decision-making. In industries including engineering and construction, aerospace and defense,… READ MORE
-
|
How to use dbms_monitor and dbms_session to turn on trace?
Using dbms_monitor.client_id_trace_enable to turn trace on for all sessions that have client identifier set to 'debug' and using dbms_session.set_identifier which… READ MORE
-
How to monitor temp tablespace usage?
At times you may have a scenario where you may want to monitor temp space usage in a running session.… READ MORE
-
|
How to check/find session information (wait, io, lock, time)
Find SQL currently executing in a session: https://oraclespin.wordpress.com/2010/05/09/how-to-find-sql-running-for-a-usersid/ Session running waiting on SYS@TESTDB> SELECT event, state, p1, p2, p3, seconds_in_wait… READ MORE
-
|
Buffer and Dictonary Hit ratio
— Buffer hit ratioselect (1-(sum(decode(name, ‘physical reads’, value, 0))/(sum(decode(name, ‘db block gets’, value, 0)) +(sum(decode(name, ‘consistent gets’, value, 0))))))*100 “Buffer… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 