Featured
The Latest
-
|
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
-
|
Substitution Variable Examples
http://www.oracle.com/technology/support/tech/sql_plus/htdocs/sub_var9.html READ MORE
-
|
How to include instance name in spool filename?
Using the example below one can include instance name in the spool filename when using SQL*Plus SQL> set termout off… 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 