Featured
The Latest
-
How to extend an account whose password is expiring?
One of the ways to extend the password of an expiring account is to change the profile of the user.… READ MORE
-
DDL to disable triggers in Oracle and SQLServer
To disable to trigger that are enabled in cases when loading data manually in a particular schema or table can… READ MORE
-
|
snapshot controlfile and RMAN-08512
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… READ MORE
-
How to find length of a TEXT column?
The “LEN” function cannot be used to find length of a column of datatype “TEXT” so using function “DATALENGTH” one… READ MORE
-
|
How to find permissions granted on individual objects in a database?
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
-
How to find average row length for a table?
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
-
|
Sample program that transfers data from MySQL to Oracle (CLOB)
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
-
|
How to skip blank lines in between SQL statements in SQL*Plus?
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script… READ MORE
-
|
How to turn off case sensitive in 11g
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON NAME TYPE VALUE ———————————— ———– —————————— sec_case_sensitive_logon boolean TRUE SQL> SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON =… READ MORE
-
How to find users with default password in 11g?
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 JDBC program which connects to Oracle
Sample program that demonstrates using JDBC to connect to Oracle database. Source code $ cat TestConnection.java import java.sql.*; public class… READ MORE
-
|
How to list the access the roles the different users have?
— print usernames and the roles assigned to the user, it can be run against any database and it will… READ MORE
-
|
How to find a length of LOB column?
Using dbms_lob.getlength(column name) one can find the length of the LOB (CLOB/BLOB/BFILE) data type. Example: SQL> SELECT dbms_lob.getlength(lob_column) FROM scott.lob_table;… READ MORE
-
How to find if a table has row chaining?
Using ANALYZE TABLE owner.table_name COMPUTE STATISTICS one can find if the table has chained rows. Example: — analyze again SQL>… READ MORE
-
|
How to find the IO stats of filesystem?
Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So… READ MORE
-
|
Information on col_usage$
In 10g SMON gathers information on columns that are used in predicates and updates them in COL_USAGE$. Here is the… READ MORE
-
|
How to create a on-demand AWR snapshot?
Using dbms_workload_repository.create_snapshot() one can create AWR snapshot. Example: Creates the snapshot and returns the snap id. If ‘ALL’ is not… READ MORE
-
sysaux – v$sysaux_occupants
— view to monitor space usage by different occupants and procedure to move the feature to a different tablespace. SQL>… READ MORE
-
Oracle Created (Default) Database Users
List of oracle default users and their password. After creating the database one may want to change the password for… READ MORE
-
How to find definitions of V$, GV$ views?
From v$fixed_view_definition one can find the definitions of V$views which may one in understand them. Example: SQL> set pages 0… READ MORE
-
How to generate AWR report?
There are few scripts that can be used to generate AWR HTML or text reports. @?/rdbms/admin/awrrpt.sql – It is an… READ MORE
-
|
How to change AWR retention, interval, topnsql?
Using dbms_workload_repository.modify_snapshot_settings, one can modify retention, interval, and topnsql. READ MORE
-
How to find AWR snapshot interval and retention settings?
Using this SQL one can find the snapshot interval and snapshot retention. SQL> SELECT extract(day from snap_interval) *24*60+extract(hour from snap_interval)… 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 