Jun 17,
2008
|
using xdb to ftp asm files (10g)
|
Jun 17,
2008
|
temp tablespace usage
|
Jun 17,
2008
|
show user locks
|
Jun 17,
2008
|
show uga and pga memory usage
|
Jun 17,
2008
|
show all running sql text
|
Jun 17,
2008
|
how to rename asm files
|
Jun 17,
2008
|
list asm file creation dates
|
Jun 17,
2008
|
users waiting for locks
|
Jun 17,
2008
|
dbms_metadata to get ddl for creating objects
|
Jun 17,
2008
|
display sessions holding locks
|
Jun 17,
2008
|
list extents by owner
|
Jun 17,
2008
|
list inactive db users
|
Jun 17,
2008
|
list running db jobs
|
Jun 17,
2008
|
list all queued jobs
|
Jun 17,
2008
|
report sql text of locks in database
|
Jun 17,
2008
|
rman and nls date format – until time
|
Jun 17,
2008
|
show all users and locks
|
Jun 17,
2008
|
more sql users and locks
|
Jun 17,
2008
|
list submitted jobs dba_jobs
|
Jun 17,
2008
|
list running jobs dba_jobs
|
Jun 17,
2008
|
sql to list users to kill
|
Jun 17,
2008
|
select extents
|
Jun 17,
2008
|
tablespace size and free space
|
Jun 23,
2008
|
alter all users to new default temp tablespace
|
Jun 23,
2008
|
check for analyzed tables with chaining.sql
|
Jun 23,
2008
|
check_hidden_params.sql
|
Jun 23,
2008
|
crate a stats table.sql
|
Jun 23,
2008
|
create a test dba schema.sql
|
Jun 23,
2008
|
create script to rebuild all invalid objects.sql
|
Jun 23,
2008
|
describe a table.sql
|
Jun 23,
2008
|
describe multiple tables.sql
|
Jun 23,
2008
|
detiled info on a table columns.sql
|
Jun 23,
2008
|
explain plan template again.sql
|
Jun 23,
2008
|
explain plan template.sql
|
Jun 23,
2008
|
get general tablespace info again again.sql
|
Jun 23,
2008
|
get general tablespace info again.sql
|
Jun 23,
2008
|
get general tablespace info another.sql
|
Jun 23,
2008
|
get general tablespace info.sql
|
Jun 23,
2008
|
get os info and hostname.sql
|
Jun 23,
2008
|
get sql text for a given hash value.sql
|
Jun 23,
2008
|
getsql text for a given hash value again.sql
|
Jun 23,
2008
|
list a tables columns.sql
|
Jun 23,
2008
|
list all awr metrics being collected.sql
|
Jun 23,
2008
|
list all initialisation parameters.sql
|
Jun 23,
2008
|
list all objects.sql
|
Jun 23,
2008
|
list all sequences.sql
|
Jun 23,
2008
|
list all sql in sga assigned to a sid.sql
|
Jun 23,
2008
|
list all tables.sql
|
Jun 23,
2008
|
list all waits by time waited.sql
|
Jun 23,
2008
|
list basic segment details again.sql
|
Jun 23,
2008
|
list basic segment details.sql
|
Jun 23,
2008
|
list db sessions.sql
|
Jun 23,
2008
|
list foreign keys on a table and all foreign references again.sql
|
Jun 23,
2008
|
list foreign keys on a table and all foreign references.sql
|
Jun 23,
2008
|
list gv$resource limits.sql
|
Jun 23,
2008
|
list index and column names for a table again.sql
|
Jun 23,
2008
|
list index and column names for a table.sql
|
Jun 23,
2008
|
list index partition details.sql
|
Jun 23,
2008
|
list rollback segment details.sql
|
Jun 23,
2008
|
list segment types per tablespace and user.sql
|
Jun 23,
2008
|
list segmet usage by type and name.sql
|
Jun 23,
2008
|
list synonyms.sql
|
Jun 23,
2008
|
list tables and their partitions.sql
|
Jun 23,
2008
|
list tables and when they were last analyzed.sql
|
Jun 23,
2008
|
list tablespaces and free space.sql
|
Jun 23,
2008
|
list tablespaces.sql
|
Jun 23,
2008
|
list users and default tablespace.sql
|
Jun 23,
2008
|
list users on this instance.sql
|
Jun 23,
2008
|
list views with name like.sql
|
Jun 23,
2008
|
list waiting and blocking users.sql
|
Jun 23,
2008
|
look for sql in the sga containing the provided text.sql
|
Jun 23,
2008
|
loop and check pool usage.sql
|
Jun 23,
2008
|
pga_mem total max and freed.sql
|
Jun 23,
2008
|
pgastat values.sql
|
Jun 23,
2008
|
query all objects.sql
|
Jun 23,
2008
|
query the plan_table.sql
|
Jun 23,
2008
|
see what foreign keys are pointing to this table.sql
|
Jun 23,
2008
|
sessions by pga usage.sql
|
Jun 23,
2008
|
set session trace off.sql
|
Jun 23,
2008
|
set session trace on.sql
|
Jun 23,
2008
|
show a users privileges.sql
|
Jun 23,
2008
|
show active sql.sql
|
Jun 23,
2008
|
show all tables being accesed and the userid.sql
|
Jun 23,
2008
|
show all tables for a user.sql
|
Jun 23,
2008
|
sql to show archive and redo logs (Oracle 10g 11g)
|
Jun 23,
2008
|
show archive and redo logs.sql
|
Jun 23,
2008
|
sql to show current date and time
|
Jun 23,
2008
|
show db sessions and sql text.sql
|
Jun 23,
2008
|
show general stats for a partitioned table again.sql
|
Jun 23,
2008
|
show stats for a partitioned table and its indexes
|
Jun 23,
2008
|
show general stats for a table – more.sql
|
Jun 23,
2008
|
show general stats for a table again again.sql
|
Jun 23,
2008
|
show general stats for a table Another view .sql
|
Jun 23,
2008
|
show general stats for a table.sql
|
Jun 23,
2008
|
show grants.sql
|
Jun 23,
2008
|
show logon_time username machine and locks for sessions.sql
|
Jun 23,
2008
|
show object dependencies.sql
|
Jun 23,
2008
|
show partition index structure.sql
|
Jun 23,
2008
|
show partition table column statistics.sql
|
Jun 23,
2008
|
show partition table structures.sql
|