- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Wanted specific oracle scripts
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2003 12:31 AM
тАО04-07-2003 12:31 AM
i'm lookinf for scripts able to return the status of PMON,SMON,DBWR,LGWR.
Scripts which checks:
- the number of opened processes
-fulfilling of the data tablespace
-fullfilling of the index tablespace
-fullfilling of the rollback tablespace
-Database stop/start
-usr login/logoff
10 points for attachments, 5 for an usefull post.
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2003 12:48 AM
тАО04-07-2003 12:48 AM
Re: Wanted specific oracle scripts
http://www.introcomp.co.uk/database/oracle.html
http://www.uaex.edu/srea/
http://web.singnet.com.sg/~petermag/oracle.html
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2003 12:58 AM
тАО04-07-2003 12:58 AM
Re: Wanted specific oracle scripts
P.Pollet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2003 01:50 AM
тАО04-07-2003 01:50 AM
Solutionabout PMON, SMON, DBWR and LGWR:
In a dedicated server mode (most common mode), there is a process per session
typically and you must count the background/slave processes (DBWR, LGWR, ARCH,
CKPT and so on). The latter processes should always be running and are visible both at the OS and database levels.
A peek at v$process will tell you how many there are and their status. (see example in attached script)
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-07-2003 02:18 AM
тАО04-07-2003 02:18 AM
Re: Wanted specific oracle scripts
The attached script display free space on the database. This gives you the overall usage.
Well, it might be 0.01% full but it might also be autoextensible. Use the following script to see whats really there:
Max
Max pct
Tablespa KBytes Used Free Used Largest Kbytes Used
SYSTEM 201,728 200,960 768 99.6 704 33,554,416 .6
shows that my system tablespace is currently 201m and has 0.4% fre HOWEVER it can grow to 33gig and hence has only used 0.6% of its potential.
What that shows me is:
Kbytes = space allocated to the tablespace currently.
Used = space allocated within the tablespace to specific objects
Free = space NOT yet allocated to any objects
Used = % of space allocated to objects in tablespace
Largest= Largest free contigous extent available (autoextensible will overrule this however by allocating additional extents as soon as required)
Now, to find the amount of free space within the allocated space, we have 2 choices:
o analyze tables frequently. Then the "EMPTY_BLOCKS" column in user_tables will be populated
o use the dbms_space package to find the free space available.
If you really want to know the amount of space used for Indexes and Data, you will have to analyze the tables and further query the data dictionary to get the desired information.
hth
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2003 03:41 AM
тАО04-08-2003 03:41 AM
Re: Wanted specific oracle scripts
-Database stop/start
Use the attached script to both start or stop your Oracle Database and listener.
START:
oracle.sh start
STOP:
oracle.sh stop
Assumptions: (please modify the script accordingly)
============================
Oracle OS user = oracle
Oracle Home = /u01/app/oracle/product/8.1.7
Oracle SID = yddb
hth
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2003 03:42 AM
тАО04-08-2003 03:42 AM
Re: Wanted specific oracle scripts
hi again,
This script can be used to view list of connected users, in the following format:
PID SID SER# BOX USERNAME OS_USER PROGRAM Logon Time
_________ _____ _____ ______ __________ ________ _______________ ______________
10956 30 1707 cmtk25 SW gw sqlplus@cmtk250 08/04/03 15:40
10963 25 1755 L1000 SW ias MK100OC0 - Make 08/04/03 15:41
This includes the actual login time of the users.
Hope this helps!
Yogeeraj