-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Now Oracle has a quick way to find users with detault password. SQL> SELECT * FROM dba_users_with_defpwd; And here is… READ MORE
|
Sample program that demonstrates using JDBC to connect to Oracle database. Source code $ cat TestConnection.java import java.sql.*; public class… READ MORE
List of oracle default users and their password. After creating the database one may want to change the password for… READ MORE
There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message… READ MORE
Using the following SQL one can find the oracle bit version installed: SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process… READ MORE
|
When an java app connects to oracle depending on the driver such as osuser, program in v$session will not be… READ MORE
On 10R2 if the Oracle binaries are installed with the RAC, one can’t use those binaries to start Oracle Instance… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
|
This simple script will check if a user password is expiring in the next 120 days. set pagesize 500 set… READ MORE
Snapshot and FlexClone Several of the capabilities of NetApp storage contribute to the ease of Oracle data management in NFS… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 